MS SQL Server Course Layout

Introduction

• Overview
• Understanding databases
• Transact-SQL basics
• Microsoft SQL certification

Course Setup

• SQL Server 2012 evaluation
• SQL Server 2012 installation
• Windows 8 Server 2012 interface
• Windows 7 interface
• SQL Server sample database
• Attaching the sample database
• Installing SQL books online

SQL Server 2012 Interface

• Management studio basics
• Connecting to SQL Server
• Customizing SSMS
• Utilizing diagrams
• Saving diagrams
• Text and graphical tools
• Using sample code files
• About the semicolon

Database Objects And Data

• What are objects?
• Understanding tables
• Understanding data integrity
• Understanding data types
• Understanding primary keys
• Understanding constraints
• Understanding NULL
• Understanding views
• Understanding stored procedures
• Understanding triggers
• Understanding synonyms

Working With Tables

• Creating a table
• Graphical table creation
• Changing a table
• Graphical table alterations
• Deleting a table
• Graphical table deletion
• Creating a primary key

SQL Query Basics

• Four basic queries
• Thinking in SQL
• Options and more options
• Good query structure
• Comments
• The USE command
• The GO command

The Basic SELECT Statement

• SELECT basics
• SELECT structure
• Using WHERE
• Using TOP To Limit Rows
• Ordering results
• Working with NULLs
• T-SQL concatenation

Advanced SELECT Statements

• Column aliasing
• Using DISTINCT
• Using SUM
• Using AVG
• Using COUNT
• Using Group By
• Using HAVING
• SELECT INTO
• Using LIKE and IN
• Understanding UNION
• INTERSECT and EXCEPT
• Offset-fetch
• What is ranking?
• Using ranking

Using Joins

• Understanding joins
• Join query structure
• Creating inner joins
• Join creation through GUI
• Creating outer joins
• Creating cross joins

Modifying Data

• The INSERT statement
• Using INSERT
• The UPDATE statement
• Using UPDATE
• The DELETE statement
• Using DELETE

Using Subqueries

• Understanding subqueries
• Subquery Vs join