Quick Start Guide to SQL

Offered By: LinkedIn Learning

Tags

SQL Courses Relational Databases Courses Data Filtering Courses Data Retrieval Courses Subqueries Courses

Course Description

Overview

Learn the fundamentals of structured query language (SQL) in Oracle Live SQL in this approachable, beginner-friendly course.

Syllabus

Introduction

Introduction to RDBMS and SQL
How to use the exercise files

1. Fetch Data from Tables

Basic select statements
Operators
Data types

2. Filtering Data

Comparison conditions
Logical conditions
Order of precedence
Sorting data

3. Single Row Functions

Types of functions and number functions
Character functions
Date functions
Data type conversion functions
Conditional expressions

4. Multiple Row Functions/ Group Functions

Types of group functions
Creating groups and nested groups
Filtering group results

5. Joins and Subqueries

Types of joins
Uses of subqueries
Types of subqueries

Conclusion

Next steps

Taught by

Deepa Maddala

Related Courses

Introduction to Databases
Meta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX