Learning MS SQL Server 2012 Cert Exam (70-461,462,463) Video Training (3 DVDs) For Sale

Learning MS SQL Server 2012 Cert Exam (70-461,462,463) Video Training (3 DVDs)


This item has been shown 19 times.

Buy Now

Learning MS SQL Server 2012 Cert Exam (70-461,462,463) Video Training (3 DVDs):
$20

*** Learning Microsoft SQL Server 2012 Cert Exam (070-461,462,463) Video Training (3 DVDs) ***

 

1. This is the most comprehensive and only tutorial you will ever need.2. Includes tutorials for absolutely every aspect of understanding Microsoft SQL Server 2012 Cert Exam (070-461,462,463).3. Learn at your own pace and achieve personal satisfaction when you have perfected your task. 4. This DVD is only suitable for a PC/laptop/Mac; it WILL NOT play on a TV (VLC Media Player will need to be installed to enable use on a Mac).
 


Table of Content:
01. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Introduction
0101 What To Expect From This Course
0102 Course Overview
0103 Understanding Databases
0104 Transact-SQL Basics
0105 Microsoft SQL Certification
0106 How To Access Your Working Files 02. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Course Setup
0201 SQL Server 2012 Evaluation
0202 SQL Server 2012 Installation
0203 Windows 8 Server 2012 Interface
0204 Windows 7 Interface
0205 SQL Server Sample Database
0206 Attaching The Sample Database
0207 Getting Help
0208 Installing SQL Books Online 03. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - SQL Server 2012 Interface
0301 Management Studio Basics
0302 Connecting To SQL Server
0303 Customizing SSMS
0304 Utilizing Diagrams
0305 Saving Diagrams
0306 Text And Graphical Tools
0307 Using Sample Code Files
0308 About The Semicolon 04. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Database Objects And Data
0401 What Are Objects?
0402 Understanding Tables
0403 Understanding Data Integrity
0404 Understanding Data Types
0405 Understanding Primary Keys
0406 Understanding Constraints
0407 Understanding NULL
0408 Understanding Views
0409 Understanding Stored Procedures
0410 Understanding Triggers
0411 Understanding Synonyms 05. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Working With Tables
0501 Creating A Table
0502 Graphical Table Creation
0503 Changing A Table
0504 Graphical Table Alterations
0505 Deleting A Table
0506 Graphical Table Deletion
0507 Creating A Primary Key 06. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - SQL Query Basics
0601 Four Basic Queries
0602 Thinking In SQL
0603 Options And More Options
0604 Good Query Structure
0605 Comments
0606 The USE Command
0607 The GO Command 07. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - The Basic SELECT Statement
0701 SELECT Basics
0702 SELECT Structure
0703 Using WHERE
0704 Using TOP To Limit Rows
0705 Ordering Results
0706 Working With NULLs
0707 T-SQL Concatenation 08. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Advanced SELECT Statements
0801 Column Aliasing
0802 Using DISTINCT
0803 Using SUM
0804 Using AVG
0805 Using COUNT
0806 Using Group By
0807 Using HAVING
0808 SELECT INTO
0809 Using LIKE And IN
0810 Understanding UNION
0811 INTERSECT And EXCEPT
0812 Using Synonyms - Part 1
0813 Using Synonyms - Part 2
0814 Offset-Fetch
0815 What Is Ranking?
0816 Using Ranking
0817 More Ranking Examples 09. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Using Joins
0901 Understanding Joins
0902 Join Query Structure
0903 Creating Inner Joins - Part 1
0904 Creating Inner Joins - Part 2
0905 Join Creation Through GUI
0906 Creating Outer Joins
0907 Creating Cross Joins 10. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Modifying Data
1001 The INSERT Statement
1002 Using INSERT - Part 1
1003 Using INSERT - Part 2
1004 The UPDATE Statement
1005 Using UPDATE
1006 The DELETE Statement
1007 Using DELETE - Part 1
1008 Using DELETE - Part 2 11. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Using Subqueries
1101 Understanding Subqueries
1102 Subquery Versus Join
1103 Creating A Scalar Subquery
1104 Creating A Multi-Valued Subquery
1105 Creating A Correlated Subquery 12. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Advanced Table Utilization
1201 Utilizing Memory
1202 What Is A Derived Table?
1203 Creating A Derived Table
1204 Table Variables - Part 1
1205 Table Variables - Part 2
1206 Common Table Expressions
1207 Temporary Tables 13. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Programmability
1301 Programmability In T-SQL
1302 What Is A Stored Procedure?
1303 Why Use Stored Procedures?
1304 A Simple Stored Procedure
1305 Input Parameters
1306 Multiple Input Parameters
1307 Output Parameters - Part 1
1308 Output Parameters - Part 2
1309 Using Case Logic - Part 1
1310 Using Case Logic - Part 2
1311 Handling Errors
1312 Stored Procedure Security
1313 Working With Functions
1314 Using Built-In Functions
1315 Creating A Scalar Function
1316 Creating A Table Valued Function
1317 What Is Dynamic SQL?
1318 Dynamic SQL Example
1319 Understanding GUIDs
1320 GUID Examples - Part 1
1321 GUID Examples - Part 2 14. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Triggers
1401 Using Triggers
1402 Inserted And Deleted Tables
1403 Trigger Examples - Part 1
1404 Trigger Examples - Part 2 15. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Transactions In T-SQL
1501 What Are Transactions?
1502 Understanding Concurrency
1503 Explicit And Implicit Transactions
1504 Cross Platform Concerns
1505 Transaction And Locking Example 16. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Under The Hood
1601 Using Metadata
1602 Using Catalog Views
1603 Using Information Schema Views
1604 Using System Stored Procedures 17. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Working With XML
1701 XML Basics
1702 Outputting XML From Queries
1703 Using FOR XML RAW
1704 Using FOR XML AUTO
1705 Using FOR XML PATH 18. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Optimizing Queries
1801 Optimization Basics
1802 Query Execution Plans - Part 1
1803 Query Execution Plans - Part 2
1804 SQL Server Extended Events - Part 1
1805 SQL Server Extended Events - Part 2
1806 SQL Server Profiler 19. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Taking The Exam
1901 Exam Basics
1902 Taking Your Exam
1903 When It Is Over 20. Microsoft SQL Server 2012 Certification Training - Exam 70-461 - Conclusion
2001 Wrap-Up
2002 About The Author
01. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Introduction
0101 What Is Exam 70-462?
0102 What You Should Expect From The Videos 02. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Installation And Configuration
0201 Growing And Shrinking Databases
0202 Monitoring Database Growth
0203 Designing Database Storage
0204 Configure An SQL Server Standby Server - Part 1
0205 Configure An SQL Server Standby Server - Part 2
0206 Changing Service Accounts
0207 Testing Database Connectivity
0208 Installing SQL Server Database Engine - Part 1
0209 Installing SQL Server Database Engine - Part 2
0210 Installing SQL Server Database Engine - Part 3
0211 Installing SQL Server Database Engine - Part 4
0212 Installing SQL Server Integration Services
0213 Enabling And Disabling Features
0214 Moving Databases Via Detach/Attach
0215 Migrating Logins
0216 Creating A Full Text Index
0217 Configuring FILESTREAM
0218 Configuring FILETABLE
0219 Create And Manage SQL Agent Jobs - Part 1
0220 Create And Manage SQL Agent Jobs - Part 2
0221 Setup Multi-Server Jobs 03. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Maintain Instances And Databases
0301 Using Multiple Files And Filegroups
0302 Recovery Models
0303 Adding New Filegroups
0304 Moving Tables Between Filegroups
0305 Enabling Contained Databases
0306 Data Compression
0307 Configuring TDE
0308 Setting Up Table Partitioning - Part 1
0309 Setting Up Table Partitioning - Part 2
0310 Managing Log File Growth - Part 1
0311 Managing Log File Growth - Part 2
0312 DBCC CHECKDB
0313 Installing Default And Named Instances - Part 1
0314 Installing Default And Named Instances - Part 2
0315 CPU Affinity
0316 Instance Level Settings - Part 1
0317 Instance Level Settings - Part 2
0318 Instance Level Settings - Part 3
0319 Memory Settings
0320 Database Mail
0321 Fillfactor
0322 Installing A Clustered Instance - Part 1
0323 Installing A Clustered Instance - Part 2
0324 Installing A Clustered Instance - Part 3
0325 Installing A Clustered Instance - Part 4
0326 Multi-Instance Clustering
0327 Multi-Subnet Clustering
0328 Recover From A Failed Cluster Node 04. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Optimization And Troubleshooting
0401 Replication For Reporting - Part 1
0402 Replication For Reporting - Part 2
0403 Replication For Reporting - Part 3
0404 Replication For Reporting - Part 4
0405 Diagnosing Locking And Blocking - Part 1
0406 Diagnosing Locking And Blocking - Part 2
0407 Diagnosing Wait Stats
0408 Using SQL Profiler
0409 Using Performance Monitor - Part 1
0410 Using Performance Monitor - Part 2
0411 Using Extended Events
0412 Using SQL Server Auditing
0413 Using Data Collector
0414 Using Policy Based Management 05. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Manage Data
0501 Define Recovery Models
0502 Mirrored Backups
0503 Stripped Backups
0504 Restoring Full Backups
0505 Restoring Differential Backups
0506 Restoring Transaction Log Backups
0507 File Group Restores
0508 Testing Backups
0509 Restoring Master Database
0510 Restoring msdb Database
0511 Restoring model Database
0512 Restoring Databases Protected By TDE
0513 Restoring A Single Database Page
0514 Point In Time Restores
0515 Index Maintenance
0516 Identifying Index Fragmentation
0517 Identifying Unused Indexes
0518 Filtered Indexes
0519 Updating Statistics
0520 Full Text Indexes
0521 Column Store Indexes
0522 Import Export Wizard
0523 BCP
0524 Bulk Insert 06. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Implement Security
0601 Logins Vs. Users
0602 Creating Logins
0603 Fixed Server Roles
0604 User Defined Server Roles
0605 Certificate Logins
0606 Instance Level Permissions
0607 Database Level Permissions
0608 Fixed Database Roles
0609 User Defined Database Roles
0610 Application Roles
0611 Creating Database Users
0612 Managing Certificates
0613 Endpoint Security 07. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Implement High Availability
0701 Configure Database Mirroring
0702 Configure AlwaysOn Availability Groups - Part 1
0703 Configure AlwaysOn Availability Groups - Part 2
0704 Failing Over Database Mirroring
0705 Failing Over AlwaysOn Availability Groups
0706 Monitoring Database Mirroring 08. Microsoft SQL Server 2012 Certification Training - Exam 70-462 - Conclusion
0801 About The Author
0802 Thank You
01. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Introduction Data Warehousing 2012
0101 What You Will Learn
0102 Data Warehouse Concepts And Architecture
0103 Data Warehouse Solutions 02. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Data Warehouse Hardware
0201 Data Warehouse Challenges - Memory
0202 Data Warehouse Challenges - Physical
0203 Data Warehouse Architectures
0204 Data Warehouse Appliances 03. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Designing And Implementing A Data Warehouse
0301 Data Warehouse Logical Design
0302 Data Warehouse Physical Design
0303 Exercise: Implementing A Data Warehouse Schema
0304 Solution For Implementing A Data Warehouse Schema 04. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Design And Implement A Data Warehouse Schema
0401 ETL And SSIS
0402 Defining A Data Source
0403 Implementing A Data Flow - Part 1
0404 Implementing A Data Flow - Part 2
0405 Exercise: Implementing A SSIS Package
0406 Solution For Implementing A SSIS Package 05. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Control Flows And SSIS Package
0501 Introduction To Control Flows
0502 Dynamic Packages
0503 Defining Containers - Part 1
0504 Defining Containers - Part 2
0505 Manage Consistency
0506 Exercise: Implement Control Flows In SSIS
0507 Solution For Implementing Control Flow SSIS 06. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Debugging And Troubleshooting SSIS Packages
0601 Debugging SSIS
0602 Error Log Providers
0603 Error Handling And SSIS - Part 1
0604 Error Handling And SSIS - Part 2
0605 Exercise: Debugging And Troubleshooting SSIS
0606 Solution For Debugging And Troubleshooting SSIS 07. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Incremental ETL Process
0701 Introduction To Incremental ETL Processes
0702 Extract Modified Data - Part 1
0703 Extract Modified Data - Part 2
0704 Load Modified Data
0705 Exercise: Load Incremental Data
0706 Solution For Incremental Load 08. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Enforcing Data Quality
0801 Data Cleansing
0802 Data Quality Services
0803 Data Quality Services And Matching Data
0804 Exercise Cleansing Data
0805 Solution For Cleansing Data
0806 Exercise: De-Duplicating Data
0807 Solution For De-Duplicating Data 09. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Master Data Services
0901 What Is Master Data Services
0902 Implementing Master Data Services
0903 Excel Add-In For Master Data Services 10. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Extending SSIS
1001 Custom SSIS Components
1002 Scripting And SSIS - Part 1
1003 Scripting And SSIS - Part 2 11. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Deploying SSIS Packages
1101 Overview Of SSIS Deployment
1102 Deploying SSIS Packages - Part 1
1103 Deploying SSIS Packages - Part 2
1104 Planning SSIS Package Execution
1105 Exercise: Deploying An SSIS Package
1106 Solution For Deploying SSIS Package 12. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - Consuming Data
1201 Data Warehouse Using Excel
1202 Using PowerPivot And Data Warehouse
1203 Data Warehouse And SSRS
1204 Exercise: Using Excel And PowerPivot
1205 Solution For Excel And PowerPivot 13. Microsoft SQL Server 2012 Certification Training - Exam 70-463 - About The Author
1301 Learn About Me
 

Note to :

This item DOES NOT infringe any trademark, copyright, or any other rights, nor does it infringe 's listing or spam policies. Everything contained on the advertised DVD is distributed freely & globally under the terms of the GNU Public License, or the GNU Lesser General Public License (L.G.P.L). I have a full & legal right to re-distribute this product.

This IS NOT a digital download; the item will be posted to the buyer on a ‘solid-state’ DVD.

 



Buy Now

Popular Tutorials