SQL Fundamentals Student Manual
C o n t e n t s
Introduction iii
Topic A: About the manual............................................................................... iv
Topic B: Setting your expectations...................................................................vii
Topic C: Re-keying the course ......................................................................... ix
Introducing SQL 1-1
Topic A: Understanding Microsoft SQL ......................................................... 1-2
Topic B: Exploring Microsoft SQL................................................................. 1-6
Unit summary: Introducing SQL...................................................................... 1-9
Retrieving data from a table 2-1
Topic A: Selecting rows................................................................................... 2-2
Topic B: Summarizing data ............................................................................ 2-10
Unit summary: Retrieving data from a table ................................................... 2-17
Using operators 3-1
Topic A: Using logical operators..................................................................... 3-2
Topic B: Using list operators........................................................................... 3-5
Topic C: Using string operators....................................................................... 3-7
Unit summary: Using operators ...................................................................... 3-10
Using functions 4-1
Topic A: Using string functions....................................................................... 4-2
Topic B: Using date functions ......................................................................... 4-4
Unit summary: Using functions ....................................................................... 4-8
Using joins 5-1
Topic A: Joining tables .................................................................................... 5-2
Topic B: Using advanced joins........................................................................ 5-5
Unit summary: Using joins............................................................................... 5-8
Using subqueries 6-1
Topic A: Using subqueries............................................................................... 6-2
Unit summary: Using subqueries ..................................................................... 6-5
Course summary S-1
Topic A: Course summary ...............................................................................S-2
Topic B: Continued learning after class ..........................................................S-3
Quick reference Q-1
Index I-1
SKU | AX0619022906 |
---|---|
Weight | 0.5100 |
Coming Soon | No |
Days of Training | 1 |
Audience | Student |
Product Family | Axzo |
Product Type | Print Courseware |
Electronic | No |
ISBN | 619022906 |
Language | English |
Page Count | 82 |
Curriculum Library | No |
Year | No |
Manufacturer's Product Code | No |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2014-03-22 00:00:00 |