MCSE: Data Management and Analysis ( Development )
The Academy of South Florida offers the fastest, most effective method to learn the industry-standard, fundamental features of Microsoft SQL Server that have made Microsoft's premiere database solution a worldwide leader in data-driven business and application infrastructure.
With this SQL Server 2016 boot camp, you will gain valuable insight into the new, powerful capabilities that SQL Server 2016 adds to a database developer and administrator's solutions tool box.
MCSE: Data Management and Analysis certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. This program covers all material and exams necessary to achieve an MCSA in Microsoft SQL Server 2016 Database Development and MCSE: Data Management and Analysis.
This 7-day boot camp is a combination of the following official Microsoft courses:
• 20761A: Querying Data with Transact SQL
(Course is available, Microsoft currently offers the exam only in Beta version... updates coming soon.)
• 20762A: Developing SQL Databases
(Course is available, Microsoft has not yet released the exam... updates coming soon.)
• 20465A: Designing Database Solutions for Microsoft SQL Server
(Course and exam available but only for 2014 SQL Server thus far...updates coming soon.)
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2016. 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-761. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-762. Database Developing and warehousing is a solution organizations use to centralize business data for reporting and analysis. This instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2016, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for exam 70-465.
After completing this course, students will be able to:
Before attending this course, students must have:
Before attending this course, students should have: