Back to Browse

SQL & Databases FULL COURSE in 2.5 Hours | MySQL, Oracle, PGSQL, MS SQL, MS Access | Free for ALL

158 views
Mar 30, 2026
2:23:15

🎓 SQL & Databases FULL COURSE in 2.5 Hours | MySQL, Oracle, PGSQL, MS SQL, MS Access | Free for ALL Learn SQL and Databases from the ground up in this comprehensive FREE course covering 60 topics across 12 sections. Taught by an industry professional with 36 years of computer science experience — from Fortune 500 companies to academic institutions. Topics include: what is a database, DBMS platforms, DB architecture, keys & normalization, DDL/DML/DCL, replication, flat files vs databases, connecting via Python/Java/ODBC/REST API, data science tools, DBA careers & certifications, and much more. 🌐 Website: https://www.MyWebUniversity.com 📺 English Channel: https://www.YouTube.com/@mywebuniversity 📺 Dari/Farsi Channel: https://www.YouTube.com/@MyWebuniversity-Dari ⏱ TIMESTAMPS — see below ⏱ ACCURATE TIMESTAMPS (verified from transcript): 00:00 Intro & Course Overview 00:10 What You Will Learn (60 topics, 12 sections) 20:03 What is a Database? 23:20 Real World Analogy (smartphone contacts) 25:09 Why Databases Matter Everywhere 28:50 Real World Database Examples (banking, healthcare, e-commerce) 30:00 DBMS Overview: MySQL, Oracle, PGSQL, MS SQL, MS Access 32:01 Types of Databases: Relational, OO, Hierarchical, NoSQL 37:14 LDAP Hierarchical Database Example 41:26 DBMS Deep Dive: MySQL, Oracle, MS SQL, MS Access, PostgreSQL 42:14 What is CRUD? 45:01 Keys: PK, FK, SK, AK, CK + ACID Properties 47:32 Major DBMS Platforms Compared 50:09 DB Architecture: SGA, Buffer Pool, Tablespace, Daemons 52:12 Oracle Architecture: SGA & Background Processes 53:01 Database Daemons & Background Processes 59:04 Tablespace, Buffer Pool & System Files 01:02:54 Database Keys Review (PK, FK, Surrogate, Alternate, Composite) 01:07:41 Table, Record, Fields & Rows 01:12:40 Normalization: 1NF, 2NF, 3NF & BCNF 01:20:01 Table Relationships: One-to-One, One-to-Many, Many-to-Many 01:23:10 DDL: Data Definition Language (CREATE, ALTER, DROP, TRUNCATE) 01:25:00 DML: INSERT, UPDATE, SELECT, DELETE 01:27:02 Replication: Snapshot & Redundancy 01:28:07 DCL: GRANT & REVOKE 01:35:54 Distributed vs Centralized Database 01:37:29 Replication, Snapshots & High Availability 01:40:23 Querying Flat Files vs Database (Excel vs SQL) 01:43:04 Data Science, APIs & Careers Overview 01:45:05 Connecting to Database: Python, Java, Languages & APIs 01:49:42 ODBC, RPC & REST API 01:51:21 Connecting Applications to DB (gRPC, REST, JSON Web Token) 01:54:14 Data Science Tools & Public Datasets 01:57:19 DBA Career Guide: Entry to Senior Level 02:01:04 Distributed vs Centralized (recap) & Cloud DBAs 02:02:16 Certification Tools & Learning Resources 02:05:44 Thank You & Please Subscribe! 02:06:08 About MyWebUniversity & YouTube Channels 02:12:03 PDF Library & Google Search Demo 02:22:02 Thank You — Please Subscribe! 02:23:01 Support Peace and Humanity For All!

Download

1 formats

Video Formats

360pmp4105.8 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

SQL & Databases FULL COURSE in 2.5 Hours | MySQL, Oracle, PGSQL, MS SQL, MS Access | Free for ALL | NatokHD