MySQL-study-repo

This is my MySQL study repo. I learned it from 'codewithmosh' course.
Code in this repo includes the syntax and clause of MySQL along with exercises in the course.
To find exercises about MySQL, you can refer to Leetcode-database-question-MySQL.

这是我的MySQL学习仓库。我从’codewithmosh‘这门课学习。
这个仓库里包括MySQL的语法与从句，连同课程中的练习。
力扣MySQL练习题： Leetcode-database-question-MySQL.

Content

Chapter 1 Introduction

1. Introduction

Chapter 2 Retrieve Data(Single Table)

1. The SELECT Statement
2. The SELECT Clause
3. The WHERE Clause
4. The AND, OR and NOT operators
5. The IN operator
6. The BETWEEN Operator
7. The LIKE Operator
8. The REGEXP Operator
9. The IS NULL Operator
10. The ORDER BY Clause
11. The LIMIT Clause

Chapter 3 Retrieve Data(Multiple Table)

1. Inner Joins
2. Join Across Databases
3. Self Joins
4. Join Multiple Tables
5. Compound Join Conditions
6. Implicit Join Syntax
7. Outer Joins
8. Outer Joins Between Multiple Tables
9. Self Outer Joins
10. The USING Clause
11. Natural Joins
12. Cross Joins
13. Unions

Chapter 4 Insert, Update & Delete

1. Column Attributes
2. Inserting a Single Row
3. Inserting Multiple Rows
4. Inserting Hierarchical Rows
5. Creating a Copy of a Table
6. Updating a Single Row
7. Using Subqueries in Updates
8. Deleting Row
9. Restoring the Databases

Chapter 5 Summarize data

1. Aggregate Functions
2. The GROUP BY Clause
3. The HAVING Clause
4. The ROLLUP Operator

Chapter 06 Complex Queries

1. Subqueries
2. The IN Operator
3. Subqueries vs Joins
4. The ALL Keyword
5. The ANY Keyword
6. Correlated Subqueries
7. The EXISTS Operation
8. Subqueries in the SELECT Clause
9. Subqueries in the FROM Clause

Chapter 07 Built-in Functions

1. Numeric Functions
2. String Functions
3. Date Functions
4. Formatting Dates and Times
5. Calculating Dates and Times
6. The IFNULL and COALESCE Functions
7. The IF Function
8. The CASE operator

Chapter 08 Views

1. Creating Views
2. Altering or Dropping Views
3. Updatable Views
4. The WITH OPTION CHECK Clause
5. Other Benefits of Views

Chapter 09 Stored Procedures & Functions

1. Stored Procedures
2. Creating a Stored Procedure
3. Creating Procedures Using MySQLWorkbench
4. Dropping Procedures
5. Parameters with Default Values
6. Parameter Validation
7. Output Parameters
8. Variables
9. Functions
10. Other Conventions

Chapter 10 Triggers

1. Triggers
2. Viewing Triggers
3. Dropping Triggers
4. Using Triggers for Auditing
5. Viewing and Dropping Events

Chapter 11 Transcations

1. Transcations
2. Creating Transactions
3. Concurrency and Locking
4. Concurrency Problems
5. Transaction Isolation Levels
6. READ UNCOMMITTED Isolation Level
7. READ COMMITTED Isolation Level
8. REPEATABLE READ Isolation Level
9. SERIALIZABLE Isolation Level
10. Deadlocks

Chapter 12 Data Type

1. Introduction
2. String Types
3. Integer Types
4. Fixed-point and Floating-point Types
5. Boolean Types
6. Enum and Set Types
7. Date and Time Types
8. Blob Types
9. JSON Types

Chapter 13a Designing Databases(Rules)

1. Data Modelling
2. Conceptual Models
3. Build a Logical Models
4. Physical Models
5. Primary Keys
6. Foreign Keys
7. Foreign Key Constraints
8. Normalization
9. First Normal Form (1NF)
10. Link Tables
11. Second Normal Form (2NF)
12. Third Normal Form (3NF)
13. Pragmatic Advice
14. Don't Model the Universe!
15. Forward Engineering a Model
16. Synchronizing a Model
17. Reverse Engineering

Chapter 13b Designing Databases(Projects)

1. Project: Flight Booking System
2. Project: Radio Rental Application
3. Creating Databases
4. Creating Tables
5. Altering Tables
6. Creating Relationships
7. Altering Primary/Foreign Key
8. Character Sets and Collations
9. Storage Engines

Chapter 14 Indexing for High Performance

1. Introduection
2. Indexes
3. Creating Indexes
4. Viewing Indexes
5. Prefix Indexes
6. Full-text Indexes
7. Composite Indexes
8. Order of Columns in Composite Indexes
9. When indexes are ignored
10. Using Indexes for Sorting
11. Covering Indexes
12. Index Maintanence

Chapter 15 Securing Databases

1. Creating a User
2. View Users
3. Dropping Users
4. Changing Passwords
5. Granting Privileges
6. Viewing Privileges
7. Dropping Privileges