Database Management
Beginner
SQL Fundamentals
Work with relational databases the way the job actually requires — designing normalised tables, then writing SELECT, JOIN, GROUP BY and subquery statements against MySQL and PostgreSQL until querying real data feels routine.
30 chapters
7h 30m
What you'll learn
- Introduction to SQL and Databases
- Installing Database Systems and SQL Tools
- Understanding Relational Databases
- Creating Databases and Tables
- SQL Data Types Explained
- INSERT Queries and Adding Data
- SELECT Queries and Retrieving Data
- Filtering Data with WHERE Clause
Course content
30 chapters · 7h 30m- 1 Introduction to SQL and Databases 15 min
- 2 Installing Database Systems and SQL Tools 15 min
- 3 Understanding Relational Databases 15 min
- 4 Creating Databases and Tables 15 min
- 5 SQL Data Types Explained 15 min
- 6 INSERT Queries and Adding Data 15 min
- 7 SELECT Queries and Retrieving Data 15 min
- 8 Filtering Data with WHERE Clause 15 min
- 9 Sorting and Limiting Results 15 min
- 10 Working with NULL Values 15 min
- 11 Aggregate Functions in SQL 15 min
- 12 GROUP BY and HAVING Clauses 15 min
- 13 Primary Keys and Constraints 15 min
- 14 Foreign Keys and Relationships 15 min
- 15 INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN 15 min
- 16 Advanced JOIN Queries 15 min
- 17 Subqueries and Nested Queries 15 min
- 18 Views in SQL 15 min
- 19 Indexing and Query Optimization 15 min
- 20 UPDATE Queries and Modifying Data 15 min
- 21 DELETE Queries and Removing Data 15 min
- 22 Transactions and ACID Properties 15 min
- 23 Stored Procedures and Functions 15 min
- 24 Triggers and Database Automation 15 min
- 25 Database Security and SQL Injection Prevention 15 min
- 26 Connecting SQL Databases with PHP 15 min
- 27 Building CRUD Applications with SQL 15 min
- 28 Real-World Database Design Projects 15 min
- 29 Final Project: Build a Complete SQL Database System 15 min
- 30 Bonus Content 15 min