MCSA: SQL 2016 Database Administration (Online Courses)
Elevate your career trajectory with our premier online course, designed to sharpen your competitive edge. Explore our curated selection of top-tier digital programs to hone your skills and propel your professional journey forward. Experience transformative learning tailored to empower your career advancement in today's dynamic landscape.
Price on Request
Start Learning
This Course Includes
-
37 hours 10 minutesof self-paced video lessons -
36 Programscrafting your path to success -
Completion Certificateawarded on course completion
Always Encrypted & Cell-level Encryption
Price on Request
45 minutes
Besides Transparent Data Encryption (TDE), there are other methods available for Azure SQL database encryption. Examine alternate encryption solutions, including Always Encrypted and cell-level encryption.
Perks of Course
Certificate: Yes
CPD Points: 44
Compliance Standards: AICC
Application Patterns
Price on Request
30 minutes
There are various types of application patterns available when migrating SQL Server-based applications to an Azure environment. Examine some of these patterns, including 1-Tier, 3-Tier, Presentation Tier, and Business Tier.
Perks of Course
Certificate: Yes
CPD Points: 28
Compliance Standards: AICC
Architecture
Price on Request
45 minutes
Understanding the architecture of SQL Server 2016 is important to being able to effectively work with it. Explore the SQL Server architecture, including parallelism, I/O operations, account types, and network protocols.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Architecture
Price on Request
1 hour 15 minutes
Explore the internal architecture of Cloud Foundry and the internal request management.
Perks of Course
Certificate: Yes
CPD Points: 74
Compliance Standards: AICC
Auditing
Price on Request
2 hour 5 minutes
Auditing is an essential administration task used to track and log database events to ensure the database is performing properly. Explore auditing, Azure SQL Database audit, and analyzing audit logs and reports from Azure SQL Database.
Perks of Course
Certificate: Yes
CPD Points: 126
Compliance Standards: AICC
Backup Management
Price on Request
1 hour 40 minutes
A tested backup strategy is the most effective means of protecting your data from potential disaster. Explore SQL Server 2016 backup management practices, including backup strategies, media options, and retention and recovery models.
Perks of Course
Certificate: Yes
CPD Points: 102
Compliance Standards: AICC
Configuring Operators & Alerts
Price on Request
1 hour 30 minutes
Keeping a SQL Server environment running its best involves constant monitoring of activity. Discover how to configure operators and alerts in SQL Server 2016 to help you maintain peak performance.
Perks of Course
Certificate: Yes
CPD Points: 36
Compliance Standards: AICC
Connection Strings & Traffic Manager
Price on Request
45 minutes
Connection strings are used to allow client applications to interact with Azure SQL databases. Explore application connections strings and the Azure Traffic Manager, which is used to control the distribution of incoming user traffic.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Data Access & Permissions
Price on Request
1 hour 10 minutes
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore data access and permissions, including database object permissions, users, and custom roles.
Perks of Course
Certificate: Yes
CPD Points: 68
Compliance Standards: AICC
Data Security & Azure SQL Database Options
Price on Request
1 hour
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore user options for Azure SQL Database, row-level security, and dynamic data masking.
Perks of Course
Certificate: Yes
CPD Points: 58
Compliance Standards: AICC
Database Mail & Alerts
Price on Request
1 hour 30 minutes
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore the creation and management of operators and SQL Server Agent alerts.
Perks of Course
Certificate: Yes
CPD Points: 62
Compliance Standards: AICC
Database Performance Settings
Price on Request
30 minutes
SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. Discover how to maximize database performance as well as the maximum amount of server memory.
Perks of Course
Certificate: Yes
CPD Points: 32
Compliance Standards: AICC
Database Restoration
Price on Request
1 hour
An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. Explore restoring SQL Server 2016 databases, including point-in-time recovery and automation for testing.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Dynamic Data Masking
Price on Request
40 minutes
Part of your deployment strategy should be to secure not only the databases but also the data itself. Examine dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data.
Perks of Course
Certificate: Yes
CPD Points: 40
Compliance Standards: AICC
Encryption
Price on Request
1 hour 30 minutes
Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. Explore encryption-related tools and processes used in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 91
Compliance Standards: AICC
File & Piecemeal Restores
Price on Request
55 minutes
In the event of an unforeseen disaster, critical data should be protected and easily recoverable. Discover how to perform piecemeal and page restores, and restoring file groups.
Perks of Course
Certificate: Yes
CPD Points: 57
Compliance Standards: AICC
Index & Statistical Management
Price on Request
1 hour 25 minutes
By carefully managing aspects of your database, you can better tune performance and identify potential issues. Explore index management tasks, such as identifying and repairing fragmentation, and identifying and creating missing indexes.
Perks of Course
Certificate: Yes
CPD Points: 86
Compliance Standards: AICC
Installation & Configuration
Price on Request
50 minutes
Justinmind provides powerful tools for creating working prototypes of web and mobile applications. Discover how to install and navigate the Justinmind desktop application, preferences and plug-ins, and how to share access to projects.
Perks of Course
Certificate: Yes
CPD Points: 52
Compliance Standards: AICC
Installation & Configuration
Price on Request
55 minutes
It's important to understand the numerous recommended pre- and post-installation best practices set forth by Microsoft to ensure a successful deployment. Explore deployment options, including post-installation best practices.
Perks of Course
Certificate: Yes
CPD Points: 54
Compliance Standards: AICC
Installation & Configuration
Price on Request
1 hour
Once your environment is set up, you are ready to install Hadoop. Follow the step-by-step instructions for installing Hadoop in a pseudo-mode, and learn more about the Hadoop architecture.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Instances & Storage Considerations
Price on Request
1 hour 35 minutes
SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. Explore SQL Server instances in IaaS and on-premises, and the various storage solutions in SQL Server 2016.
Perks of Course
Certificate: Yes
CPD Points: 96
Compliance Standards: AICC
Log Shipping & High Availability
Price on Request
1 hour 40 minutes
Data is an important enterprise asset and must be protected, retrievable, and highly available. Examine high availability and disaster recovery in SQL Server 2016, including log shipping, shared disks, and cluster shared volumes.
Perks of Course
Certificate: Yes
CPD Points: 100
Compliance Standards: AICC
Managing Database Integrity
Price on Request
55 minutes
Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. Explore database consistency checks and how to identify and recover from database corruption.
Perks of Course
Certificate: Yes
CPD Points: 53
Compliance Standards: AICC
Migrating to Azure SQL Databases
Price on Request
1 hour
Migrating a database to Azure SQL Database primarily involves three steps: preparing, exporting, and importing. Explore the requirements and processes involved in migrating data to Azure SQL Databases.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Monitoring Database Activity
Price on Request
1 hour 30 minutes
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore managing and monitoring SQL Server database activity, including data collector and creating a utility control point.
Perks of Course
Certificate: Yes
CPD Points: 61
Compliance Standards: AICC
Monitoring Queries
Price on Request
1 hour
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore SQL Server database queries, including the Query Store, Extended Events, SQL Trace, and troubleshooting server health.
Perks of Course
Certificate: Yes
CPD Points: 59
Compliance Standards: AICC
Multiple Tenant Deployments
Price on Request
30 minutes
There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. Examine the considerations for each design option.
Perks of Course
Certificate: Yes
CPD Points: 28
Compliance Standards: AICC
Performance Tuning & Availability Sets
Price on Request
30 minutes
Moving Microsoft SQL Server applications to Azure virtual machines can help optimize overall performance. Discover various methods used for performance tuning and configuring availability sets for redundancy.
Perks of Course
Certificate: Yes
CPD Points: 31
Compliance Standards: AICC
Policy-based Management & Performance Monitoring
Price on Request
55 minutes
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore Policy-Based Management and performance monitoring of SQL Server 2016 instances.
Perks of Course
Certificate: Yes
CPD Points: 55
Compliance Standards: AICC
Securing Azure SQL Databases
Price on Request
45 minutes
Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. Discover how to implement firewalls, authentication, and auditing to ensure Azure SQL database security.
Perks of Course
Certificate: Yes
CPD Points: 47
Compliance Standards: AICC
Service Tiers, Pools, & SQL Databases
Price on Request
50 minutes
Azure virtual machines (VMs) provide a way to move on-premise SQL Server workloads and applications to the cloud. Explore service tiers, pools and SQL databases for Azure VMs.
Perks of Course
Certificate: Yes
CPD Points: 48
Compliance Standards: AICC
SQL Platform & Installation Best Practices
Price on Request
1 hour 5 minutes
It's important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. Explore the SQL Server platform and best practices and guidelines to follow when preparing for an installation.
Perks of Course
Certificate: Yes
CPD Points: 64
Compliance Standards: AICC
Transparent Data Encryption
Price on Request
45 minutes
Transparent Data Encryption (TDE) performs real-time I/O encryption of data and can be used to secure SQL servers and Azure SQL databases. Discover TDE commands, functions, and considerations.
Perks of Course
Certificate: Yes
CPD Points: 43
Compliance Standards: AICC
Upgrading to SQL Server 2016
Price on Request
45 minutes
When performing a SQL Server 2016 upgrade, it's important to understand numerous recommended pre- and post-installation best practices. Examine upgrade options, such as in-place and side-by-side upgrades.
Perks of Course
Certificate: Yes
CPD Points: 46
Compliance Standards: AICC
Virtual Machines & Benchmark Data
Price on Request
50 minutes
Microsoft SQL Server applications can be moved to Azure virtual machines to help reduce costs and to optimize overall performance. Explore the various methods used to migrate applications as well as gathering benchmark data.
Perks of Course
Certificate: Yes
CPD Points: 51
Compliance Standards: AICC
Virtual Machines on Azure
Price on Request
55 minutes
Azure virtual machines provide a way to move on-premise SQL Server workloads and applications to the cloud. Discover the recommended usage scenarios for Azure VMs as well as how to provision, create, and connect to Azure SQL Databases.
Perks of Course
Certificate: Yes
CPD Points: 57
Compliance Standards: AICC