70-462: SQL Server Database Administration (DBA)
Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.
Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.
Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.
Do you want to gain practical experience in Database Administration in SQL Server? Welcome.
In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
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.
We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.
We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.
The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.
The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.
The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I'll introduce every component as we go on.
No knowledge of T-SQL is required, as I'll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.
The course is recorded on SQL Server 2017, but will also work fully in 2022, 2019, 2016, 2014 and 2012, and mostly in 2008R2 and 2008.
Khu vực Câu hỏi thường gặp trống
Introduction
Xem trướcWelcome to Udemy
Xem trướcThe Udemy Interface
Xem trướcDo you want auto-translated subtitles in more languages?
Curriculum
Databases - Resources
Xem trướcDownloading SQL Server Developer 2022
Xem trướcInstalling SQL Server Developer 2022
Xem trướcWhich version of SSMS should I use?
Xem trướcInstalling SQL Server Management Studio (SSMS)
Downloading AdventureWorks
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
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
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
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
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
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
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
You don't need any prior DBA knowledge prior to taking this course.
It would be helpful if you knew how to create simple T-SQL statements (SELECT, FROM, WHERE, GROUP BY) for some parts of the course, but not essential
You don't need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it - for free.
You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)
Most of the DBA functionality is not available on Azure Data Studio, and therefore you will not be able to do the DBA operations using a Mac.
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
1.2
1 Học viên
275 Khóa học
1253 Đánh giá
Xin chào các bạn, tôi là Nguyễn Đình Cường, một lập trình viên và giảng viên đam mê công nghệ với hơn 15 năm kinh nghiệm trong ngành công nghiệp phần mềm. Tôi tốt nghiệp từ Bưu Chính Viễn Thông và đã từng làm việc cho một số công ty công nghệ hàng đầu như FPT Software và VinGroup. Với chuyên môn chính là phát triển ứng dụng web, tôi đã làm việc với nhiều công nghệ như HTML, CSS, JavaScript, React cho front-end và Node.js, Express, MongoDB cho back-end. Không chỉ dừng lại ở việc viết mã, tôi còn yêu thích tìm hiểu sâu về thiết kế hệ thống và kiến trúc phần mềm. Tôi tin rằng quá trình học lập trình không chỉ đơn thuần là lý thuyết, mà còn là sự trải nghiệm thực tế và giải quyết vấn đề. Trong các khóa học của mình, tôi cố gắng cung cấp cho học viên những bài giảng thú vị và dễ hiểu, cùng với các bài tập thực hành giúp củng cố kiến thức. Tôi hy vọng rằng qua các khóa học của mình, bạn sẽ không chỉ học được cách viết mã, mà còn phát triển tư duy lập trình và kỹ năng giải quyết vấn đề. Hãy cùng nhau khám phá thế giới lập trình và biến ý tưởng của bạn thành hiện thực! Nếu bạn có bất kỳ câu hỏi nào, đừng ngần ngại liên hệ với tôi. Tôi rất vui được hỗ trợ bạn trong hành trình học tập của mình!
Xem chi tiết