Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

lynda SQL for Non-Programmers

Video Introducing this tutorial


Introduction :
How can SQL answer your data questions?

1. Introduction to SQL Server and Relational Database Concepts :
What is SQL Server?
Understanding servers, databases, and tables
Relational database concepts
Surrogate, primary, and foreign keys

2. Single Table Select Statements :
SQL data types and nullability
Reading from a single table in SQL
Filtering on a single condition in SQL
Filtering on multiple conditions in SQL

3. Multiple Table Select Statements :
Inner joins
Multiple inner joins
Outer joins
Subqueries

4. Additional SQL Query Tools :
Case statements
Built-in functions
Aggregates
Query processing order

Conclusion :
Next steps