Introduction |
|
1 | (12) |
|
|
3 | (1) |
|
|
4 | (1) |
|
A Word of Encouragement for the Pure Beginner |
|
|
5 | (1) |
|
The Scope and Focus of This Book |
|
|
5 | (1) |
|
|
6 | (2) |
|
|
8 | (5) |
|
PART I CREATING YOUR SQL LEARNING ENVIRONMENT |
|
|
|
1 Understanding Database Structure |
|
|
13 | (20) |
|
|
13 | (3) |
|
Fundamental Elements of Relational Databases |
|
|
16 | (7) |
|
|
23 | (4) |
|
Relational Database Management Systems |
|
|
27 | (1) |
|
|
28 | (1) |
|
Queries, Statements, Clauses, and Keywords |
|
|
29 | (1) |
|
|
30 | (3) |
|
2 SQL Tools And Strategies |
|
|
33 | (6) |
|
Introducing the sTunes Database |
|
|
33 | (1) |
|
Introducing DB Browser for SQLite |
|
|
34 | (1) |
|
Installing DB Browser for SQLite |
|
|
34 | (1) |
|
How to Test Your SQL Knowledge |
|
|
34 | (1) |
|
|
35 | (4) |
|
3 Exploring A Database In Sqlite |
|
|
39 | (12) |
|
|
39 | (1) |
|
Opening the sTunes Database |
|
|
40 | (1) |
|
Investigating the Structure of the Database |
|
|
41 | (1) |
|
Viewing the Individual Records |
|
|
42 | (1) |
|
|
43 | (2) |
|
|
45 | (6) |
|
PART II WRITING SQL STATEMENTS |
|
|
|
4 Getting Started With Queries |
|
|
51 | (14) |
|
Adding Comments to Queries |
|
|
51 | (1) |
|
The Structure of a Basic Query |
|
|
52 | (1) |
|
|
53 | (3) |
|
Coding Syntax Versus Coding Convention |
|
|
56 | (1) |
|
Adding an Alias to Your Columns |
|
|
57 | (1) |
|
Using the ORDER BY Clause |
|
|
58 | (3) |
|
Selecting the Top Ten Records Using LIMIT |
|
|
61 | (1) |
|
|
62 | (3) |
|
5 Turning Data Into Information |
|
|
65 | (26) |
|
Comparison, Logical, and Arithmetic Operators |
|
|
66 | (1) |
|
Filtering Records by Numbers with the WHERE Clause |
|
|
67 | (5) |
|
Filtering Records by Text |
|
|
72 | (2) |
|
Using the LIKE Operator to Search for Wildcards |
|
|
74 | (3) |
|
Filtering Records by Date |
|
|
77 | (1) |
|
|
78 | (1) |
|
Using the AND and OR Operators with Two Separate Fields |
|
|
79 | (1) |
|
|
80 | (1) |
|
Using Parentheses with AND and OR to Specify the Order of Operations |
|
|
81 | (3) |
|
|
84 | (5) |
|
|
89 | (2) |
|
6 Working With Multiple Tables |
|
|
91 | (24) |
|
|
91 | (3) |
|
How Joins Interact with Relational Database Structure |
|
|
94 | (1) |
|
Using Joins with an Alias |
|
|
95 | (3) |
|
Join Types and Their Differences |
|
|
98 | (7) |
|
Inner Joins with More Than Two Tables |
|
|
105 | (3) |
|
Using Left Outer Joins with NULL, IS, and NOT |
|
|
108 | (3) |
|
Turning a Right Join into a Left Join |
|
|
111 | (2) |
|
|
113 | (2) |
|
|
115 | (30) |
|
Adding Calculations to Your Queries |
|
|
115 | (1) |
|
Types of Functions in SQL |
|
|
116 | (2) |
|
Manipulating Text Data with String Functions |
|
|
118 | (2) |
|
Concatenating Strings of Text |
|
|
120 | (2) |
|
|
122 | (3) |
|
Additional String Functions |
|
|
125 | (2) |
|
|
127 | (4) |
|
|
131 | (1) |
|
Nesting Functions with the ROUND () Function |
|
|
132 | (1) |
|
Using Aggregate Functions with the GROUP BY Clause |
|
|
133 | (2) |
|
Using the WHERE and HAVING Clauses with Grouped Queries |
|
|
135 | (3) |
|
The WHERE Clause Versus the HAVING Clause |
|
|
138 | (1) |
|
Using GROUP BY with Multiple Fields |
|
|
139 | (1) |
|
A Final Word on Functions |
|
|
140 | (1) |
|
|
140 | (5) |
|
PART III MORE ADVANCED SQL TOPICS |
|
|
|
|
145 | (12) |
|
Introduction to Subqueries Using Aggregate Functions |
|
|
145 | (2) |
|
Using a Subquery in the SELECT Statement |
|
|
147 | (2) |
|
Using a WHERE Clause in a Subquery |
|
|
149 | (1) |
|
Subqueries without Aggregate Functions |
|
|
150 | (1) |
|
Returning Multiple Values from a Subquery |
|
|
151 | (1) |
|
Subqueries and the DISTINCT Clause |
|
|
152 | (3) |
|
|
155 | (2) |
|
|
157 | (10) |
|
Turning Previous Queries into Views |
|
|
157 | (2) |
|
|
159 | (1) |
|
|
160 | (1) |
|
Creating a View from Joins |
|
|
160 | (3) |
|
Removing a View Using the DROP Statement |
|
|
163 | (1) |
|
|
164 | (3) |
|
10 Data Manipulation Language (DML) |
|
|
167 | (8) |
|
Data Analysis Versus Database Management |
|
|
167 | (1) |
|
Inserting Data into a Database |
|
|
168 | (3) |
|
Updating Data and the SET Keyword |
|
|
171 | (1) |
|
|
172 | (1) |
|
|
173 | (2) |
|
|
175 | (8) |
|
It Is All About Asking Good Questions |
|
|
175 | (1) |
|
|
175 | (1) |
|
Choosing the Right Database Occupation |
|
|
176 | (1) |
|
Is It All about the Money? |
|
|
176 | (1) |
|
Is SQL Knowledge Universal? |
|
|
177 | (1) |
|
|
178 | (1) |
|
Selling Your New Skills to Your Company |
|
|
178 | (1) |
|
Beyond SQL: Data Visualization Software |
|
|
179 | (1) |
|
|
179 | (1) |
|
|
180 | (1) |
|
Final Thoughts and Parting Words |
|
|
180 | (3) |
|
|
183 | (20) |
|
Chapter 3 Data Analysis Checkpoint |
|
|
183 | (1) |
|
Chapter 4 Data Analysis Checkpoint |
|
|
184 | (3) |
|
Chapter 5 Data Analysis Checkpoint |
|
|
187 | (3) |
|
Chapter 6 Data Analysis Checkpoint |
|
|
190 | (1) |
|
Chapter 7 Data Analysis Checkpoint |
|
|
191 | (2) |
|
Chapter 8 Data Analysis Checkpoint |
|
|
193 | (4) |
|
Chapter 9 Data Analysis Checkpoint |
|
|
197 | (2) |
|
Chapter 10 Data Analysis Checkpoint |
|
|
199 | (4) |
|
|
203 | (10) |
|
|
203 | (1) |
|
|
203 | (3) |
|
|
206 | (1) |
|
|
207 | (1) |
|
|
208 | (1) |
|
|
209 | (1) |
|
|
209 | (4) |
About The Author |
|
213 | (2) |
About Clydebank Media |
|
215 | (2) |
Glossary |
|
217 | (4) |
References |
|
221 | (2) |
Index |
|
223 | |