70-462: SQL Server Database Administration (DBA)

BY
Udemy

Obtain a basic to intermediate understanding of the concepts and strategies involved in managing a SQL server database.

Mode

Online

Fees

₹ 3099

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
₹ 3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Troubleshooting Database knowledge Sql knowledge

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.

The syllabus

Introduction

  • 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

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

Mr Phillip Burton
Instructor
Udemy

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books