Teach Yourself SQL in 21 Days, Second Edition
Teach Yourself SQL in 21 Days, Second Edition
Introduction
Week 1 at a Glance
Day 1 Introduction to SQL
Day 2 Introduction to the Query: The SELECT Statement
Day 3 Expressions, Conditions, and Operators
Day 4 Functions: Molding the Data You Retrieve
Day 5 Clauses in SQL
Day 6 Joining Tables
Day 7 Subqueries: The Embedded SELECT Statement
Week 1 in Review
Week 2 at a Glance
Day 8 Manipulating Data
Day 9 Creating and Maintaining Tables
Day 10 Creating Views and Indexes
Day 11 Controlling Transactions
Day 12 Database Security
Day 13 Advanced SQL Topics
Day 14 Dynamic Uses of SQL
Week 2 in Review
Week 3 at a Glance
Day 15 Streamlining SQL Statements for Improved Performance
Day 16 Using Views to Retrieve Useful Information from the Data Dictionary
Day 17 Using SQL to Generate SQL Statements
Day 18 PL/SQL: An Introduction
Day 19 Transact-SQL: An Introduction
Day 20 SQL*Plus
Day 21 Common SQL Mistakes/Errors and Resolutions
Week 3 in Review