Helo 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.

• 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

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

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

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

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

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

• 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()

• 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

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

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