Logo SQL Server

MCSA: SQL 2016 Database Administration

This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.

Course 20765C: Administering a SQL Database Infrastructure

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

After completing this course, students will be able to:

  • Provision a Database Server

  • Upgrade SQL Server

  • Configure SQL Server

  • Manage Databases and Files (shared)

  • Provision, migrate and manage databases in the cloud


SQL Server logo

The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

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

Logo SQL Server

MCSA: SQL 2016 Database Administration

This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.

Course 20764C: Administering a SQL Database Infrastructure

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

You will learn these contents:

  • 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.

Logo SQL Server

This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

You will learn these contents:

  • Describe reporting services and it’s components.
  • Describe reporting services data sources.
  • Implement paginated reports.
  • Work with reporting services data.
  • Visualize data with reporting services.
  • Aggregate report data.
  • Share reporting services reports.
  • Administer reporting services.
  • Expand and integrate reporting services.
  • Describe mobile reports.
  • Develop mobile reports.

Logo SQL Server

This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

You will learn these contents:

  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.


SQLServer

This 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.

After completing this course, students will be able to:

  • Provision a Database Server.
  • Upgrade SQL Server.
  • Configure SQL Server.
  • Manage Databases and Files (shared).