Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Training Course

This course is designed to measure the knowledge and skills of participants in making suitable career choices in developing Microsoft SQL Server 2012 Databases. It is intended for Database professionals who design and build database solutions.

Subscribe to this course +

USD 50

Subscribe Now

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

The Microsoft 70-465 course prepares you to pass the Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012 exam which validates your ability to create and alter tables, design, implement, and troubleshoot security, collect performance and system information and other related activities. This course is suitable for IT professionals and anyone aspiring for a Microsoft certification.

1-year access to audio-video lectures
GreyCampus course completion certificate

Course Outline

Designing Database Solutions for Microsoft SQL Server 2012

Course Introduction

Course Modules
Introduction to SQL Server 2012

Introduction Part1

Introduction Part2

SQL Server Instances

SQL Server Editions and Licensing

SQL Server Objects

System Databases

SQL Server Management Studio

SSMS Components Part1

SSMS Components Part2

SQL Server Data Tools

SQLCMD

Working with SSMS Part1

Working with SSMS Part2

Working with SQLCMD

Exam Scenarios

Module Review

465_01_01_02h

465_01_06_01h
Introduction to Databases

Introduction Part1

Introduction Part2

Database Files Part1

Database Files Part2

Temp db

Working with Databases

Introduction to Filegroups and Files Part1

Introduction to Filegroups and Files Part2

Introduction to Log Files

Transactions

Moving Databases

Detaching and Attaching Databases

Backing Up and Restoring Databases

Copy Database Wizard

Database Catalog View

Creating and Configuring Databases Part1

Creating and Configuring Databases Part2

Exam Scenarios

Module Review

465_02_08_01h
Introduction to Data Types and Tables

Introduction Part1

Introduction Part2

Supported Data Types

Collations and Unicode Characters Part1

Collations and Unicode Characters Part2

Introduction to NULLS

Converting Data Types

Introduction to Tables Part1

Introduction to Tables Part2

Normalization

Temporary Tables

Working with Tables

Schemas

Primary and Foreign Keys Part1

Primary and Foreign Keys Part2

Primary and Foreign Keys Part3

UNIQUE Constraint/Index

Data Types in SQL Server Demonstration Part1

Data Types in SQL Server Demonstration Part2

Working with Tables Demonstration Part1

Working with Tables Demonstration Part2

Exam Scenarios Part1

Exam Scenarios Part2

Module Review

SQL Server Indexing

Introduction Part1

Introduction Part2

Introduction to Indexing

Heaps

Clustered Indexes

Non-Clustered Indexes Part1

Non-Clustered Indexes Part2

Non-Clustered Indexes Part3

Maintaining Indexes Part1

Maintaining Indexes Part2

Index Fragmentation

SQL Server Profiler

Index Tuning

Working with Indexes Demonstration Part1

Working with Indexes Demonstration Part2

Working with Indexes Demonstration Part3

SQL Server Tuning Advisor Demonstration Part1

SQL Server Tuning Advisor Demonstration Part2

Exam Scenarios

Module Review

465_04_10_02c
Performance Considerations

Introduction Part1

Introduction Part2

Partitioning Function

Partition Scheme

Partitioned Table or Index

Introduction to Transaction

Implicit and Explicit Transactions

Locking

Working with Partition Tables, Transaction & Locks Part1

Working with Partition Tables, Transaction & Locks Part2

Working with Partition Tables, Transaction & Locks Part3

Exam Scenarios

Module Review

465_05_05_01h
Backup and Restore

Introduction Part1

Introduction Part2

Database Data and Log Files Part1

Database Data and Log Files Part2

Recovery Model

Database Backups Types Part1

Database Backups Types Part2

Database Backups Types Part3

Database Backups Types Part4

Database Backups Types Part5

Backup Compression and Mirrored Media Sets

Verifying Backups

Restoration Process

Restoring Backup Types Part1

Restoring Backup Types Part2

Restoring Backup Types Part3

Restoring to a Point in Time

WITH STANDBY

Restoring a Database

Restoring System Databases

Restoring the Master Database

Backing Up and Restoring SQL Server Part1

Backing Up and Restoring SQL Server Part2

Backing Up and Restoring SQL Server Part3

Backing Up and Restoring SQL Server Part4

Exam Scenarios

Module Review

465_06_14_02c
Views and Functions

Introduction Part1

Introduction Part2

Introduction Part3

Types Of Views

Creating and Altering Views

Updatable and Indexed Views

Partitioned Views

Introduction to Functions

Function Types

Scalar and Table Valued Functions

Working with Views and Functions Part1

Working with Views and Functions Part2

Working with Views and Functions Part3

Exam Scenarios

Module Review

465_07_01_02h
Stored Procedures and Triggers

Introduction Part1

Introduction Part2

Introduction Part3

Types of Stored Procedures

Parameters

Stored Procedure Compilation

Execution Context Part1

Execution Context Part2

Introduction to Triggers Part1

Introduction to Triggers Part2

Types of Triggers

Nested and Recursive Triggers

Trigger Firing Order

Working with Stored Procedures & Triggers Part1

Working with Stored Procedures & Triggers Part2

Exam Scenarios

Module Review

465_08_03_01h
SQL Server Security

Introduction Part1

Introduction Part2

SQL Authentication

SQL Logins

Accessing a Database

Authorization Across Servers

Server Roles

Database Roles

Application Roles

Authorizing Access Part1

Authorizing Access Part2

Configuring Access Using Schemas

Working with SQL Security Part1

Working with SQL Security Part2

Exam Scenarios

Module Review
Installing and Upgrading SQL

Introduction Part1

Introduction Part2

Server Resources Part1

Server Resources Part2

32 vs. 64 Bit

SQL Requirements

Software Requirements

Collations

Service Accounts

Installing SQL Server

Troubleshooting Installation

Upgrading SQL Server Part1

Upgrading SQL Server Part2

Unattended Installations

Exam Scenarios

Module Review

Course Review

465_10_11_01h