SQL Tutorial | #1 Course Overview & Introduction SQL (Structured Query Language) #sqltutorial #mysql

In this video, we will look at the SQL tutorial course overview and a quick introduction to SQL (Structured Query Language). #sql #sqltutorial #mysql Agenda for SQL Tutorial - Full Course: 1. Introduction to SQL 2. MySQL Installation & Setup Install MySQL Server and MySQL Workbench on Windows 11 Connecting to MySQL using CMD and MySQL Workbench, Create, Show, Use, Drop Database 3. SQL Table Operations SQL CREATE Table, SHOW Tables, DROP Table SQL ALTER TABLE - ADD, Modify, DROP, Rename Columns SQL ALTER TABLE with Constraints - ADD and DROP Constraints 4. SQL Data Manipulation Statements INSERT Statement in SQL SELECT Statement in SQL UPDATE Statement in SQL DELETE Statement in SQL TRUNCATE TABLE Statement in SQL 5. SQL Clauses WHERE Clause in SQL ORDER BY Clause in SQL GROUP BY Clause in SQL HAVING Clause in SQL 6. SQL Operators Logical Operators in SQL IN Operator in SQL BETWEEN Operator in SQL LIKE Operator in SQL UNION Operator in SQL 7. SQL Aggregate Functions COUNT Aggregate Function in SQL SUM Aggregate Function in SQL AVG Aggregate Function in SQL MIN Aggregate Function in SQL MAX Aggregate Function in SQL 8. SQL Keys SQL Primary Key SQL Foreign Key SQL Composite Key SQL UNIQUE Key 9. SQL Joins SQL Joins SQL INNER JOIN SQL LEFT JOIN SQL RIGHT JOIN SQL FULL JOIN SQL CROSS JOIN SQL SELF JOIN 10. SQL Views SQL CREATE VIEW SQL UPDATE View SQL RENAME VIEW 11. SQL Indexes SQL CREATE INDEX SQL DROP INDEX SQL SHOW INDEXES 12. SQL Auto Increment SQL AUTO INCREMENT 13. SQL Subqueries SQL Subqueries