• CATALOG
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN
      Forget your password?
  • Open Search Dialog
State University of New York - Canton
Home > Training Programs > Networking > Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
CALL
NOW

855.520.6806

Fill out the form below

By continuing you are agreeing to have ed2go contact you.
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)

DETAILS

OUTLINE

  1. MS-026 Querying SQL Server
    1. Unit 1
      1. Handout
      2. Lecture: Intro to Databases
      3. Lecture: Tables and
      4. Lab: Installing SQL, SQL Management Studio, and Databases
      5. Quiz: Database Basics
      6. Lecture: T-SQL
      7. Lecture: More T- Lab: T-SQL Queries
      8. Quiz: T-SQL
      9. Lecture: Stored Procedures
      10. Lab: Create Stored Procedures
      11. Quiz: Stored Procedures (00:45:00)
      12. Handout: Obtaining the 70-461 Text and Sample Files
      13. Lecture: Introduction to 70-461 Querying SQL Server
      14. Reading: 70-461 Training Kit: Chapter 1
      15. Lab: Query Processing
      16. Quiz: Query Processing
      17. Unit 1 Exam
    2. Unit 2
      1. Lecture: Querying Data Using SELECT
      2. Lecture: Implementing Data Types
      3. Handout: Data Types and Functions
      4. Text Reading: 70-461 Training Kit: Chapter 2
      5. Lab: The Select Clause
      6. Handout: Filtering and Sorting Data
      7. Text Reading: 70-461 Training Kit: Chapter 3
      8. Lab: Filtering and Sorting Data
      9. Quiz: Selection, Filtering, and Sorting
      10. Lecture: CBT Nuggets: Implementing Subqueries
      11. Lecture: Combining Datasets
      12. Handout: Joins, Subqueries, and Set Operators
      13. Lab: Joins, Subqueries, and Set Operators
      14. Lecture: Implementing Aggregates
      15. Handout: Grouping and Windowing
      16. Lab: Grouping and Windowing
      17. Quiz: Joins, Grouping, and Windowing
      18. Unit 2 Exam
    3. Unit 3
      1. Lecture: Querying and Managing XML Data
      2. Handout: XML
      3. Text Reading: 70-461 Training Kit: Chapter 7
      4. Lab: Using XML with T-SQL
      5. Lecture: Creating and Altering Tables with T-SQL
      6. Lecture: Creating and Modifying Constraints
      7. Handout: Table Creation, Alteration, and Constraints
      8. Text Reading: 70-461 Training Kit: Chapter 8
      9. Lab: Working with Tables and Enforcing Data Integrity
      10. Quiz: XML and Data Integrity
      11. Lecture: Creating and Altering Views with T-SQL
      12. Lecture: Designing Views
      13. Text Reading: 70-461 Training Kit: Chapter 9
      14. Lab: Views
      15. Quiz: Views
      16. Unit 3 Exam
    4. Unit 4
      1. Lecture: Modifying Data with T-SQL
      2. Text Reading: 70-461 Training Kit: Chapter 10
      3. Lab: Creating, Modifying, and Altering Data
      4. Text Reading: 70-461 Training Kit: Chapter 11
      5. Lab: IDENTITY, OUTPUT, and Merging
      6. Quiz: Modifying Data and Merging
      7. Lecture: Managing Transactions
      8. Lecture: Implementing Error Handling
      9. Text Reading: 70-461 Training Kit: Chapter 12
      10. Lab: Transactions
      11. Lecture: Creating and Altering Stored Procedures
      12. Lecture: Creating and Modifying DML Triggers
      13. Lecture: Working With Functions
      14. Text Reading: 70-461 Training Kit: Chapter 13
      15. Lab: Triggers, Stored Procedures, and Functions
      16. Quiz: Transactions, Stored Procedures, and Functions
      17. Unit 4 Exam
    5. Unit 5
      1. Lecture: Optimizing Queries
      2. Text Reading: 70-461 Training Kit: Chapter 14
      3. Lab: Optimization
      4. Text Reading: 70-461 Training Kit: Chapter 15
      5. Lab: Indexes and Statistics
      6. Quiz: Optimization, Indexes, and Statistics
      7. Lecture: Row-Based vs. Set-Based Operations
      8. Text Reading: 70-461 Training Kit: Chapter 16
      9. Lab: Cursors, Sets, and Temporary Tables
      10. Quiz: Cursors, Sets, and Temporary Tables
      11. MS-026 Unit 5 Exam
    6. Unit 6
      1. Lab: Installing VMWare
      2. Lab: Setting Up the Windows Server 2008 R2 Environment Using VMWare
      3. Lab: Installing SQL Server Enterprise and Databases on the Virtual Machine
      4. Text Reading: 70-461 Training Kit: Chapter 17
      5. Lab: More Optimization
      6. Text Reading: 70-461 Training Kit: Chapter 6
      7. Lab: Downloading, Installing, and Attaching the Semantics Statistics Database
      8. Lab: Full-Text
      9. Quiz: Advanced Optimization and Full-Text
      10. Final Practice Exam A
      11. Final Practice Exam B
      12. Final Practice Exam C
      13. Final Exam A
      14. Final Exam B
      15. Final Exam C
  2. MS-027 Admin SQL Server
    1. Unit 1
      1. Handout
      2. Lab: Downloading Server 2008 and Creating Non-Server Core Machines
      3. Lab: Creating Server Core Machine
      4. Lab: Setting Up Virtual Machines to Enable Networking
      5. Lab: Setting Up Domain Controller and Building the Networked Domain
      6. Lecture: Introduction to 70-462
      7. Lecture: Planning a SQL Server 2012 Installation
      8. Lecture: Installing SQL Server 2012
      9. Text Reading: 70-462 Training Kit Chapter 1
      10. Handout: Planning to Install SQL Server 2012
      11. Handout: Installing SQL Server 2012
      12. Lab: Initial Install of SQL Server
      13. Lab: Server Core, Features, and Connectivity
      14. Lecture: Configuring and Managing Instances
      15. Text Reading: 70-462 Training Kit Chapter 2
      16. Handout: Configuring and Managing SQL Server Instances
      17. Lab: Configuring and Managing SQL Server Instances
      18. Quiz: Installing, Configuring, and Managing
      19. Lecture: Configuring SQL Server Components
      20. Lecture: Configuring and Managing Databases
      21. Text Reading: 70-462 Training Kit Chapter 3
      22. Handout: Configuring Additional Components
      23. Handout: Managing and Configuring Databases
      24. Lab: Configuring SQL Server 2012 Components
      25. Quiz: Configuring Components
      26. Unit 1 Exam
    2. Unit 2
      1. Lecture: Implementing a Migration Strategy
      2. Lecture: Importing and Exporting Data
      3. Text Reading: 70-462 Training Kit Chapter 4
      4. Handout: Migrating, Importing, and Exporting
      5. Lab: Migrating, Importing, and Exporting
      6. Lecture: Managing Logins and Server Roles
      7. Lecture: Managing Users and Database Roles
      8. Text Reading: 70-462 Training Kit Chapter 5
      9. Handout: Logins, Roles, and Users
      10. Lab: Logins, Roles, and Users
      11. Quiz: Migration, Logins, Roles, and Users
      12. Lecture: Managing and Troubleshooting Security
      13. Lecture: Auditing SQL Server
      14. Text Reading: 70-462 Training Kit Chapter 6
      15. Handout: Securables
      16. Handout: Troubleshooting and Auditing
      17. Lab: Security
      18. Quiz: Security
      19. Unit 2 Exam
    3. Unit 3
      1. Lecture: Implementing Database Mirroring
      2. Lecture: Implementing Replication
      3. Text Reading: 70-462 Training Kit Chapter 7
      4. Handout: Mirroring
      5. Handout: Replication
      6. Lab: Mirroring and Replication
      7. Lecture: Implementing a Clustered Instance
      8. Lecture: Implementing Always On
      9. Text Reading: 70-462 Training Kit Chapter 8
      10. Handout: Clustering
      11. Handout: AlwaysOn
      12. Lab: Clustering and AlwaysOn
      13. Quiz: Mirroring, Clustering, and Replication
      14. Lecture: Troubleshooting SQL Server
      15. Text Reading: 70-462 Training Kit Chapter 9
      16. Handout: Performance Monitor, Pror, and Activity Monitor
      17. Handout: Performance Monitoring in SQL Server
      18. Lab: Troubleshooting
      19. Quiz: Troubleshooting
      20. Unit 3 Exam
    4. Unit 4
      1. Lecture: Implementing and Maintaining Indexes
      2. Lecture: Identifying/Resolving Concurrency Issues
      3. Text Reading: 70-462 Training Kit Chapter 10
      4. Handout: Indexes
      5. Handout: Transactions
      6. Lab: Indexes and Concurrency
      7. Quiz: Indexes and Concurrency
      8. Lecture: Managing SQL Server Agent
      9. Lecture: Implementing a Backup Strategy
      10. Lecture: Restoring Databases
      11. Text Reading: 70-462 Training Kit Chapter 11
      12. Handout: Agent
      13. Handout: Backup
      14. Handout: Restore
      15. Lab: Agent, Backup, and Restore
      16. Quiz: Agent, Backup, and Restore
      17. Lab: Code Case Studies
      18. Final Practice Exam A
      19. Final Practice Exam B
      20. Final Practice Exam C
      21. Final Exam A
      22. Final Exam B
      23. Final Exam C
  3. MS-028 Implement Data Warehouse
    1. Unit 1
      1. Handout
      2. Lab: Installing VMWare
      3. Lab: Setting Up the Windows Server 2008 R2 Environment Using VMWare (if needed)
      4. Lab: Installing SQL Server Enterprise and Databases on the Virtual Machine (if needed)
      5. Lecture: Introduction to 70-463
      6. Lecture: Designing and Implementing Dimensions
      7. Lecture: Designing and Implementing Fact Tables
      8. Book Text Reading: 70-463 Training Kit: Chapter 1
      9. Handout: Data Warehouse Logical Design Supplementary Videos
      10. Handout: Research Data Warehouse Logical Design
      11. Lab: Data Warehouse Logical Design
      12. Text Reading: 70-463 Training Kit: Chapter 2
      13. Handout: Research Data Warehouse Implementation
      14. Lab: Implementing a Data Warehouse
      15. Quiz: Data Warehouse Design and Implementation
      16. Lecture: Introduction to SSIS/Connection Managers
      17. Text Reading: 70-463 Training Kit: Chapter 3
      18. Handout: Research SSIS Package Creation
      19. Lab: Introduction to SSIS
      20. Lecture: Designing Control Flow
      21. Lecture: Implementing Control Flow
      22. Text Reading: 70-463 Training Kit: Chapter 4
      23. Handout: Basic Control Flow Supplementary Videos
      24. Handout: Introducing Control Flow
      25. Lab: Control Flow
      26. Quiz: SSIS Introduction and Control Flow
      27. Unit 1 Exam
    2. Unit 2
      1. Lecture: Designing Data Flow
      2. Lecture: Implementing Data Flow
      3. Book Text Reading: 70-463 Training Kit: Chapter 5
      4. Handout: Basic Data Flow Supplementary Videos
      5. Lab: Data Flow
      6. Handout: Enhancing Control Flow Supplementary Videos
      7. Book Text Reading: 70-463 Training Kit: Chapter 6
      8. Handout: Researching Control Flow Enhancement
      9. Lab: Enhancing Control Flow
      10. Quiz: Data Flow and Enhanced Control Flow
      11. Lecture: Implementing Package Logic
      12. Lecture: Data Loading Options
      13. Text Reading: 70-463 Training Kit: Chapter 7
      14. Handout: Enhancing Data Flow Supplementary Videos
      15. Handout: Researching Data Flow Enhancement
      16. Lab: Enhancing Data Flow
      17. Lecture: Implementing Auditing, Logging, and Event Handlers
      18. Text Reading: 70-463 Training Kit: Chapter 8
      19. Handout: Restartable Package Supplementary Videos
      20. Lab: Transactions, Checkpoints, and Event Handlers
      21. Quiz: Enhancing Data Flow and Transactions
      22. Unit 2 Exam
    3. Unit 3
      1. Book Text Reading: 70-463 Training Kit: Chapter 9
      2. Handout: Researching Dynamic Packages
      3. Lab: Dynamic Packages
      4. Handout: Auditing and Logging Supplementary Videos
      5. Book Text Reading: 70-463 Training Kit: Chapter 10
      6. Handout: Researching Auditing and Logging
      7. Lab: Auditing and Logging
      8. Quiz: Dynamic Packages, Auditing, and Logging
      9. Lecture: Installing and Maintaining SSIS Components
      10. Lecture: Deploying SSIS Solutions
      11. Text Reading: 70-463 Training Kit: Chapter 11
      12. Handout: Researching SSIS Packages
      13. Handout: Installing and Deploying Supplementary Videos
      14. Lab: Installing SSIS and Deploying Packages
      15. Lecture: Managing SSIS Package Execution
      16. Lecture: Configuring SSIS Security
      17. Text Reading: 70-463 Training Kit: Chapter 12
      18. Lab: Executing and Securing Packages
      19. Quiz: Installing, Deploying, Executing, and Securing SSIS Packages
      20. Unit 3 Exam
    4. Unit 4
      1. Lecture: Troubleshooting Data Integration Issues
      2. Book Text Reading: 70-463 Training Kit: Chapter 13
      3. Handout: Troubleshooting Supplementary Videos
      4. Handout: Researching Troubleshooting and Debugging
      5. Lab: Troubleshooting Data Integration Issues
      6. Lecture: Installing and Maintaining Data Quality Services
      7. Lecture: Implementing Data Quality Services
      8. Book Text Reading: 70-463 Training Kit: Chapter 14
      9. Handout: Data Quality Services Supplementary Videos (24:40)
      10. Handout: Researching Data Quality Services
      11. Lab: Data Quality Services
      12. Quiz: Troubleshooting and Data Quality Services
      13. Lecture: How To Use the Data Profiling Task (10:24)
      14. Text Reading: 70-463 Training Kit: Chapter 17
      15. Handout: Researching DQS Data Cleansing Projects
      16. Lab: Cleaning Data Using Data Quality Projects
      17. Text Reading: 70-463 Training Kit: Chapter 18
      18. Handout: Researching Data Mining
      19. Lab: SSIS and Data Mining
      20. Quiz: Cleaning Data and SSIS Data Mining
      21. Unit 4 Exam
    5. Unit 5
      1. Lab: Installing the Windows SDK
      2. Lecture: Implementing Script Tasks
      3. Lecture: Implementing Script Components
      4. Book Text Reading: 70-463 Training Kit: Chapter 19
      5. Handout: Script Task Supplementary Videos
      6. Handout: Researching Scripts in SSIS
      7. Lab: Installing Visual Studio 2013 Community and VSTA 2012
      8. Lab: Script Tasks
      9. Lecture: Implementing Master Data Services
      10. Text Reading: 70-463 Training Kit: Chapter 15
      11. Handout: Master Data Services Supplementary Videos
      12. Handout: Researching Master Data Services
      13. Lab: Unpacking and Installing Office 2013 Trial and Tools for Office Runtime
      14. Lab: Master Data Services
      15. Quiz: Script Tasks and Master Data Services
      16. Lecture: Master Data Security (15:39)
      17. Lecture: MDS Add-In for Excel (13:29)
      18. Text Reading: 70-463 Training Kit: Chapter 16
      19. Handout: Researching Master Data Management
      20. Lab: Managing Master Data
      21. Quiz: Managing Master Data
      22. Unit 5 Exam
    6. Unit 6
      1. Handout: Fuzzy Transform Supplementary Videos
      2. Lecture: Fuzzy Transforms
      3. Book Text Reading: 70-463 Training Kit: Chapter 20
      4. Handout: Researching Fuzzy Transformations
      5. Lab: Identity Mapping and De-Duplicating
      6. Quiz: Identity Mapping and De-Duplicating
      7. Final Practice Exam A
      8. Final Practice Exam B
      9. Final Practice Exam C
      10. Final Exam A
      11. Final Exam B
      12. Final Exam C

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

State University of New York - Canton
CREST
34 Cornell Drive
Canton, NY 13617 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.