Torrent Downloads » Other » [ CourseBoat com ] Udemy - 70-462 - SQL Server Database Administration (DBA)
Other
[ CourseBoat com ] Udemy - 70-462 - SQL Server Database Administration (DBA)
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 2.50 GB) (Files: 103)
Get Bonus Downloads Here.url
~Get Your Files Here !
1 - Introduction
1 - Introduction.mp4
10 - Downloading AdventureWorks.mp4
2 - Welcome to Udemy.html
3 - The Udemy Interface.mp4
4 - Do you want auto-translated subtitles in more languages.html
5 - Curriculum.mp4
6 - Databases - Resources.html
7 - Downloading SQL Server Developer E9.mp4
8 - Installing SQL Server Developer E9.mp4
9 - Installing SQL Server Management Studio (SSMS).mp4
AdventureWorks2014.bak
10 - Collect and analyse troubleshooting data
1 - 11a, 11c. Collect trace data by using SQL Server Profiler.mp4
2 - 11i. Use XEvents (Extended Events).mp4
3 - 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4
4 - 11l. Identify IO v memory v CPU bottlenecks.mp4
5 - Practice Activity Number 7.html
11 - Audit SQL Server Instances
1 - 12a. implement a security strategy for auditing; 12c. configure server audits.mp4
2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4
3 - 12b. Configure an audit; 12d. Track who modified an object.mp4
4 - Practice Activity Number 8.html
12 - Plan installation
1 - 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4
2 - 1c. Plan Scale-up vs Scale-out basics.mp4
3 - 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4
4 - 1f. Design the storage for new databases.mp4
13 - Install SQL Server and related services
1 - 9a. Install an instance; 7b. Install Default and named instances.mp4
2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4
3 - 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4
4 - 2a. Test connectivity.mp4
5 - 2d. Configure an OS disk.mp4
6 - Practice Activity 9.html
14 - Implement a migration strategy
1 - 3a. Restore versus detach attach.mp4
2 - 3b. Migrate Security.mp4
3 - 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4
4 - 3e. Migrate systems and data from other sources.mp4
15 - Install SQL Server, related services and additional SQL Server components
1 - 4b. Configure full-text indexing.mp4
2 - 4c. SSIS Security.mp4
3 - 4d. Filestream.mp4
4 - 4e. Filetable.mp4
16 - Well done
1 - Congratulations.mp4
2 - Bonus Lecture.mp4
2 - Backup and Restore - Part 1
1 - Restoring a Database.mp4
10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4
11 - 13d and 14b. Recover from a corrupted drive.mp4
12 - Practice Activity Number 1.html
2 - Looking around SSMS and how to generate T-SQL.mp4
3 - Backing up Database, and problem with Restoring.mp4
4 - Changing Recovery Model.mp4
5 - 13a. Different backup models - theory.mp4
6 - 13a. Different backup models - practice in SSMS.mp4
7 - 13a and 14c. Point in Time Recovery.mp4
8 - Using NORECOVERY and RECOVERY.mp4
9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4
3 - Manage logins and server roles
1 - 17c. Create login accounts.mp4
10 - Practice Activity Number 2.html
2 - 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4
3 - 17e. Create and maintain user-defined server roles.mp4
4 - 19c. Create Database User Accounts.mp4
5 - 18b. Fixed Database-Level Roles.mp4
6 - User Database-Level Roles.mp4
7 - Creating and Using Schemas.mp4
8 - Creating access to server database with least privilege.mp4
9 - 18c. Protect objects from being modified.mp4
4 - Implement and maintain indexes
1 - What are indexes.mp4
2 - 15d. Implement indexes.mp4
3 - Fragmentation - theory.mp4
4 - Fragmentation, reorganize and rebuild in SSMS.mp4
5 - Fill factor.mp4
6 - 15g. Optimise indexes (full, filter index).mp4
7 - 15c. Identify unused indexes.mp4
8 - 15h. Statistics (full, filter) force or fix queue.mp4
9 - Practice Activity Number 3.html
5 - Import and export data
1 - Transfer data.mp4
2 - Bulk Insert.mp4
6 - Manage SQL Server Agent - Part 1
1 - 5a. Create, maintain and monitor jobs.mp4
2 - 5b. Administer jobs and alerts.mp4
3 - RAISERROR and Create Event Alerts.mp4
4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4
5 - 5b. Adding operators to jobs and alerts.mp4
6 - 11j. Create alerts on critical server condition.mp4
7 - Practice Activity Number 4.html
7 - Manage and configure databases
1 - 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4
10 - 6i. DBCC.mp4
11 - 6d, 19d. Implement and configure contained databases and logins.mp4
12 - Practice Activity Number 5.html
2 - 6a. Design multiple file groups.mp4
3 - 6a. Creating database with multiple file groups.mp4
4 - 6c. Manage file space, including adding new filegroups and moving objects.mp4
5 - 6g. Partitioning in theory.mp4
6 - Partitioning in practice using the GUI.mp4
7 - Partitioning in practice using T-SQL, and testing partitioning.mp4
8 - 13e. Manage a multi-TB database; 14d. File group restore.mp4
9 - 6h. Manage log file growth.mp4
8 - Compression
1 - 6e. Page and Row Data Compression.mp4
2 - 6e. Sparse columns.mp4
3 - 15k. Columnstore Indexes.mp4
4 - Practice Activity Number 6.html
9 - Identify and resolve concurrency problems
1 - 10d. Diagnose blocking, live locking and deadlocking - theory.mp4
2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4
3 - 10c. Monitor via DMV or other MS product; 10e. diagnose waits.mp4
4 - 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4
5 - 10g. Know What Affects Performance.mp4
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ CourseBoat com ] Udemy - 70-462 - SQL Server Database Administration (DBA) Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
