Udemy SQL Server Learn T-SQL in 9 hours ITS-201 98-364

Files Included :

1 - Introduction.mp4 (55.64 MB)
MP4
3 - The Udemy Interface.mp4 (19.88 MB)
MP4
5 - Curriculum.mp4 (79.72 MB)
MP4
51 - 12a What are Primary keys and Creating Primary Keys.mp4 (65.34 MB)
MP4
52 - Primary keys shortcut.mp4 (26.8 MB)
MP4
53 - 12b Select appropriate fields for composite keys and IDENTITY.mp4 (63.81 MB)
MP4
54 - More about IDENTITY.mp4 (18.46 MB)
MP4
56 - Practice Activity Number 6 The Solution.mp4 (30.03 MB)
MP4
57 - 14a What are Foreign keys and creating Foreign Keys.mp4 (80.72 MB)
MP4
58 - 14c understand the relationship between foreign and primary keys.mp4 (132.03 MB)
MP4
59 - 14b Entityrelationship diagrams ERDs.mp4 (25.77 MB)
MP4
61 - Practice Activity Number 7 The Solution.mp4 (29.21 MB)
MP4
62 - What is DML and its role in databases.mp4 (11.72 MB)
MP4
63 - Understand how data is inserted into a database.mp4 (46.85 MB)
MP4
64 - 41b How to use INSERT statements VALUES.mp4 (73.42 MB)
MP4
65 - 41a How to use INSERT statements from tables and INSERT INTO.mp4 (18.19 MB)
MP4
67 - Practice Activity Number 9 The Solution.mp4 (15.22 MB)
MP4
68 - Understand how data is updated in a database.mp4 (19.21 MB)
MP4
69 - 42 How to write the updated data to the database using UPDATE.mp4 (26.25 MB)
MP4
70 - 42 update by using a table.mp4 (49.53 MB)
MP4
71 - 43 Delete data from single or multiple tables.mp4 (40.36 MB)
MP4
73 - Practice Activity Number 10 The Solution.mp4 (18.32 MB)
MP4
74 - 22b Understand how TSQL can be used to create database objects.mp4 (17.05 MB)
MP4
75 - 22b Understand when to use views.mp4 (23.25 MB)
MP4
76 - 22a How to create a view by using TSQL or a graphical designer.mp4 (17.51 MB)
MP4
77 - 22aii 22aiii Alter and drop views by using proper ANSI SQL syntax.mp4 (16.34 MB)
MP4
78 - Updating rows using views or Inserting or Deleting.mp4 (36 MB)
MP4
79 - Views WITH CHECK OPTION.mp4 (29.59 MB)
MP4
80 - View WITH SCHEMABINDING.mp4 (28.83 MB)
MP4
82 - Practice Activity Number 11 The Solution.mp4 (33.11 MB)
MP4
83 - 23a 23c Create stored procedures.mp4 (47.04 MB)
MP4
84 - 23a Getting an OUTPUT value from Stored Procedures.mp4 (32.29 MB)
MP4
85 - 23b Scalar Functions.mp4 (39.75 MB)
MP4
87 - Practice Activity Number 12 The Solution.mp4 (24.71 MB)
MP4
88 - 31g combine result sets by using UNION INTERSECT and EXCEPT.mp4 (55.77 MB)
MP4
89 - 24a Clustered and nonclustered indexes.mp4 (59.33 MB)
MP4
91 - Practice Activity Number 13 The Solution.mp4 (18.64 MB)
MP4
92 - Understand the need to secure a database.mp4 (23.32 MB)
MP4
93 - 16e User accounts and roles.mp4 (22.73 MB)
MP4
94 - 16b What objects canshould be secured.mp4 (31.14 MB)
MP4
95 - 16 GRANT WITH GRANT OPTION REVOKE and principle of least privilege.mp4 (46 MB)
MP4
96 - 16aiii Principle of least privilege.mp4 (13.38 MB)
MP4
101 - Practice Activity Number 14 The Solution.mp4 (22.51 MB)
MP4
97 - 16ai Importance of backups.mp4 (7.57 MB)
MP4
98 - 16ai Understand various backup types such as full and incremental.mp4 (57.37 MB)
MP4
99 - 16aii How to restore a database.mp4 (86.04 MB)
MP4
102 - Whats next.mp4 (44.36 MB)
MP4
103 - Congratulations.mp4 (36.47 MB)
MP4
7 - Downloading SQL Server Express 2022 back end.mp4 (57.71 MB)
MP4
9 - Opening and Exploring SSMS.mp4 (41.95 MB)
MP4
105 - Other constraints NOT NULL and DEFAULT.mp4 (23.72 MB)
MP4
106 - Other constraints UNIQUE and CHECK.mp4 (38.35 MB)
MP4
108 - Practice Activity Number 8 The Solution.mp4 (16.53 MB)
MP4
109 - AFTER Triggers.mp4 (60.08 MB)
MP4
110 - INSTEAD OF Triggers.mp4 (44.76 MB)
MP4
111 - Insert Snippets.mp4 (15.49 MB)
MP4
114 - Normal Forms 4 and 5.mp4 (38.63 MB)
MP4
115 - Bonus Lecture.mp4 (77.68 MB)
MP4
10 - 31i 31j The SELECT clause.mp4 (41.7 MB)
MP4
11 - The FROM clause one table and how to save and export queries.mp4 (64.46 MB)
MP4
13 - Practice Activity Number 1 The Solution.mp4 (11.32 MB)
MP4
14 - 11 Entities rowsrecords columnsfields NULL and NOT NULL.mp4 (33.5 MB)
MP4
15 - 32bg 32in The WHERE clause Part 1.mp4 (52.14 MB)
MP4
16 - 32bg 32io The WHERE clause Part 2 using a subquery.mp4 (80 MB)
MP4
17 - 32m 32n The WHERE clause Part 3 Text and dates.mp4 (123.06 MB)
MP4
18 - 31h 32h 33a 33cg The GROUP BY clause.mp4 (64.23 MB)
MP4
20 - Practice Activity Number 2 The Solution.mp4 (17.27 MB)
MP4
22 - 33b The HAVING clause.mp4 (25.09 MB)
MP4
23 - 32a The ORDER BY clause.mp4 (45.66 MB)
MP4
25 - Practice Activity Number 3 The Solution.mp4 (10.81 MB)
MP4
26 - 13 Choose data types Introduction.mp4 (21.47 MB)
MP4
27 - 13 Numeric Data Types including Boolean values.mp4 (41.89 MB)
MP4
28 - 13 Datetime Data Types.mp4 (33.72 MB)
MP4
29 - 13 Character Types.mp4 (41.01 MB)
MP4
30 - 13 Other Field Types.mp4 (12.15 MB)
MP4
31 - Examining existing tables fields.mp4 (27.18 MB)
MP4
32 - Creating Database and 21a how to create a table.mp4 (22.43 MB)
MP4
33 - 21ai 21b Designing the Employee table determining the right fields to use.mp4 (37.76 MB)
MP4
34 - 21aii 21aiii Alter and drop tables by using proper ANSI SQL syntax.mp4 (30.08 MB)
MP4
35 - Entering data using GUI and TSQL.mp4 (147.05 MB)
MP4
36 - Creating a second table the Transaction table.mp4 (70.95 MB)
MP4
37 - The need for relational database management systems RDBMS.mp4 (34.5 MB)
MP4
38 - How relations are established.mp4 (86.02 MB)
MP4
39 - 31a JOINing two tables using an INNER JOIN.mp4 (69.5 MB)
MP4
40 - 31b31e extract data by using joins other JOINs.mp4 (112.25 MB)
MP4
41 - Find missing data using IS NULL.mp4 (54.43 MB)
MP4
42 - 31f Self joins.mp4 (34.49 MB)
MP4
45 - Practice Activity Number 4 The Solution.mp4 (38.05 MB)
MP4
46 - 15a Understand the reasons for normalization.mp4 (31.84 MB)
MP4
47 - 15b the first three common levels of normalization.mp4 (41.17 MB)
MP4
48 - Adding altering and removing columns.mp4 (24.54 MB)
MP4
50 - Practice Activity Number 5 The Solution.mp4 (11.96 MB)
MP4