HONE YOUR SKILLS AND UPGRADE YOUR STATUS AND INCOME. EARN MINIMUM £50K WITH YOUR MICROSOFT DATABASE SKILLS.
PERFECT SELF-TEACH TRAINING FOR THOSE PREPARING FOR MICROSOFT CERTIFICATION EXAMS AS WELL AS THOSE WHO WORK WITH OTHER DATABASES TOOLS OR WISH TO UPSKILL TO AN MICROSOFT SQL SERVER ENVIRONMENT.
GOOD FOR SQL SERVER 2012, 2014, 2016, 2017 AND 2019 ENVIRONMENTS
MICROSOFT SQL SERVER DATABASE 2019 ADMINISTRATION WORKSHOP SELF-STUDY CBT
How This Course Is Organised
On this SQL Server 2019 Database Administration course, you’ll learn to administer, develop and manage SQL Server 2019 databases. This will include managing and authorizing user access, assigning and creating different types of database roles and learning to automate SQL Server management.
As well as learning skills specific to SQL databases, you’ll learn how to install, configure and manage SQL Server 2019 itself. This will teach you to setup SQL Server 2019 and prove you know how it functions within your business.
This course is best suited to database administrators, specifically those who work closely with Microsoft SQL Server 2019. It is also relevant application developers who deliver content from SQL Server databases.
Certification
This course will assist in preparation for the Microsoft Database Development and Administration certification exams.
Duration: N/A
Audience:
Database Administrators
Database Developers
Prerequisites: None
Objectives:
Describe SQL Server Database Development Tools
Describe Enhancements and New features in SQL Server
Describe SQL Server Database and Instances
Describe SQL Server Instance Architecture
Describe SQL Server Database Architecture
Configure and Manage SQL Server Database Instance
Manage Database Storage structures
Managing Data Objects
Managing Data Access
Managing Schema Operations
Protection and Security
Create and Administer User Accounts
Implement Database Auditing
Data Transport - Import and Export Data
Configure Database For Backup and Recovery Operations
Monitor the Database
Performance Tuning
High Availability
Prerequisites:
Familiariry with SQL or Database Management Systems
Course Outline
Introduction to Microsoft Database
SQL Server Editions and Versions
SQL Server Management Studio and Azure Studio
Understanding the SQL Server Database Architecture
Understanding SQL Server Business Intelligence and Data Warehousing
Microsoft Database Development Tools
Microsoft SQL Development Tools
Azure Data Studio Overview
Navigate SQL Server Management Studio (SSMS)
Exploring Database Objects using SSMS
SQL Server Data Tools (SSDT)
Exploring SQL Server Data Tools (SSDT)
Enhancements and New features in SQL Server
SQL Server 2019 on Linux
Azure data platform Overview
SQL Server 2019 In-Memory OLTP
SQL Server Columnstore
SQL Server Adaptive Query Processing (AQP)
SQL Server 2019 Stretch Database
SQL Server 2019 Always On
SQL Server 2019 Query Store & Live Query Statistics
SQL Server 2019 Temporal Tables
Enhanced Backup to Azure
Planning to Install and Configure SQL Server
Installation Decisions
Design the Storage for New Databases
Plan for Growth and Capacity
Service Account Configuration
Basic Administration
Installing SQL Server
Managing and Configuring SQL Server
Working with SQL Server Databases
Maintain Instances and Databases
Transparent Data Encryption
Database Compression
Failover Clustering
Affinity and Parallelism
Automation: SQL Agent Jobs and Alerts
Database Mail
Performance Tuning and Troubleshooting
Locking, Blocking, and Deadlocks
Profiler
Auditing
Catalog Views and DMOs
Data Collector and the Management Data Warehouse
Manage Data - Backup and Recovery
Custom Backups and Backup Strategies
Restores and Recovery
Move Databases and Database Files
Ensure Database Integrity
Indexes, Statistics, and Maintenance
Security
Server Logins and Server-Level Roles
Database Users and Database-Level Roles
implementing Permissions
High Availability Options
What is High Availability?
Replication
Log Shipping
Mirroring
Always On
Failover Clustering
NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, TRAINING GUIDES OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, CBT OR TRAINING GUIDES E-BOOK LEARNING FORMATS. PRICES DIFFER.
What is Computer Based Training - CBT??
Computer Based Training - CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.
Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.
Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.
CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.
· Material retention with CBT’S are 45% better than with conventional training methods
· Your learning curve with CBT is 25%-55% less than conventional methods
· The cost of CBT training is over 65% less than Classroom training
· CBT’S are self pacing, interactive and simulate the actual software being studied
The WebLearning unique Methodology
All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning.