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

Предпросмотр недоступен