Udemy - 70-462 - SQL Server Database Administration (DBA)

seeders: 0
leechers: 0
Added 4 years ago by freecoursewb in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - 70-462 - SQL Server Database Administration (DBA) (Size: 2.5 GB)
  1 - 10d. Diagnose blocking, live locking and deadlocking - theory.mp4 29.1 MB
  1 - 11a, 11c. Collect trace data by using SQL Server Profiler.mp4 27.2 MB
  1 - 12a. implement a security strategy for auditing; 12c. configure server audits.mp4 39.3 MB
  1 - 17c. Create login accounts.mp4 20.2 MB
  1 - 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4 18 MB
  1 - 3a. Restore versus detach attach.mp4 14.2 MB
  1 - 4b. Configure full-text indexing.mp4 32.4 MB
  1 - 5a. Create, maintain and monitor jobs.mp4 28.3 MB
  1 - 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4 48.7 MB
  1 - 6e. Page and Row Data Compression.mp4 36.5 MB
  1 - 9a. Install an instance; 7b. Install Default and named instances.mp4 21.2 MB
  1 - Congratulations.mp4 7.7 MB
  1 - Introduction.mp4 29.7 MB
  1 - Restoring a Database.mp4 46.7 MB
  1 - Transfer data.mp4 42.9 MB
  1 - What are indexes.mp4 55.1 MB
  10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4 48.6 MB
  10 - 6i. DBCC.mp4 16.2 MB
  10 - Downloading AdventureWorks.mp4 13.2 MB
  10 - Practice Activity Number 2.html 1.2 KB
  11 - 13d and 14b. Recover from a corrupted drive.mp4 34.1 MB
  11 - 6d, 19d. Implement and configure contained databases and logins.mp4 37.2 MB
  12 - Practice Activity Number 1.html 1.2 KB
  12 - Practice Activity Number 5.html 614.4 B
  2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4 24.3 MB
  2 - 11i. Use XEvents (Extended Events).mp4 20.3 MB
  2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4 34 MB
  2 - 15d. Implement indexes.mp4 26.7 MB
  2 - 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4 31.6 MB
  2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4 49.4 MB
  2 - 1c. Plan Scale-up vs Scale-out basics.mp4 12.3 MB
  2 - 3b. Migrate Security.mp4 13.6 MB
  2 - 4c. SSIS Security.mp4 15 MB
  2 - 5b. Administer jobs and alerts.mp4 11.5 MB
  2 - 6a. Design multiple file groups.mp4 22.9 MB
  2 - 6e. Sparse columns.mp4 20 MB
  2 - Bonus Lecture.mp4 12.4 MB
  2 - Bulk Insert.mp4 13.5 MB
  2 - Looking around SSMS and how to generate T-SQL.mp4 40.8 MB
  2 - Welcome to Udemy.html 921.6 B
  3 - 10c. Monitor via DMV or other MS product; 10e. diagnose waits.mp4 27.1 MB
  3 - 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4 32.5 MB
  3 - 12b. Configure an audit; 12d. Track who modified an object.mp4 31.8 MB
  3 - 15k. Columnstore Indexes.mp4 48.2 MB
  3 - 17e. Create and maintain user-defined server roles.mp4 25.6 MB
  3 - 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4 15.6 MB
  3 - 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4 9 MB
  3 - 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4 66.5 MB
  3 - 4d. Filestream.mp4 34.7 MB
  3 - 6a. Creating database with multiple file groups.mp4 21.9 MB
  3 - Backing up Database, and problem with Restoring.mp4 41 MB
  3 - Fragmentation - theory.mp4 47.8 MB
  3 - RAISERROR and Create Event Alerts.mp4 18.7 MB
  3 - The Udemy Interface.mp4 9.8 MB
  4 - 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4 53.6 MB
  4 - 11l. Identify IO v memory v CPU bottlenecks.mp4 8.7 MB
  4 - 19c. Create Database User Accounts.mp4 20.8 MB
  4 - 1f. Design the storage for new databases.mp4 17.3 MB
  4 - 2a. Test connectivity.mp4 10.1 MB
  4 - 3e. Migrate systems and data from other sources.mp4 7.8 MB
  4 - 4e. Filetable.mp4 31.4 MB
  4 - 6c. Manage file space, including adding new filegroups and moving objects.mp4 66 MB
  4 - Changing Recovery Model.mp4 16 MB
  4 - Do you want auto-translated subtitles in more languages.html 2.2 KB
  4 - Fragmentation, reorganize and rebuild in SSMS.mp4 44.3 MB
  4 - Practice Activity Number 6.html 409.6 B
  4 - Practice Activity Number 8.html 716.8 B
  4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4 13.8 MB
  5 - 10g. Know What Affects Performance.mp4 24.5 MB
  5 - 13a. Different backup models - theory.mp4 42.8 MB
  5 - 18b. Fixed Database-Level Roles.mp4 27.1 MB
  5 - 2d. Configure an OS disk.mp4 18.5 MB
  5 - 5b. Adding operators to jobs and alerts.mp4 31.9 MB
  5 - 6g. Partitioning in theory.mp4 23.7 MB
  5 - Curriculum.mp4 54.5 MB
  5 - Fill factor.mp4 21.9 MB
  5 - Practice Activity Number 7.html 819.2 B
  6 - 11j. Create alerts on critical server condition.mp4 9.4 MB
  6 - 13a. Different backup models - practice in SSMS.mp4 35.6 MB
  6 - 15g. Optimise indexes (full, filter index).mp4 15.6 MB
  6 - Databases - Resources.html 307.2 B
  6 - Partitioning in practice using the GUI.mp4 49.6 MB
  6 - Practice Activity 9.html 204.8 B
  6 - User Database-Level Roles.mp4 48.3 MB
  7 - 13a and 14c. Point in Time Recovery.mp4 52 MB
  7 - 15c. Identify unused indexes.mp4 22 MB
  7 - Creating and Using Schemas.mp4 25.2 MB
  7 - Downloading SQL Server Developer E9.mp4 34.8 MB
  7 - Partitioning in practice using T-SQL, and testing partitioning.mp4 33.3 MB
  7 - Practice Activity Number 4.html 921.6 B
  8 - 13e. Manage a multi-TB database; 14d. File group restore.mp4 28.4 MB
  8 - 15h. Statistics (full, filter) force or fix queue.mp4 20.6 MB
  8 - Creating access to server database with least privilege.mp4 28 MB
  8 - Installing SQL Server Developer E9.mp4 22.1 MB
  8 - Using NORECOVERY and RECOVERY.mp4 56.1 MB
  9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4 27.5 MB
  9 - 18c. Protect objects from being modified.mp4 8.9 MB
  9 - 6h. Manage log file growth.mp4 25.6 MB
  9 - Installing SQL Server Management Studio (SSMS).mp4 12.1 MB
  9 - Practice Activity Number 3.html 512 B
  AdventureWorks2014.bak 44.6 MB
  Bonus Resources.txt 307.2 B
  Get Bonus Downloads Here.url 204.8 B
  ▲ 103 total files

Description


70-462: SQL Server Database Administration (DBA)
https://CourseBoat.com

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.

Related Torrents

torrent name size uploader age seed leech
1
4
1
0
0