DATABASE | Think360 Discover more below

Think360 offers a wide range of Microsoft certification programs designed to take your IT skills—and your career—to the next level.

MTA: Database

40364: Database Administration Fundamentals

ABOUT THIS COURSE – This three-day 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. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

VIEW FULL COURSE

MCSA: SQL 2016 Database Development

20761: Querying Data with Transact-SQL

ABOUT THIS COURSE – The main purpose of this 3-day instructor led course is 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. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers
VIEW FULL COURSE

20762: Developing SQL Databases

ABOUT THIS COURSE – This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
VIEW FULL COURSE

MCSA: SQL 2016 Database Administration

20764: Administering a SQL Database Infrastructure

ABOUT THIS COURSE – This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
VIEW FULL COURSE

20765: Provisioning SQL Databasess

ABOUT THIS COURSE –This three-day instructor-led 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.
VIEW FULL COURSE

MCSA: SQL 2016 Business Intelligence Development

20767: Implementing a SQL Data Warehouse

ABOUT THIS COURSE – This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services
VIEW FULL COURSE

20768: Developing SQL Data Models

ABOUT THIS COURSE – This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
VIEW FULL COURSE

MCSA: SQL Server 2014

20461: Querying Microsoft SQL Server

ABOUT THIS COURSE – This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
VIEW FULL COURSE

20462: Administering Microsoft(r) SQL Server(r) Databases

ABOUT THIS COURSE – This five-day instructor-led 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.
VIEW FULL COURSE

20463: Implementing a Data Warehouse with Microsoft(r) SQL Server

ABOUT THIS COURSE – This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft(r) SQL Server(r) 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
VIEW FULL COURSE

MCSE: Data Platform

20464: Developing Microsoft(r) SQL Server(r) Databases

ABOUT THIS COURSE – This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.
VIEW FULL COURSE

20465: Designing a Data Solution with Microsoft(r) SQL Server

ABOUT THIS COURSE – The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.
VIEW FULL COURSE

MCSE: Business Intelligence

20466: Implementing Data Models and Reports with Microsoft(r) SQL Server

ABOUT THIS COURSE – The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft(r) SQL Server(r) Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
VIEW FULL COURSE

20467:Designing Self-Service Business Intelligence and Big Data Solutions

ABOUT THIS COURSE – This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.
VIEW FULL COURSE