Microsoft SQL Server Certification Guide
MCSA: SQL SERVER
Microsoft Certified Solutions Associate • •
Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst.
COURSE: 20461
COURSE: 20462 Administering Microsoft SQL Server 2012-2014 Databases
Querying Microsoft SQL Server 2012-2014
EXAM: 70-462
COURSE: 20463 EXAM: 70-461
Implementing a Data Warehouse with Microsoft SQL Server 2012-2014
EXAM: 70-463
COURSE INFORMATION COURSE: 20461
COURSE: 20462
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 70461. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
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. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
COURSE: 20463 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 SQL Server 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. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
BECOME MCSA: SQL SERVER 2012 NOW
CERTIFICATION BUNDLE
SOFTWARE ASSURANCE
Just $7800+GST
$0 for 15-days of training Purchase these two classes with 15 Software Assurance Vouchers
15-days of instructor-led training: Class 20461: Querying Microsoft SQL Server 2012-2014 + Class 20462: Administering Microsoft SQL Server 20122014 Databases + Class 20463: Implementing a Data Warehouse with Microsoft SQL Server 2012-2014 + 3 Microsoft certification exams Exam 70-461 Exam 70-462 Exam 70-463
15-days of instructor-led training: Class 20461: Querying Microsoft SQL Server 2012-2014 + Class 20462: Administering Microsoft SQL Server 20122014 Databases + Class 20463: Implementing a Data Warehouse with Microsoft SQL Server 2012-2014
Add your 3 exams for just $449+GST
NEXT STEP: MCSE: DATA PLATFORM Microsoft Certified Solutions Expert • •
Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments. Earning an MCSE: Data Platform certification will qualify you for such jobs as database analyst and database designer.
MCSA SQL SERVER 2012-2014 COURSE: 20464
COURSE: 20465
Developing Microsoft SQL Server Databases
Designing a Data Solution with Microsoft SQL Server
EXAM: 70-464
EXAM: 70-465
COURSE INFORMATION COURSE: 20464
COURSE: 20465
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.
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.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
BECOME MCSE: DATA PLATFORM NOW
CERTIFICATION BUNDLE
SOFTWARE ASSURANCE
MCSA + $5700+GST
$0 for 10-days of training Purchase these two classes with 10 Software Assurance Vouchers
10-days of instructor-led training: Class 20464: Developing Microsoft SQL Server Databases + Class 20465: Designing a Data Solution with Microsoft SQL Server + 2 Microsoft certification exams Exam 70-464 Exam 70-465
10-days of instructor-led training: Class 20464: Developing Microsoft SQL Server Databases + Class 20465: Designing a Data Solution with Microsoft SQL Server
Add your two exams for just $299+GST
NEXT STEP: MCSE: BUSINESS INTELLIGENCE Microsoft Certified Solutions Expert • •
Show that you can deploy and manage desktops and devices that provide access from anywhere, while maintaining security and compliance. Also validate your skills in desktop virtualisation, remote desktop services and application virtualisation. Earning an MCSE: Desktop Infrastructure certification will qualify you for job roles such as desktop and device support, and data and applications manager.
MCSA SQL SERVER 2012-2014 COURSE: 20466
COURSE: 20467
Implementing Data Models and Reports with Microsoft SQL Server
Designing Self-Service Business Intelligence and Big Data Solutions
EXAM: 70-466
EXAM: 70-467
COURSE INFORMATION COURSE: 20466
COURSE: 20467
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 SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
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.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
BECOME MCSE: BUSINESS INTELLIGENCE NOW
CERTIFICATION BUNDLE
SOFTWARE ASSURANCE
MCSA + $5700+GST
$0 for 10-days of training Purchase these two classes with 10 Software Assurance Vouchers
10-days of instructor-led training: Class 20466: Implementing Data Models and Reports with Microsoft SQL Server + Class 20467: Designing Self-Service Business Intelligence and Big Data Solutions + 2 Microsoft certification exams Exam 70-466 Exam 70-467
10-days of instructor-led training: Class 20466: Implementing Data Models and Reports with Microsoft SQL Server + Class 20467: Designing Self-Service Business Intelligence and Big Data Solutions
Add your two exams for just $299+GST
GET CERTIFIED WITH AULDHOUSE AULDHOUSE
CONTACT US
Auldhouse is the IT training partner of choice for many of NZ's leading organisations as well as the world's largest software vendors. We are NZ's largest Microsoft Gold Partner for Learning delivering world class in‐depth Microsoft training. Auldhouse were awarded the Partner of the Year Award for Learning Solutions at the 2007, 2008, 2009, 2010, 2012 and 2013 Microsoft New Zealand Partner Awards.
www.auldhouse.co.nz
[email protected] 0800 835 835 Follow us on Twitter @trainauldhouse
Follow us on LinkedIn www.linkedin.com/company/auldhouse-computer-training
Become a friend on Facebook www.facebook.com/Auldhouse
