MCSA: SQL Server 2012/2014 Boot Camp teaches you the knowledge and skills for designing, building, and maintaining the next wave of cloud-ready database and information solutions." >
Shopping Cart  [0]

Call 800.698.5501

Microsoft - MCSA SQL Server 2012/2014 Boot Camp - Training Camp

SQL Certification Training
TrainingCamp Twitter Feed

Our 9-day Microsoft MCSA: SQL Server 2012/2014 Boot Camp teaches you the knowledge and skills for designing, building, and maintaining the next wave of cloud-ready database and information solutions.

During this course you will take the following Official Microsoft exams onsite during the class:

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

All SQL Server–related exams and certification programs have been updated to be applicable to both SQL Server 2012 and SQL Server 2014, to have continued relevance for database professionals working with either product version.

Enrollment Information

MCSA SQL Training Pricing View Pricing
MCSA SQL Certification Schedule Course Schedule


Duration: 9 days
Exam Voucher: Included
Testing: Delivered On-Site
GI Bill Eligible: ≤ 100% of Fees
GSA Catalog: GS-02F-0044T
MS SATV: 15 Vouchers
Microsof Certification Training

Official Microsoft Training Includes:
  • Official Microsoft Courseware
  • Hands-On Labs
  • SATV Redemption Options
  • Education Guarantee

  • Training Camp Exclusive Boot Camp Add-ons:
  • Official Exam Testing Onsite During Class
  • Practice Exams/Evening Review Sessions
  • Hotel/Travel Packages
  • Pre-Class Self-Paced Video Access
  • Training on your terms.

    Training Camp offers the full spectrum of learning [delivery] options - providing our customers with end-to-end solutions to assist in achieving education goals.

    Instructor-Led Boot Camp
    Check out our dates and locations for this MCSA SQL Server 2014 Certification Boot Camp.

    Microsoft SATV
    These benefits may cover up to 100% of tuition & courseware, plus other training-related costs as well.

    Group Training
    We offer Microsoft training with onsite exam delivery options to support your team training requirements.

    Microsoft Winner
    As a Microsoft Gold Partner, Training Camp has successfully delivered hands-on, Microsoft database training for Microsoft Certification since 1999. Training Camp pioneered the first exam-focused Microsoft "Exam Prep" Boot Camps, and has since successfully certified thousands of professionals.

    Microsoft Instructors
    Experienced Microsoft MCT & MCSE Certified Instructors

    Our instructors are well-versed in accelerated learning concepts and exam preparation. During our MCSA SQL Server 2014 boot camp, the experience of working with thousands of exam takers give our team unique insight into the learning requirements needed for success. This program delivery accommodates every student's learning needs through individualized instruction, lab partner and group exercises, independent study, self-testing, and question/answer drills.

    MICROSOFT Certification Practice Tests
    Detailed Practice Exams/Evening Review Sessions
    *Training Camp Exclusive Feature

    Our MCSA SQL Server 2014 Certification Boot Camp training boot camp includes custom practice exams - representative of the actual exam questions from Microsoft. During our evening review sessions we drill down on these questions, which is the key to Microsoft exam preparation.

    Microsoft Exam
    Onsite Exams/Retake Vouchers
    *Training Camp Exclusive Feature

    We host the official Our MCSA SQL Server 2014 Certification Boot Camp training 70-461, 70-462, and 70-463 exams during the class for our students. These exams are delivered at our site - with Pearson VUE/Microsoft approval - not at 'local' testing centers that are subject to seat availability. With our award winning exam prep, , you will be ready to take on this required Microsoft SQL 2012/2014 track of exams. Our goal is for students to leave class with knowledge & certification.

    MCSA SQL Candidate
    This certification is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

    This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

    MCSA SQL Course Outline

    Describe the basic architecture and concepts of Microsoft SQL Server 2014
    Understand the similarities and differences between Transact-SQL and other computer languages
    Write SELECT queries
    Query multiple tables
    Sort and filter data
    Describe the use of data types in SQL Server
    Modify data using Transact-SQL
    Use built-in functions
    Group and aggregate data
    Use subqueries
    Use table expressions
    Use set operators
    Use window ranking, offset and aggregate functions
    Implement pivoting and grouping sets
    Execute stored procedures
    Program with T-SQL
    Implement error handling
    Implement transactions

    Describe core database administration tasks and tools
    Install and configure SQL Server 2014
    Configure SQL Server databases and storage
    Plan and implement a backup strategy
    Restore databases from backups
    Import and export data
    Monitor SQL Server
    Trace SQL Server activity
    Manage SQL Server security
    Audit data access and encrypt data
    Perform ongoing database maintenance
    Automate SQL Server maintenance with SQL Server Agent Jobs
    Configure Database Mail, alerts and notifications

    Describe data warehouse concepts and architecture considerations
    Select an appropriate hardware platform for a data warehouse
    Design and implement a data warehouse
    Implement Data Flow in an SSIS Package
    Implement Control Flow in an SSIS Package
    Debug and Troubleshoot SSIS packages
    Implement an ETL solution that supports incremental data extraction
    Implement an ETL solution that supports incremental data loading
    Implement data cleansing by using Microsoft Data Quality Services
    Implement Master Data Services to enforce data integrity
    Extend SSIS with custom scripts and components
    Deploy and Configure SSIS packages
    Describe how BI solutions can consume data from the data warehouse