• CATALOG
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN
University of New Mexico, Continuing Education Division
Home > Training Programs > Networking > Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
CALL
NOW

855.520.6806

Fill out the form below

Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

mcsa-sql-server-2012
$1,995.00 (USD)

OVERVIEW

OBJECTIVE

DETAILS

OUTLINE

Querying Microsoft SQL Server 2012 Intro

  1. T-SQL and Stored Procedures
    1. Install SQL Management Studio and Database
    2. T-SQL Overview
    3. T-SQL Queries
    4. Create Stored Procedures
    5. Querying SQL Server 2012
  2. Select, Data Types, Subqueries, Data Sets, and Aggregates
    1. Query Data Using Select
    2. Implement Data Types
    3. Functions
    4. Filter and Sort Data
    5. Implement Subqueries
    6. Combine Datasets
    7. Joins
    8. Subqueries
    9. Set Operators
    10. Implementing Aggregates
  3. XML Data, Tables and Views
    1. Using XML and T-SQL
    2. Create Tables
    3. Alter Tables
    4. Table Constraints
    5. Alter Views with T-SQL
    6. Design Views
  4. Modify Data, Stored Procedures, Triggers and Functions
    1. Create, Modify and Alter Data
    2. IDENTITY
    3. OUTPUT
    4. Merging
    5. Implement Error Handling
    6. Transactions
    7. Create Stored and Procedures
    8. Alter Stored Procedures
    9. Work and Functions
    10. Triggers
  5. Optimization
    1. Optimize Queries
    2. Indexes
    3. Statistics
    4. Row-Based vs. Set-Based Operations
    5. Advanced Optimization and Full-Text
    6. Install Server 2008
    7. Configure a VM Environment
    8. Explore Advanced Optimization
    9. Full-Text

Administering Microsoft SQL Server 2012 Databases

  1. Install and Configure SQL Server 2012
    1. Plan Installation
    2. Install SQL and Its Services
    3. Migrate Data
    4. Configure SQL Components
    5. Manage SQL Agent
  2. Maintain Instances and Databases
    1. Manage and Configure Databases
    2. Configure SQL Server Instances
    3. Implement a SQL Server Clustered Instance
    4. Manage SQL Server Instances
  3. Optimize and Troubleshoot
    1. Identify and Resolve Concurrency Problems
    2. Collect and Analyze Troubleshooting Data
    3. Audit SQL Server Instances
  4. Manage Data
    1. Configure and Maintain a Backup Strategy
    2. Restore Databases
    3. Implement and Maintain Indexes
    4. Import and Export Data
  5. Implement Security
    1. Manage Logins and Server Roles
    2. Manage Database Permissions
    3. Manage Users and Database Roles
    4. Troubleshoot Security
  6. Implement High Availability
    1. Implement AlwaysOn
    2. Implement Database Mirroring

Implementing a Data Warehouse with Microsoft SQL Server 2012

  1. Dimensions and Fact Tables
    1. Install Server 2008 R2
    2. Install SQL Server Enterprise
    3. Design and Implement Dimensions
    4. Design and Implement Fact Tables
    5. Star and Snowflake
    6. Containers and Tasks
    7. Conforming and Non-Conforming Dimensions
    8. Time Dimensions
    9. SSIS / Connection Managers
    10. Design Control Flow
    11. Face and Dimension Granularity
    12. Precedence Constraints
  2. Data Flow, Variables and Parameters, Package Logic
    1. Designing Data Flow
    2. Implementing Data Flow
    3. Data Sources and Destinations
    4. Splitting the Flow
    5. Variables and Parameters
    6. Package Logic
    7. Data Loading Options
    8. Change Data Capture
    9. Change Tracking
    10. Error Rows
    11. Checkpoints and Transactions
    12. Event Handlers
  3. Logging and SSIS
    1. Logging
    2. Auditing
    3. SSIS Solutions
    4. Deployment
    5. Managing SSIS Package Execution
    6. SSIS Security
  4. Troubleshooting, Debugging and Data Quality
    1. Troubleshooting
    2. Debugging
    3. Installing and Maintaining Data Quality Service
    4. Implementing Data Quality Services
    5. Use the Data Profiling Task
  5. Scripting and Master Data Services
    1. Implement Script Tasks
    2. Implement Script Components
    3. Implement Master Data Services
    4. Master Data Security
    5. MSDS Add-Ins for Excel
  6. Fuzzy Transformations
    1. Fuzzy Transformations
    2. Identity Mapping and De-Duplicating

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

University of New Mexico, Continuing Education Division
Division of Continuing Education
1634 Univeristy Blvd. NE
Albuquerque, NM 87131 US
MAIN CONTENT

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.