Markovdata > Courses > Complete guide to SQL

Complete guide to SQL

Abstract SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction. Instructor Eng/Ahmed Fawzy Duration 5 Weeks Sessions Sundays & Wednesdays, 7:00 to 10:00PM […]

Instructor
Markov Data
11 students enrolled

Abstract

SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

Instructor

Eng/Ahmed Fawzy

Duration

5 Weeks

Sessions

Sundays & Wednesdays, 7:00 to 10:00PM

Location

Live Streaming (on-line)

Prerequisites

None

1
Part 1 – SQL Basics
  1. SQL Introduction.
  2. Why SQL.
  3. ERD Fundamentals.
  4. How Databases Store Data.
  5. Types of Databases.
  6. Types of Statements.
  7. Statements.
  8. SELECT & FROM.
  9. Formatting Best Practices.
  10. LIMIT.
  11. ORDER BY.
  12. ORDER BY Part II.
  13. WHERE.
  14. WHERE with Non-Numeric Data.
  15. Arithmetic Operators.
  16. Introduction to Logical Operators.
  17. LIKE.
  18. IN.
  19. NOT.
  20. AND and BETWEEN.
  21. OR.
2
Part 2 – SQL Joins
  1. Introduction to JOINs.
  2. ERD Reminder.
  3. Primary and Foreign Keys.
  4. Alias.
  5. LEFT and RIGHT JOINs.
  6. Other JOIN Notes.
  7. JOINs and Filtering.
  8. Recap & Looking Ahead.
3
Part 3 – SQL Aggregations
  1. Introduction to Aggregation.
  2. Introduction to NULLs.
  3. NULLs and Aggregation.
  4. First Aggregation - COUNT.
  5. COUNT & NULLs.
  6. SUM.
  7. MIN & MAX.
  8. AVG.
  9. GROUP BY Part I.
  10. GROUP BY Part II.
  11. DISTINCT.
  12. HAVING.
  13. DATE Functions.
  14. DATE Functions II.
  15. CASE Statements.
  16. CASE & Aggregations.
  17. Recap.
4
Part 4 – SQL Subqueries & Temporary Tables
  1. Introduction to Subqueries.
  2. Subquery Formatting.
  3. More on Subqueries.
  4. WITH.
  5. WITH vs. Subquery.
  6. Subquery Conclusion.
5
Part 5 – SQL Data Cleaning
  1. Introduction to SQL Data Cleaning.
  2. LEFT & RIGHT.
  3. POSITION, STRPOS, & SUBSTR.
  4. CONCAT.
  5. CAST.
  6. COALESCE.
  7. Recap.
6
Part 6 – [Advanced] SQL Window Functions
  1. Introduction to Window Functions.
  2. Window Functions.
  3. ROW_NUMBER & RANK.
  4. Aggregates in Window Functions.
  5. Aliases for Multiple Window Functions.
  6. Comparing a Row to Previous Row.
  7. Introduction to Percentiles.
  8. Percentiles.
  9. Recap.
7
Part 7 – [Advanced] SQL Advanced JOINs & Performance Tuning
  1. Introduction to Advanced SQL.
  2. FULL OUTER JOIN.
  3. JOINs with Comparison Operators.
  4. Self JOINs.
  5. UNION.
  6. Performance Tuning Motivation.
  7. Joining Subqueries.
  8. SQL Completion Congratulations.

Be the first to add a review.

Please, login to leave a review
Enroll course
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV