Microsoft SQL Server continues to be one of the world's most popular and top databases. The database is the heart of IT which is needed to store all critical data and information.
If you want to become an SQL database administrator then this is the course for YOU.
This training course will provide you with all the necessary skills you need to be a successful database administrator.
Explain MS SQL storage engines
Explain database transactions
Obtain database metadata
Describe MS SQL GUI tools
Monitor database performance
Perform database backup and recovery
Export and import database data
Describe the features and benefits of MS SQL
Explain the basics of relational databases
Design an effective database
Build a database and tables by using SQL Modify or delete database entities
Join data from multiple tables
Use built-in MS SQL functions
Team leaders seeking professional development in MS SQL
IT Team Leader.
MS SQL developer
IT manager
IT department managers.
Project managers.
Systems designers.
RDBMS
What is SQL?
Top 5 RDBMS
Introduction to MS SQL Server
Different editions of MS SQL
MS SQL Server prerequisite
Lab setup
What is virtualization?
Download and Install VMWare Workstation Player
Optional - Download and Install Oracle Virtualbox
Create a Virtual Machine
Download and Install Windows Server
Virtual Machine Management
Prerequisites for MSSQL Installation
Download MSSQL and SQL Server Management Studio
Install and Configure MSSQL
Install SQL Server Management Studio
Download and Install AdventureWorks Database
What are Data and Database?
How is data stored?
What are a Table, COLUMN, and ROW?
What is a key? primary, foreign, unique keys, etc.
What is Relational Database and Relational Database Management System (RDBMS)?
What is a Transaction and ACID properties?
Database Normalization AND Different forms of Database Normalization
Create your first Database, Table, and Populate the table with data…
Welcome to Basic SQL Commands
What are SQL Statements and what types of SQL statements
DML Statement with examples
DDL Statements with examples
DCL Statement with examples
TCL Statement with examples
Create TABLE(s) and Temp Table(s)
What Is a View?
SELECT Statement in detail
Operators, Expressions, and Conditions
WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause
Select from two tables – JOINS
Different Types of JOINS
What is a Sub Query?
INSERT, UPDATE, DELETE and Truncate Statements
What is a Store Procedure?
Function, Trigger, and INDEX
Clustered, Non-clustered Indexes and Index Design considerations
Index Fragmentation and Lab for Index
Overview of MSSQL Management Tools
Exploring SQL Server Management Studio (SSMS)
Exploring SQL Server Configuration Manager
MSSQL System Databases, DO's and DONT's of System databases
What are master, etmpdb, msdb, and other system databases?
What are Pages, Extents, Page Architecture, and PFS?
MSSQL Architecture
MSSQL Database Architecture
Operation and working of transaction log
Configuring user Database
Best practices while creating a user Database
Backup of a Database, Importance for DBA, and Different Media used for Backups
Recovery Models in MSSQL and how that impact backups and restore
Full and differential backups
Transaction Log Backups, Log Backup Chain, and Tail-log Backup
Lab for Full, Differential, and Transaction Log Backups
Restore and Recovery Overview
Full, Differential, and Transaction Log database restore
Point in time restore of a database
Complete Backup, Restore, and Restore in Time Lab
MS SQL Server DBCC CHECKDB command
Page Level Restore / Recovery using Full Backups
Creating Maintenance Plan Backups/Re-indexing etc.
MSSQL Security Model
MSSQL Server Authentication Modes
Server Logins
Server Roles
Database Users
Database Roles
Permissions (GRANT, DENY, and REVOKE)
SQL Server Agent Introduction
SQL Server Agent Jobs and Schedules
Agent Alerts
Operators
Database Mail
Activity Monitor
High Availability and its Types
What Is Replication and Transactional Replication
Transactional Replication Setup (LAB)
Log Shipping and Configuring Log Shipping
SQL Server Encryption and Encryption Types
Transparent Data Encryption (TDE) and configuration
We all operate in an increasingly complex commercial and professional environment that requires us to negotiate on a daily basis not only with customers, clients, suppliers and contractor, but also with managers, fellow employees and colleagues within our own organisation.
‘Mastering Negotiation Skills’ is a five-day course designed to explain the negotiation process in detail and demonstrate how to use it effectively, giving delegates the negotiation skills and strategies they need to succeed in today’s challenging commercial environment.
The ability to negotiate effectively and manage conflict is one of the most valuable skill sets we can develop within our organization. Not only does developing these skills allow us to negotiate better deals by creating and then claiming value, but it also enables us to manage teams more expertly, interact more constructively with colleagues and manage conflict effectively.
This course provides both a comprehensive strategic analysis of the negotiation process as well as the essential tools for planning and managing every negotiation. Delegates will learn to negotiate excellent outcomes both externally with suppliers, contractors, and customers but also internally within your organization between colleagues, departments, and managers.
One of the major keys to success in the business world is being able to apply “discipline” to your life and actions! This is the key to developing personal effectiveness and professional excellence.
This training course will provide professionals with the knowledge, skills, and attitudes required to manage and lead teams and organizations before, during, and after a crisis or emergency. All leaders are sooner or later confronted with the need to lead and manage their team or organization during a crisis or emergency. The leadership skills and competencies that are required in these demanding circumstances are much more challenging for the leader than normal everyday leadership. This course will also cover the basics of the COVID 19 Virus currently impacting the world. Most of our lives are a combination of work, family, and community involvement. A pandemic can affect all of these areas. Being informed and knowing what to do during a pandemic can help minimize the impact.
This course is designed for IT professionals who are looking to take on the role of Chief Information Security Officer (CISO) in an organization. The course will cover key concepts and skills in information security, including risk management, security governance, incident response, and compliance.
A five-day course on the practical aspects of piping and pipeline design, integrity, maintenance, and repair. The participants will obtain an in-depth understanding of the ASME B31 code rules and API standards, their technical basis, and practical application to field conditions.