MCSA: SQL 2016 Solutions Associate

MCSA: SQL 2016 Solutions Associate
 
mcsa sql server 2016 banner
The skills for your professional career
Demonstrate your essential skills as a database professional, for both on-premises and cloud-based databases. 
Earning an MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

lrn-certlogo-SolAssoc SQL2016 DBDev Blk 1MCSA: SQL 2016 Database Development 

Exam
MOC
Course name
hours
70-761
20761
24
70-762
20762
32



 

Earning an MCSA: SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist. 

lrn-certlogo-SolAssoc SQL2016 DBAdmin BlkMCSA: SQL 2016 Database Administration 

Exam
MOC
Course name
hours
70-764
20764
40
70-765
20765
24

 

 

 

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

 lrn-certlogo-SolAssoc SQL2016 BisInt BlkMCSA: SQL 2016 Business Intelligence Development

Exam
MOC
Course name
hours
70-767
20767
40
70-768
20768
24

 

 

 

 Course 20761A:Querying Data with Transact-SQL

About this course
The main purpose of this 3 day instructor led  course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Audience profile
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
 
Prerequisites
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.
 
At course completion
After completing this course, students will be able to:
Describe the basic architecture and concepts of Microsoft SQL Server 2016.
Understand the similarities and differences between Transact-SQL and other computer languages.
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions
Course Outline
Module 1: Introduction to Microsoft SQL Server 2016
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2016 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Set Operators

Course 20762A:Developing SQL Databases

About this course

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

 

Audience profile

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

 

At course completion

After completing this course, students will be able to:

Design and Implement Tables.

Describe advanced table designs

Ensure Data Integrity through Constraints.

Describe indexes, including Optimized and Columnstore indexes

Design and Implement Views.

Design and Implement Stored Procedures.

Design and Implement User Defined Functions.

Respond to data manipulation using triggers.

Design and Implement In-Memory Tables.

Implement Managed Code in SQL Server.

Store and Query XML Data.

Work with Spatial Data.

Store and Query Blobs and Text Documents.

 

Course Outline

Module 1: Introduction to Database Development

Module 2: Designing and Implementing Tables

Module 3: Advanced Table Designs

Module 4: Ensuring Data Integrity through Constraints

Module 5: Introduction to Indexes

Module 6: Designing Optimized Index Strategies

Module 7: Columnstore Indexes

Module 8: Designing and Implementing Views

Module 9: Designing and Implementing Stored Procedures

Module 10: Designing and Implementing User-Defined Functions

Module 11: Responding to Data Manipulation via Triggers

Module 12: Using In-Memory Tables

Module 13: Implementing Managed Code in SQL Server

Module 14: Storing and Querying XML Data in SQL Server

Module 15: Storing and Querying Spatial Data in SQL Server

Module 16: Storing and Querying BLOBs and Text Documents in SQL Server

Back to Top 

 

Course 20764A: Administering a SQL Database Infrastructure

 

About this course

 

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

 

Audience profile

 

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

 

At course completion

 

After completing this course, students will be able to:

Authenticate and authorize users

Assign server and database roles

Authorize users to access resources

Protect data with encryption and auditing

Describe recovery models and backup strategies

Backup SQL Server databases

Restore SQL Server databases

Automate database management

Configure security for the SQL Server agent

Manage alerts and notifications

Managing SQL Server using PowerShell

Trace access to SQL Server

Monitor a SQL Server infrastructure

Troubleshoot a SQL Server infrastructure

Import and export data

 

Course Outline

 

Module 1: Authenticating and Authorizing Users

Module 2: Assigning Server and Database Roles

Module 3: Authorizing Users to Access Resources

Module 4: Protecting Data with Encryption and Auditing

Module 5: SQL Server Recovery Models

Module 6: Backup of SQL Server Databases

Module 7: Restoring SQL Server Databases

Module 8: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agent

Module 10: Monitoring SQL Server with Alerts and Notifications

Module 11: Introduction to Managing SQL Server by using PowerShell

Module 12: Tracing Access to SQL Server

Module 13: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

Module 15: Importing and Exporting Data

Back to Top 

 

Course 20765A: Provisioning SQL Databases
 
About this course
 
This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 
 
Audience profile
 
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
 
 
At course completion
 
After completing this course, students will be able to:
Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)
 
Course Outline
 
Module 1: SQL Server 2016 Components
Module 2: Installing SQL Server 2016
Module 3: Upgrading SQL Server to SQL Server 2016
Module 4: Deploying SQL Server on Microsoft Azure
Module 5: Working with Databases
Module 6: Database Storage Options
Module 7: Performing Database Maintenance

 Back to Top

Course 20767A: Implementing a SQL Data Warehouse

About this course

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

 

Audience profile

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

 

 

At course completion

After completing this course, students will be able to:

Describe the key elements of a data warehousing solution

Describe the main hardware considerations for building a data warehouse

Implement a logical design for a data warehouse

Implement a physical design for a data warehouse

Create columnstore indexes

Implementing an Azure SQL Data Warehouse

Describe the key features of SSIS

Implement a data flow by using SSIS

Implement control flow by using tasks and precedence constraints

Create dynamic packages that include variables and parameters

Debug SSIS packages

Describe the considerations for implement an ETL solution

Implement Data Quality Services

Implement a Master Data Services model

Describe how you can use custom components to extend SSIS

Deploy SSIS projects

Describe BI and common BI scenarios

Course Outline

Module 1: Introduction to Data Warehousing

Module 2: Planning Data Warehouse Infrastructure

Module 3: Designing and Implementing a Data Warehouse

Module 4: Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

Module 7: Implementing Control Flow in an SSIS Package

Module 8: Debugging and Troubleshooting SSIS Packages

Module 9: Implementing an Incremental ETL Process

Module 10: Enforcing Data Quality

Module 11: Using Master Data Services

Module 12: Extending SQL Server Integration Services (SSIS)

Module 13: Deploying and Configuring SSIS Packages

Module 14: Consuming Data in a Data Warehouse

Back to Top

Course 20768A:Developing SQL Data Models

About this course

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
 
Audience profile
 
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.  Primary responsibilities will include:
Implementing multidimensional databases by using SQL Server Analysis Services
Creating tabular semantic data models for analysis by using SQL Server Analysis Services
The secondary audiences for this course are ‘power’ information workers/data analysts.
 
At course completion
 
After completing this course, students will be able to:
Describe the components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
 
Course Outline
 
Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Creating Multidimensional Databases
Module 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
Module 5: Introduction to MDX
Module 6: Customizing Cube Functionality
Module 7: Implementing a Tabular Data Model by Using Analysis Services
Module 8: Introduction to Data Analysis Expression (DAX)
Module 9: Performing Predictive Analysis with Data Mining
 
  
 

 

 

 

All Rights Reseved © Computekeg.com