Lynda Microsoft SQL Server 2019 Essential Training | 824C9909F09CDAC7072069279938C3BF7A42078B

Lynda Microsoft SQL Server 2019 Essential Training

Name	[Lynda] Microsoft SQL Server 2019 Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	638.8 MB
Total Files	162
Hash	824C9909F09CDAC7072069279938C3BF7A42078B

/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 03/
Landon_Employees.csv	1.2 KB
Landon_Guests.csv	0.4 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 05/
CreateTable_Complete.sql	0.2 KB
Delete_Complete.sql	0.5 KB
Delete_Start.sql	0.4 KB
Insert_Complete.sql	0.4 KB
Insert_Start.sql	0.2 KB
Joins_Complete.sql	0.4 KB
Select_Complete.sql	0.4 KB
Select_Start.sql	0.4 KB
Sort_Complete.sql	0.6 KB
Sort_Start.sql	0.5 KB
Update_Complete.sql	0.1 KB
Where_Complete.sql	0.5 KB
Where_Start.sql	0.4 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 06/
Create_Index.sql	0.2 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 07/
Aggregate_Functions.sql	1.4 KB
BuiltIn_Functions_Complete.sql	0.1 KB
Parameters.sql	1.9 KB
Stored_Procedure.sql	1.5 KB
User_Functions_Complete.sql	0.5 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 08/
Differential_Backup.sql	0.6 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 09/
Dynamic_Mask.sql	0.6 KB
Schema_Complete.sql	0.3 KB
/.../Ex_Files_SQL_Server_2019_EssT/Exercise Files/Chapter 10/
DBCC.sql	0.6 KB
DMV.sql	0.7 KB
/[Lynda] Microsoft SQL Server 2019 Essential Training/
01 - Harness the modern and innovative tools in SQL Server 2019.en.srt	2.9 KB
02 - What you should know.en.srt	1.5 KB
03 - Core concepts.en.srt	11.1 KB
04 - SQL Server 2019 editions.en.srt	7.8 KB
05 - Install SQL Server Developer Edition.en.srt	16.3 KB
06 - Install Management Studio.en.srt	7.7 KB
07 - Enable features with Configuration Manager.en.srt	2.5 KB
08 - Management Studio first steps.en.srt	9.0 KB
09 - Authentication and user permissions.en.srt	4.9 KB
10 - Create a new user account.en.srt	6.3 KB
11 - Create the first database.en.srt	12.8 KB
12 - Database configuration options.en.srt	15.5 KB
13 - Table structures.en.srt	6.6 KB
14 - Create a simple table.en.srt	13.8 KB
15 - Edit a table's structure.en.srt	4.6 KB
16 - Enter data into a table using the GUI.en.srt	3.5 KB
17 - Import data from CSV files.en.srt	12.8 KB
18 - Create tables from flat files.en.srt	6.1 KB
19 - Install a sample database.en.srt	6.4 KB
20 - Understand data types.en.srt	11.0 KB
21 - Table column properties.en.srt	9.7 KB
22 - Primary key fields.en.srt	4.7 KB
23 - Establish a default value.en.srt	7.7 KB
24 - Check constraints.en.srt	5.7 KB
25 - Unique constraints.en.srt	9.6 KB
26 - Foreign keys.en.srt	8.9 KB
27 - Create a foreign key column.en.srt	4.9 KB
28 - Create relationships between tables.en.srt	8.6 KB
29 - Understand the role of T-SQL.en.srt	4.4 KB
30 - Use the T-SQL editor.en.srt	14.4 KB
31 - Create a table with T-SQL.en.srt	8.1 KB
32 - Add data to a table.en.srt	5.2 KB
33 - Retrieve records with SELECT.en.srt	4.3 KB
34 - Filter returned results with WHERE.en.srt	3.5 KB
35 - Sort records.en.srt	5.1 KB
36 - Delete records from a table.en.srt	8.0 KB
37 - Update records in a table.en.srt	5.7 KB
38 - Join related tables.en.srt	5.4 KB
39 - LEFT JOIN and RIGHT JOIN.en.srt	4.8 KB
40 - Remove a table from the database.en.srt	8.8 KB
41 - Create a view of the data.en.srt	8.1 KB
42 - Data table indexes.en.srt	6.1 KB
43 - Create additional indexes on a table.en.srt	5.9 KB
44 - Columnstore indexes.en.srt	4.6 KB
45 - View execution plans.en.srt	4.3 KB
46 - SQL Server's Query Store.en.srt	7.2 KB
47 - Rebuild indexes.en.srt	8.9 KB
48 - Aggregate functions.en.srt	15.1 KB
49 - Use built-in functions.en.srt	6.6 KB
50 - Leverage user-defined scalar functions.en.srt	9.1 KB
51 - Introduction to stored procedures.en.srt	2.2 KB
52 - Create stored procedures.en.srt	8.0 KB
53 - Parameterized stored procedures.en.srt	5.9 KB
54 - Create a full backup of the database.en.srt	9.7 KB
55 - Create a differential backup.en.srt	4.9 KB
56 - Restore a backup.en.srt	7.5 KB
57 - Automate backups.en.srt	6.0 KB
58 - Business continuity solutions.en.srt	6.5 KB
59 - User roles and permissions.en.srt	9.4 KB
60 - Database schemas.en.srt	12.2 KB
61 - Dynamic data masking.en.srt	6.5 KB
62 - Always On data encryption.en.srt	5.2 KB
63 - Explore the role of system databases.en.srt	5.0 KB
64 - Prevent excessive tempdb autogrowth.en.srt	3.1 KB
65 - Review the SQL Server error log.en.srt	2.3 KB
66 - Dynamic management views.en.srt	1.1 KB
67 - Database Console Commands (DBCC).en.srt	4.8 KB
68 - Next steps.en.srt	1.9 KB
[ FreeCourseWeb.com ] 01 - Harness the modern and innovative tools in SQL Server 2019.mp4	6.3 MB
[ FreeCourseWeb.com ] 02 - What you should know.mp4	988.8 KB
[ FreeCourseWeb.com ] 03 - Core concepts.mp4	8.5 MB
[ FreeCourseWeb.com ] 04 - SQL Server 2019 editions.mp4	8.4 MB
[ FreeCourseWeb.com ] 05 - Install SQL Server Developer Edition.mp4	22.8 MB
[ FreeCourseWeb.com ] 06 - Install Management Studio.mp4	9.7 MB
[ FreeCourseWeb.com ] 07 - Enable features with Configuration Manager.mp4	5.9 MB
[ FreeCourseWeb.com ] 08 - Management Studio first steps.mp4	9.8 MB
[ FreeCourseWeb.com ] 09 - Authentication and user permissions.mp4	7.0 MB
[ FreeCourseWeb.com ] 10 - Create a new user account.mp4	10.4 MB
[ FreeCourseWeb.com ] 11 - Create the first database.mp4	13.2 MB
[ FreeCourseWeb.com ] 12 - Database configuration options.mp4	15.0 MB
[ FreeCourseWeb.com ] 13 - Table structures.mp4	4.6 MB
[ FreeCourseWeb.com ] 14 - Create a simple table.mp4	14.1 MB
[ FreeCourseWeb.com ] 15 - Edit a table's structure.mp4	4.7 MB
[ FreeCourseWeb.com ] 16 - Enter data into a table using the GUI.mp4	7.8 MB
[ FreeCourseWeb.com ] 17 - Import data from CSV files.mp4	13.8 MB
[ FreeCourseWeb.com ] 18 - Create tables from flat files.mp4	6.9 MB
[ FreeCourseWeb.com ] 19 - Install a sample database.mp4	9.9 MB
[ FreeCourseWeb.com ] 20 - Understand data types.mp4	11.6 MB
[ FreeCourseWeb.com ] 21 - Table column properties.mp4	9.9 MB
[ FreeCourseWeb.com ] 22 - Primary key fields.mp4	8.9 MB
[ FreeCourseWeb.com ] 23 - Establish a default value.mp4	9.6 MB
[ FreeCourseWeb.com ] 24 - Check constraints.mp4	10.0 MB
[ FreeCourseWeb.com ] 25 - Unique constraints.mp4	14.0 MB
[ FreeCourseWeb.com ] 26 - Foreign keys.mp4	13.7 MB
[ FreeCourseWeb.com ] 27 - Create a foreign key column.mp4	8.4 MB
[ FreeCourseWeb.com ] 28 - Create relationships between tables.mp4	10.5 MB
[ FreeCourseWeb.com ] 29 - Understand the role of T-SQL.mp4	5.0 MB
[ FreeCourseWeb.com ] 30 - Use the T-SQL editor.mp4	16.7 MB
[ FreeCourseWeb.com ] 31 - Create a table with T-SQL.mp4	12.1 MB
[ FreeCourseWeb.com ] 32 - Add data to a table.mp4	8.8 MB
[ FreeCourseWeb.com ] 33 - Retrieve records with SELECT.mp4	8.4 MB
[ FreeCourseWeb.com ] 34 - Filter returned results with WHERE.mp4	4.6 MB
[ FreeCourseWeb.com ] 35 - Sort records.mp4	6.9 MB
[ FreeCourseWeb.com ] 36 - Delete records from a table.mp4	8.9 MB
[ FreeCourseWeb.com ] 37 - Update records in a table.mp4	7.1 MB
[ FreeCourseWeb.com ] 38 - Join related tables.mp4	13.6 MB
[ FreeCourseWeb.com ] 39 - LEFT JOIN and RIGHT JOIN.mp4	6.0 MB
[ FreeCourseWeb.com ] 40 - Remove a table from the database.mp4	10.6 MB
[ FreeCourseWeb.com ] 41 - Create a view of the data.mp4	17.9 MB
[ FreeCourseWeb.com ] 42 - Data table indexes.mp4	4.6 MB
[ FreeCourseWeb.com ] 43 - Create additional indexes on a table.mp4	6.6 MB
[ FreeCourseWeb.com ] 44 - Columnstore indexes.mp4	4.0 MB
[ FreeCourseWeb.com ] 45 - View execution plans.mp4	8.0 MB
[ FreeCourseWeb.com ] 46 - SQL Server's Query Store.mp4	7.2 MB
[ FreeCourseWeb.com ] 47 - Rebuild indexes.mp4	11.9 MB
[ FreeCourseWeb.com ] 48 - Aggregate functions.mp4	17.6 MB
[ FreeCourseWeb.com ] 49 - Use built-in functions.mp4	7.5 MB
[ FreeCourseWeb.com ] 50 - Leverage user-defined scalar functions.mp4	17.2 MB
[ FreeCourseWeb.com ] 51 - Introduction to stored procedures.mp4	5.1 MB
[ FreeCourseWeb.com ] 52 - Create stored procedures.mp4	12.3 MB
[ FreeCourseWeb.com ] 53 - Parameterized stored procedures.mp4	9.1 MB
[ FreeCourseWeb.com ] 54 - Create a full backup of the database.mp4	10.0 MB
[ FreeCourseWeb.com ] 55 - Create a differential backup.mp4	7.5 MB
[ FreeCourseWeb.com ] 56 - Restore a backup.mp4	8.5 MB
[ FreeCourseWeb.com ] 57 - Automate backups.mp4	9.2 MB
[ FreeCourseWeb.com ] 58 - Business continuity solutions.mp4	5.4 MB
[ FreeCourseWeb.com ] 59 - User roles and permissions.mp4	10.1 MB
[ FreeCourseWeb.com ] 60 - Database schemas.mp4	16.0 MB
[ FreeCourseWeb.com ] 61 - Dynamic data masking.mp4	10.9 MB
[ FreeCourseWeb.com ] 62 - Always On data encryption.mp4	14.5 MB
[ FreeCourseWeb.com ] 63 - Explore the role of system databases.mp4	4.3 MB
[ FreeCourseWeb.com ] 64 - Prevent excessive tempdb autogrowth.mp4	4.0 MB
[ FreeCourseWeb.com ] 65 - Review the SQL Server error log.mp4	3.5 MB
[ FreeCourseWeb.com ] 66 - Dynamic management views.mp4	6.3 MB
[ FreeCourseWeb.com ] 67 - Database Console Commands (DBCC).mp4	12.4 MB
[ FreeCourseWeb.com ] 68 - Next steps.mp4	1.7 MB
Total files 162