Description
About this Course
Explosive growth in data collection by businesses as well as an increased need for database security measures contributes to the phenomenal demand for database administrators. Modern leading businesses depend on databases for deeper insights into their data which drive critical business decisions.
Master the skills required to become a database professional on the most widely used database management system for both on-premises and cloud-based databases - SQL Server 2016/2017. This course leads you to successfully achieve the MCSA SQL Database Administration certification which validates your skills and hands-on experience with database installation, maintenance, configuration and provisioning tasks and will qualify you for various key roles including database administrator, architect, development lead or infrastructure specialist.
Who Should Attend
- Individuals who administer and maintain SQL Server databases.
- Professionals who work in environments where databases play a key role in their primary job.
- Developers who craft applications that deliver content from SQL Server databases.
- Database Administration, Business Intelligence and Machine Learning enthusiasts.
Course Outline
- SQL Server Security
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Protecting Data with Encryption and Auditing
- Recovery Models and Backup Strategies
- Backing Up SQL Server Databases
- Restoring SQL Server 2016 Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server with Extended events
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data
For more details on this module, kindly visit the official Microsoft page by following this link.
- SQL Server Components
- Installing SQL Server
- Upgrading SQL Server to SQL Server 2017
- Working with Databases
- Performing Database Maintenance
- Database Storage Options
- Planning to Deploy SQL Server on Microsoft Azure
- Migrating Databases to Azure SQL Database
- Deploying SQL Server on a Microsoft Azure Virtual Machine
- Managing databases in the Cloud
For more details on this module, kindly visit the official Microsoft page by following this link.
Certification
 |
The MCSA SQL Database Administration certification validates that you have the skills needed to install, maintain, configure and provision databases. This internationally recognised credential can be earned by passing the following 2 Microsoft exams:
70-764: Administering a SQL Database Infrastructure |
Funding
Students following the MCSA SQL Database Administration study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (i.e. €1,120 will be refunded back for this course).
For further details and assistance on how to apply for this scheme, kindly contact us for an appointment.
Course Details
MODE OF STUDY
PARTTIME
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
- Good Knowledge of English
- Foundational IT skills
NEXT STEPS
DURATION
81 Hours (27 Lessons of 3 Hours)
DAY(S)
TBA
TIME
TBA
WHAT'S INCLUDED
- Training by a Microsoft Certified Trainer (MCT)
- Official Microsoft Courseware (Format: Paperback)
- Official Microsoft Virtual Labs
- Official Microsoft Presentations
- Official Microsoft Practice Tests
- Official Microsoft Exams
Price: € 1600
Explosive growth in data collection by businesses as well as an increased need for database security measures contributes to the phenomenal demand for database administrators. Modern leading businesses depend on databases for deeper insights into their data which drive critical business decisions.
Master the skills required to become a database professional on the most widely used database management system for both on-premises and cloud-based databases - SQL Server 2016/2017. This course leads you to successfully achieve the MCSA SQL Database Administration certification which validates your skills and hands-on experience with database installation, maintenance, configuration and provisioning tasks and will qualify you for various key roles including database administrator, architect, development lead or infrastructure specialist.
Who Should Attend
- Individuals who administer and maintain SQL Server databases.
- Professionals who work in environments where databases play a key role in their primary job.
- Developers who craft applications that deliver content from SQL Server databases.
- Database Administration, Business Intelligence and Machine Learning enthusiasts.
- SQL Server Security
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Protecting Data with Encryption and Auditing
- Recovery Models and Backup Strategies
- Backing Up SQL Server Databases
- Restoring SQL Server 2016 Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server with Extended events
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data
For more details on this module, kindly visit the official Microsoft page by following this link.
- SQL Server Components
- Installing SQL Server
- Upgrading SQL Server to SQL Server 2017
- Working with Databases
- Performing Database Maintenance
- Database Storage Options
- Planning to Deploy SQL Server on Microsoft Azure
- Migrating Databases to Azure SQL Database
- Deploying SQL Server on a Microsoft Azure Virtual Machine
- Managing databases in the Cloud
For more details on this module, kindly visit the official Microsoft page by following this link.
|
The MCSA SQL Database Administration certification validates that you have the skills needed to install, maintain, configure and provision databases. This internationally recognised credential can be earned by passing the following 2 Microsoft exams:
70-764: Administering a SQL Database Infrastructure |
Students following the MCSA SQL Database Administration study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (i.e. €1,120 will be refunded back for this course).
For further details and assistance on how to apply for this scheme, kindly contact us for an appointment.
MODE OF STUDY
PARTTIME
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
- Good Knowledge of English
- Foundational IT skills
NEXT STEPS
DURATION
81 Hours (27 Lessons of 3 Hours)
DAY(S)
TBA
TIME
TBA
WHAT'S INCLUDED
- Training by a Microsoft Certified Trainer (MCT)
- Official Microsoft Courseware (Format: Paperback)
- Official Microsoft Virtual Labs
- Official Microsoft Presentations
- Official Microsoft Practice Tests
- Official Microsoft Exams