30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

MCSA: SQL Server 2012 Bundle Tutorial

This discounted bundle includes:
Microsoft SQL Server 2012 70-461
Duration: 12.25 Hours, 148 Lessons

Microsoft SQL Server 2012 70-462
Duration: 11.75 hours, 109 Lessons

Microsoft SQL Server 2012 70-463
Duration: 7 hours, 61 Lessons
A professionally created, self-study video training course
Includes 31 hours of easy to follow MCSA: SQL Server 2012 Bundle video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample MCSA: SQL Server 2012 Bundle tutorial videos by clicking a blue link below:
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Contents from the SQL Server Certification 70-461 Exam
Introduction
What To Expect From This Course
Course Overview
Understanding Databases
Transact-SQL Basics
Microsoft SQL Certification
How To Access Your Working Files

Course Set Up
SQL Server 2012 Evaluation
SQL Server 2012 Installation
Windows 8 Server 2012 Interface
Windows 7 Interface
SQL Server Sample Database
Attaching The Sample Database
Getting Help
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
Using Synonyms - Lesson 1
Using Synonyms - Lesson 2
Offset-Fetch
What Is Ranking?
Using Ranking
More Ranking Examples

Using Joins
Understanding Joins
Join Query Structure
Creating Inner Joins - Lesson 1
Creating Inner Joins - Lesson 2
Join Creation Through GUI
Creating Outer Joins
Creating Cross Joins

Modifying Data
The INSERT Statement
Using INSERT - Lesson 1
Using INSERT - Lesson 2
The UPDATE Statement
Using UPDATE
The DELETE Statement
Using DELETE - Lesson 1
Using DELETE - Lesson 2

Using Subqueries
Understanding Subqueries
Subquery Versus Join
Creating A Scalar Subquery
Creating A Multi-Valued Subquery
Creating A Correlated Subquery

Advanced Table Utilization
Utilizing Memory
What Is A Derived Table?
Creating A Derived Table
Table Variables - Lesson 1
Table Variables - Lesson 2
Common Table Expressions
Temporary Tables

Programmability
Programmability In T-SQL
What Is A Stored Procedure?
Why Use Stored Procedures?
A Simple Stored Procedure
Input Parameters
Multiple Input Parameters
Output Parameters - Lesson 1
Output Parameters - Lesson 2
Using Case Logic - Lesson 1
Using Case Logic - Lesson 2
Handling Errors
Stored Procedure Security
Working With Functions
Using Built-In Functions
Creating A Scalar Function
Creating A Table Valued Function
What Is Dynamic SQL?
Dynamic SQL Example
Understanding GUIDs
GUID Examples - Lesson 1
GUID Examples - Lesson 2

Triggers
Using Triggers
Inserted And Deleted Tables
Trigger Examples - Lesson 1
Trigger Examples - Lesson 2

Transactions In T-SQL
What Are Transactions?
Understanding Concurrency
Explicit And Implicit Transactions
Cross Platform Concerns
Transaction And Locking Example

Under The Hood
Using Metadata
Using Catalog Views
Using Information Schema Views
Using System Stored Procedures

Working With XML
XML Basics
Outputting XML From Queries
Using FOR XML RAW
Using FOR XML AUTO
Using FOR XML PATH

Optimizing Queries
Optimization Basics
Query Execution Plans - Lesson 1
Query Execution Plans - Lesson 2
SQL Server Extended Events - Lesson 1
SQL Server Extended Events - Lesson 2
SQL Server Profiler

Taking The Exam
Exam Basics
Taking Your Exam
When It Is Over

Conclusion
Wrap-Up
About The Author
Contents from the SQL Server Certification 70-462 Exam
Introduction
What Is Exam 70-462?
What You Should Expect From The Videos

Installation And Configuration
Growing And Shrinking Databases
Monitoring Database Growth
Designing Database Storage
Configure An SQL Server Standby Server - Lesson 1
Configure An SQL Server Standby Server - Lesson 2
Changing Service Accounts
Testing Database Connectivity
Installing SQL Server Database Engine - Lesson 1
Installing SQL Server Database Engine - Lesson 2
Installing SQL Server Database Engine - Lesson 3
Installing SQL Server Database Engine - Lesson 4
Installing SQL Server Integration Services
Enabling And Disabling Features
Moving Databases Via Detach/Attach
Migrating Logins
Creating A Full Text Index
Configuring FILESTREAM
Configuring FILETABLE
Create And Manage SQL Agent Jobs - Lesson 1
Create And Manage SQL Agent Jobs - Lesson 2
Setup Multi-Server Jobs

Maintain Instances And Databases
Using Multiple Files And Filegroups
Recovery Models
Adding New Filegroups
Moving Tables Between Filegroups
Enabling Contained Databases
Data Compression
Configuring TDE
Setting Up Table Partitioning - Lesson 1
Setting Up Table Partitioning - Lesson 2
Managing Log File Growth - Lesson 1
Managing Log File Growth - Lesson 2
DBCC CHECKDB
Installing Default And Named Instances - Lesson 1
Installing Default And Named Instances - Lesson 2
CPU Affinity
Instance Level Settings - Lesson 1
Instance Level Settings - Lesson 2
Instance Level Settings - Lesson 3
Memory Settings
Database Mail
Fillfactor
Installing A Clustered Instance - Lesson 1
Installing A Clustered Instance - Lesson 2
Installing A Clustered Instance - Lesson 3
Installing A Clustered Instance - Lesson 4
Multi-Instance Clustering
Multi-Subnet Clustering
Recover From A Failed Cluster Node

Optimization And Troubleshooting
Replication For Reporting - Lesson 1
Replication For Reporting - Lesson 2
Replication For Reporting - Lesson 3
Replication For Reporting - Lesson 4
Diagnosing Locking And Blocking - Lesson 1
Diagnosing Locking And Blocking - Lesson 2
Diagnosing Wait Stats
Using SQL Profiler
Using Performance Monitor - Lesson 1
Using Performance Monitor - Lesson 2
Using Extended Events
Using SQL Server Auditing
Using Data Collector
Using Policy Based Management

Manage Data
Define Recovery Models
Mirrored Backups
Stripped Backups
Restoring Full Backups
Restoring Differential Backups
Restoring Transaction Log Backups
File Group Restores
Testing Backups
Restoring Master Database
Restoring msdb Database
Restoring model Database
Restoring Databases Protected By TDE
Restoring A Single Database Page
Point In Time Restores
Index Maintenance
Identifying Index Fragmentation
Identifying Unused Indexes
Filtered Indexes
Updating Statistics
Full Text Indexes
Column Store Indexes
Import Export Wizard
BCP
Bulk Insert

Implement Security
Logins VsUsers
Creating Logins
Fixed Server Roles
User Defined Server Roles
Certificate Logins
Instance Level Permissions
Database Level Permissions
Fixed Database Roles
User Defined Database Roles
Application Roles
Creating Database Users
Managing Certificates
Endpoint Security

Implement High Availability
Configure Database Mirroring
Configure AlwaysOn Availability Groups - Lesson 1
Configure AlwaysOn Availability Groups - Lesson 2
Failing Over Database Mirroring
Failing Over AlwaysOn Availability Groups
Monitoring Database Mirroring

Conclusion
About The Tutor
Thank You
Contents from the SQL Server Certification 70-463 Exam
Introduction Data Warehousing 2012
What You Will Learn
Data Warehouse Concepts And Architecture
Data Warehouse Solutions

Data Warehouse Hardware
Data Warehouse Challenges - Memory
Data Warehouse Challenges - Physical
Data Warehouse Architectures
Data Warehouse Appliances

Designing And Implementing A Data Warehouse
Data Warehouse Logical Design
Data Warehouse Physical Design
Exercise: Implementing A Data Warehouse Schema
Solution For Implementing A Data Warehouse Schema

Design And Implement A Data Warehouse Schema
ETL And SSIS
Defining A Data Source
Implementing A Data Flow - Lesson 1
Implementing A Data Flow - Lesson 2
Exercise: Implementing A SSIS Package
Solution For Implementing A SSIS Package

Control Flows And SSIS Package
Introduction To Control Flows
Dynamic Packages
Defining Containers - Lesson 1
Defining Containers - Lesson 2
Manage Consistency
Exercise: Implement Control Flows In SSIS
Solution For Implementing Control Flow SSIS

Debugging And Troubleshooting SSIS Packages
Debugging SSIS
Error Log Providers
Error Handling And SSIS - Lesson 1
Error Handling And SSIS - Lesson 2
Exercise: Debugging And Troubleshooting SSIS
Solution For Debugging And Troubleshooting SSIS

Incremental ETL Process
Introduction To Incremental ETL Processes
Extract Modified Data - Lesson 1
Extract Modified Data - Lesson 2
Load Modified Data
Exercise: Load Incremental Data
Solution For Incremental Load

Enforcing Data Quality
Data Cleansing
Data Quality Services
Data Quality Services And Matching Data
Exercise Cleansing Data
Solution For Cleansing Data
Exercise: De-Duplicating Data
Solution For De-Duplicating Data

Master Data Services
What Is Master Data Services
Implementing Master Data Services
Excel Add-In For Master Data Services

Extending SSIS
Custom SSIS Components
Scripting And SSIS - Lesson 1
Scripting And SSIS - Lesson 2

Deploying SSIS Packages
Overview Of SSIS Deployment
Deploying SSIS Packages - Lesson 1
Deploying SSIS Packages - Lesson 2
Planning SSIS Package Execution
Exercise: Deploying An SSIS Package
Solution For Deploying SSIS Package

Consuming Data
Data Warehouse Using Excel
Using PowerPivot And Data Warehouse
Data Warehouse And SSRS
Exercise: Using Excel And PowerPivot
Solution For Excel And PowerPivot

About The Tutor
Learn About Me
  • Tutor: Various
  • Duration: 31 hours
  • Video lessons: 318
  • Product code: 01874
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 3rd December 2013
Join seasoned Microsoft SQL trainers Mark Long, Denny Cherry and Steve Hamilton as they show you everything you need to know to prepare for and pass the 70-461, 70-462, and 70-463 exams with the ultimate aim of helping you earn your Microsoft Certified Solutions Associate certification. AKA the MCSA.

Starting each course from the basics and acting as an essential exam guide, the respective trainer uses step by step training videos that explain and demonstrate core exam material along with surrounding IT disciplines, which will help you prepare and give you huge confidence for the day of your tests.

All three exam courses include the same working files as the the instructors use, which allows you to easily keep pace and follow along with the concepts being taught.

The first exam (70-461, Querying Microsoft SQL Server 2012) will show you the best way to work in the user interface and the best practices for creating and altering tables using T-SQL. Once the basic principles have been explained, you will learn about the SELECT statement, understanding subqueries, querying: SQL basics, making use of triggers, how to optimize queries, troubleshooting techniques and so much more.

The 70-462 tuition (Administering Microsoft SQL Server 2012 Databases) commences with an overview of the installation and configuration of the SQL server and how best to manage your data. The course then moves onto lessons on automation techniques, how to manage SQL Server, security considerations explained, best practices for backup and recovery and so more.

The instruction for the 70-63 exam (Implementing a Data Warehouse) demonstrates the steps involved in how to design and implement a data warehouse and the principles of load data. You will also learn extracting and transforming data, the steps involved in enforcing data quality, how to ensure data quality and so much more.

The full course contents for all three titles are listed below and you can take your first steps in achieving your MCSA: SQL Server 2012 certification right away. Click any of the blue linked lessons to access the free sample videos and discover how effective this practical teaching is...
What Our Customers Are Saying

"Your training cds have been invaluable and i am going to be ordering some more. I have developed new skills really fast at a low cost. Once again, thanks a lot."Andrew Fast, Freelance Photographer
 
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
 
  Item(s):
   
Once purchased, you will receive 318 MCSA: SQL Server 2012 Bundle training videos (listed left), lasting a total of 31 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This MCSA: SQL Server 2012 Bundle course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this MCSA: SQL Server 2012 Bundle course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
See our complete range of Beginners Networking Tutorials
See our complete range of CompTIA A+ Tutorials
See our complete range of Beginners HTML Tutorials
See our complete range of Java Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of MCSA: SQL Server 2012 Bundle. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"I'm very happy that i bought this training for Pro Tools. Before i purchased this, i was very undecided what to buy, there are so many out there. But I'm glad that i decided on this one, it's very nice & clear, and above all his sense of humor...I would defiantly recommend this to other people."Solomon Wechter, New York