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 Intro to Relational Databases
Udacity Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera Web Application Development: Basic Concepts
University of New Mexico via Coursera