Introducing SQL: The Basics of Database Querying
(SQLINT, Live Instructor-Led Training, 2 days)


Description

This SETC certified course covers every aspect of the SQL language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the SQL language. We discuss the basic data manipulation statement of SQL together with the data modification statements of the language. With some basics under our belts, we are freed to look at more advanced topics like string and date time manipulation as well as the use of NULL values in tables and scripts. We also take the time to study joins and aggregated data along the way. It makes for a busy and rewarding 2 days.

Dates and Pricing


Jan 29 to Jan 30, 2018$1,150/person Feb 26 to Feb 27, 2018$1,150/person Mar 26 to Mar 27, 2018$1,150/person

Outline

Structured Query Language (SQL) Basics
Choosing data
Using the Where Clause
Ordering Data with the Order By Clause
Using Expressions
Working with Dates
Working with NULL Values
Working with Functions
Modifying Data
Using the INSERT Statement
Adding Table Records Using INSERT INTO
Using the UPDATE Statement
Using Update with Sub-Queries
Using the DELETE Statement
Working with Aggregate Data
Retrieving Aggregate Values with the Group By Clause
Using GROUP By with Order By and Where
Using TOP
Using CUBE and ROLLUP
Advanced Aggregate Operations
Joining Data
Database Integrity and Constraints
About Primary Keys and Foreign Keys
Performing an Inner Join
Performing an Outer Join
Performing a Cross Join
About Working with NULL Values
Performance Considerations: Indexes and Keys
Advanced SQL Querying
Creating and Using Views
Performance Considerations and Limitations
Creating and Using Simple Sub-Queries
Creating and Using Advanced Sub-Queries
Comparing Sub-Queries and Views: Which is Better?
A Note on Indexed/Stored Views
A Few Useful Scripts