ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £35K WITH YOUR SQL SERVER DATABASE SKILLS.
EXCELLENT SELF-TEACH TRAINING COURSE . IDEAL FOR THOSE DEVELOPING AND ADMINISTERING SQL BASED APPLICATIONS AND ANALYTICS APPLICATIONS IN ANY SQL SERVER DEPLOYMENT ENVIRONMENT. EXCELLENT FOR IT DEVELOPERS/CONSULTANTS, DATABASE DEVELOPERS AND MODELLERS, BUSINESS INTELLIGENCE AND DATA WAREHOUSE CONSULTANTS PREPARING FOR THE SQL SERVER CERTIFICATION EXAMS.
ALSO GOOD FOR ANALYSTS, IT DEVELOPERS/CONSULTANTS WHO WISH TO CROSS TRAIN/UPSKILL FROM ORACLE, SYBASE OR IBM DB2 TO SQL SERVER DBMS ENVIRONMENT.
MICROSOFT SQL SERVER 2019 DATABASE ADMINISTRATION WORKSHOP SELF-STUDY CBT
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 authorising 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.
Audience:
Data Warehouse Administrator
Database Administrators
Database Designers
Technical Administrator
prerequisites:
Suggested Prerequisites:
Knowledge of relational server technology
Course 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:
Familiarity 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
Database and Instances
Terminology Concepts
Client Interaction with Database and Instance
Understanding Database Limits
Instance Architecture
Configuring a database server
Memory Architecture Overview
Understanding Processes and threads
Background Processes
Database Architecture
Schema and Data Storage
Tablespaces and Datafiles
Logging and Data Dictionary
Data Objects
Database Tables
Schema Objects
Data and data types
Non-Native Data Types- Beyone Relational
Data Access
Comparing Structured Query Language
Control and Procedural Statements
Developing Robust Queries
Managing Schema Operations
Managing Tables, Constraints, Objectifers, and Naming
Managing Triggers
Managing Indexes and Views
Data Protection and Security
Securing the Database
Managing Users
Understanding Privileges
Managing Roles
Data Transport
Getting Data Into and Out of SQL Server
Understanding SQL Server Integration Services
Other Transfer Methods
Backup and Recovery
Understanding Database Backups
Data Recovery
Backup and Recovery Tools and Solutions
Monitoring and Performance Tuning
SQL Server Performance Tuning
Managing Memory and Processes for SQL Server
Managing Database Interactions
Monitoring Availability and Errors
Monitoring Performance
Scalability and High Availability
Understanding Availability Features
Replicating Databases
Impact of Scale and Disaster Recovery
NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT FORMAT OR
DISTANCE LEARNING. FEEL FREE TO ASK IF YOU PREFER DISTANCE LEARNING OR CBT
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. This Publishers 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 Training Guide 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.
The WebLearning unique Methodology
All WebLearning® Training Guide 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.
FACT: