Gain essential skills taught by industry experts with our custom tailored curriculum. Work on projects that add weightage to your resume and get job ready.
Tekslate SQL Server DBA Training provides you with immense knowledge of SQL DBA, SQL Server instances, SAN storage, and security. This training will offer insights into new concepts like disaster recovery, replication. You will also get an exposure to industry based real-time projects.
Contact Us
Pre-requisites
Installation
Post Installation
verification
Types of database
A brief explanation about system databases
User database
Database architecture pages
Extents
Filegroups
Database transaction architecture
Creating a database
Modifying a database
Adding Files
Moving and renaming database files
Database modes
Real time Scenario
Types in SQL Server
Types of Login
Windows Login
SQL Login
Creating Users and Logins
Server Roles
Password policy
Understanding Database and Server Roles
Permissions
Working on access level issues
Orphan users
Finding and Fixing Important Queries
Database Backups
Why we need backups
Types of Backup Full Backup
Differential Backup
Transaction Log Backup
Copy-only, Mirrored, Split and Tail log Backups
Differences between backups
Backup Strategy
Understanding how the data moving from Log to Data File
CHECKPOINT Monitoring the space usage of Log File and fixing Checking the backup files
VALID or CORRUPTED Backup storage tables
Important Queries
Performing Restorations
Types of Restoration
Attach and Detach Shrinking files
Types of Recovery Models
Full Bulk Logged
Differences between Recovery Models
Setting Recovery Models according to the Scenarios with examples
Creating Jobs
Managing Jobs
Resolving issues
Monitoring Jobs
Monitoring Tables
Log Shipping
Mirroring
Replication
Clustering
Log Shipping
Working with Log Shipping
Terminology
Prerequisites to implement Log Shipping
Different modes of Log Shipping
Configuring Log Shipping
Monitoring
Manually Performing Failover
Log Shipping Tables
Discussing Real Time Scenarios
Working with Database Mirroring
Terminology
Prerequisites to implement Mirroring
Pre check mirroring ports
ENABLED or DISABLED Architecture Operating Modes
Differences between Modes Port numbers involved in Mirroring
Requirements for Mirroring
Configuring Mirroring
Mirroring Failover
Issues on Mirroring
Working with Replication
Terminology
Prerequisites to implement to Replication
Types of Replications
DISTRIBUTOR Database
Agents involved in Replication
Configuring Replication
Resolving Issues
Introduction about clustering
Clustering Architecture
Importance of IP’s involved in Clustering
SAN importance
Drive dependency
Nodes in Clustering
Important commands
System Monitor
SQL Server
Profiler SQL Server
Windows Error Logs
Indexes
Types of indexes
Fragmentation in Indexes
Types of Fragmentations
Database Tuning Advisor
Dead Locks
Blockings Terminating Processes
Starting SQL Server in Single user mode
Changing the Default path of Database files
Modifying the Logical and Physical names of database files
Self Paced Training
20 Aug, 2022-
20 Sep, 2022
23 Aug, 2022-
23 Sep, 2022
27 Aug, 2022-
27 Sep, 2022
30 Aug, 2022-
30 Sep, 2022
Tekslate is the training partner for more than 120+ corporates across the globe having trained over 2000+ professionals. We are a one stop solution for skill upgrade for organizations and individuals to innovate and progress rapidly.
Flexible training options globally
Tailored curriculum to fit your project needs.
Assured practical exposure
We have got everything covered for any IT skill upgrade for your organization. We are just a click away.
This course will help you in honing your database management skills like data storage, disaster recovery, database mirroring, and replication.
At the end of this course,
You will be able to control and monitor user access and optimise the performance of the database.
You will be trained in such a way that you will be able to modify the database structure, allocate system storage space, and plan for future storage requirements.
If you are a certified SQL Server DBA, it increases the weight of your CV and improves the chances of acquiring better job opportunities.
A certified SQL Server DBA salary is around $122000 per annum.
SQL Developers.
Software/Hardware Experts.
DBAs.
Those who are aspiring for a career in SQL Server management.
You don’t need any specific skills to take this training course. Basic knowledge of SQL and database is enough. However, as the opportunities in the field are increasing, the following job roles will get benefited by taking up this course.
SQL developers and administrators.
Database server professionals.
Database backend developers.
With real-world projects you’ll gain working experience that companies require while you get hired.
Our career services include mock interviews, certification assistance and guide you to prepare your professional resume that gets you hired.
Customize your curriculum as per your project needs, learn at your own pace or choose the schedule that fits best to you.
Our expert mentors help you when you are stuck in any time of the training sessions and help you stay on track.
Upon completion of the training you’ll be provided a course completion certificate which adds weightage to your resume and increases your chances of getting hired.
Benefits:
1/3
1/11