SQL 101 Curriculum - EssentialSQL Online Courses

SQL 101 Curriculum

The course consists of 7 modules covering 30 lessons.  Each lesson includes video and written text.  You can try the sample problem to see how you’re learning.  If you have any questions, I’m here to help.  Lesson reviews and quizzes are included to help you reinforce what you have learned.

SQL Overview:

  • What is SQL Server?
  • Introduction to SSMS (SQL Server Management Studio)
  • Arranging Windows in SSMS
  • Exploring the Database using SSMS
  • Creating and Running Queries
  • Writing you First Query
  • Filtering Your Results
  • Sorting Results

Writing SELECT Queries:

  • Basic Structure
  • Table Naming
  • Duplicates
  • Naming Columns and Expressions

Sorting:

  • Sort Data Using ORDER BY
  • Limit Results with TOP
  • Paging with OFFSET and FETCH

Filtering Data:

  • Using the WHERE Clause to Filter Results
  • Filter Using Boolean Logic
  • Pattern Matching

Data Types and Null Values

  • Null Values
  • Common SQL Data Types
  • Esoteric Data Types

Built-In Functions

  • Conversion Functions
  • CASE Statement
  • Logical Functions
  • Math Functions
  • String Functions
  • Date Functions

Group and Summarize Your Data

  • Aggregate Functions
  • Grouping Data
  • Filtering Grouped Data with HAVING

 

Buy this Course Today