Learn SQL The Easy Way

Hello Learners, Welcome to the SQL training course.

During the training I will follow MySQL syntax and you can follow along by using MySQL flavor DBMS (on your personal computer or you can use db-fiddle to practice).

This course is divided into 10 chapters, each chapter will cover a major subject area/topic on SQL. Click an the chapter name to go to the chapter.

Chapter 1: The Beginning

• Why Learn SQL?
• What is SQL?
• Database and DBMS
• What is RDBMS?
• MySQL
• Setup MySQL on your local machine/computer
• Run a sample SQL query

Chapter 2: SQL Commands

• SQL Commands
  • Data Definition Language (DDL)
  • Data Query Language (DQL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)

Chapter 3: Understand Data Types, Create Table & Load Data

• Data Types in SQL
• Create a Databse
• Create Tables
• Insert Data into the Tables
• Check the Data

Chapter 4: Querying Table & SQL Caluses

• Querying table
• Clause in SQL
  • Where Clause
  • Like Clause
  • Distinct Clause
  • Limit Clause
  • Order By Clause
  • Group By Clause
  • Having Clause
• SQL Syntax Order

Chapter 5: SQL Joins

• SQL Joins
  • Inner Join
  • Left Join
  • Right Join
  • Cross Join
  • Self Join
• SQL UNION
  • UNION
  • UNION ALL

Chapter 6: SQL Operators & Functions

• Operators in SQL
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Bitwise Operators
• SQL Functions
  • Flow Control Functions and Expressions
    • CASE
    • IF
    • IFNULL
    • NULLIF
    • COALESCE

Chapter 7: SQL Functions

• SQL Functions
  • String Functions
    • CONCAT
    • LENGTH
    • LEFT
    • RIGHT
    • LOWER
    • UPPER
    • TRIM
    • LTRIM
    • RTRIM
    • SUBSTRING
    • REPLACE
  • Aggregate Functions
    • COUNT()
    • COUNT(DISTINCT)
    • SUM()
    • AVG()
    • MAX()
    • MIN()
    • STDDEV()
    • VARIANCE()
  • Mathematical Functions
    • ABS()
    • TRUNCATE()
    • CEIL()
    • CEILING()
    • FLOOR()
    • POW()
    • POWER()
    • SQRT()
    • RAND()

Chapter 8: SQL Functions

• SQL Functions
  • Date & Time Functions
    • CURDATE
    • SYSDATE
    • NOW
    • YEAR
    • MONTH
    • WEEK
    • DAY
    • DAYNAME
    • EXTRACT
    • DATEDIFF
    • DATE_ADD
    • DATE_SUB
  • Window Functions
    • ROW_NUMBER
    • RANK
    • DENSE_RANK
    • FIRST_VALUE
    • LAST_VALUE
    • LEAD
    • LAG

Chapter 9: Subquery, CTE & Temporary Table

• Subquery
  • In Where Clause
  • In From Clause
  • In Select Clause
  • Correlated Subqueries
• CTE
• Temp Table

Chapter 10: The Conclusion

• SQL Views
• Stored Procedure
• Miscellaneous
  • Choosing Default Database
  • Changing Delimiter
  • SQL Best Practices
  • SQL Resources