Overview
-
Discover the top five skills to know in Microsoft SQL Server to manage data-driven insights more efficiently for your business.
Syllabus
-
Introduction
- Why data? The role of SQL and how you can get involved
- What you should know: Microsoft SQL Server and installation
- Environment orientation
- Tweaking your settings
- Loading the database file
- Getting familiar with your database
- The basic query structure
- Aliases and sorting
- Common mistakes
- The WHERE clause: Finding numeric data
- WHERE clause: Operators IN and BETWEEN
- The WHERE clause: Finding text data and using Wildcards
- The WHERE clause: Finding data using dates
- Introducing the AND and OR
- Challenge: The heist!
- Solution: The heist!
- Calculated columns
- The CASE statement
- Where to go from here?
