Course and Instructor Introduction
- Course and Instructor Introduction
Laying out the foundation - Overview & Installation
- Pre-requisites & Different Editions of SQL Server
- Learn SQL Server : New location for Adventure Works Database download
- Downloading Express Edition & sample database
- Installing the downloads & Configuration
- The sa Login
- Wrap up - what we went over !
- Quiz - Section 2
Core concepts - Taming the RDBMS beast !
- What is RDBMS ?
- Where does SQL Server fit in ?
- Basic database objects
- Different Files that got installed - MDF & LDF
- Wrap up - what we went over !
Tool of the trade - SQL Server Management Studio
- Getting started with SSMS
- Getting around Object Explorer
- Query Window
- Pre built DB - system database
- Wrap up - what we went over !
Simple SELECT
- Bare Minimum : SELECTING a literal
- Retrieving / Querying data from a table - using FROM clause
- Playing with Column Names
- Rearranging columns to your liking
- Wrap up - what we went over !
Filtering out unwanted data
- Narrowing down and ordering result set - WHERE and ORDER clause
- Narrowing down result set - BETWEEN / NOT BETWEEN
- Narrowing down result set - IN and NOT IN operator
- Narrowing down result set - Pattern Matching : LIKE and Wildcards
- Wrap up - what we went over !
Expressions and Functions
- Dealing with nothing : NULL
- Working with strings : Concatenation and other string functions
- Working with dates : Date Functions
- Some System Functions
- Wrap up - what we went over !
Getting data out of multiple tables
- Joining multiple tables - INNER JOIN
- Join types - OUTER JOIN - LEFT / RIGHT / FULL
- Join types - CROSS JOIN
- Holy UNION !
- A bite of Sub…….queries
- Wrap up - what we went over !
Summarizing and Grouping data
- DISTINCT and ALL Predicates
- Aggregate Functions
- GROUP BY clause / HAVING clause
- WHERE and ORDER BY in aggregate queries
- Wrap up - what we went over !
Bonus
- Bonus
- Learn Microsoft SQL Server : Useful Links
