Microsoft Learning Training and Certification - SQL Server 2012
Technorati Tags: Microsoft Certification,SQL Server 2012
MSL Training Portal: https://www.microsoft.com/learning/en/us/training/sql-server.aspx
Courses: The SQL Server 2012 courses are designed to enable database professionals to take full advantage of SQL Server 2012 and if they choose to validate their skills with certification. Over 100 industry professionals identified baskic skills that they use and expected peers and employees to know regardless of final career path. This common set of knowledge is covered in our first three courses. Therefore, if someone wants to embark on the journey or quickly learn an aspect of SQL Server that they may not use currently use they would start here. For those who have not had formal training or hands on with SQL 2012, these courses cover the latest version of SQL Server so they can take advantage of the latest features while getting the fundamentals correct to save time later.
The later courses divide into some typical specialized career paths for database platform and business intelligence developer. Students may take an entire path or take what they need to round out skills in SQL Server 2012.
Course 10774: Querying Microsoft SQL Server 2012
This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. It is also appropriate entry for business analysts who may write SQL queries in other tools such as Excel, and those embarking on the jobs in the data steward career path. In short anyone who may read data from a database and can write ad-hoc queries against it. Later students will encapsulate the queries in database objects but at this stage in their knwledge would most likely not have those rights in prodcution environments. This course helps people prepare for exam 70-461
Course 10775: Administering Microsoft SQL Server 2012 Databases
This course is designed to be the second in the series of basic skills. At this point student can retrieve (SELECT) data and has baskic relational database concepts and tools experience. The next step is to understand the system more such understanding of the security model, working with the database maintenence such as backup and maintainence of indexes are covered. Students who will primarily maintain the database will find key knowledge here, but those learnign the platform will benefit. Those with ANSI SQL knowledge wanting to understand the Microsoft SQL Server database management system will want to start here. This course helps you prepare for the Exam 70-462 .
Course 10776: Developing Microsoft SQL Server 2012 Databases
Students emabark on implementing the database objects in this course. They now have the rights on the server to implement the objects using data definition language statements for optimal server code performance with stored procedures. Students are also taught key topics such as geo-pacial data and XML storage and retrieval common in Web databases. This course helps you prepare for the Exam 70-464 .
Course 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
This course is about the movement of data. Professionals identified a key task was to move data into and out of their servers. This course covers ETL and Microsoft SQL Server 2012 Integration Services. It is the final course now that data may be retireved, data objects such as views created, and now to move into other locations such as a data warehouse snowflake or star schema. It is still usings the SQL Server relational engine so is everythign up to the data warehouse before moving to analysis services. This course helps people prepare for the exam 70-463 . It is the basis for feeding the datawarehouse solution created in course 10778.
Course 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012
Students are now ready to implement multi-dimensional models and use SQL Server Analysis service. They will support end user reporting solutions and SQL Server Reporting Service. Business analysts may be interested in portions of this course if their primary interest is reporting piece and do not intent to create the datawarehouse. Excel Power Pivot is coveredin the course. This course helps people prepare for exam 70-466 .
Exams:
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam 70-464: Developing Microsoft SQL Server 2012 Databases
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Free Snacks:
Introduction to the Database Consolidation Appliance
Value Proposition of the Database Consolidation Appliance
Using the Database Consolidation Appliance
SQL Server 2012: Mission Critical Confidence
SQL Server 2012: Breakthrough Insight
SQL Server 2012: Cloud On Your Terms
Free eBook: Introducing Microsoft SQL Server 2012 (second DRAFT preview)
Book: Microsoft® SQL Server® 2012 Pocket Consultant
SQL Cookbook Wiki: Additional MS Content