MCSA: SQL Server 2012 Boot Camp

Quantity

$6,295.00

Add to Cart

New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Microsoft MCSA SQL 2012 Boot Camp, Microsoft Office, Sharepoint, SQL, Exchange and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.

✉ Microsoft Training Specialist | ☏ 502.909.0819

---

EXCLUSIVE BENEFIT:

This course includes a twelve-month subscription to these exclusive benefits:

• 12 months of anytime access to your course labs and lab environment
• 12 months of 24/7 access to mentoring via chat, email, and phone
• 12 months of on-demand access to indexed, searchable recordings of your Online Live class
• 12 months of unlimited retakes of your class
• 30 days of access to the online Microsoft Press E-Reference Library, including all training kits, exam references, and rapid review books
• 30 days of access to a recommended Microsoft reading List designed by our instructors, including topics and chapters within the Microsoft Press E-Reference Library
• 12 months of access to certification practice exams from Transcender that provide realistic Microsoft exam simulations in online and downloadable versions
• 12 months of access to recorded “Power Hours” — an online review session covering key exam objectives conducted by our expert instructors – for each exam

---

COURSE INFORMATION

MCSA: SQL Server 2012 Boot Camp Overview:

The MCSA: SQL Server 2012 Boot Camp is an accelerated learning environment where you will build your skills and prepare for the MCSA: SQL Server 2012 certification exams.

This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

MCSA: SQL Server 2012 Boot Camp incorporates content from Microsoft Official Courses (MOC):

• Querying Microsoft SQL Server (M20461)
• Administering Microsoft SQL Server Databases (M20462)
• Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Note: Microsoft Learning recommends the above courses, which use SQL Server 2014 for preparation for the following MCSA exams that reference SQL Server 2012. Microsoft Learning has no plans to update the MCSA: SQL Server 2012 exams to SQL Server 2014. All the exam skill objectives, however, are covered in the latest courseware as designed.

You Will Prepare for These Exams:

• 70-461: Querying Microsoft SQL Server 2012
• 70-462: Administering Microsoft SQL Server 2012 Databases
• 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Who Needs to Attend:

• Administrators with at least two years of hands-on experience implementing and administering database systems
• Database administrators, systems engineers, systems analysts, and technical consultants who want to prepare for their MCSA: SQL Server 2012 credential in an accelerated format

MCSA: SQL Server 2012 Boot Camp Prerequisites:

Before attending this course, you must have the following:

• Working knowledge of relational databases
• Two years of hands-on experience working in a SQL Server 2008 or SQL Server 2012 environment
• Basic knowledge of the Microsoft Windows operating system and its core functionality

MCSA: SQL Server 2012 Boot Camp Objectives:

After successfully completing this course, you will be able to:

• The technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012
• The knowledge and skills to maintain Microsoft SQL Server 2012 databases
• Create a data warehouse with SQL Server 2012
• Implement ETL with SQL Server Integration Services
• Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services
• Key topics and concepts addressed on the MCSA: SQL Server 2012 exams

Follow-On Courses

• Developing Microsoft SQL Server Databases (M20464)
• Designing a Data Solution with Microsoft SQL Server (M20465)
• Implementing Data Models and Reports with Microsoft SQL Server (M20466)
• Designing Self-Service Business Intelligence and Big Data Solutions (M20467)

MCSA: SQL Server 2012 Boot Camp Outline:

Querying Microsoft SQL Server (M20461)

Module 1: Introduction to Microsoft SQL Server 2014

• SQL Server Architecture
• SQL Server Editions and Versions
• SQL Server Management Studio
• Module 1 Lab:
• SQL Server 2014 Tools

Module 2: Introduction to T-SQL Querying

• T-SQL
• Sets
• Predicate Logic
• Logical Order of Operations in SELECT Statements
• Module 2 Lab:
• Transact-SQL Querying

Module 3: Writing SELECT Queries

• Writing Simple SELECT Statements
• Eliminating Duplicates with DISTINCT
• Using Column and Table Aliases
• Writing Simple CASE Expressions
• Module 3 Lab:
• Write Basic SELECT statements

Module 4: Querying Multiple Tables

• Joins
• Querying with Inner and Outer Joins
• Querying with Cross Joins and Self Joins
• Module 4 Lab:
• Query Multiple Tables

Module 5: Sorting and Filtering Data

• Sorting Data
• Filtering Data with a WHERE Clause
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown and Missing Values
• Module 5 Lab:
• Sort and Filter Data

Module 6: Working with SQL Server 2014 Data Types

• SQL Server 2014 Data Types
• Working with Character Data
• Working with Date and Time Data
• Module 6 Lab:
• Work with SQL Server 2014 Data Types

Module 7: DML to Modify Data

• Insert Data
• Modify and Delete Data
• Module 7 Lab:
• Modify Data using DML

Module 8: Using Built-In Functions

• Writing Queries with Built-In Functions
• Using Conversion Functions
• Using Logical Functions
• Using Functions to Work with NULL
• Module 8 Lab:
• Built-In Functions

Module 9: Grouping and Aggregating Data

• Using Aggregate Functions
• Using the GROUP BY Clause
• Filtering Groups with HAVING
• Module 9 Lab:
• Group and Aggregate Data

Module 10: Subqueries

• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries
• Module 10 Lab:
• Subqueries

Module 11: Using Table Expressions

• Using Derived Tables
• Using Common Table Expressions
• Using Views
• Using Inline Table-Valued Functions
• Module 11 Lab:
• Table Expressions

Module 12: Using Set Operators

• Writing Queries with the UNION Operator
• Using EXCEPT and INTERSECT
• Using APPLY
• Module 12 Lab:
• Set Operators

Module 13: Using Window Ranking, Offset, and Aggregate Functions

• Creating Windows with OVER
• Exploring Window Functions
• Module 13 Lab:
• Use Window Ranking, Offset, and Aggregate Functions

Module 14: Pivoting and Grouping Sets

• Writing Queries with PIVOT and UNPIVOT
• Working with Grouping Sets
• Module 14 Lab:
• Pivot and Group Sets

Module 15: Executing Stored Procedures

• Querying Data with Stored Procedures
• Passing Parameters to Stored Procedures
• Creating Simple Stored Procedures
• Working with Dynamic SQL
• Module 15 Lab:
• Execute Stored Procedures

Module 16: Programming with T-SQL

• T-SQL Programming Elements
• Controlling Program Flow
• Module 16 Lab:
• Program with T-SQL

Module 17: Implementing Error Handling

• Using TRY/CATCH Blocks
• Working with Error Information
• Module 17 Lab:
• Implement Error Handling

Module 18: Implementing Transactions

• Transactions and the Database Engine
• Controlling Transactions
• Module 18 Lab:
• Implement Transactions

Module 19: Improving Query Performance

• Factors in Query Performance
• Displaying Query Performance Data
• Module 19 Lab:
• Improve Query Performance

Module 20: Querying SQL Server Metadata

• Querying System Catalog Views and Functions
• Executing System Stored Procedures
• Querying Dynamic Management Objects
• Module 20 Lab:
• Query SQL Server Metadata

Administering Microsoft SQL Server Databases (M20462)

Module 1: Introduction to SQL Server 2014 Database Administration

• Database Administration Overview
• Introduction to the SQL Server Platform
• Database Management Tools and Techniques
• Module 1 Lab:
• Use SQL Server Administrative Tools

Module 2: Installing and Configuring SQL Server 2014

• Plan SQL Server Installation
• Install SQL Server 2014 and Post-Installation Configuration
• Module 2 Lab:
• Install SQL Server 2014

Module 3: Work with Databases and Storage

• Introduction to Data Storage with SQL Server
• Manage Storage for System Databases and User Databases
• Move Database Files
• Configure the Buffer Pool Extension
• Module 3 Lab:
• Manage Database Storage

Module 4: Plan and Implement a Backup Strategy

• SQL Server Recovery Models
• Plan a Backup Strategy
• Backup Databases and Transaction Logs
• Backup Options and Backup Reliability
• Module 4 Lab:
• Back Up SQL Server Databases

Module 5: Restore SQL Server 2014 Databases

• Restore Process and Databases Restoration
• Advanced Restore Scenarios
• Point-in-Tim Recovery
• Module 5 Lab:
• Restore SQL Server 2014 Databases

Module 6: Import and Export Data

• Transferring Data
• Import and Export Table Data
• Copy or Move a Database
• Module 6 Lab:
• Import and Export Data

Module 7: Monitor SQL Server 2014

• Introduction to Monitoring SQL Server
• Dynamic Management Views and Functions
• Performance Monitor
• Module 7 Lab:
• Monitor SQL Server 2014

Module 8: Tracing SQL Server Activity

• Trace SQL Server Workload Activity and Use Traces
• Module 8 Lab:
• Trace SQL Server Workload Activity

Module 9: Manage SQL Server Security

• Introduction to SQL Server Security
• Manage Server-Level Security and Database-Level Principals
• Manage Database Permissions
• Module 9 Lab:
• Manage SQL Server Security

Module 10: Audit Data Access and Encrypt Data

• Audit Data Access in SQL Server
• Implement SQL Server Audit
• Encrypt Databases
• Module 10 Lab:
• Audit Data Access and Encrypting Data

Module 11: Perform Ongoing Database Maintenance

• Ensure Database Integrity
• Maintain Indexes
• Automate Routine Database Maintenance
• Module 11 Lab:
• Perform Ongoing Database Maintenance

Module 12: Automate SQL Server 2014 Management

• Implement and Manage SQL Server Agent Jobs
• Manage Job Step Security Contexts
• Manage Job on Multiple Servers
• Module 12 Lab:
• Automate SQL Server Management

Module 13: Monitor SQL Server 2014 Using Alerts and Notifications

• Monitor SQL Server Errors
• Configure Database Mail
• Configure Operators, Alerts, and Notifications
• Module 12 Lab:
• Monitor SQL Agent using Alerts and Notifications

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Module 1: Data Warehousing

• Concepts and Architecture Considerations
• Considerations for a Data Warehouse Solution
• Module 1 Lab:
• Exploring a Data Warehousing Solution

Module 2: Data Warehouse Infrastructure

• Hardware Selections
• Considerations for Business Intelligence Infrastructure
• Module 2 Lab:
• Planning Data Warehouse Infrastructure

Module 3: Design and Implement a Data Warehouse

• Logical Design, Including Dimension Tables and Fact Tables
• Physical Implementation, Including a Star Schema, Snowflake Schema, and Time Dimension
• Module 3 Lab:
• Implementing a Data Warehouse

Module 4: Create an ETL Solution with SSIS

• ETL with SSIS
• Explore Source Data
• Implement Data Flow
• Module 4 Lab:
• Implement Data Flow in an SSIS Package

Module 5: Implement Control Flow in an SSIS Package

• Control Flow
• Create Dynamic Packages
• Using Containers
• Manage Consistency with Transactions and Checkpoints
• Module 5 Labs:
• Implementing Control Flow in an SSIS Package
• Using Transactions and Checkpoints

Module 6: Debug and Troubleshoot SSIS Packages

• Debug an SSIS Package
• Log SSIS Package Events
• Implement an Event Handler
• Handle Errors in an SSIS Package
• Module 6 Labs:
• Debugging and Troubleshooting an SSIS Package

Module 7: Implement an Incremental ETL Process

• Incremental ETL
• Data and Modified Data Extraction
• Module 7 Labs:
• Extracting Modified Data

Module 8: Load Data into a Data Warehouse

• Data and Modified Data Load planning
• Incremental loads Using SSIS
• Transact-SQL Loading Techniques
• Module 8 Labs:
• Loading a Data Warehouse

Module 9: Enforce Data Quality

• Microsoft SQL Server DQS
• Use DQS to Cleanse Data
• Use DQS to Match Data
• Module 9 Labs:
• Cleansing Data and Deduplicating Data

Module 10: Master Data Services

• Master Data Services Concepts
• Implement a Master Data Services Model
• Master Data Services Tools to Manage and Create Master Data
• Module 10 Labs:
• Implementing Master Data Services

Module 11: Extend SSIS

• Custom Components in SSIS
• Scripting in SSIS
• Module 11 Labs:
• Using Custom Scripts

Module 12: Deploy and Configure SSIS Packages

• Deployment Considerations
• Deploy SSIS Projects
• Plan SSIS Package Execution
• Module 12 Labs:
• Deploying and Configuring SSIS Packages

Module 13: Consume Data in a Data Warehouse

• Business Intelligence Solutions
• Enterprise BI Solution
• Self-Service BI and Big Data Solutions
• Module 13 Labs:
• Using a Data Warehouse

---

Boost your salary by obtaining your Microsoft Certification: Microsoft Certified Solutions Associate (MCSA)