SQLDBA

SQL Server DBA Training

The course is designed and developed for individuals who are interested to land a job in Database Administration. In SQL Server Database Administration course you will learn how to perform all activities related to maintaining a successful database environment.  Typically DBA responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use.

SQL Server DBA Training at Data Intellect has been designed as per the latest industry trends. The advanced SQL Server DBA course content and syllabus and real-world examples will help you to get placement in a DBA job accross USA.

The Instructor will not rest until you succeed. You will be prepared for the interview and on-Demand support will be provided as needed. According to Gartner,  Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in the next 2 years. A SQL Database Administrator in the United States can earn $91,000 – indeed.com

This course will cover:

SQL Server overview
SQL Server DBA responsibility
The demand of a Database Administrator (DBA)
Salary of a SQL Server DBA
Hardware and Software Requirement
Difference between Enterprise and Standard Editions of SQL Server

Software Installation in a local Server
Software Download Links
Install Virtual Machine (VM)
Install Windows 2012 Server in VMWare.
Install SQL Server 2017 in VMware Local Server.
Install AdventureWorks 2017 Sample Database
Tour SQL Server Management Studio (SSMS)

Database Concept
Relational Database Management System (RDBMS)
Normalization
Entity Relationship Diagram
Under the hood of a SQL Server Database Engine.

Transact-SQL Foundation Concepts
Database Objects
Table, Views, Synonyms
Creating Indexes
Altering an Index
Dropping an Index
Index Fragmentation
Using the Database Tuning Advisor
Materialize view
Variables and data types
Assignment expressions
Null handling
Stored Procedures Transact-SQL or T-SQL
Creating and maintaining stored procedures
Variables
Parameters
Error handling
Cursor
Cursor Basic Syntax
Cursor examples
User-Defined Functions User-defined
Functions vs. stored procedures
Views and stored procedures
Transactions Overview
Triggers, Triggers Types

Complete SQL Query for DBA
Elements of the SELECT statement
Optional Clauses
JOINS
UNION queries
GROUP BY queries
Sub-queries
CASE statement
Data Manipulation Statements Insert statements
Update statements
Delete statements
Manipulation over JOINS
Calling a view
Calling Stored Procedures and Functions Calling a procedure for effect versus data
Using parameters
Calling a user-defined function
matched or missing records
Finding duplicates
Calculating running sums
Changing a primary key

Software Installation in Production Environment
Installing Windows Server 12 in VM Ware.
Basics in Networking
Setup Static IP for your database Server
Create Virtual Machine Domain Controller
Install SQL Server in a Separate Server
Create a Domain and add Domain
Promote Domain Controller to Active Directory
Install SQL Server On Separate Drive with Service Accounts
Connecting to SQL Server from a User Account
Installing Service Packs and Fixes (SP2)
Introduction to System Databases

Deep Dive into SQL Server part 1
SQL Server Data and Log Files
Detail Transaction log ATM Example
Auto Growth and sizing of transaction log
Types of Recovery Models
Create simple database script
Function fn dblog to view inside a transaction log
What is virtual log file (VLF)
Create a SQL database
The importance of Tempdb
move a tempdb
Attach and detach a database

Deep Dive into SQL Server part 2
Introduction to Backups
Database Backup Strategies.docx
Full Database Backup
Transactional Log Backups
Differential Backups
Introduction to Restore
Restoring a database.docx
Restore database with GUI
Restore database using differential
Recovery mode with tail log backup
Backup using Maintenance plan
Backup database using a Maintenance plan
Maintenance Plan Tasks
Don’t shrink a database

Deep Dive into SQL Server part 3
The importance of using SQL Server Agent
Using SQL Agent.docx
Create a simple backup job using SQL Server Agent
The importance of DBCC CheckDB
Using SQL Server Agent with multiple steps
Setting up SQL Database Mail
Setting up alerts Severity Errors from 17 to 25
Central Management with SQL Server Agent

Deep Dive into SQL Server  part 4
Introduction to SQL Server Security
Understanding Windows and SQL Security users.docx
Demonstration of Users Logins Roles
Managing security with T SQL
A script for creating a login and SQL User.sql
Selecting Authentication or Mixed Mode security
Windows or SQL Authentication mode.docx
Accessing SQL Server using SQL Login
Create a SQL Login not using Windows User.docx
Understanding SQL Server Roles
Managing SQL Server Roles via TSQL
SQL Server Roles Demonstration
Managing SQL Server Permissions
Understanding GRANT, revoke, deny ermissions.docx