- Introduction
- Welcome to Udemy
- The Udemy Interface
- Do you want auto-translated subtitles in more languages?
- Curriculum
- Databases - Resources
- Downloading SQL Server Developer 2019
- Installing SQL Server Developer 2019
- Installing SQL Server Management Studio (SSMS)
- Downloading AdventureWorks
Online
₹ 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Database administration is the broad variety of challenges carried out by a database administrator to guarantee that a database is always accessible when required. Database administration is a big challenge in any business that depends on one or more databases, 70-462: SQL Server Database Administration (DBA) online certification is designed by Phillip Burton - A certified instructor, and delivered by Udemy, which is intended for candidates who want to practice techniques associated with SQL server database administration.
70-462: SQL Server Database Administration (DBA) online course offers 10 hours of prerecorded sessions accompanied by 12 articles and 5 downloadable resources covering a range of aspects that are covered in the Microsoft 70-462 administering Microsoft SQL server exam. 70-462: SQL Server Database Administration (DBA) online classes begin with the installation of a SQL server to restore databases as well as cover topics like SQL auditing, SQL server agent, concurrency, compression, fragmentation, migration strategies, troubleshooting, and more.
The highlights
- Certificate of completion
- Self-paced course
- 10 hours of pre-recorded video content
- 12 articles
- 5 downloadable resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the 70-462: SQL Server Database Administration (DBA) certification course, candidates will gain a fundamental understanding of the principles of SQL and SQL servers. Candidates will explore the strategies involved with SQL server database administration and SQL server audit. Candidates will learn about concepts involved with database administration including fragmentation, concurrency, compression as well as implementing and maintaining indexes. Candidates will also learn about the functions of recovery models as well as will get the skills to work with migration strategies and analyze troubleshooting data.
Who it is for
The syllabus
Introduction
Backup and Restore - Part 1
- 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
Manage logins and server roles
- 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
Implement and maintain indexes
- 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
Import and export data
- Transfer data
- Bulk Insert
- Import and Export Data
Manage SQL Server Agent - Part 1
- 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
Manage and configure databases
- 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
Compression
- 6e. Page and Row Data Compression
- 6e. Sparse columns
- 15k. Columnstore Indexes
- Compresison
- Practice Activity Number 6
Identify and resolve concurrency problems
- 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
Collect and analyse troubleshooting data
- 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
Audit SQL Server Instances
- 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
Plan installation
- 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
Install SQL Server and related services
- 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
Implement a migration strategy
- 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
Install SQL Server, related services and additional SQL Server components
- 4b. Configure full-text indexing
- 4c. SSIS Security
- 4d. Filestream
- 4e. Filetable
- Install SQL Server, related services and additional SQL Server components
Well done
- Congratulations
- Bonus Lecture
Instructors
Mr Phillip Burton
Instructor
Udemy