Express.js Routing
Lectures 34 • 40 slides
Narration
Slide 1: Welcome to Applied SQL
mindmap
root((Applied SQL))
Subqueries
Scalar
Row
Table
CTE
Indexes
B-Tree
Composite
EXPLAIN
Transactions
ACID
Locking
Isolation Level
Course Overview
- Advanced version of the 34th session, "SQL Basics"
- Learn more advanced queries and optimization techniques
Learning Content for the 35th Session
- How to use and the types of subqueries
- The mechanism and creation of indexes
- How to read execution plans (EXPLAIN)
- Transactions and ACID properties
- Locking and Isolation Levels
Skills You Will Acquire
- Implementation of complex data retrieval
- Query performance optimization
- Ensuring data integrity
1/40