Introduction
- What is SQL?
- Who should learn SQL?
- Quiz 1: Introduction
Setup a Testing Environment
- Download & Install MySQL 8.0.11 on Windows 10 Operating System
- Install MySQL database server on Mac operating system (MySQL 5.7.20)
- Install MySQL database server on Linux operating system (MySQL 5.7.20)
- How to add a new database user and add privileges
- Quiz 2: Setup a Testing Environment
An Overview of SQL
- What is DBMS and RDBMS?
- Difference between Database Engine, Database Server and Database Software
- What is a database? How to create and use a database?
- What is a database table? How to create and use a database table?
- How to add the data rows to a database table?
- Understand Keywords, Identifiers, Constants and Clauses
- Learn about SQL Statements
- Data Definition Language(DDL) and Data Manipulation Language(DML)?
- Quiz 3: An Overview of SQL
Important SQL Clauses (Data Manipulation Language)
- Create example databases, tables and data rows
- Learn about SQL SELECT Clause
- SQL SELECT DISTINCT Statement
- Learn about SQL FROM Clause
- Learn about SQL WHERE Clause
- Quiz 4: Important SQL Clauses
Conditions and Operators (Data Manipulation Language)
- SQL True Condition
- SQL False Condition
- SQL AND Operator
- SQL OR Operator
- SQL IN Operator
- SQL EXISTS Condition
- SQL NOT IN or NOT EXISTS? Conditions
- SQL Comparison Operators
- SQL LIKE Operator
- SQL BETWEEN Operator
- SQL Numeric Operators
- SQL Concatenation Operator
- SQL Temporal Operator
- Quiz 5: Conditions and Operators
Data grouping, sorting, select and dates (Data Manipulation Language)
- Learn about SQL GROUP BY Clause
- Learn about SQL HAVING Clause
- Learn about SQL ORDER BY Clause
- SQL LIMIT or TOP Clause
- SQL Wildcards
- SQL Aliases
- SQL Dates
- Quiz 6: Data grouping, sorting, select and dates
Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
- Add the data rows in a table using INSERT INTO Statement
- SQL INSERT INTO SELECT Statement
- Update data rows using UPDATE Statement
- Delete data rows using DELETE Statement
- What is SQL Injection and How to secure a database?
- Quiz 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
SQL JOINS (Data Manipulation Language)
- What are JOINS in SQL? Types of SQL JOINS
- Learn about INNER JOIN in SQL
- Learn about LEFT OUTER JOIN in SQL
- Learn about RIGHT OUTER JOIN in SQL
- Learn about FULL OUTER JOIN in SQL
- Learn about CROSS JOIN in SQL
- SQL UNION Operator
- SQL VIEWS
- Derived Tables or Inline Views
- Quiz 8: SQL JOINS (Data Manipulation Language)
SQL Functions
- Functions in SQL and Types of SQL functions
- SQL COUNT() Function
- SQL FIRST() Function
- SQL LAST() Function
- SQL SUM() Function
- SQL MIN() Function
- SQL MAX() Function
- SQL AVG() Function
- SQL UCASE() Function
- SQL LCASE() Function
- SQL MID() Function
- SQL LEN() Function
- SQL ROUND() Function
- SQL FORMAT() Function
- SQL SUBSTRING() Function
- SQL COALESCE() Function
- SQL CHAR_LENGTH() Function
- SQL CAST() Function
- SQL CASE() Function
- SQL NULLIF() Function
- Quiz 9: SQL Functions
SQL Data Types
- What is data type in SQL?
- Integer Numbers in SQL (Exact Values)
- Fixed-Point Numbers in SQL (Exact Values)
- Floating-Point Numbers in SQL (Approximate Values)
- CHAR and VARCHAR in SQL (String Values)
- NCHAR and NVARCHAR in SQL (String Values)
- CLOB and BLOB in SQL (String Values)
- DATE, TIME and TIMESTAMP in SQL (Temporal Values)
