Questions? Feedback? powered by Olark live chat software

MCSA: SQL Server 2012 Combo Training Courses

About the MCSA: SQL Server 2012 Combo

Duration: 15 days (120 hours)

MCSA: SQL Server 2012

Demonstrate to potential hiring managers your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments by achieving the MCSA: SQL Server 2012 certification. This certification is your first step towards earning an MCSE: Data Platform or MCSE: Business Intelligence certification.

For future SQL Server dates, click here: MCSA: SQL Server (with 2014 Updates)

The data explosion is happening at every level of the business - across devices, applications, and individual roles. Become certified on Microsoft SQL Server and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

This training consists of the following courses:

Why take a combo course?
In one word, savings! You save an average of 15-20% off the individual courses if taken separately.

10774: Querying Microsoft SQL Server 2012   More on this course

5 days | 40 hours

arrow Course Objectives

  • » Write SELECT Queries
  • » Query Multiple Tables
  • » Use Built-In Functions
  • » Use Subqueries
  • » Execute Stored Procedures
  • » Use Set Operators
  • » Implement Error Handling
  • » Implementing Transactions
  • » Use Table Expressions
  • » Sort and Filter Data
  • » Use Window Ranking, Offset and Aggregate Functions
  • » Query SQL Server Metadata
  • » Program with T-SQL
  • » Improve Query Performance

Back to Top

arrow Course Outline

  • Module 1: Introduction to Microsoft SQL Server 2012
    1. Describe SQL Server components
    2. Create and save T-SQL scripts in SQL Server Management Studio
    3. Browse the objects in a database
    4. Search T-SQL syntax definitions in Books Online
  • Module 2: Introduction to Transact-SQL Querying
    1. Describe the elements of T-SQL and its role in writing queries
    2. Describe the use of sets in SQL Server
    3. Describe the use of predicate logic in SQL Server
    4. Define the logical order of operations in SELECT statements
  • Module 3: Writing SELECT Queries
    1. Write Simple SELECT statements
    2. Eliminate duplicates using the DISTINCT clause
    3. Use column and table aliases
    4. Write simple CASE expressions
  • Module 4: Querying Multiple Tables
    1. Describe how multiple tables may be queried in a SELECT statement using joins
    2. Write queries which use inner joins
    3. Write queries which use outer joins
    4. Write queries which use self-joins and cross joins
  • Module 5: Sorting and Filtering Data
    1. Filter data with predicates in the WHERE clause
    2. Sort data using ORDER BY
    3. Filter data in the SELECT clause with TOP
    4. Filter data with OFFSET and FETCH
    5. Understand and handle NULLs
  • Module 6: Working with SQL Server Denali Data Types
    1. Describe numeric data types, type precedence and type conversions
    2. Write queries using character data types
    3. Write queries using date and time data types
  • Module 7: Using Built-In Functions
    1. Write queries with built-in scalar functions
    2. Use conversion functions
    3. Use logical functions
    4. Use functions that work with NULL
  • Module 8: Grouping and Aggregating Data
    1. Write queries which summarize data using built-in aggregate functions
    2. Use the GROUP BY clause to arrange rows into groups
    3. Use the HAVING clause to filter out groups based on a search condition
  • Module 9: Using Subqueries
    1. Use self-contained subqueries, correlated subqueries, scalar subqueries, and multi-valued subqueries
    2. Use the IN and EXISTS predicates
  • Module 10: Using Table Expressions
    1. Write queries against views
    2. Use derived tables
    3. Use common table expressions
    4. Use inline table-valued expressions
  • Module 11: Use Set Operators
    1. Describe the difference between a set and a multi-set
    2. Use the UNION and UNION ALL operators
    3. Use CROSS APPLY, OUTER APPLY and APPLY
    4. Use EXCEPT and INTERSECT operators
  • Module 12: Using Window Ranking, Offset and Aggregate Functions
    1. Use window ranking functions ROW_NUMBER, RANK, DENSE_RANK, NTILE
    2. Use offset functions LAG, LEAD, FIRST_VALUE, LAST_VALUE
    3. Use window aggregate functions
    4. Use the basic forms of window partitioning, window ordering and window framing
  • Module 13: Pivoting and Grouping Sets
    1. Use the basic form of PIVOT and UNPIVOT operators
    2. Use the fundamental form of GROUPING SETS clause
  • Module 14: Querying SQL Server Metadata
    1. Write queries against system catalog views and functions
    2. Execute system stored procedures
    3. Identify and query system dynamic management objects
    4. Describe security permissions necessary to query system objects
  • Module 15: Executing Stored Procedures
    1. Invoke existing stored procedures with EXECUTE
    2. Pass input parameters and receive output parameters
    3. Generate dynamic SQL statements
  • Module 16: Programming with T-SQL
    1. Understand where T-SQL programming objects can be used
    2. Declare variables and delimit batches
    3. Use control of flow elements such as IF, WHILE, BEGIN, END, RETURN
    4. Use synonyms
  • Module 17: Implementing Error Handling
    1. Describe the behavior of SQL Server when errors occur in T-SQL code
    2. Use TRY/CATCH blocks to handle error flow
    3. Understand ERROR class functions
  • Module 18: Implementing Transactions
    1. Describe the benefits of using transactions
    2. Control transactions with BEGIN, COMMIT, ROLLBACK
    3. Describe error handling behavior in transactions
  • Module 19: Improving Query Performance
    1. Describe how SQL Server uses indexes to support query execution
    2. Enable the display of execution plans in SQL Server Management Studio
    3. Enable system IO and time information in query results
    4. Describe the differences between accessing data in sets versus via cursors

Back to Top

10775: Administering Microsoft SQL Server 2012 Databases   More on this course

5 days | 40 hours

arrow Course Objectives

  • » Plan and install SQL Server.
  • » Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • » Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • » Create SQL Server Backups.
  • » Restore SQL Server databases.
  • » Use the import/export wizards and explain how they relate to SSIS.
  • » Work with SQL Server security models, logins and users.
  • » Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • » Work with permissions and the assignment of permissions.
  • » Work with SQL Server Audit.
  • » Work with SQL Server Agent, jobs and job history.
  • » Implement SQL Server agent security, proxy accounts and credentials.
  • » Configure database mail, alerts and notifications.
  • » Create database maintenance plans.
  • » Work with SQL Profiler and SQL Trace stored procedures.
  • » Introduce DMVs and the configuration of data collection.
  • » Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
  • » Troubleshoot SQL Server databases.

Back to Top

arrow Course Outline

  • Module 1: Introduction to SQL Server 2012 and its Toolset
    1. Introduction to the SQL Server Platform
    2. Working with SQL Server Tools
    3. Configuring SQL Server Services
  • Module 2: Preparing Systems for SQL Server 2012
    1. Overview of SQL Server Architecture
    2. Planning Server Resource Requirements
    3. Pre-installation Testing for SQL Server
  • Module 3: Installing and Configuring SQL Server 2012
    1. Preparing to Install SQL Server
    2. Installing SQL Server
    3. Upgrading and Automating Installation
  • Module 4: Working with Databases
    1. Overview of SQL Server Databases
    2. Working with Files and Filegroups
    3. Moving Database Files
  • Module 5: Understanding SQL Server 2012 Recovery Models
    1. Backup Strategies
    2. Understanding SQL Server Transaction Logging
    3. Planning a SQL Server Backup Strategy
  • Module 6: Backup of SQL Server 2012 Databases
    1. Backing up Databases and Transaction Logs
    2. Managing Database Backups
    3. Working with Backup Options
  • Module 7: Restoring SQL Server 2012 Databases
    1. Understanding the Restore Process
    2. Restoring Databases
    3. Working with Point-in-time recovery
    4. Restoring System Databases and Individual Files
  • Module 8: Importing and Exporting Data
    1. Transferring Data To/From SQL Server
    2. Importing & Exporting Table Data
    3. Inserting Data in Bulk
  • Module 9: Authenticating and Authorizing Users
    1. Authenticating Connections to SQL Server
    2. Authorizing Logins to Access Databases
    3. Authorization Across Servers
  • Module 10: Assigning Server and Database Roles
    1. Working with Server Roles
    2. Working with Fixed Database Roles
    3. Creating User-defined Database Roles
  • Module 11: Authorizing Users to Access Resources
    1. Authorizing User Access to Objects
    2. Authorizing Users to Execute Code
    3. Configuring Permissions at the Schema Level
  • Module 12: Auditing SQL Server Environments
    1. Options for Auditing Data Access in SQL
    2. Implementing SQL Server Audit
    3. Managing SQL Server Audit
  • Module 13: Automating SQL Server 2012 Management
    1. Automating SQL Server Management
    2. Working with SQL Server Agent
    3. Managing SQL Server Agent Jobs
  • Module 14: Configuring Security for SQL Server Agent
    1. Understanding SQL Server Agent Security
    2. Configuring Credentials
    3. Configuring Proxy Accounts
  • Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
    1. Configuration of Database Mail
    2. Monitoring SQL Server Errors
    3. Configuring Operators, Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
  • Module 17: Tracing Access to SQL Server 2012
    1. Capturing Activity using SQL Server Profiler
    2. Improving Performance with the Database Engine Tuning Advisor
    3. Working with Tracing Options
  • Module 18: Monitoring SQL Server 2012
    1. Monitoring Activity
    2. Capturing and Managing Performance Data
    3. Analyzing Collected Performance Data
  • Module 19: Managing Multiple Servers
    1. Working with Multiple Servers
    2. Virtualizing SQL Server
    3. Deploying and Upgrading Data-Tier Applications
  • Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
    1. SQL Server Troubleshooting Methodology
    2. Resolving Service-related Issues
    3. Resolving Concurrency Issues
    4. Resolving Login and Connectivity Issues

Back to Top

10777: Implementing a Data Warehouse with Microsoft SQL Server 2012   More on this course

5 days | 40 hours

arrow Course Objectives

  • » 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 Data Flow in an SSIS Package.
  • » Debug and Troubleshoot SSIS packages.
  • » Implement an SSIS solution that supports incremental DW loads and changing data.
  • » Integrate cloud data into a data warehouse ecosystem infrastructure.
  • » Implement data cleansing by using Microsoft Data Quality Services.
  • » Implement Master Data Services to enforce data integrity at source.
  • » Extend SSIS with custom scripts and components.
  • » Deploy and Configure SSIS packages.
  • » Describe how information workers can consume data from the data warehouse.

Back to Top

arrow Course Outline

  • Module 1: Introduction to Data Warehousing
    1. Describe data warehouse concepts and architecture considerations
    2. Considerations for a Data Warehouse Solution
  • Module 2: Data Warehouse Hardware Considerations
    1. The Challenges of Building a Data Warehouse
    2. Data Warehouse Reference Architectures
    3. Data Warehouse Appliances
  • Module 3: Designing and Implementing a Data Warehouse
    1. Logical Design for a Data Warehouse
    2. Physical Design for a Data Warehouse
  • Module 4: Design and implement a schema for a data warehouse
    1. Introduction to ETL with SSIS
    2. Exploring Source Data
    3. Implementing Data Flow
  • Module 5: Implementing Control Flow in an SSIS Package
    1. Introduction to Control Flow
    2. Creating Dynamic Packages
    3. Using Containers
    4. Managing Consistency
  • Module 6: Debugging and Troubleshooting SSIS Packages
    1. Debugging an SSIS Package
    2. Logging SSIS Package Events
    3. Handling Errors in an SSIS Package
  • Module 7: Implementing an Incremental ETL Process
    1. Introduction to Incremental ETL
    2. Extracting Modified Data
    3. Loading Modified Data
  • Module 8: Incorporating Data from the Cloud in a Data Warehouse
    1. Overview of Cloud Data Sources
    2. SQL Server Azure
    3. Azure Data Market
  • Module 9: Enforcing Data Quality
    1. Introduction to Data Cleansing
    2. Using Data Quality Services to Cleanse Data
    3. Using Data Quality Services to Match Data
  • Module 10: Using Master Data Services
    1. Master Data Services Concepts
    2. Implementing a Master Data Services Model
    3. Using the Master Data Services Excel Add-in
  • Module 11: Extending SSIS
    1. Using Custom Components in SSIS
    2. Using Scripting in SSIS
  • Module 12: Deploying and Configuring SSIS Packages
    1. Overview of Deployment
    2. Deploying SSIS Projects
    3. Planning SSIS Package Execution
  • Module 13: Consuming Data in a Data Warehouse
    1. Using Excel to Analyze Data in a data Warehouse.
    2. An Introduction to PowerPivot
    3. An Introduction to Crescent

Back to Top

This training prepares students for the following exam(s):

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

Back to Top

Recent Client Testimonials & Reviews

Oct 21 2014
high level of knowledge. Friendly learning environment
Vlad Averyanov
Course(s) Taken

» MCSA: SQL Server 2012 Boot Camp
» End to End Microsoft Business Intelligence From SQL 2008R2 to SharePoint 2010 and MS Office

Jun 23 2014
2 reasons. I would tell people to work directly with Bill Dolan. He's a true professional that knows this space well and encourages us to do more business with Netcom. Secondly the technical expertise for most class is above par compared to the staff at other training facilties. I recently took and MS Exchange class with Hisham and gained a great deal of knowledge that will help me. Hisham offered much more than the core curriculum.

-Vincent R.
Course(s) Taken

» MCSA: SQL Server 2012 Boot Camp

Jun 16 2014
The technical expertise for most class is above par compared to the staff at other training facilties. I recently took and MS Exchange class with Hisham and gained a great deal of knowledge that will help me. Hisham offered much more than the core curriculum.

-Vincent R.
Course(s) Taken

» MCSA: SQL Server 2012 Boot Camp

  More testimonials »  

Back to Top

Ways to contact us

Website Live Chat

Call us toll-free at 1-888-563-8266

FREE Training Inquiry form

Contact us via Email: info@netcomlearning.com

Back to Top

Redeem Your Microsoft Software Assurance Training Vouchers

Microsoft Software 
Assurance Training Vouchers

As a Microsoft Gold Learning Solutions Partner, NetCom Learning proudly accepts Microsoft Software Assurance Training Vouchers. You can attend Microsoft training at NetCom Learning for free, by redeeming your Microsoft vouchers.

Call 1-(888)-563-8266 for more information.

Back to Top