European Internet School: Mastering MySQL: From Beginner to Advanced Database Management
European Internet School
Back
/
Data Bases
/
Mastering MySQL: From Beginner to Advanced Database Management
Mastering MySQL: From Beginner to Advanced Database Management
Course Content
Lesson 1: Installing MySQL and Setting Up Your Development Environment
No preview available
Start Lesson
Lesson 2: Understanding SQL Basics: Queries, Clauses, and Data Types
No preview available
Start Lesson
Lesson 3: Creating and Managing Databases: Schemas, Tables, and Constraints
No preview available
Start Lesson
Lesson 4: Writing CRUD Operations: INSERT, SELECT, UPDATE, and DELETE in Practice
No preview available
Start Lesson
Lesson 5: Filtering and Sorting Data: WHERE, ORDER BY, and LIMIT Clauses
No preview available
Start Lesson
Lesson 6: Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, and Self-Joins
No preview available
Start Lesson
Lesson 7: Aggregating Data: GROUP BY, HAVING, and Common Aggregate Functions (COUNT, SUM, AVG, etc.)
No preview available
Start Lesson
Lesson 8: Subqueries and CTEs: Writing Efficient Nested Queries and Common Table Expressions
No preview available
Start Lesson
Lesson 9: Indexing and Performance Optimization: Creating and Managing Indexes
No preview available
Start Lesson
Lesson 10: Storing and Manipulating Large Objects: BLOB, TEXT, and JSON Data Types
No preview available
Start Lesson
Lesson 11: User Management and Security: Creating Users, Granting Privileges, and Securing Your Database
No preview available
Start Lesson
Lesson 12: Transactions and Concurrency Control: ACID Properties, Locking, and Isolation Levels
No preview available
Start Lesson
Lesson 13: Backup and Recovery: Automating Backups, Restoring Data, and Handling Failures
No preview available
Start Lesson
Lesson 14: Advanced Querying: Window Functions, PIVOT/UNPIVOT, and Recursive Queries
No preview available
Start Lesson
Lesson 15: Connecting MySQL to Applications: Using Python, PHP, and Node.js APIs
No preview available
Start Lesson