SQL (Structured Query Language) is used in programming and designed for managing data held in a relational database management system. The 70-764 and 70-765 modules are designed to teach you how to provision SQL Server databases both on premise and in SQL Azure, so managing a database from the cloud becomes an efficient and smooth process. You will also learn how to administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.
In this package, you will receive training for the two modules required, fully preparing you for the exams you need to gain certification and showcase your skills as a Database Administrator:
Microsoft 70-764: Administering a SQL Database Infrastructure
Microsoft 70-765: Provisioning SQL Databases
The database is key to any business, storing vital information about the business, employees, customers, market research and more data which helps your company to run day-to-day. The MCSA SQL 2016 Database Administration course is for IT professionals who work in an environment where databases play a key role in their primary responsibilities.
The MCSA SQL Server 2016 course will enable you to establish your technical skills in administering and managing databases to build a rewarding and sustainable career in IT.
Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry, with businesses of all sizes utilising these data platform solutions.
KEY LEARNING POINTS
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)
Provision, migrate and manage databases in the cloud
ADVANTAGES OF THIS COURSE
Learn how to administer and manage databases using the SQL database platform
Expert instructor-led training from subject matter experts with a minimum of 15 years’ industry experience
Exam simulations to help you prepare for the real thing
24/7 access to the course content for 12 months, so you can study anywhere, anytime!
Learn how to administer and manage databases in the cloud
Work your way towards coveted MCSA status
Self-paced training program that is designed to allow flexibility
Demonstrations and visual representations that allow students to develop their skills
Quizzes and exam simulators
World class Learning Management System (LMS) which allows you to interact with other students