70-462: SQL Server Database Administration (DBA)
4.5 /5- Offered byUDEMY
70-462: SQL Server Database Administration (DBA) at UDEMY Overview
Duration | 10 hours |
Total fee | ₹490 |
Mode of learning | Online |
Credential | Certificate |
70-462: SQL Server Database Administration (DBA) at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Learn through 12 articles and 5 downloadable resources
70-462: SQL Server Database Administration (DBA) at UDEMY Course details
- Create Backups and Restore Databases, understanding the different recovery models
- Manage logins and server roles, and import and export data
- Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems
- Manage SQL Server Agent and audit SQL Server instances
- Collect and analyse troubleshooting data
- In this course, learn some of the skills that Microsoft want people to know, and add another tool to CV or resume, and even go for the official Microsoft certification
- SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL server could be very useful for your current work, and your next job hunt
- The course is recorded on SQL Server 2017, but will also work fully in 2016, 2014 and 2012, and mostly in 2008R2 and 2008
70-462: SQL Server Database Administration (DBA) at UDEMY Curriculum
Downloading SQL Server Developer 2019
Installing SQL Server Developer 2019
Installing SQL Server Management Studio (SSMS)
Downloading Adventure Works
Looking around SSMS and how to generate T-SQL
Backing up Database, and problem with Restoring
Changing Recovery Model
13a. Different backup models - practice in SSMS
13a and 14c. Point in Time Recovery
Recovery and Backup models
17c. Create login accounts
17d. Manage access to the server, 17b. secure the SQL server using server roles
17e. Create and maintain user-defined server roles
19c. Create Database User Accounts
18b. Fixed Database-Level Roles
User Database-Level Roles
What are indexes?
15d. Implement indexes
Fragmentation - theory
Fragmentation, reorganize and rebuild in SSMS
Fill factor
15g. Optimise indexes (full, filter index)
15c. Identify unused indexes
5a. Create, maintain and monitor jobs
5b. Administer jobs and alerts
RAISERROR and Create Event Alerts
What happens when a job runs? And running a RAISERROR WITH LOG
5b. Adding operators to jobs and alerts
11j. Create alerts on critical server condition
6b, 7a. Database configuration: autoclose, autoshrink, recovery models
6a. Design multiple file groups
6a. Creating database with multiple file groups
6c. Manage file space, including adding new filegroups and moving objects
6g. Partitioning in theory
70-462: SQL Server Database Administration (DBA) at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?