European Internet School: Mastering MySQL: From Beginner to Advanced Database Management

European Internet School: Mastering MySQL: From Beginner to Advanced Database Management

Европейско интернет училище

/
Data Bases
/
Mastering MySQL: From Beginner to Advanced Database Management

Mastering MySQL: From Beginner to Advanced Database Management

Съдържание на курса

Урок 1: Installing MySQL and Setting Up Your Development Environment

Няма наличен преглед

Урок 2: Understanding SQL Basics: Queries, Clauses, and Data Types

Няма наличен преглед

Урок 3: Creating and Managing Databases: Schemas, Tables, and Constraints

Няма наличен преглед

Урок 4: Writing CRUD Operations: INSERT, SELECT, UPDATE, and DELETE in Practice

Няма наличен преглед

Урок 5: Filtering and Sorting Data: WHERE, ORDER BY, and LIMIT Clauses

Няма наличен преглед

Урок 6: Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, and Self-Joins

Няма наличен преглед

Урок 7: Aggregating Data: GROUP BY, HAVING, and Common Aggregate Functions (COUNT, SUM, AVG, etc.)

Няма наличен преглед

Урок 8: Subqueries and CTEs: Writing Efficient Nested Queries and Common Table Expressions

Няма наличен преглед

Урок 9: Indexing and Performance Optimization: Creating and Managing Indexes

Няма наличен преглед

Урок 10: Storing and Manipulating Large Objects: BLOB, TEXT, and JSON Data Types

Няма наличен преглед

Урок 11: User Management and Security: Creating Users, Granting Privileges, and Securing Your Database

Няма наличен преглед

Урок 12: Transactions and Concurrency Control: ACID Properties, Locking, and Isolation Levels

Няма наличен преглед

Урок 13: Backup and Recovery: Automating Backups, Restoring Data, and Handling Failures

Няма наличен преглед

Урок 14: Advanced Querying: Window Functions, PIVOT/UNPIVOT, and Recursive Queries

Няма наличен преглед

Урок 15: Connecting MySQL to Applications: Using Python, PHP, and Node.js APIs

Няма наличен преглед