Bluelime Learning Solutions
SQL Server DBA Skills are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that’s designed for the enterprise environment.
A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running
of the SQL sever database.
Some of the key daily responsibilities of a SQL Server DBA includes:
Backups
Confirm that backups have been made and successfully saved to a secure location
Check the backup failure alerts, correct the errors and rerun the backups
Review the average duration of backup, any significant changes occurred investigates on this.
Most of the time it happens due to networking low bandwidth
Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.
Performance
Regularly monitor and identify blocking issues.
Check Performance counters on all production servers and verify that all counters are within the normal range.
Throughout the day, periodically monitor performance by collecting relevant data
Create indexes to reduce the time it takes to get responses from the SQL Server after a T–SQL Script is executed.
Security
Check the auditing logs for failed logins and notify the audit team if necessary
Implement relevant permissions to prevent authorized access to SQL Server databases
Instructor Details
Courses : 34
Specification: Learn SQL Server DBA Skills from Scratch
|
14 reviews for Learn SQL Server DBA Skills from Scratch
Add a review
| Price | $12.99 |
|---|---|
| Provider | |
| Duration | 8.5 hours |
| Year | 2020 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$12.99
John Hill –
According to the intro this is exactly what I am looking for to get training to become a DBA.
Luke J –
Content is explained well Content explained clearly
Sara Estifanos –
it explained well.
Dr Godwin Ekebuisi –
The contents are very good and delivery excellent. Making mistakes, which I believe were deliberate, was very useful to replicate the type of thing that happens in real life environments.
Greyson Kirk –
Your audio almost makes this unbearable. I don’t want to hear your tongue moving around.
Bidhan Chakma –
This is the beginning course for my SQL Server Administration. So far, I have not yet encountered any problem to install and create the database.
Le Le Win –
Yes. it is quite helpful to me. Thank you!
D vid Attila –
I think the SSRS part was to long and repetitive, unnecessary to show how to create data source or dataset all the time, that part could be shorter and focused to the report tools. My other problem with this course is i missed how to build and handle the replication in local and cloud based servers. Otherwise is a good course to beginners.
Raghav Mehra –
The query written for currency lookup is pretty very poor query, using OR in where clause. It should be like in this fashion, select * from tablename where currnecy id in (‘AUD’,’IND’,’EUR’)
Gishera K. Joseph –
Great content!
Omid –
Amazingly explained, easy to follow, however, there is a tiny problem with the editing. Few videos are placed repeatedly.
Pavanm –
Good
John Magdalinos –
No explanation of each section in the introduction, no explanation of commands etc
Nalin Singhal –
A Good Experience