Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online SQL courses).
Click here to download a sample of the first two chapters of this Introduction manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | The Four Stages of Database Design |
1.2 | Many-to-Many Relationships |
Section | Title |
---|---|
2.1 | Starting to Use Management Studio |
2.2 | Object Explorer |
Section | Title |
---|---|
3.1 | Creating the Database |
3.2 | Creating Tables |
3.3 | Setting an Identity Primary Key |
3.4 | Creating Columns |
3.5 | Whole Numbers |
3.6 | Other Numerical Fields |
3.7 | Character Data Types |
3.8 | Date/Time Data Types |
3.9 | Default and Null Values |
3.10 | Database Diagrams |
Section | Title |
---|---|
4.1 | Basic SELECT Statements |
4.2 | Creating Queries |
4.3 | Running Queries |
4.4 | Dealing with Errors |
4.5 | Using IntelliSense |
4.6 | Multiple SQL Commands |
4.7 | Saving, Opening and Closing Queries |
Section | Title |
---|---|
5.1 | Using Case |
5.2 | Indentation and Word Wrap |
5.3 | Comments |
5.4 | Colours in SQL |
5.5 | Auto-formatting SQL |
Section | Title |
---|---|
6.1 | SELECT Statement Syntax |
6.2 | Qualified Tables and Columns |
6.3 | Table Aliases |
6.4 | Column Aliases |
6.5 | Ordering Rows |
6.6 | Miscellaneous SELECT Tricks |
6.7 | Using UNION to Combine Results |
Section | Title |
---|---|
7.1 | Starting Query Designer |
7.2 | Using Query Designer |
7.3 | Editing Generated SQL |
7.4 | Advanced Features |
Section | Title |
---|---|
8.1 | The WHERE Clause |
8.2 | Criteria with Numbers |
8.3 | Criteria using Text |
8.4 | Criteria for Dates |
8.5 | Combining Criteria |
8.6 | Nulls |
Section | Title |
---|---|
9.1 | Copying and Pasting |
9.2 | Exporting Data |
Section | Title |
---|---|
10.1 | Creating Calculated Columns |
10.2 | Using SQL Functions |
10.3 | Casting Data Types |
10.4 | Numerical Calculations |
10.5 | Text Calculations |
10.6 | Dealing with Nulls |
10.7 | Testing Conditions using IIF |
Section | Title |
---|---|
11.1 | The Searched Case Expression |
11.2 | The Simple Case Statement |
11.3 | Nested CASE Statements |
Section | Title |
---|---|
12.1 | How Dates and Times Work |
12.2 | Formatting Dates using FORMAT |
12.3 | Formatting Dates using CONVERT |
12.4 | Parts of a Date: DATEPART and DATENAME |
12.5 | Getting the Difference between Dates |
12.6 | Calculating Ages Correctly |
12.7 | Adding Dates using DATEADD |
Section | Title |
---|---|
13.1 | Overview of Joins |
13.2 | Understanding your Database |
13.3 | Easy Joins, using Query Designer |
13.4 | Inner Joins |
13.5 | Outer Joins |
13.6 | Cross Joins |
13.7 | Self-Joins |
Section | Title |
---|---|
14.1 | Simple Summarising |
14.2 | Counting |
14.3 | Grouping |
14.4 | Filtering Results using HAVING |
14.5 | Casting Data for (eg) Averages |
14.6 | Dealing with Nulls |
14.7 | Additional Options when Grouping |
Section | Title |
---|---|
15.1 | Why Views are Useful |
15.2 | Views using the Designer |
15.3 | Scripting Views |
15.4 | Switching between the Designer and Scripting |
Section | Title |
---|---|
16.1 | Multi-Stage Queries |
16.2 | Derived Tables |
16.3 | Single CTEs (Common Table Expressions) |
16.4 | Multiple CTEs |
Section | Title |
---|---|
17.1 | Single-Value Subqueries |
17.2 | ANY, ALL, IN and NOT IN |
17.3 | Correlated Subqueries |
Section | Title |
---|---|
18.1 | Ranking and Numbering |
18.2 | Leading and Lagging |
18.3 | Percentiles |
Section | Title |
---|---|
19.1 | Choosing an AI Tool |
19.2 | Blind Queries |
19.3 | Querying a Specific Database |
19.4 | Formatting and Refactoring |
19.5 | Optimising Queries |
19.6 | Debugging SQL |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.