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

Structured Query Language (SQL) using SAS
SAS via Coursera Advanced SQL Retrieval Queries in SQLiteStudio
Coursera Project Network via Coursera SQL
Udacity Advanced Database Queries
New York University (NYU) via edX Data Manipulation in SQL
DataCamp