Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. Our exam simulators creates a simulation of an actual certification exam. Sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test. Combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our courses are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields. In this module, students will learn how to deploy packages and their dependencies to a server, and how to manage and monitor the execution of deployed packages.
This module describes the techniques you can use to implement an incremental data warehouse refresh process. This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation. This module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The module is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause. Write queries that retrieve system metadata using system views and functions.
Lab: Auditing Data Access and Encrypting Data
Use captured traces to test, troubleshoot, and optimize database performance. Describe SQL 2014 Admin Lessons how database transaction logs function, and how they affect database recovery.
Delegates must have a good working knowledge of Microsoft SQL Server. This can be obtained by attending our SQL Server Essentials course. We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs. If you have access to a second screen, we would encourage you to use it as it improves the experience. Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch. This course will give you a comprehensive insight into the infrastructure and architecture of SQL Server. This will allow you to fully understand the product that you are managing.
Microsoft SQL Server Administration
A full day training programme that delivers techniques for producing professionally-presented minutes and includes a review and evaluation of minutes that delegates are currently producing. A broad set of database-related skills that can be applied across multiple operating environments. Using SQL to query Oracle databases directly and return specific data.