Accordion Content

Microsoft 70-461: Querying SQL Server 2012

This course is intended for SQL Server
database administrators, implementers, system engineers, and developers. This
new SQL 2012 course is focused on anyone interested in the validation of your
skills and knowledge with writing queries. 

This course provides the knowledge and
understanding for some of these important job functions:

• Apply built-in scalar functions
• Apply ranking functions
• Combine datasets
• Creates and alters
• Design T-SQL stored procedures, views
• Implementing aggregate queries, error handling, sequence
  generation and data types
• Manage transactions
• Modify data by using INSERT, UPDATE, DELETE and MERGE
  statements
• Optimizing queries
• Query data using SELECT statements and Managing XML data
• OUTPUT clause to return data

This learning course provides the knowledge
for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

• Create Database Objects
• Create and alter tables using T-SQL syntax (simple statements).
• Create and alter views (simple statements).
• Design views.
• Create and modify constraints (simple statements).
• Create and alter DML triggers.
• Work with Data
• Query data by using SELECT statements.
• Implement sub-queries.
• Implement data types.
• Implement aggregate queries.
• Query and manage XML data.
• Modify Data
• Create and alter stored procedures (simple statements).
• Modify data by using INSERT, UPDATE, and DELETE statements.
• Combine datasets.
• Work with functions.
• Troubleshoot & Optimize
• Optimize queries.
• Manage transactions.
• Evaluate the use of row-based operations vs. set-based
  operations.
• Implement error handling.

We create the highest quality course
curriculum possible, ensuring you receive the training and knowledge needed to
succeed. 

Who is the target audience?

• SQL Server database administrators, system engineers, and
  developers with two or more years of experience, who are seeking to
  validate their skills and knowledge in writing queries.

Microsoft 70-462: Administering SQL Server 2012 Databases

This training course was created
specifically for those individuals (Database Professionals) who install,
maintain and configure as their primary job function. Any participants setting
up database systems and/or responsible for efficient system operation, regular
database backups stored effectively, and securing data from unauthorized access
is also a candidate for this training course on SQL 2012.

Below is a partial list of job functions
associated to this training course:

• Audit SQL Server instances
• Back up databases
• Configure additional SQL Server components, Instances and
  Services
• Deploying a SQL Server
• Implementing strategies, columnstores and High-Availability and
  Disaster Recovery solutions
• Importing/exporting
• Install SQL Server and related services.
• Maintenance
• Management, configuration, permissions, alerts, logins and
  roles.
• Optimization
• Installation Planning
• Restoring
• Troubleshooting

The SQL 2012 Administering Databases course
prepares you for the Microsoft Exam 70-462 – As the participant in the SQL 2012
Administering course will learn:

• Installation Planning
• Installing SQL Server and related services
• Implementation of a migration strategy
• How to configure additional SQL Server components
• Managing the SQL Server Agent
• Database management and configuration
• How to configure SQL Server instances
• Implementing a SQL Server clustered instance
• SQL Server instances management
• How to properly Identify and resolve concurrency problems
• The collection of and how to analyze troubleshooting data
• Auditing SQL Server instances
• Configure and maintain a backup strategy
• Database restoration
• Implementing and maintaining indexes
• Importing and exporting data
• Managing logins and server roles
• Managing database permissions
• Managing users and database roles
• Troubleshooting security
• Implementing AlwaysOn, database mirroring and replication

We create the highest quality course
curriculum possible, ensuring you receive the training and knowledge needed to
succeed. 

Who is the target audience?

• IT Professionals
• Database Professionals 

Microsoft 70-463: Implementing A Data Warehouse With
SQL Server 2012

This course is specifically for
participants to measure their knowledge and skills on making the appropriate
job role decisions around implementing a Data Warehouse with Microsoft SQL
Server 2012. 

This course is designed for ETL and Data
Warehouse Developers who most likely focus on hands-on work creating business
intelligence (BI) solutions, including data cleansing, Extract Transform Load
(ETL), and Data Warehouse implementation. Primary responsibilities may include:

• Mastering data using Master Data Services
• Cleansing data using Data Quality Services
• ETL Package development for data
  loading/transfer/transformation
• Data Synchronization
• One-time data or application migration
• Ad-hoc data manipulations, transformations
• Scheduling ETL jobs
• Managing, configuring and deploying SQL Server Integration
  Services (SSIS) packages

This training course on implementing a Data
Warehouse with Microsoft SQL Server 2012 prepares participants for the
Microsoft Exam 70-463.

This course will provide all the skills and
knowledge for the following areas:

• Designing and implementing dimensions
• Designing and implementing fact tables
• Defining connection managers
• Designing and implementing data flow
• Managing SSIS package execution
• Implementing script tasks in SSIS
• Designing and implementing control flow
• Implementing package logic using SSIS variables and parameters
• Implementing data load options
• Implementing script components in SSIS
• Troubleshooting data integration issues
• Installing and maintaining SSIS components
• Implementing auditing, logging, and event handling
• Deploying SSIS solutions
• Configuring SSIS security settings
• Installing and maintaining Data Quality Services
• Implementing master data management solutions
• Creating a data quality project to clean data

We create the highest quality course
curriculum possible, ensuring you receive the training and knowledge needed to
succeed. 

Who is the target audience?

• IT Professionals who wish to gain Microsoft Certification
• ETL and data warehouse developers

Microsoft 70-464: Developing Microsoft SQL Server 2012
Databases

This course is specifically for
participants to measure their knowledge and skills on making the appropriate
job role decisions around Developing Microsoft SQL Server 2012 Databases. 

This course is designed for Database
developers who build and implement databases across the organization, while
ensuring high levels of data availability. They perform tasks including
creating database files, create data types, tables, plan create and optimize indexes,
implement data integrity, implement views, stored procedures and functions,
manage transactions and locks. Primary responsibilities may include:

• Optimizing and tuning queries.
• Creating and altering indexes and stored procedures.
• Maintaining database integrity.
• Optimizing indexing strategies.
• Creating and altering tables.
• Maintaining indexes.
• Creating and modifying constraints.

This training course on developing
Microsoft SQL Server 2012 Databases prepares participants for the Microsoft
Exam 70-464.

This course will provide all the skills and
knowledge for the following areas:

• Creating and altering tables (complex statements)
• Designing, implementing, and troubleshooting security
• Designing the locking granularity level
• Maintaining indexes
• Implementing data types
• Creating and modifying constraints (complex statements)
• Working with XML Data
• Writing automation scripts
• Designing and implementing stored procedures
• Designing T-SQL table-valued and scalar functions
• Creating, using, and altering user-defined functions (UDFs)
• Creating and altering views (complex statements)
• Designing tables
• Designing for concurrency
• Creating and altering indexes
• Designing data integrity
• Designing for implicit and explicit transactions
• Optimizing and tuning queries
• Troubleshooting and resolving performance problems
• Optimizing indexing strategies
• Capturing and analyzing execution plans
• Collecting performance and system information

We create the highest quality course
curriculum possible, ensuring you receive the training and knowledge needed to
succeed. 

Who is the target audience?

• IT professionals

Microsoft 70-465: Designing Database Solutions for
Microsoft SQL Server 2012

This course is specifically for
participants to measure their knowledge and skills on making the appropriate
job role decisions around designing database solutions for Microsoft SQL Server
2012. 

This course is designed for Database
professionals who design and build database solutions. These Database
professionals are responsible for the creation of plans and designs for
Database structure, storage, objects, and servers, as well as creating the plan
for the environment in which the database solution runs. Primary
responsibilities may include but are not limited to designing:

• Data compression strategies
• Database models
• Full-Text Search strategies
• High-availability solutions
• Maintenance strategy for database servers
• Management automation strategies
• Migration, consolidation, and upgrade strategies
• Database, schema, and object security parameters

This training course on designing database
solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft
Exam 70-465:

• Creating and altering tables (complex statements)
• Designing, implementing, and troubleshooting security
• Designing the locking granularity level
• Maintaining indexes
• Implementing data types
• Creating and modifying constraints (complex statements)
• Working with XML Data
• Writing automation scripts
• Designing and implementing stored procedures
• Designing T-SQL table-valued and scalar functions
• Creating, using, and altering user-defined functions (UDFs)
• Creating and altering views (complex statements)
• Designing tables
• Designing for concurrency
• Creating and altering indexes
• Designing data integrity
• Designing for implicit and explicit transactions
• Optimizing and tuning queries
• Troubleshooting and resolving performance problems
• Optimizing indexing strategies
• Capturing and analyzing execution plans
• Collecting performance and system information

We create the highest quality course
curriculum possible, ensuring you receive the training and knowledge needed to
succeed. 

Who is the target audience?

• IT professionals
• Anyone aspiring to be Microsoft certification