Introduce DMVs and the configuration of data collection.Work with SQL Profiler and SQL Trace stored procedures.Configure database mail, alerts, and notifications.

Implement SQL Server agent security, proxy accounts, and credentials.

Work with SQL Server Agent, jobs, and job history.

Work with permissions and the assignment of permissions.

Work with fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.

Work with SQL Server security models, logins, and users.

Use the import/export wizards and explain how they relate to SSIS.

Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.Describes the system databases, the physical structure of databases, and the most common configuration options related to them.Use window ranking, offset and aggregate functions.

This course helps people prepare for exam 70-463.Īfter completing this course, students will be able to: This instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2012/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. Data warehousing is a solution organizations use to centralize business data for reporting and analysis. Also, this course helps you prepare for Exam 70-462. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012/2014 database. This course helps people prepare for exam 70-461. This course is the foundation for all SQL Server-related disciplines namely, Database Administration, Database Development, and Business Intelligence. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012/2014. 20463D: Implementing a Data Warehouse with Microsoft SQL Server 2014.20462D: Administering Microsoft SQL Server 2014 Databases.20461D: Querying Microsoft SQL Server 2014.This 7-day boot camp is a combination of the following official Microsoft courses: This program covers all material and exams necessary to achieve an MCSA in Microsoft SQL Server 2012/2014. MCSA: Microsoft SQL Server 2012/2014 certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. With this SQL Server 2012/2014 course, you will gain valuable insight into the new, powerful capabilities that SQL Server 2012 adds to a database developer and administrator’s solutions toolbox. You get detailed explanations for right and wrong answers - including a customized learning path that describes how and where to focus your studies.įor customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.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. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. Maximize your performance on the exam by mastering the skills and experience measured by these objectives:Īssess your skills with practice tests. Then, reinforce and apply what you've learned through real-world case scenarios and practice exercises. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Ace your preparation for the skills measured by Exam 70-462 - and on the job - with this official Microsoft study guide.

Mcsa guide to microsoft sql server 2012