Microsoft MCSA: SQL 2016 Database Administration
MCSA: SQL 2016 Database Administration badge earners have obtained essential skills
in Microsoft SQL Server and have the knowledge to develop, run, and maintain an advanced
database and information solutions. Participants can write basic Transact-SQL and
build foundations for SQL Server related disciplines in database administration, database
development, and business intelligence. Badge earners can create and manage an Azure
Prerequisite: Working knowledge of relational databases
- Write basic Transact-SQL
- Build foundation for SQL Server
- Maintain a SQL Server database
- Implement a business intelligence platform
- Implement the appropriate Security model to protect the data
- Create and manage an Azure SQL database
LNT8761 Querying Data with Transact-SQL
This course is designed 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. Write SELECT queries, query multiple tables, sort and filter data, use built-in functions, group and aggregate data types, work with table expressions and set operators, and program with T-SQL. Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; working knowledge of relational databases.
LNT8764 Administering a SQL Database Infrastructure
Learn the skills to administer and maintain the SQL Server 2016 database infrastructure. The course is designed for developers of applications that deliver content from SQL Server databases. Learn how to authenticate and authorize users and access resources. Understand how to monitor and troubleshoot the SQL Server infrastructure. Prerequisites: basic knowledge of the MS Windows core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design.
LNT8765 Provisioning SQL Databases
Gain the knowledge and skills to provision a Microsoft SQL Server 2016 database, both on-premise and in Azure. Covers installing from new and migrating from an existing install. Learn to upgrade and configure SQL servers; manage databases and files. Prerequisites: basic knowledge of the MS Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design (LNT0008 Querying Data with Transact-SQL or equivalent experience).