Curriculum
- 1 Section
- 26 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Introduction to SQL27
- 1.1Introduction to SQL5 Minutes
- 1.2Database Basics10 Minutes
- 1.3SQL Data Types7 Minutes
- 1.4Database Design Basics12 Minutes
- 1.5Setting Up MySQL, MySQL Workbench, and Connecting to Your Database20 Minutes
- 1.6How to Connect to MySQL on Localhost8 Minutes
- 1.7SQL Constraints – Enforcing Data Integrity30 Minutes
- 1.8Working with SQL Queries – SELECT, WHERE, and ORDER BY15 Minutes
- 1.9Sorting Data with SQL – The ORDER BY Clause12 Minutes
- 1.10SQL Aggregation Functions – Summarizing Data25 Minutes
- 1.11SQL GROUP BY and Aggregate Functions20 Minutes
- 1.12SQL Joins – Combining Data from Multiple Tables30 Minutes
- 1.13SQL Subqueries – Using Queries Inside Queries30 Minutes
- 1.14Advanced SQL Concepts – Recursive Queries and Window Functions40 Minutes
- 1.15Cloud-Based SQL and Database Management15 Minutes
- 1.16Filtering Data with SQL – The WHERE Clause12 Minutes
- 1.17SQL Stored Procedures and Functions – Reusable SQL Logic30 Minutes
- 1.18SQL Transactions – Ensuring Data Integrity20 Minutes
- 1.19SQL Triggers – Automating Actions Based on Database Events25 Minutes
- 1.20SQL Views – Simplifying Complex Queries20 Minutes
- 1.21SQL Normalization – Organizing Data Efficiently35 Minutes
- 1.22SQL Indexes – Improving Query Performance25 Minutes
- 1.23SQL Data Security and Best Practices35 Minutes
- 1.24SQL Optimization and Performance Tuning35 Minutes
- 1.25SQL Security Best Practices35 Minutes
- 1.26SQL Best Practices, Troubleshooting & Real-World Applications10 Minutes
- 1.27Introduction to sql quiz10 Minutes5 Questions
SQL Best Practices, Troubleshooting & Real-World Applications
Prev