SQLServer

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Objetivos

Al finalizar el curso, los alumnos serán capaces de:

  • Describe core database administration tasks and tools.

  • Install and configure SQL Server 2014.

  • Configure SQL Server databases and storage.

  • Plan and implement a backup strategy.

  • Restore databases from backups.

  • Import and export data. Monitor SQL Server.

  • Trace SQL Server activity.

  • Manage SQL Server security.

  • Audit data access and encrypt data.

  • Perform ongoing database maintenance.

  • Automate SQL Server maintenance with SQL Server Agent Jobs.

  • Configure Database Mail, alerts and notifications.


Conoce más detalles sobre este curso

Logo SQL Server

This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Objetivos:

• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

Conoce más detalles sobre este curso

Logo SQL Server

This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.

Conoce más detalles de este curso

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

Conoce más detalles sobre este curso

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
Conoce más detalles sobre este curso

Logo SQL Server

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.

Conoce más detalles sobre este curso

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.

Conoce más detalles sobre este curso

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.

Conoce más detalles sobre este curso

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).
Conoce más detalles sobre este curso