Special Offers | My Account | Log In
  0 items in your cart

Search: Boson Sites | Products
Microsoft > MCSA | MCSE > MCSA: SQL 2014 with MCSE: Data Platform Training

Upcoming Dates:

Don’t see the date you want? Contact us.
Price: $7495

Call 813-925-0700 (opt 2) to request this class.

MCSA: SQL 2014 with MCSE: Data Platform Training

Class Delivery Methods
Request a private class

Contact Us:

813-925-0700 (opt 2)
877-333-EXAM (opt 2)
FAX: 813-925-3957
EMAIL: Boson Training

Full Course List

Request More Information

MCSA: SQL 2014 with MCSE: Data Platform Training

About This IT Training:

Exam Numbers: 70-461, 70-462, 70-463, 70-464, 70-465
Certifications: MCSA, MCSE
Single-User License  

This course prepares you for:
  • Microsoft Certified Solutions Associate: SQL Server 2014
  • Microsoft Certified Solutions Expert: Data Platform

MCSA: SQL 2014 w/ MCSE: Data Platform Combo Training

The MCSA: SQL 2014 w/ MCSE: Data Platform Combo Bootcamp is a 14-day course designed to review all aspects of SQL 2014 Administration and Development. Microsoft has completely revamped the SQL 2012 certification to blend Administrator and Developer concepts together into a unified certification. This Bootcamp is a combination of lectures, demonstrations and labs, all of which are focused on the advanced topics related to new technologies in SQL 2014.

While attending this training Bootcamp, you will take exams to test and certify for the Microsoft Certified Solutions Associate: SQL Server 2014 official certification.

The Course Content section below lists the topics covered in camp.  Fundamentals are covered quickly and the lectures, demonstrations and labs are focused on the advanced topics related to new technologies in SQL 2014.

What’s Included

  • Comprehensive study materials, including official Microsoft courseware
  • On-site certification testing with up to ten vouchers that are valid for one year from original class date

MCSA: SQL 2014 / MCSE: Data Platform Training Course Content

  • 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
  • Plan and install SQL Server
  • Describe system databases, the physical structure of databases, and the most common configuration options related to them
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server
  • Back up SQL Server databases
  • Restore SQL Server databases
  • Import and export data by using wizards, the bulk copy utility, and data-tier applications
  • Work with SQL Server security models, logins, users, and contained databases
  • Work with server roles and database roles
  • Use permissions to secure resources
  • Use SQL Server audit and Transparent Data Encryption
  • Work with SQL Server Agent to configure and execute jobs
  • Implement SQL Server Agent security, proxy accounts, and credential
  • Configure database mail, alerts, and notifications
  • Create database maintenance plans
  • Use SQL Server Profiler, SQL Trace, and Distributed Relay
  • Use Distributed Management Views and configure data collection
  • 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
  • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts
  • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types
  • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered)
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints
  • Determine appropriate single column and composite indexes strategies
  • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure
  • Read and interpret details of common elements from execution plans
  • Design effective non-clustered indexes
  • Design and implement views
  • Design and implement stored procedures
  • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses
  • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues)
  • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency
  • Use both traditional T-SQL error handling code and structured exception handling
  • Design and implement DML triggers
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server
  • Store XML data and schemas in SQL Server
  • Perform basic queries on XML data in SQL Server
  • Work with the GEOGRAPHY and GEOMETRY data types
  • Implement and query a full-text index
  • Assess an existing enterprise environment
  • Plan and implement Policy-Based Management
  • Describe the considerations for consolidating workloads with SQL Server 2014
  • Describe considerations for including SQL Server 2014 in a private cloud
  • Use Windows Azure storage with SQL Server 2014
  • Implement and configure databases in Windows Azure SQL Database
  • Implement and configure databases in Windows Azure virtual machines
  • Describe high availability technologies in SQL Server 2014 and implement log shipping
  • Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance
  • Implement an Always On Availability Group
  • Plan high availability and disaster recovery solutions
  • Plan and implement database replication

Related Products

Practice Lab for Microsoft 70-461
Practice Lab for Microsoft 70-462
Practice Lab for Microsoft 70-463
Practice Lab for Microsoft 70-464
MCSA: SQL Server 2012 Training

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.