Microsoft SQL Server 2012 Certification Training Exam 70-461

Course Curriculum

Chapter 1: Introduction

Lecture 1: Important – Download These First – Working Files

Lecture 2: What To expect From This Course

Lecture 3: Course Overview

Lecture 4: Understanding Databases

Lecture 5: Transact-SQL Basics

Lecture 6: Microsoft SQL Certification

Lecture 7: How To Access Your Working Files

Chapter 2: Course Setup

Lecture 1: SQL Server 2012 Evaluation

Lecture 2: SQL Server 2012 Installation

Lecture 3: Windows 8 Server 2012 Interface

Lecture 4: Windows 7 Interface

Lecture 5: SQL Server Sample Database

Lecture 6: Attaching The Sample Database

Lecture 7: Getting Help

Lecture 8: Installing SQL Books Online

Chapter 3: SQL Server 2012 Interface

Lecture 1: Management Studio Basics

Lecture 2: Connecting To SQL Server

Lecture 3: Customizing SSMS

Lecture 4: Utilizing Diagrams

Lecture 5: Saving Diagrams

Lecture 6: Text And Graphical Tools

Lecture 7: Using Sample Code Files

Lecture 8: About the Semicolon

Chapter 4: Database Objects And Data

Lecture 1: 0401 What Are Objects?

Lecture 2: 0402 Understanding Tables

Lecture 3: 0403 Understanding Data Integrity

Lecture 4: 0404 Understanding Data Types

Lecture 5: 0405 Understanding Primary Keys

Lecture 6: 0406 Understanding Constraints

Lecture 7: 0407 Understanding NULL

Lecture 8: 0408 Understanding Views

Lecture 9: 0409 Understanding Stored Procedures

Lecture 10: 0410 Understanding Triggers

Lecture 11: 0411 Understanding Synonyms

Chapter 5: Working With Tables

Lecture 1: 0501 Creating A Table

Lecture 2: 0502 Graphical Table Creation

Lecture 3: 0503 Changing A Table

Lecture 4: 0504 Graphical Table Alterations

Lecture 5: 0505 Deleting A Table

Lecture 6: 0506 Graphical Table Deletion

Lecture 7: 0507 Creating A Primary Key

Chapter 6: SQL Query Basics

Lecture 1: 0601 Four Basic Queries

Lecture 2: 0602 Thinking In SQL

Lecture 3: 0603 Options And More Options

Lecture 4: 0604 Good Query Structure

Lecture 5: 0605 Comments

Lecture 6: 0606 The USE Command

Lecture 7: 0607 The GO Command

Chapter 7: The Basic SELECT Statement

Lecture 1: 0701 SELECT Basics

Lecture 2: 0702 SELECT Structure

Lecture 3: 0703 Using WHERE

Lecture 4: 0704 Using TOP To Limit Rows

Lecture 5: 0705 Ordering Results

Lecture 6: 0706 Working With NULLs

Lecture 7: 0707 T-SQL Concatenation

Chapter 8: Advanced SELECT Statements

Lecture 1: 0801 Column Aliasing

Lecture 2: 0802 Using DISTINCT

Lecture 3: 0803 Using SUM

Lecture 4: 0804 Using AVG

Lecture 5: 0805 Using COUNT

Lecture 6: 0806 Using Group By

Lecture 7: 0807 Using HAVING

Lecture 8: 0808 SELECT INTO

Lecture 9: 0809 Using LIKE And IN

Lecture 10: 0810 Understanding UNION

Lecture 11: 0811 INTERSECT And EXCEPT

Lecture 12: 0812 Using Synonyms – Part 1

Lecture 13: 0813 Using Synonyms – Part 2

Lecture 14: 0814 Offset-Fetch

Lecture 15: 0815 What Is Ranking?

Lecture 16: 0816 Using Ranking

Lecture 17: 0817 More Ranking Examples

Chapter 9: Using Joins

Lecture 1: 0901 Understanding Joins

Lecture 2: 0902 Join Query Structure

Lecture 3: 0903 Creating Inner Joins – Part 1

Lecture 4: 0904 Creating Inner Joins – Part 2

Lecture 5: 0905 Join Creation Through GUI

Lecture 6: 0906 Creating Outer Joins

Lecture 7: 0907 Creating Cross Joins

Chapter 10: Modifying Data

Lecture 1: 1001 The INSERT Statement

Lecture 2: 1002 Using INSERT – Part 1

Lecture 3: 1003 Using INSERT – Part 2

Lecture 4: 1004 The UPDATE Statement

Lecture 5: 1005 Using UPDATE

Lecture 6: 1006 The DELETE Statement

Lecture 7: 1007 Using DELETE – Part 1

Lecture 8: 1008 Using DELETE – Part 2

Chapter 11: Using Subqueries

Lecture 1: 1101 Understanding Subqueries

Lecture 2: 1102 Subquery Versus Join