Subject Ⅰ Data

Understanding Modeling 1
Chapter 1: Understanding Data Modeling 3
Chapter 2: Data Models and SQL19

Subject II: SQL Basics and Applications 29

Chapter 1 SQL Basics 31
Chapter 2 Using SQL (5)
Chapter 3 Management Syntax 111

Subject III: Advanced SQL Utilization and Tuning 133

Chapter 1: SQL Execution Structure 135
Chapter 2 SQL Analysis Tools 145
Chapter 3 Index Tuning 151
Chapter 4 Join Tuning 1(5
Chapter 5: SQL Optimizer 175
Chapter 187 Advanced SQL Tuning
Chapter 7: Locks and Transaction Concurrency Control205
SQL Expert Practice Test 215
SQL Certification Exam Practice Questions Answers and Explanations 229