Quick Start Guide to SQL

Go to class
Write Review

Free Online Course: Quick Start Guide to SQL provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Quick Start Guide to SQL is taught by Deepa Maddala.

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