MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 2.49 GB | Duration: 9h 51m Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462. What you'll learn 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
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 If you want to know enough T-SQL to assist you with your SSRS work, please have a look at the first two sessions of my 70-461 courses. 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. Description 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.
~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4
29.7 MB
~Get Your Files Here !/1 - Introduction/10 - Downloading AdventureWorks.mp4
13.2 MB
~Get Your Files Here !/1 - Introduction/2 - Welcome to Udemy.html
886 B
~Get Your Files Here !/1 - Introduction/3 - The Udemy Interface.mp4
9.8 MB
~Get Your Files Here !/1 - Introduction/4 - Do you want auto-translated subtitles in more languages.html
2.2 KB
~Get Your Files Here !/1 - Introduction/5 - Curriculum.mp4
54.5 MB
~Get Your Files Here !/1 - Introduction/6 - Databases - Resources.html
325 B
~Get Your Files Here !/1 - Introduction/7 - Downloading SQL Server Developer E9.mp4
34.8 MB
~Get Your Files Here !/1 - Introduction/8 - Installing SQL Server Developer E9.mp4
22.1 MB
~Get Your Files Here !/1 - Introduction/9 - Installing SQL Server Management Studio (SSMS).mp4
12.1 MB
~Get Your Files Here !/1 - Introduction/AdventureWorks2014.bak
44.6 MB
~Get Your Files Here !/10 - Collect and analyse troubleshooting data/1 - 11a, 11c. Collect trace data by using SQL Server Profiler.mp4
27.2 MB
~Get Your Files Here !/10 - Collect and analyse troubleshooting data/2 - 11i. Use XEvents (Extended Events).mp4
20.3 MB
~Get Your Files Here !/10 - Collect and analyse troubleshooting data/3 - 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4
32.5 MB
~Get Your Files Here !/10 - Collect and analyse troubleshooting data/4 - 11l. Identify IO v memory v CPU bottlenecks.mp4
8.7 MB
~Get Your Files Here !/10 - Collect and analyse troubleshooting data/5 - Practice Activity Number 7.html
805 B
~Get Your Files Here !/11 - Audit SQL Server Instances/1 - 12a. implement a security strategy for auditing; 12c. configure server audits.mp4
39.3 MB
~Get Your Files Here !/11 - Audit SQL Server Instances/2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4
34 MB
~Get Your Files Here !/11 - Audit SQL Server Instances/3 - 12b. Configure an audit; 12d. Track who modified an object.mp4
31.8 MB
~Get Your Files Here !/11 - Audit SQL Server Instances/4 - Practice Activity Number 8.html
730 B
~Get Your Files Here !/12 - Plan installation/1 - 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4
18 MB
~Get Your Files Here !/12 - Plan installation/2 - 1c. Plan Scale-up vs Scale-out basics.mp4
12.3 MB
~Get Your Files Here !/12 - Plan installation/3 - 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4
15.6 MB
~Get Your Files Here !/12 - Plan installation/4 - 1f. Design the storage for new databases.mp4
17.3 MB
~Get Your Files Here !/13 - Install SQL Server and related services/1 - 9a. Install an instance; 7b. Install Default and named instances.mp4
21.2 MB
~Get Your Files Here !/13 - Install SQL Server and related services/2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4
49.4 MB
~Get Your Files Here !/13 - Install SQL Server and related services/3 - 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4
66.5 MB
~Get Your Files Here !/13 - Install SQL Server and related services/4 - 2a. Test connectivity.mp4
10.1 MB
~Get Your Files Here !/13 - Install SQL Server and related services/5 - 2d. Configure an OS disk.mp4
18.5 MB
~Get Your Files Here !/13 - Install SQL Server and related services/6 - Practice Activity 9.html
185 B
~Get Your Files Here !/14 - Implement a migration strategy/1 - 3a. Restore versus detach attach.mp4
14.2 MB
~Get Your Files Here !/14 - Implement a migration strategy/2 - 3b. Migrate Security.mp4
13.6 MB
~Get Your Files Here !/14 - Implement a migration strategy/3 - 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4
9 MB
~Get Your Files Here !/14 - Implement a migration strategy/4 - 3e. Migrate systems and data from other sources.mp4
7.8 MB
~Get Your Files Here !/15 - Install SQL Server, related services and additional SQL Server components/1 - 4b. Configure full-text indexing.mp4
32.4 MB
~Get Your Files Here !/15 - Install SQL Server, related services and additional SQL Server components/2 - 4c. SSIS Security.mp4
15 MB
~Get Your Files Here !/15 - Install SQL Server, related services and additional SQL Server components/3 - 4d. Filestream.mp4
34.7 MB
~Get Your Files Here !/15 - Install SQL Server, related services and additional SQL Server components/4 - 4e. Filetable.mp4
31.4 MB
~Get Your Files Here !/16 - Well done/1 - Congratulations.mp4
7.7 MB
~Get Your Files Here !/16 - Well done/2 - Bonus Lecture.mp4
12.4 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/1 - Restoring a Database.mp4
46.7 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4
48.6 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/11 - 13d and 14b. Recover from a corrupted drive.mp4
34.1 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/12 - Practice Activity Number 1.html
1.2 KB
~Get Your Files Here !/2 - Backup and Restore - Part 1/2 - Looking around SSMS and how to generate T-SQL.mp4
40.8 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/3 - Backing up Database, and problem with Restoring.mp4
41 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/4 - Changing Recovery Model.mp4
16 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/5 - 13a. Different backup models - theory.mp4
42.8 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/6 - 13a. Different backup models - practice in SSMS.mp4
35.6 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/7 - 13a and 14c. Point in Time Recovery.mp4
52 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/8 - Using NORECOVERY and RECOVERY.mp4
56.1 MB
~Get Your Files Here !/2 - Backup and Restore - Part 1/9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4
27.5 MB
~Get Your Files Here !/3 - Manage logins and server roles/1 - 17c. Create login accounts.mp4
20.2 MB
~Get Your Files Here !/3 - Manage logins and server roles/10 - Practice Activity Number 2.html
1.2 KB
~Get Your Files Here !/3 - Manage logins and server roles/2 - 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4
31.6 MB
~Get Your Files Here !/3 - Manage logins and server roles/3 - 17e. Create and maintain user-defined server roles.mp4
25.6 MB
~Get Your Files Here !/3 - Manage logins and server roles/4 - 19c. Create Database User Accounts.mp4
20.8 MB
~Get Your Files Here !/3 - Manage logins and server roles/5 - 18b. Fixed Database-Level Roles.mp4
27.1 MB
~Get Your Files Here !/3 - Manage logins and server roles/6 - User Database-Level Roles.mp4
48.3 MB
~Get Your Files Here !/3 - Manage logins and server roles/7 - Creating and Using Schemas.mp4
25.2 MB
~Get Your Files Here !/3 - Manage logins and server roles/8 - Creating access to server database with least privilege.mp4
28 MB
~Get Your Files Here !/3 - Manage logins and server roles/9 - 18c. Protect objects from being modified.mp4
8.9 MB
~Get Your Files Here !/4 - Implement and maintain indexes/1 - What are indexes.mp4
55.1 MB
~Get Your Files Here !/4 - Implement and maintain indexes/2 - 15d. Implement indexes.mp4
26.7 MB
~Get Your Files Here !/4 - Implement and maintain indexes/3 - Fragmentation - theory.mp4
47.8 MB
~Get Your Files Here !/4 - Implement and maintain indexes/4 - Fragmentation, reorganize and rebuild in SSMS.mp4
44.3 MB
~Get Your Files Here !/4 - Implement and maintain indexes/5 - Fill factor.mp4
21.9 MB
~Get Your Files Here !/4 - Implement and maintain indexes/6 - 15g. Optimise indexes (full, filter index).mp4
15.6 MB
~Get Your Files Here !/4 - Implement and maintain indexes/7 - 15c. Identify unused indexes.mp4
22 MB
~Get Your Files Here !/4 - Implement and maintain indexes/8 - 15h. Statistics (full, filter) force or fix queue.mp4
20.6 MB
~Get Your Files Here !/4 - Implement and maintain indexes/9 - Practice Activity Number 3.html
473 B
~Get Your Files Here !/5 - Import and export data/1 - Transfer data.mp4
42.9 MB
~Get Your Files Here !/5 - Import and export data/2 - Bulk Insert.mp4
13.5 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/1 - 5a. Create, maintain and monitor jobs.mp4
28.3 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/2 - 5b. Administer jobs and alerts.mp4
11.5 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/3 - RAISERROR and Create Event Alerts.mp4
18.7 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4
13.8 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/5 - 5b. Adding operators to jobs and alerts.mp4
31.9 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/6 - 11j. Create alerts on critical server condition.mp4
9.4 MB
~Get Your Files Here !/6 - Manage SQL Server Agent - Part 1/7 - Practice Activity Number 4.html
883 B
~Get Your Files Here !/7 - Manage and configure databases/1 - 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4
48.7 MB
~Get Your Files Here !/7 - Manage and configure databases/10 - 6i. DBCC.mp4
16.2 MB
~Get Your Files Here !/7 - Manage and configure databases/11 - 6d, 19d. Implement and configure contained databases and logins.mp4
37.2 MB
~Get Your Files Here !/7 - Manage and configure databases/12 - Practice Activity Number 5.html
595 B
~Get Your Files Here !/7 - Manage and configure databases/2 - 6a. Design multiple file groups.mp4
22.9 MB
~Get Your Files Here !/7 - Manage and configure databases/3 - 6a. Creating database with multiple file groups.mp4
21.9 MB
~Get Your Files Here !/7 - Manage and configure databases/4 - 6c. Manage file space, including adding new filegroups and moving objects.mp4
66 MB
~Get Your Files Here !/7 - Manage and configure databases/5 - 6g. Partitioning in theory.mp4
23.7 MB
~Get Your Files Here !/7 - Manage and configure databases/6 - Partitioning in practice using the GUI.mp4
49.6 MB
~Get Your Files Here !/7 - Manage and configure databases/7 - Partitioning in practice using T-SQL, and testing partitioning.mp4
33.3 MB
~Get Your Files Here !/7 - Manage and configure databases/8 - 13e. Manage a multi-TB database; 14d. File group restore.mp4
28.4 MB
~Get Your Files Here !/7 - Manage and configure databases/9 - 6h. Manage log file growth.mp4
25.6 MB
~Get Your Files Here !/8 - Compression/1 - 6e. Page and Row Data Compression.mp4
36.5 MB
~Get Your Files Here !/8 - Compression/2 - 6e. Sparse columns.mp4
20 MB
~Get Your Files Here !/8 - Compression/3 - 15k. Columnstore Indexes.mp4
48.2 MB
~Get Your Files Here !/8 - Compression/4 - Practice Activity Number 6.html
413 B
~Get Your Files Here !/9 - Identify and resolve concurrency problems/1 - 10d. Diagnose blocking, live locking and deadlocking - theory.mp4
29.1 MB
~Get Your Files Here !/9 - Identify and resolve concurrency problems/2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4
24.3 MB
Alternative Torrents for 'CourseBoat.com Udemy SQL Server Database Administration DBA'.
![[ CourseBoat.com ] Udemy - 70-462 - SQL Server Database Administration (DBA)](https://l.t0r.site/cover/60353540.webp)
