The data explosion is happening at every level of business, across devices, applications, and individual roles. Maintaining maximum uptime, data availability, and level of compliance are not just expected skills from IT professionals, but are absolutely critical to ensuring a healthy business. By obtaining essential skills in Microsoft SQL Server, IT professionals can open doors to new opportunities and use their expertise to unite the power of the cloud with the demand for deeper insight into customer data. The MCSA: SQL 2016 Database Administration badge will teach the essential skills and knowledge to develop, run and, maintain the next wave of advanced database and information solutions.
Fees for each course include courseware, test preparation software, and a Microsoft certification voucher.
Querying Data with Transact-SQL
20434 LNT8761-300, 9/18-10/16, MON/WED., 6 p.m.-10:15 p.m., Tuition $1465 Fees $465
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
20435 LNT8764-300, 10/18-11/13, MON/WED., 6 p.m.-10:15 p.m., Tuition $1325 Fees $465
Learn the skills to administer and maintain the SQL Server 2016 database infrastructure. This 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.
LNT8765 Provisioning SQL Databases
20436 LNT8765-300, 11/15-12/13, MON/WED., 6 p.m.-10:15 p.m., Tuition $1325 Fees $465
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.
Register online or call 847.925.6300.
Visit our Computer Training page for additional information.