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

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

Europäische Internetschule

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

Mastering MySQL: From Beginner to Advanced Database Management

Kursinhalt

Lektion 1: Installing MySQL and Setting Up Your Development Environment

# **Installing MySQL and Setting Up Your Development Environment** ## **Introduction** Before divi...

Lektion 2: Understanding SQL Basics: Queries, Clauses, and Data Types

```markdown # Understanding SQL Basics: Queries, Clauses, and Data Types ## Introduction SQL (Stru...

Lektion 3: Creating and Managing Databases: Schemas, Tables, and Constraints

# Creating and Managing Databases: Schemas, Tables, and Constraints ## Introduction Databases are ...

Lektion 4: Writing CRUD Operations: INSERT, SELECT, UPDATE, and DELETE in Practice

# **Writing CRUD Operations: INSERT, SELECT, UPDATE, and DELETE in Practice** ## **Introduction** ...

Lektion 5: Filtering and Sorting Data: WHERE, ORDER BY, and LIMIT Clauses

hn', 'JOHN', 'john', etc. SELECT * FROM users WHERE username = 'John'; ``` #### Forcing Case-Sensit...

Lektion 6: Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, and Self-Joins

# **Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, and Self-Joins** ## **Introduction** Databa...

Lektion 7: Aggregating Data: GROUP BY, HAVING, and Common Aggregate Functions (COUNT, SUM, AVG, etc.)

# Aggregating Data: GROUP BY, HAVING, and Common Aggregate Functions ## Introduction Data aggregat...

Lektion 8: Subqueries and CTEs: Writing Efficient Nested Queries and Common Table Expressions

# Subqueries and CTEs: Writing Efficient Nested Queries and Common Table Expressions ## Introductio...

Lektion 9: Indexing and Performance Optimization: Creating and Managing Indexes

```markdown # **Indexing and Performance Optimization: Creating and Managing Indexes** ## **Introdu...

Lektion 10: Storing and Manipulating Large Objects: BLOB, TEXT, and JSON Data Types

'MySQL provides specialized data types for handling large objects, including **BLOB (Binary Large Ob...

Lektion 11: User Management and Security: Creating Users, Granting Privileges, and Securing Your Database

```markdown # **User Management and Security: Creating Users, Granting Privileges, and Securing Your...

Lektion 12: Transactions and Concurrency Control: ACID Properties, Locking, and Isolation Levels

tain edge cases, such as when using range queries (e.g., `WHERE id > 5`). **Characteristics**: - **...

Lektion 13: Backup and Recovery: Automating Backups, Restoring Data, and Handling Failures

```markdown # **Backup and Recovery: Automating Backups, Restoring Data, and Handling Failures** ##...

Lektion 14: Advanced Querying: Window Functions, PIVOT/UNPIVOT, and Recursive Queries

# Advanced Querying: Window Functions, PIVOT/UNPIVOT, and Recursive Queries ## Introduction Advanc...

Lektion 15: Connecting MySQL to Applications: Using Python, PHP, and Node.js APIs

# **Connecting MySQL to Applications: Using Python, PHP, and Node.js APIs** ## **Introduction** My...