Questions? Feedback? powered by Olark live chat software
Passionate about Learning
HOME      LIVE CHAT        My NetCom Free Catalog 1-888-563-8266
.
Home > Vendors > Microsoft - Technical > Microsoft SQL Server > MCSA: SQL Server 2012 Combo

MCSA: SQL Server 2012 Combo Training Courses

About MCSA: SQL Server 2012 Combo

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.


MCSA: SQL Server 2012 Combo
10774: Querying Microsoft SQL Server 2012 40 hours Schedule

view course outline

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

view course outline

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

view course outline

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

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.

Duration: 15 days (120 hours)
.  Next Class Dates
Oct 20, 2014–Nov 7, 2014
9:00am – 5:00pm EST
Guaranteed to run class (GTR)
Dec 1, 2014–Dec 19, 2014
9:00am – 5:00pm CST

For a customized version of this class, please contact us or call 1-888-563-8266.
.  Get More Information
Name: 
Email:  
Phone: 
Comments:
Help us filter out spammers:

Change text if hard to read
Enter code above:
. .
Live Help! Click to start chat.
Newsletter:
© 1998-2014, NetCom Learning. All Rights Reserved.