Training 5 or more people?Get your team access to 3,500+ top courses anytime, anywhere. Contact our sale
Master the fundamentals of enterprise-class database management using Microsoft SQL Server with this course bundle. From basic installation and maintenance, through to advanced deployments that support Business Intelligence applications, the MCSA SQL Server bundle contains everything required to sit and pass the associated Microsoft examination.
Moving quickly from basic concepts to advanced techniques, this cost-effective course bundle is best suited to:
The MCSA SQL Server Certification bundle contains four separate courses to give a complete grounding in database management, particularly with regards to data warehousing and Business Intelligence applications. Delivered completely online using the e-learning platform, students can access content whenever, wherever and however they choose. A careful blend of instructor-led videos, interactive content and eGuides takes students step-by-step through each concept, ensuring they have a good understanding of each topic before moving on.
Helping students develop and refine their practical database querying and management skills with access to dedicated live equipment. This set-up allows them to put their knowledge to the test and recreate each of the scenarios they encounter in their studies. By completing this course students will not only fully understand the concepts behind Microsoft SQL Server 2012, but also develop the skills needed to properly manage, maintain and manipulate a database in a real world environment as well passing the included MCSA certification exam.
Composed of four in-depth standalone courses, the MCSA SQL Certification bundle contains everything needed to manage a SQL Server database environment – particularly those being used for data warehousing or business intelligence applications.
The first course – Querying SQL Server 2012 – teaches candidates how to access and manipulate data stored in the tables using Transact-SQL (T-SQL):
The next course – Administering SQL Server 2012 Databases – then takes students through the tools and techniques required to manage and maintain a SQL Server environment. Participants will learn to:
The third course – Implementing a Data Warehouse with SQL Server 2012 – introduces the concepts behind data warehousing, and building extremely large database stores:
The fourth and final course – Microsoft SQL Server 2008 Business Intelligence Development and Maintenance – looks at using SQL Server databases for Business Intelligence and data mining purposes, covering:
Once the four constituent courses have been completed, students will be fully prepared to work in enterprise-class database environments, and to sit and pass the included MCSA examination.
Other benefits of completing this course include:
Once all of the practical exercises have been complete, students will have all the knowledge and experience they need to earn their MCSA qualification – particularly valuable proof of their skills and ability.