SQL Server Fundamentals: Master Basic Query Techniques

Introduction

• How can SQL answer your data questions?
• Introduction to CoderPad

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
• Solution: Filtering dates

3. Multiple Table Select Statements

• Inner joins
• Multiple inner joins
• Solution: Inner joins
• Outer joins
• Solution: Working with multiple tables
• Subqueries

4. Additional SQL Query Tools

• Case statements
• Solution: Case statement
• Built-in functions
• Aggregates
• Solution: Aggregates
• Query processing order

Conclusion

• Next steps