SQL for Non-Programmers

This course provides a straightforward, concise resource for non-developers to learn enough about relational databases and SQL syntax to write simple queries.

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