Skip to main content
Database Management Beginner

SQL Fundamentals

A comprehensive, beginner-friendly guide to learning SQL Fundamentals. Master the fundamentals and build real-world projects.

60 chapters 15h 4.6 (208)
Start Learning

What you'll learn

  • Introduction to SQL and Databases | Learn SQL Basics
  • Introduction to SQL and Databases
  • Install MySQL & PostgreSQL | Setup SQL Tools Localhost
  • Installing Database Systems and SQL Tools
  • Relational Databases Explained | Tables, Rows & Normalization
  • Understanding Relational Databases
  • Create SQL Databases and Tables | DDL Commands
  • Creating Databases and Tables

Course content

60 chapters Β· 15h
  1. 1 Introduction to SQL and Databases | Learn SQL Basics 15 min
  2. 2 Introduction to SQL and Databases 15 min
  3. 3 Install MySQL & PostgreSQL | Setup SQL Tools Localhost 15 min
  4. 4 Installing Database Systems and SQL Tools 15 min
  5. 5 Relational Databases Explained | Tables, Rows & Normalization 15 min
  6. 6 Understanding Relational Databases 15 min
  7. 7 Create SQL Databases and Tables | DDL Commands 15 min
  8. 8 Creating Databases and Tables 15 min
  9. 9 SQL Data Types Explained | INT, VARCHAR, DATE, BOOLEAN 15 min
  10. 10 SQL Data Types Explained 15 min
  11. 11 SQL INSERT INTO | Add Data to Relational Databases 15 min
  12. 12 INSERT Queries and Adding Data 15 min
  13. 13 SQL SELECT Statement | Retrieve Database Data 15 min
  14. 14 SELECT Queries and Retrieving Data 15 min
  15. 15 SQL WHERE Clause | Filter Database Records 15 min
  16. 16 Filtering Data with WHERE Clause 15 min
  17. 17 SQL ORDER BY and LIMIT | Sorting & Pagination 15 min
  18. 18 Sorting and Limiting Results 15 min
  19. 19 SQL NULL Values | IS NULL and IS NOT NULL Operators 15 min
  20. 20 Working with NULL Values 15 min
  21. 21 SQL Aggregate Functions | COUNT, SUM, AVG, MIN, MAX 15 min
  22. 22 Aggregate Functions in SQL 15 min
  23. 23 SQL GROUP BY and HAVING | Data Bucketing and Aggregation 15 min
  24. 24 GROUP BY and HAVING Clauses 15 min
  25. 25 SQL Constraints Explained | Primary Key, UNIQUE, NOT NULL 15 min
  26. 26 Primary Keys and Constraints 15 min
  27. 27 SQL Foreign Keys | One-to-Many, Many-to-Many Relationships 15 min
  28. 28 Foreign Keys and Relationships 15 min
  29. 29 SQL JOIN Tutorial | INNER, LEFT, RIGHT, FULL JOINs Explained 15 min
  30. 30 INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN 15 min
  31. 31 Advanced SQL JOINs | Multiple JOINs and Self JOINs 15 min
  32. 32 Advanced JOIN Queries 15 min
  33. 33 SQL Subqueries | Nested SELECT Statements 15 min
  34. 34 Subqueries and Nested Queries 15 min
  35. 35 SQL Views | CREATE VIEW and Virtual Tables 15 min
  36. 36 Views in SQL 15 min
  37. 37 SQL Indexing and Query Optimization | CREATE INDEX Explained 15 min
  38. 38 Indexing and Query Optimization 15 min
  39. 39 SQL UPDATE Statement | Modify Existing Data Safely 15 min
  40. 40 UPDATE Queries and Modifying Data 15 min
  41. 41 SQL DELETE Statement | Remove Database Records 15 min
  42. 42 DELETE Queries and Removing Data 15 min
  43. 43 SQL Transactions Explained | ACID Properties 15 min
  44. 44 Transactions and ACID Properties 15 min
  45. 45 SQL Stored Procedures | Functions and Database Logic 15 min
  46. 46 Stored Procedures and Functions 15 min
  47. 47 SQL Triggers | Automate Database Events 15 min
  48. 48 Triggers and Database Automation 15 min
  49. 49 Prevent SQL Injection | Database Security Best Practices 15 min
  50. 50 Database Security and SQL Injection Prevention 15 min
  51. 51 PHP to MySQL Database Connection | mysqli vs PDO Tutorial 15 min
  52. 52 Connecting SQL Databases with PHP 15 min
  53. 53 Build a PHP SQL CRUD Application | Secure Database Workflow 15 min
  54. 54 Building CRUD Applications with SQL 15 min
  55. 55 Database Design Strategies | Real-World SQL Architecture 15 min
  56. 56 Real-World Database Design Projects 15 min
  57. 57 SQL Capstone Project | Build a Complete Database System 15 min
  58. 58 Final Project: Build a Complete SQL Database System 15 min
  59. 59 SQL Developer Resources | Interviews, Roadmap & Optimization 15 min
  60. 60 Bonus Content 15 min