Training 5 or more people?Get your team access to 3,500+ top courses anytime, anywhere. Contact our sale
Supporting database analysts and designers to go beyond simply understanding the mechanics of SQL Server 2012, this course shows how to create and deploy database solutions for an enterprise-class environment. Once this intensive, hands-on course has been completed, database analysts will have the knowledge and skills required to implement and develop robust and efficient SQL server solutions.
By completing this course students will fully understand the concepts behind Microsoft SQL Server 2012 and how to build and query complex database solutions in a real world environment. From the core fundamentals of installing and configuring SQL Server 2012, through to querying data directly using T-SQL and on to building and developing enterprise class data platforms, delegates will gain a complete understanding of the database system and How it can be extended to meet the data needs of the modern enterprise.
In addition to comprehensive training materials, the MCSE SQL Server 2012 Data Platform course also provides access to Practice-Labs. The Practice-Labs is an online environment where delegates have access to dedicated live equipment, allowing them to recreate course scenarios and design new database solutions without constructing their own costly test environment.
Students can expect to boost their job prospects and employability as they acquire new expert-level database design skills and experience in SQL Server 2012.
View more about Practice Labs
Completing the five modules included in this course will give participants all the skills and knowledge required to pass the MCSE Data Platform exams and prepare them for a successful career in database management and development.
After completing early modules that cover T-SQL and SQL Server 2012 installation and management, students will then go even deeper by learning about enterprise deployment scenarios, using SQL Server 2012 data warehousing to provide the back-end infrastructure for BI applications:
Building on the understanding of how SQL Server 2012 works, participants will then move on to extending functionality programmatically by:
The final module then uses all of the techniques learned so far, applying them to the question of designing and developing database solutions that will meet the most demanding business requirements:
Students will also cover a number of fundamental basics, such as the use of T-SQL to access and manipulate data, and installing and managing the SQL Server 2012 database platform. The course ensures that database analysts and designers gain a 360º overview of the system, necessary for building robust BI and data warehousing systems.
Web-accessible course materials allow students to follow the course at their own pace, in their own time. The MCSE SQL Server 2012 Data Platform course is essential for database developers and analysts who need:
Completion of this course also fully prepares database designers and data analysts for the SQL 2012 MCSA/MCSE exams.
Live Labs help to improve your understanding of specific exam objectives and provide direction on how to carry out actions in real world scenarios.