Emby / SQL - Introduction to MySQL + a glimpse to MsSQL & PLSQL
1. Introduction to SQL
2. Setting up the Database, the Application Servers and Starting the DB Services
3. Creating our 1st Database
4. Creating & Dropping Tables in our Database
5. Inserting Data with Insert Statement and Cloning Tables
6. Select Statements and Where Clause in SQL
7. Update and Delete Data in SQL
8. Like Operators, Limiting Results and Ordering Datasets in SQL
9. Group Dataset based on a Condition in SQL and use Distinct to Extract the Unique
10. TRUNCATE TABLE Command to Delete the Data Inside a Table and Conclusions
11. From SQL to Programming - Learning the Programming Logic
12. Advanced Programming Concepts
13. Bonus Section