IIRF Online > Development > Database Design & Development > Database Management Systems (DBMS) > 70-462: SQL Server Database Administration (DBA)
70-462: SQL Server Database Administration (DBA) by Udemy
Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.
Course Highlights
- 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
- Plan and install SQL Server and related services, including implementing a migration strategy
Skills you will learn!
Curriculum
11 Topics
Introduction
Welcome to Udemy
The Udemy Interface
Do you want auto-translated subtitles in more languages?
Curriculum
Databases - Resources
Downloading SQL Server Developer 2022
Installing SQL Server Developer 2022
Which version of SSMS should I use?
Installing SQL Server Management Studio (SSMS)
Downloading AdventureWorks
14 Topics
Restoring a Database
Looking around SSMS and how to generate T-SQL
Backing up Database and problem with Restoring
Changing Recovery Model
13a. Different backup models - theory
13a. Different backup models - practice in SSMS
13a and 14c. Point in Time Recovery
Recovery and Backup models
Using NORECOVERY and RECOVERY
13g and 13h. Back up an SQL Server environment and system databases
13c and 13f. Perform backup/restore based on strategies inc. backup redundancy
13d and 14b. Recover from a corrupted drive
More backing up questions
Practice Activity Number 1
11 Topics
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
Creating and Using Schemas
Creating access to server/database with least privilege
18c. Protect objects from being modified
Manage logins and server roles
Practice Activity Number 2
10 Topics
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
15h. Statistics (full filter) force or fix queue
Implement and maintain indexes
Practice Activity Number 3
3 Topics
Transfer data
Bulk Insert
Import and Export Data
8 Topics
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
Manage SQL Server Agent
Practice Activity Number 4
13 Topics
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
Partitioning in practice using the GUI
Partitioning in practice using T-SQL and testing partitioning
13e. Manage a multi-TB database; 14d. File group restore
6h. Manage log file growth
6i. DBCC
6d 19d. Implement and configure contained databases and logins
Manage and configure databases
Practice Activity Number 5
5 Topics
6e. Page and Row Data Compression
6e. Sparse columns
15k. Columnstore Indexes
Compression
Practice Activity Number 6
6 Topics
10d. Diagnose blocking live locking and deadlocking - theory
10d. Diagnose deadlocking - practice; 10h. kill processes
10c. Monitor via DMV or other MS product; 10e. diagnose waits
10a. Examine deadlocking issues using the SQL server logs using trace flags
10g. Know What Affects Performance
Identify and resolve concurrency problems
6 Topics
11a 11c. Collect trace data by using SQL Server Profiler
11i. Use XEvents (Extended Events)
11b 11f 11g 11h. Collect performance data by using System Monitor
11l. Identify IO v memory v CPU bottlenecks
Collect and analyse troubleshooting data
Practice Activity Number 7
5 Topics
12a. implement a security strategy for auditing; 12c. configure server audits
12e. Monitor elevated privileges as well as unsolicited attempts to connect
12b. Configure an audit; 12d. Track who modified an object
Audit SQL Server Instances
Practice Activity Number 8
5 Topics
1l. Choose the right hardware; 1a. Evaluate Installation Requirements
1c. Plan Scale-up vs Scale-out basics
1d. Plan for capacity; 1i. Windows-Level and Service Level Security
1f. Design the storage for new databases
Plan Installation
7 Topics
9a. Install an instance; 7b. Install Default and named instances
1b 2b 2c 4a 4b. Design the installation of SQL Server and its components
4a. Set up and configure all SQL Server components including Visual Studio SSDT
2a. Test connectivity
2d. Configure an OS disk
Install SQL Server and related services
Practice Activity 9
5 Topics
3a. Restore versus detach/attach
3b. Migrate Security
3c. Migrate from a previous version; 3d. Migrate to new hardware
3e. Migrate systems and data from other sources
Implement a migration strategy
5 Topics
4b. Configure full-text indexing
4c. SSIS Security
4d. Filestream
4e. Filetable
Install SQL Server related services and additional SQL Server components
2 Topics
Congratulations
Bonus Lecture SQL
70-462: SQL Server Database Administration (DBA)
Related Database Management Systems (DBMS) Courses
Thank You!
Your review has been submitted successfully.