Online | Self-Paced | Corporate
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.
A complete index of
job-ready skills curated
to meet the industrial need.
Responsibilities of Database Administrator
Types of DBAs
History of SQL Server
Editions of SQL Server Tools
SQL Server Differences
Standard and Enterprise editions Instances
Types in SQL Server Default Instance
SQL Server Services
Instance aware services
Instance unaware services
Types of database
A brief explanation about system databases
Database architecture pages
Database transaction architecture
Creating a database
Modifying a database
Moving and renaming database files
Real time Scenario
Types in SQL Server
Types of Login
Creating Users and Logins
Understanding Database and Server Roles
Working on access level issues
Finding and Fixing Important Queries
Why we need backups
Types of Backup Full Backup
Transaction Log Backup
Copy-only, Mirrored, Split and Tail log Backups
Differences between backups
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
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
Working with Log Shipping
Prerequisites to implement Log Shipping
Different modes of Log Shipping
Configuring Log Shipping
Manually Performing Failover
Log Shipping Tables
Discussing Real Time Scenarios
Working with Database Mirroring
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
Issues on Mirroring
Working with Replication
Prerequisites to implement to Replication
Types of Replications
Agents involved in Replication
Introduction about clustering
Importance of IP’s involved in Clustering
Nodes in Clustering
Profiler SQL Server
Windows Error Logs
Types of indexes
Fragmentation in Indexes
Types of Fragmentations
Database Tuning Advisor
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
We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.
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.
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.
We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.
|Additional tips from the trainer|
24 Jan 2022, 07:00 AM IST
31 Jan 2022, 07:00 AM IST
|Weekdays & Working Hours|
|Accessible through LMS|
|At your convenience|
Schedules Doesn't Suit You ?
Our Team can set up a batch at your convinient time.
Customized training options
Tailored curriculum to fit your project needs.
Practical exposure is assured.
We have got everything covered for any IT upgrade for your organization. We are one click away.
Have questions? We’ve got the answers. Get the details on how you can grow in this course.
See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate