Top Five Things to Know in SQL

Introduction

• Why data? The role of SQL and how you can get involved
• What you should know: Microsoft SQL Server and installation
• Environment orientation
• Introduction to CoderPad

1. How to Optimize Your DB Software

• Tweaking your settings
• Loading the database file

2. Get Familiar with Your Database and Its Data

• Getting familiar with your database
• The basic query structure and using aliases
• Aliases and sorting
• Common mistakes
• Solution: Crafting queries

3. Understand Simple and Powerful Syntax to Filter and Analyze Data

• The WHERE clause: Finding numeric data
• The WHERE clause: Operators IN and BETWEEN
• The WHERE clause: Finding text data and using Wildcards
• The WHERE clause: Finding data using dates
• Solution: Date range and set analysis

4. Filter Data Based on More than One Condition

• Introducing AND and OR
• Solution: Filtering with logical operators

5. Analyze Data with Flexibility, Efficiency, and Calculated Fields

• Calculated columns
• The CASE statement
• Solution: Calculated columns and conditional logic

Conclusion

• Next steps