Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in SQL Server DBA
Course Duration | 30 hrs | ||
---|---|---|---|
Live Projects | 2 | ||
Next Batch | 5 December, 2020 |
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
Named Instance
SQL Server Services
Instance aware services
Instance unaware services
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
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.
Have More Questions
Contact usHave questions? We’ve got the answers. Get the details on how you can grow in this course.
Have More Questions. Reach our Support Team
Contact usSee 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
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in SQL Server DBA
By providing us with your details, We wont spam your inbox.