MySQL
-
MODULE 1: Getting StartedIntroduction to Databases – What, Why, Types (Relational vs NoSQL)Installing MySQL, MySQL WorkbenchCreating a Database – Syntax, Naming, StructureCreating Tables – Data Types, Constraints, Primary KeysInserting Data – INSERT INTO, Bulk Inserts, NULL ValuesReading Data – SELECT, Filtering with WHERE, DISTINCT
-
MODULE 2: Querying & Filtering Data
-
MODULE 3: Advanced Querying
-
MODULE 4: Modifying Data
-
MODULE 5: Schema Design & OptimizationER Diagrams – Understanding Relationships VisuallyDatabase Normalization – 1NF, 2NF, 3NFIndexes – What, Why, Types (BTREE, FULLTEXT)Performance Tips – Avoiding Slow QueriesViews – Virtual Tables, Reusability, Use CasesStored Procedures – Creating, Calling, ParametersFunctions vs Stored ProceduresTriggers – Event-based Logic (BEFORE, AFTER INSERT/UPDATE)
This course provides an in-depth overview of the subject. It is designed to help learners understand the fundamentals, apply practical skills, and gain confidence to move forward in this area. Suitable for beginners as well as those looking to refresh their knowledge.
What's included
- 10+ Hours on-demand video
- 5+ Special Bonuses
- 10+ Downloadable Resources
- Full Lifetime Access
- Access on Mobile & TV
