|
/
|
|
Get Bonus Downloads Here.url
|
0.2 KB
|
|
/1 - Introduction/
|
|
1 - Introduction.mp4
|
31.2 MB
|
|
10 - Downloading AdventureWorks.mp4
|
13.8 MB
|
|
2 - Welcome to Udemy.html
|
0.9 KB
|
|
3 - The Udemy Interface.mp4
|
10.2 MB
|
|
4 - Do you want auto-translated subtitles in more languages.html
|
2.2 KB
|
|
5 - Curriculum.mp4
|
57.1 MB
|
|
6 - Databases - Resources.html
|
0.3 KB
|
|
7 - Downloading SQL Server Developer E9.mp4
|
36.5 MB
|
|
8 - Installing SQL Server Developer E9.mp4
|
23.2 MB
|
|
9 - Installing SQL Server Management Studio (SSMS).mp4
|
12.7 MB
|
|
AdventureWorks2014.bak
|
46.8 MB
|
|
/.../10 - Collect and analyse troubleshooting data/
|
|
1 - 11a, 11c. Collect trace data by using SQL Server Profiler.mp4
|
28.5 MB
|
|
2 - 11i. Use XEvents (Extended Events).mp4
|
21.3 MB
|
|
3 - 11b, 11f, 11g, 11h. Collect performance data by using System Monitor.mp4
|
34.1 MB
|
|
4 - 11l. Identify IO v memory v CPU bottlenecks.mp4
|
9.2 MB
|
|
5 - Practice Activity Number 7.html
|
0.8 KB
|
|
/.../11 - Audit SQL Server Instances/
|
|
1 - 12a. implement a security strategy for auditing; 12c. configure server audits.mp4
|
41.2 MB
|
|
2 - 12e. Monitor elevated privileges as well as unsolicited attempts to connect.mp4
|
35.6 MB
|
|
3 - 12b. Configure an audit; 12d. Track who modified an object.mp4
|
33.3 MB
|
|
4 - Practice Activity Number 8.html
|
0.7 KB
|
|
/.../12 - Plan installation/
|
|
1 - 1l. Choose the right hardware; 1a. Evaluate Installation Requirements.mp4
|
18.9 MB
|
|
2 - 1c. Plan Scale-up vs Scale-out basics.mp4
|
12.9 MB
|
|
3 - 1d. Plan for capacity; 1i. Windows-Level and Service Level Security.mp4
|
16.4 MB
|
|
4 - 1f. Design the storage for new databases.mp4
|
18.1 MB
|
|
/.../13 - Install SQL Server and related services/
|
|
1 - 9a. Install an instance; 7b. Install Default and named instances.mp4
|
22.2 MB
|
|
2 - 1b, 2b, 2c, 4a, 4b. Design the installation of SQL Server and its components.mp4
|
51.8 MB
|
|
3 - 4a. Set up and configure all SQL Server components, including Visual Studio SSDT.mp4
|
69.7 MB
|
|
4 - 2a. Test connectivity.mp4
|
10.6 MB
|
|
5 - 2d. Configure an OS disk.mp4
|
19.4 MB
|
|
6 - Practice Activity 9.html
|
0.2 KB
|
|
/.../14 - Implement a migration strategy/
|
|
1 - 3a. Restore versus detach attach.mp4
|
14.9 MB
|
|
2 - 3b. Migrate Security.mp4
|
14.3 MB
|
|
3 - 3c. Migrate from a previous version; 3d. Migrate to new hardware.mp4
|
9.4 MB
|
|
4 - 3e. Migrate systems and data from other sources.mp4
|
8.2 MB
|
|
/.../15 - Install SQL Server, related services and additional SQL Server components/
|
|
1 - 4b. Configure full-text indexing.mp4
|
33.9 MB
|
|
2 - 4c. SSIS Security.mp4
|
15.8 MB
|
|
3 - 4d. Filestream.mp4
|
36.4 MB
|
|
4 - 4e. Filetable.mp4
|
32.9 MB
|
|
/.../16 - Well done/
|
|
1 - Congratulations.mp4
|
8.1 MB
|
|
2 - Bonus Lecture.mp4
|
13.0 MB
|
|
/.../2 - Backup and Restore - Part 1/
|
|
1 - Restoring a Database.mp4
|
49.0 MB
|
|
10 - 13c and 13f. Perform backup restore based on strategies inc. backup redundancy.mp4
|
51.0 MB
|
|
11 - 13d and 14b. Recover from a corrupted drive.mp4
|
35.8 MB
|
|
12 - Practice Activity Number 1.html
|
1.2 KB
|
|
2 - Looking around SSMS and how to generate T-SQL.mp4
|
42.8 MB
|
|
3 - Backing up Database, and problem with Restoring.mp4
|
43.0 MB
|
|
4 - Changing Recovery Model.mp4
|
16.8 MB
|
|
5 - 13a. Different backup models - theory.mp4
|
44.8 MB
|
|
6 - 13a. Different backup models - practice in SSMS.mp4
|
37.3 MB
|
|
7 - 13a and 14c. Point in Time Recovery.mp4
|
54.6 MB
|
|
8 - Using NORECOVERY and RECOVERY.mp4
|
58.9 MB
|
|
9 - 13g and 13h. Back up an SQL Server environment and system databases.mp4
|
28.8 MB
|
|
/.../3 - Manage logins and server roles/
|
|
1 - 17c. Create login accounts.mp4
|
21.2 MB
|
|
10 - Practice Activity Number 2.html
|
1.3 KB
|
|
2 - 17d. Manage access to the server, 17b. secure the SQL server using server roles.mp4
|
33.1 MB
|
|
3 - 17e. Create and maintain user-defined server roles.mp4
|
26.8 MB
|
|
4 - 19c. Create Database User Accounts.mp4
|
21.8 MB
|
|
5 - 18b. Fixed Database-Level Roles.mp4
|
28.4 MB
|
|
6 - User Database-Level Roles.mp4
|
50.7 MB
|
|
7 - Creating and Using Schemas.mp4
|
26.5 MB
|
|
8 - Creating access to server database with least privilege.mp4
|
29.4 MB
|
|
9 - 18c. Protect objects from being modified.mp4
|
9.3 MB
|
|
/.../4 - Implement and maintain indexes/
|
|
1 - What are indexes.mp4
|
57.7 MB
|
|
2 - 15d. Implement indexes.mp4
|
28.0 MB
|
|
3 - Fragmentation - theory.mp4
|
50.1 MB
|
|
4 - Fragmentation, reorganize and rebuild in SSMS.mp4
|
46.4 MB
|
|
5 - Fill factor.mp4
|
22.9 MB
|
|
6 - 15g. Optimise indexes (full, filter index).mp4
|
16.3 MB
|
|
7 - 15c. Identify unused indexes.mp4
|
23.0 MB
|
|
8 - 15h. Statistics (full, filter) force or fix queue.mp4
|
21.6 MB
|
|
9 - Practice Activity Number 3.html
|
0.5 KB
|
|
/.../5 - Import and export data/
|
|
1 - Transfer data.mp4
|
45.0 MB
|
|
2 - Bulk Insert.mp4
|
14.1 MB
|
|
/.../6 - Manage SQL Server Agent - Part 1/
|
|
1 - 5a. Create, maintain and monitor jobs.mp4
|
29.6 MB
|
|
2 - 5b. Administer jobs and alerts.mp4
|
12.1 MB
|
|
3 - RAISERROR and Create Event Alerts.mp4
|
19.7 MB
|
|
4 - What happens when a job runs And running a RAISERROR WITH LOG.mp4
|
14.5 MB
|
|
5 - 5b. Adding operators to jobs and alerts.mp4
|
33.4 MB
|
|
6 - 11j. Create alerts on critical server condition.mp4
|
9.8 MB
|
|
7 - Practice Activity Number 4.html
|
0.9 KB
|
|
/.../7 - Manage and configure databases/
|
|
1 - 6b, 7a. Database configuration autoclose, autoshrink, recovery models.mp4
|
51.0 MB
|
|
10 - 6i. DBCC.mp4
|
17.0 MB
|
|
11 - 6d, 19d. Implement and configure contained databases and logins.mp4
|
39.0 MB
|
|
12 - Practice Activity Number 5.html
|
0.6 KB
|
|
2 - 6a. Design multiple file groups.mp4
|
24.0 MB
|
|
3 - 6a. Creating database with multiple file groups.mp4
|
22.9 MB
|
|
4 - 6c. Manage file space, including adding new filegroups and moving objects.mp4
|
69.2 MB
|
|
5 - 6g. Partitioning in theory.mp4
|
24.9 MB
|
|
6 - Partitioning in practice using the GUI.mp4
|
52.0 MB
|
|
7 - Partitioning in practice using T-SQL, and testing partitioning.mp4
|
35.0 MB
|
|
8 - 13e. Manage a multi-TB database; 14d. File group restore.mp4
|
29.7 MB
|
|
9 - 6h. Manage log file growth.mp4
|
26.8 MB
|
|
/8 - Compression/
|
|
1 - 6e. Page and Row Data Compression.mp4
|
38.3 MB
|
|
2 - 6e. Sparse columns.mp4
|
21.0 MB
|
|
3 - 15k. Columnstore Indexes.mp4
|
50.5 MB
|
|
4 - Practice Activity Number 6.html
|
0.4 KB
|
|
/.../9 - Identify and resolve concurrency problems/
|
|
1 - 10d. Diagnose blocking, live locking and deadlocking - theory.mp4
|
30.5 MB
|
|
2 - 10d. Diagnose deadlocking - practice; 10h. kill processes.mp4
|
25.5 MB
|
|
3 - 10c. Monitor via DMV or other MS product; 10e. diagnose waits.mp4
|
28.4 MB
|
|
4 - 10a. Examine deadlocking issues using the SQL server logs using trace flags.mp4
|
56.2 MB
|
|
5 - 10g. Know What Affects Performance.mp4
|
25.7 MB
|
|
/~Get Your Files Here !/
|
|
Bonus Resources.txt
|
0.4 KB
|
|
Total files 103
|
