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

299 USD 18.99 USD 94%
Test scorm

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012. 

read more

Module 1

  • Course Introduction
  • Course Modules
  • Introduction to SQL Server 2012
  • SQL Server Instances
  • SQL Server Editions and Licensing
  • SQL Server Objects
  • System Databases
  • SQL Server Management Studio
  • SSMS Components
  • SQL Server Data Tools
  • SQLCMD
  • Working with SSMS
  • Working with SQLCMD
  • Exam Scenarios
  • Module Review

Module 2

  • Introduction to Databases
  • Database Files
  • Temp db
  • Working with Databases
  • Introduction to Filegroups and Files
  • 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
  • Exam Scenarios
  • Module Review

Module 3

  • Introduction to Data Types and Tables
  • Supported Data Types
  • Collations and Unicode Characters
  • Introduction to NULLS
  • Converting Data Types
  • Introduction to Tables
  • Normalization
  • Temporary Tables
  • Working with Tables
  • Schemas
  • Primary and Foreign Keys
  • UNIQUE Constraint/Index
  • Data Types in SQL Server Demonstration
  • Working with Tables Demonstration
  • Exam Scenarios
  • Module Review

Module 4

  • SQL Server Indexing
  • Introduction to Indexing
  • Heaps
  • Clustered Indexes
  • Non-Clustered Indexes
  • Maintaining Indexes
  • Index Fragmentation
  • SQL Server Profiler
  • Index Tuning
  • Working with Indexes Demonstration
  • SQL Server Tuning Advisor Demonstration
  • Exam Scenarios
  • Module Review

Module 5

  • Performance Considerations
  • Partitioning Function
  • Partition Scheme
  • Partitioned Table or Index
  • Introduction to Transaction
  • Implicit and Explicit Transactions
  • Locking
  • Working with Partition Tables, Transaction and Locks
  • Exam Scenarios
  • Module Review

Module 6

  • Backup and Restore
  • Database Data and Log Files
  • Recovery Model
  • Database Backups Types
  • Backup Compression and Mirrored Media Sets
  • Verifying Backups
  • Restoration Process
  • Restoring Backup Types
  • Restoring to a Point in Time
  • WITH STANDBY
  • Restoring a Database
  • Restoring System Databases
  • Restoring the Master Database
  • Backing Up and Restoring SQL Server
  • Exam Scenarios
  • Module Review

Module 7

  • Views and Functions
  • 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
  • Exam Scenarios
  • Module Review

Module 8

  • Stored Procedures and Triggers
  • Types of Stored Procedures
  • Parameters
  • Stored Procedure Compilation
  • Execution Context
  • Introduction to Triggers
  • Types of Triggers
  • Nested and Recursive Triggers
  • Trigger Firing Order
  • Working with Stored Procedures and Triggers
  • Exam Scenarios
  • Module Review

Module 9

  • SQL Server Security
  • SQL Authentication
  • SQL Logins
  • Accessing a Database
  • Authorization Across Servers
  • Server Roles
  • Database Roles
  • Application Roles
  • Authorizing Access
  • Configuring Access Using Schemas
  • Working with SQL Security
  • Exam Scenarios
  • Module Review

Module 10

  • Installing and Upgrading SQL
  • Server Resources
  • 32 vs. 64 Bit
  • SQL Requirements
  • Software Requirements
  • Collations
  • Service Accounts
  • Installing SQL Server
  • Troubleshooting Installation
  • Upgrading SQL Server
  • Unattended Installations
  • Exam Scenarios
  • Module Review
  • Course Review
  1. Module 1
6
Start
SQL Server Editions and Licensing
7
Start
SQL Server Objects
8
Start
System Databases
9
Start
SQL Server Management Studio
10
Start
SSMS Components
10
Start
SSMS Components
11
Start
SQL Server Data Tools
12
Start
SQLCMD
13
Start
Working with SSMS
13
Start
Working with SSMS
14
Start
Working with SQLCMD
15
Start
Exam Scenarios
16
Start
Module Review
  1. Module 2
17
Start
Module 2: Introduction to Databases
17
Start
Module 2: Introduction to Databases
18
Start
Database Files
18
Start
Database Files
19
Start
Temp db
20
Start
Working with Databases
21
Start
Introduction to Filegroups and Files
21
Start
Introduction to Filegroups and Files
22
Start
Introduction to Log Files
23
Start
Transactions
24
Start
Moving Databases
25
Start
Detaching and Attaching Databases
26
Start
Backing Up and Restoring Databases
27
Start
Copy Database Wizard
28
Start
Database Catalog View
29
Start
Creating and Configuring Databases
29
Start
Creating and Configuring Databases

Good Coarse thank you

by Mbiganyi Kitsi

Add New Discussion

How do you rate this product?

Select currency