動画検索
関連広告
検索結果
Introduction
What is SQL?
Installing MySQL on Mac
Installing MySQL on Windows
The SELECT Statement
The WHERE Clause
The AND, OR, and NOT Operators
The BETWEEN Operator
The REGEXP Operator
The IS NULL Operator
The LIMIT Operator
Inner Joins
Self Joins
Compound Join Conditions
Implicit Join Syntax
Outer Join Between Multiple Tables
The USING Clause
Natural Joins
Unions
Column Attributes
Inserting Multiple Rows
Creating a Copy of a Table
Updating a Single Row
Using Subqueries in Updates
Restoring Course Databases
0. SQL is King
1. The Legend of Ted Codd
2. ORM Magic
3. What is a RDBMS?
4. Draw SQL Diagrams
5. Schemas, Datatypes, & Constraints
6. Be Normalized
7. Install MySQL on Windows/Mac
8. Create a New Database
9. SQLTools VS Code Extension
10. --comments
11. Basic SQL Syntax
12. Primary Key
13. Varchar vs Text
14. INSERT New Data
15. Read or SELECT Data
16. LIMIT & ORDER
17. Filtering with WHERE
18. LIKE pattern matching
19. INDEX for read speed
20. JOIN a relationship
21. Alias AS
22. JOIN through a middle man
23. DROP a video
Introduction
How to create an AWS EC2 Instance
How to install MySQL database
Data Modeling
SQL Basics - Creating a Table
SQL Basics - Inserting data
SQL Basics - Updating and Deleting Data
SQL Basics - Reading data (Select statements)
SQL Joins
Transaction Isolation Levels
Table Level Locks
Row Level Locks
Database Deadlocks
Clustered Indexes
SQL Explain