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 SQL database.
 
Prerequisite: Working knowledge of relational databases
 
Program objectives:

  • 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

Required courses

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

alert iconCoronavirus (COVID-19) Outbreak
Harper College has implemented safety measures that impact fall semester coursework, events and travel. Read More