Download Free Download : Udemy - SQL Masterclass From Zero to Hero with SQL Server (2024)
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:3.06 GB
Files Included :
1 1 What is SQL.mp4 (11.78 MB)
MP4
2 2 DBMS, Databases, and Tables.mp4 (10.71 MB)
MP4
3 3 Install MS SQL Server and SSMS.mp4 (45.88 MB)
MP4
4 4 Use SSMS to Connect to SQL Servers.mp4 (42.56 MB)
MP4
5 5 How to execute SQL statements.mp4 (35.45 MB)
MP4
1 6 Create & Delete Database.mp4 (34.21 MB)
MP4
10 15 Modify existing tables.mp4 (43.25 MB)
MP4
11 16 Assignment 1 Questions.mp4 (7.28 MB)
MP4
12 17 Assignment 1 Answers.mp4 (77.7 MB)
MP4
13 18 Table Relationships 1 to Many.mp4 (46.31 MB)
MP4
14 19 FOREIGN KEY contraint.mp4 (28.67 MB)
MP4
15 20 Table Relationships Many to Many.mp4 (70.1 MB)
MP4
16 21 Assignment 2 Questions.mp4 (12.46 MB)
MP4
17 22 Assignment 2 Answers.mp4 (99.29 MB)
MP4
2 7 Create Table & USE database.mp4 (53.68 MB)
MP4
3 8 Data Types Char, Varchar, NChar, NVarchar.mp4 (58.34 MB)
MP4
4 9 Data Types float, real & decimal.mp4 (59.47 MB)
MP4
5 10 Data Types date, time, datetime.mp4 (36.23 MB)
MP4
6 11 Column Constraints NOT NULL.mp4 (21.91 MB)
MP4
7 12 Column Constraints UNIQUE.mp4 (12.82 MB)
MP4
8 13 Column Constraints CHECK.mp4 (15.51 MB)
MP4
9 14 Column Constraints PRIMARY KEY & IDENTITY.mp4 (37.16 MB)
MP4
1 23 Insert data with the INSERT statement.mp4 (53.7 MB)
MP4
2 24 Update data with the UPDATE statement.mp4 (46.36 MB)
MP4
3 25 Delete data with the DELETE statement.mp4 (12.1 MB)
MP4
4 26 TRUNCATE TABLE statement.mp4 (29.66 MB)
MP4
5 27 Assignment 3 Questions.mp4 (5.59 MB)
MP4
6 28 Assignment 3 Answers.mp4 (27.77 MB)
MP4
1 29 SELECT statement column manipulations.mp4 (47.82 MB)
MP4
10 38 Assignment 4 Answer.mp4 (46.33 MB)
MP4
11 39 LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN.mp4 (73.61 MB)
MP4
12 40 Built-in functions CHARINDEX, SUBSTRING.mp4 (44.35 MB)
MP4
13 41 Built-in function REPLACE.mp4 (20.66 MB)
MP4
14 42 Built-in function CAST.mp4 (18.68 MB)
MP4
15 43 Assignment 5 Question.mp4 (30.24 MB)
MP4
16 44 Assignment 5 Answer.mp4 (66.03 MB)
MP4
17 45 Built-in functions for Dates.mp4 (30.62 MB)
MP4
18 46 Assignment 6 Question.mp4 (5.65 MB)
MP4
19 47 Assignment 6 Answer.mp4 (31.59 MB)
MP4
2 30 SELECT statement Mathematical Relationships.mp4 (25.15 MB)
MP4
20 48 Built-in functions ISNULL.mp4 (36.64 MB)
MP4
21 49 Built-in functions Aggregation functions.mp4 (31.18 MB)
MP4
22 50 GROUP BY.mp4 (69.79 MB)
MP4
23 51 HAVING.mp4 (33.91 MB)
MP4
24 52 Assignment 7 Questions.mp4 (9.15 MB)
MP4
25 53 Assignment 7 Answers.mp4 (50.74 MB)
MP4
26 54 UNION UNION ALL.mp4 (23.31 MB)
MP4
27 55 Assignment 8 UNION.mp4 (5.34 MB)
MP4
28 56 Assignment 8 Answers.mp4 (44.92 MB)
MP4
29 57 TOP.mp4 (17.37 MB)
MP4
3 31 SELECT statement And or OR operators.mp4 (25.17 MB)
MP4
30 58 VIEW.mp4 (31.77 MB)
MP4
4 32 SELECT statement Wildcards.mp4 (21.56 MB)
MP4
5 33 SELECT statements IS operator.mp4 (11.65 MB)
MP4
6 34 SELECT statement DISTINCT.mp4 (38.47 MB)
MP4
7 35 Ordering Data.mp4 (26.17 MB)
MP4
8 36 INNER JOIN.mp4 (76.8 MB)
MP4
9 37 Assignment 4 Question.mp4 (5.03 MB)
MP4
1 59 Variables.mp4 (47.05 MB)
MP4
10 68 Assignment 11 Answers & Tips for writing complicated queries.mp4 (56.63 MB)
MP4
11 69 WHILE loop.mp4 (67.81 MB)
MP4
2 60 Assignment 9 Variables.mp4 (3 MB)
MP4
3 61 Assignment 9 Answer.mp4 (26.34 MB)
MP4
4 62 IF ELSE.mp4 (34.04 MB)
MP4
5 63 Assignment 10 IF ELSE.mp4 (18.59 MB)
MP4
6 64 Assignment 10 Answer.mp4 (38.88 MB)
MP4
7 65 EXISTS.mp4 (40.08 MB)
MP4
8 66 CASE expression.mp4 (60.23 MB)
MP4
9 67 Assignment 11 Products Analysis with CASE expression.mp4 (10.05 MB)
MP4
1 70 Temporary Tables.mp4 (118.37 MB)
MP4
10 79 Assignment 13 Answer.mp4 (81.36 MB)
MP4
11 80 Dynamic SQL.mp4 (58.22 MB)
MP4
12 81 UPDATE with JOINS.mp4 (27.06 MB)
MP4
13 82 Subqueries.mp4 (75.53 MB)
MP4
14 83 Derived Tables.mp4 (45.71 MB)
MP4
2 71 Assignment 12 Temporary Tables.mp4 (13.13 MB)
MP4
3 72 Assignment 12 Answer.mp4 (50.62 MB)
MP4
4 73 Table Variables.mp4 (24.51 MB)
MP4
5 74 Temp Tables vs Table Variables.mp4 (13.75 MB)
MP4
6 75 Stored Procedure #1.mp4 (85.94 MB)
MP4
7 76 Stored Procedure #2.mp4 (27.24 MB)
MP4
8 77 User Defined Functions.mp4 (63.9 MB)
MP4
9 78 Assignment 13 Stored Procedures & Functions.mp4 (5.71 MB)
MP4
MP4
2 2 DBMS, Databases, and Tables.mp4 (10.71 MB)
MP4
3 3 Install MS SQL Server and SSMS.mp4 (45.88 MB)
MP4
4 4 Use SSMS to Connect to SQL Servers.mp4 (42.56 MB)
MP4
5 5 How to execute SQL statements.mp4 (35.45 MB)
MP4
1 6 Create & Delete Database.mp4 (34.21 MB)
MP4
10 15 Modify existing tables.mp4 (43.25 MB)
MP4
11 16 Assignment 1 Questions.mp4 (7.28 MB)
MP4
12 17 Assignment 1 Answers.mp4 (77.7 MB)
MP4
13 18 Table Relationships 1 to Many.mp4 (46.31 MB)
MP4
14 19 FOREIGN KEY contraint.mp4 (28.67 MB)
MP4
15 20 Table Relationships Many to Many.mp4 (70.1 MB)
MP4
16 21 Assignment 2 Questions.mp4 (12.46 MB)
MP4
17 22 Assignment 2 Answers.mp4 (99.29 MB)
MP4
2 7 Create Table & USE database.mp4 (53.68 MB)
MP4
3 8 Data Types Char, Varchar, NChar, NVarchar.mp4 (58.34 MB)
MP4
4 9 Data Types float, real & decimal.mp4 (59.47 MB)
MP4
5 10 Data Types date, time, datetime.mp4 (36.23 MB)
MP4
6 11 Column Constraints NOT NULL.mp4 (21.91 MB)
MP4
7 12 Column Constraints UNIQUE.mp4 (12.82 MB)
MP4
8 13 Column Constraints CHECK.mp4 (15.51 MB)
MP4
9 14 Column Constraints PRIMARY KEY & IDENTITY.mp4 (37.16 MB)
MP4
1 23 Insert data with the INSERT statement.mp4 (53.7 MB)
MP4
2 24 Update data with the UPDATE statement.mp4 (46.36 MB)
MP4
3 25 Delete data with the DELETE statement.mp4 (12.1 MB)
MP4
4 26 TRUNCATE TABLE statement.mp4 (29.66 MB)
MP4
5 27 Assignment 3 Questions.mp4 (5.59 MB)
MP4
6 28 Assignment 3 Answers.mp4 (27.77 MB)
MP4
1 29 SELECT statement column manipulations.mp4 (47.82 MB)
MP4
10 38 Assignment 4 Answer.mp4 (46.33 MB)
MP4
11 39 LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN.mp4 (73.61 MB)
MP4
12 40 Built-in functions CHARINDEX, SUBSTRING.mp4 (44.35 MB)
MP4
13 41 Built-in function REPLACE.mp4 (20.66 MB)
MP4
14 42 Built-in function CAST.mp4 (18.68 MB)
MP4
15 43 Assignment 5 Question.mp4 (30.24 MB)
MP4
16 44 Assignment 5 Answer.mp4 (66.03 MB)
MP4
17 45 Built-in functions for Dates.mp4 (30.62 MB)
MP4
18 46 Assignment 6 Question.mp4 (5.65 MB)
MP4
19 47 Assignment 6 Answer.mp4 (31.59 MB)
MP4
2 30 SELECT statement Mathematical Relationships.mp4 (25.15 MB)
MP4
20 48 Built-in functions ISNULL.mp4 (36.64 MB)
MP4
21 49 Built-in functions Aggregation functions.mp4 (31.18 MB)
MP4
22 50 GROUP BY.mp4 (69.79 MB)
MP4
23 51 HAVING.mp4 (33.91 MB)
MP4
24 52 Assignment 7 Questions.mp4 (9.15 MB)
MP4
25 53 Assignment 7 Answers.mp4 (50.74 MB)
MP4
26 54 UNION UNION ALL.mp4 (23.31 MB)
MP4
27 55 Assignment 8 UNION.mp4 (5.34 MB)
MP4
28 56 Assignment 8 Answers.mp4 (44.92 MB)
MP4
29 57 TOP.mp4 (17.37 MB)
MP4
3 31 SELECT statement And or OR operators.mp4 (25.17 MB)
MP4
30 58 VIEW.mp4 (31.77 MB)
MP4
4 32 SELECT statement Wildcards.mp4 (21.56 MB)
MP4
5 33 SELECT statements IS operator.mp4 (11.65 MB)
MP4
6 34 SELECT statement DISTINCT.mp4 (38.47 MB)
MP4
7 35 Ordering Data.mp4 (26.17 MB)
MP4
8 36 INNER JOIN.mp4 (76.8 MB)
MP4
9 37 Assignment 4 Question.mp4 (5.03 MB)
MP4
1 59 Variables.mp4 (47.05 MB)
MP4
10 68 Assignment 11 Answers & Tips for writing complicated queries.mp4 (56.63 MB)
MP4
11 69 WHILE loop.mp4 (67.81 MB)
MP4
2 60 Assignment 9 Variables.mp4 (3 MB)
MP4
3 61 Assignment 9 Answer.mp4 (26.34 MB)
MP4
4 62 IF ELSE.mp4 (34.04 MB)
MP4
5 63 Assignment 10 IF ELSE.mp4 (18.59 MB)
MP4
6 64 Assignment 10 Answer.mp4 (38.88 MB)
MP4
7 65 EXISTS.mp4 (40.08 MB)
MP4
8 66 CASE expression.mp4 (60.23 MB)
MP4
9 67 Assignment 11 Products Analysis with CASE expression.mp4 (10.05 MB)
MP4
1 70 Temporary Tables.mp4 (118.37 MB)
MP4
10 79 Assignment 13 Answer.mp4 (81.36 MB)
MP4
11 80 Dynamic SQL.mp4 (58.22 MB)
MP4
12 81 UPDATE with JOINS.mp4 (27.06 MB)
MP4
13 82 Subqueries.mp4 (75.53 MB)
MP4
14 83 Derived Tables.mp4 (45.71 MB)
MP4
2 71 Assignment 12 Temporary Tables.mp4 (13.13 MB)
MP4
3 72 Assignment 12 Answer.mp4 (50.62 MB)
MP4
4 73 Table Variables.mp4 (24.51 MB)
MP4
5 74 Temp Tables vs Table Variables.mp4 (13.75 MB)
MP4
6 75 Stored Procedure #1.mp4 (85.94 MB)
MP4
7 76 Stored Procedure #2.mp4 (27.24 MB)
MP4
8 77 User Defined Functions.mp4 (63.9 MB)
MP4
9 78 Assignment 13 Stored Procedures & Functions.mp4 (5.71 MB)
MP4
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!