4.3 GB | 25min 53s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English
Files Included :
1 -Introduction.mp4 (19.09 MB)
2 -Understanding the Foundations of SQL.mp4 (27.39 MB)
3 -SELECT Statement.mp4 (31.04 MB)
4 -Overview of SQL Server.mp4 (9.28 MB)
5 -Windows - How to Setup SQL Server and SSMS on a Windows Computer.mp4 (52.15 MB)
6 -Windows - How to Setup the SAMPLEDB Database on Windows Computer.mp4 (66.44 MB)
7 -MacOS - How to set up SQL Server Database on a Mac Computer using Docker.mp4 (198.72 MB)
8 -Overview of the Course Challenges.mp4 (14.46 MB)
9 -SELECT Challenges.mp4 (8.63 MB)
10 -Solutions to the SELECT Challenges.mp4 (29.05 MB)
11 -SELECT DISTINCT Statement.mp4 (21.47 MB)
12 -SELECT DISTINCT Challenges.mp4 (5.63 MB)
13 -Solutions to the SELECT DISTINCT Challenges.mp4 (22.33 MB)
14 -Row Ordering - ORDER BY.mp4 (28.58 MB)
15 -Filtering Data with TOP.mp4 (21.63 MB)
16 -ORDER BY Challenges.mp4 (8.9 MB)
17 -Solutions to the ORDER BY Challenges.mp4 (48.67 MB)
18 -WHERE Clause - Three-valued Logic.mp4 (17.68 MB)
19 -Replacing Nulls in Queries.mp4 (45.55 MB)
20 -WHERE Clause - Comparison Operators.mp4 (13.79 MB)
21 -WHERE Clause Challenges.mp4 (8.96 MB)
22 -Solutions to the WHERE Clause Challenges.mp4 (35.78 MB)
23 -Introduction to Collations and Pattern Matching.mp4 (34.48 MB)
24 -Pattern Matching - Part 2.mp4 (21.03 MB)
25 -Introduction to Character Data Types.mp4 (18.68 MB)
26 -Pattern Matching Challenges.mp4 (3.52 MB)
27 -Solutions to the Pattern Matching Challenges.mp4 (20.25 MB)
28 -Introduction to Aggregate Functions.mp4 (22.08 MB)
29 -GROUP BY and Aggregate Functions.mp4 (23.63 MB)
30 -HAVING Clause.mp4 (18.47 MB)
31 -Logical Query Processing Order.mp4 (30.16 MB)
32 -GROUP BY Challenges.mp4 (9.93 MB)
33 -Solutions to the GROUP BY Challenges.mp4 (78.77 MB)
34 -AND operator.mp4 (9.62 MB)
35 -OR operator.mp4 (10.39 MB)
36 -Operator Precedence.mp4 (15.57 MB)
37 -IN Operator.mp4 (13.32 MB)
38 -Logical Operator Challenges.mp4 (6.52 MB)
39 -Solutions to the Logical Operator Challenges.mp4 (58.88 MB)
1 -Inner Joins.mp4 (28.51 MB)
2 -Outer Joins - LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4 (25.18 MB)
3 -FULL OUTER JOIN.mp4 (17.63 MB)
4 -Integrity Constraints.mp4 (60.95 MB)
5 -Many-to-many Relationships.mp4 (33.71 MB)
6 -Join Challenges.mp4 (7.81 MB)
7 -Solutions to the Join Challenges.mp4 (41.96 MB)
8 -Composite Joins - Joining on multiple columns.mp4 (39.6 MB)
9 -Joining more than two tables.mp4 (24.21 MB)
10 -Predicate placement - ON clause vs WHERE clause.mp4 (45.21 MB)
11 -Self-referencing Joins.mp4 (17.94 MB)
12 -Cross Joins.mp4 (8.55 MB)
13 -Advanced Join Challenges.mp4 (30.02 MB)
14 -Solutions to the Advanced Join Challenges.mp4 (152.45 MB)
1 -UNION and UNION ALL.mp4 (43.71 MB)
2 -INTERSECT.mp4 (12.51 MB)
3 -EXCEPT.mp4 (11.06 MB)
4 -Set Operator Precedence.mp4 (11.74 MB)
5 -SET Operator Challenges.mp4 (12.06 MB)
6 -Solutions to the Set Operator Challenges.mp4 (108.11 MB)
1 -Self-contained Subqueries.mp4 (20.78 MB)
2 -Correlated Subqueries.mp4 (29.6 MB)
3 -EXISTS.mp4 (21.33 MB)
4 -Introduction to Window Functions.mp4 (33.73 MB)
5 -Common Table Expressions.mp4 (35.71 MB)
6 -Avoiding the NOT IN trap.mp4 (48 MB)
7 -Subquery Challenges.mp4 (34.09 MB)
8 -Solutions to the Subquery Challenges.mp4 (102.47 MB)
1 -Concatenation in SQL Server.mp4 (22.6 MB)
2 -String Manipulation Functions.mp4 (34.55 MB)
3 -Date and Time Functions.mp4 (102.62 MB)
4 -Function Challenges.mp4 (26.1 MB)
5 -Solutions to the Function Challenges.mp4 (119.88 MB)
6 -CASE Expression.mp4 (39.01 MB)
7 -CASE Expression Challenges.mp4 (21.41 MB)
8 -Solutions to the CASE Expression Challenges.mp4 (101.75 MB)
1 -Overview of Data Types.mp4 (55.12 MB)
2 -Integer Data Types.mp4 (38.87 MB)
3 -DECIMAL Data Type.mp4 (10.98 MB)
4 -FLOAT Data Type.mp4 (57.89 MB)
5 -CREATE TABLE Statement.mp4 (78.1 MB)
6 -INSERT Statement.mp4 (18.3 MB)
7 -CREATE TABLE Challenges.mp4 (22.86 MB)
8 -Solutions to the CREATE TABLE Challenges.mp4 (63.34 MB)
9 -UNIQUEIDENTIFIER (GUID) Data Type.mp4 (41.06 MB)
10 -UPDATE Statement.mp4 (17.05 MB)
11 -DELETE Statement.mp4 (13.45 MB)
12 -TRUNCATE TABLE statement.mp4 (23.99 MB)
13 -DROP TABLE Statement.mp4 (44.73 MB)
14 -Transactions.mp4 (50.62 MB)
15 -Stored Procedures.mp4 (27.02 MB)
16 -Stored Procedures Demo.mp4 (229.94 MB)
17 -Stored Procedure Challenges.mp4 (68.03 MB)
18 -Solutions to the Stored Procedure Challenges.mp4 (126.76 MB)
19 -ALTER TABLE Statement and sp rename.mp4 (31.21 MB)
20 -ALTER TABLE Challenges.mp4 (6.13 MB)
21 -Solutions to the ALTER TABLE Challenges.mp4 (36.38 MB)
22 -UNIQUE Constraints.mp4 (63.4 MB)
23 -CHECK Constraints.mp4 (26.4 MB)
24 -Introduction to Indexes.mp4 (46.8 MB)
25 -Index Types and Indexing Guidelines.mp4 (88.87 MB)
26 -Index Types Part 2 - Composite vs Included Columns.mp4 (48 MB)
27 -Sargable Queries.mp4 (37.15 MB)
28 -Indexing and Sargable Query Challenges.mp4 (14.05 MB)
29 -Solutions to the Indexing and Sargable Query Challenges.mp4 (68.99 MB)
30 -CREATE VIEW Statement.mp4 (19.76 MB)
1 -Introduction to Data Normalization.mp4 (62.03 MB)
2 -Functional Dependencies.mp4 (23.46 MB)
3 -Functional Dependencies Exercise.mp4 (34.98 MB)
4 -Candidate Keys and Super Keys.mp4 (34.4 MB)
5 -First Normal Form.mp4 (47.65 MB)
6 -Restructuring Multi-valued and Multi-type fields.mp4 (21.71 MB)
7 -Second Normal Form.mp4 (17.13 MB)
8 -Third Normal Form.mp4 (33.15 MB)
9 -Boyce Codd Normal Form.mp4 (56 MB)
2 -Understanding the Foundations of SQL.mp4 (27.39 MB)
3 -SELECT Statement.mp4 (31.04 MB)
4 -Overview of SQL Server.mp4 (9.28 MB)
5 -Windows - How to Setup SQL Server and SSMS on a Windows Computer.mp4 (52.15 MB)
6 -Windows - How to Setup the SAMPLEDB Database on Windows Computer.mp4 (66.44 MB)
7 -MacOS - How to set up SQL Server Database on a Mac Computer using Docker.mp4 (198.72 MB)
8 -Overview of the Course Challenges.mp4 (14.46 MB)
9 -SELECT Challenges.mp4 (8.63 MB)
10 -Solutions to the SELECT Challenges.mp4 (29.05 MB)
11 -SELECT DISTINCT Statement.mp4 (21.47 MB)
12 -SELECT DISTINCT Challenges.mp4 (5.63 MB)
13 -Solutions to the SELECT DISTINCT Challenges.mp4 (22.33 MB)
14 -Row Ordering - ORDER BY.mp4 (28.58 MB)
15 -Filtering Data with TOP.mp4 (21.63 MB)
16 -ORDER BY Challenges.mp4 (8.9 MB)
17 -Solutions to the ORDER BY Challenges.mp4 (48.67 MB)
18 -WHERE Clause - Three-valued Logic.mp4 (17.68 MB)
19 -Replacing Nulls in Queries.mp4 (45.55 MB)
20 -WHERE Clause - Comparison Operators.mp4 (13.79 MB)
21 -WHERE Clause Challenges.mp4 (8.96 MB)
22 -Solutions to the WHERE Clause Challenges.mp4 (35.78 MB)
23 -Introduction to Collations and Pattern Matching.mp4 (34.48 MB)
24 -Pattern Matching - Part 2.mp4 (21.03 MB)
25 -Introduction to Character Data Types.mp4 (18.68 MB)
26 -Pattern Matching Challenges.mp4 (3.52 MB)
27 -Solutions to the Pattern Matching Challenges.mp4 (20.25 MB)
28 -Introduction to Aggregate Functions.mp4 (22.08 MB)
29 -GROUP BY and Aggregate Functions.mp4 (23.63 MB)
30 -HAVING Clause.mp4 (18.47 MB)
31 -Logical Query Processing Order.mp4 (30.16 MB)
32 -GROUP BY Challenges.mp4 (9.93 MB)
33 -Solutions to the GROUP BY Challenges.mp4 (78.77 MB)
34 -AND operator.mp4 (9.62 MB)
35 -OR operator.mp4 (10.39 MB)
36 -Operator Precedence.mp4 (15.57 MB)
37 -IN Operator.mp4 (13.32 MB)
38 -Logical Operator Challenges.mp4 (6.52 MB)
39 -Solutions to the Logical Operator Challenges.mp4 (58.88 MB)
1 -Inner Joins.mp4 (28.51 MB)
2 -Outer Joins - LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4 (25.18 MB)
3 -FULL OUTER JOIN.mp4 (17.63 MB)
4 -Integrity Constraints.mp4 (60.95 MB)
5 -Many-to-many Relationships.mp4 (33.71 MB)
6 -Join Challenges.mp4 (7.81 MB)
7 -Solutions to the Join Challenges.mp4 (41.96 MB)
8 -Composite Joins - Joining on multiple columns.mp4 (39.6 MB)
9 -Joining more than two tables.mp4 (24.21 MB)
10 -Predicate placement - ON clause vs WHERE clause.mp4 (45.21 MB)
11 -Self-referencing Joins.mp4 (17.94 MB)
12 -Cross Joins.mp4 (8.55 MB)
13 -Advanced Join Challenges.mp4 (30.02 MB)
14 -Solutions to the Advanced Join Challenges.mp4 (152.45 MB)
1 -UNION and UNION ALL.mp4 (43.71 MB)
2 -INTERSECT.mp4 (12.51 MB)
3 -EXCEPT.mp4 (11.06 MB)
4 -Set Operator Precedence.mp4 (11.74 MB)
5 -SET Operator Challenges.mp4 (12.06 MB)
6 -Solutions to the Set Operator Challenges.mp4 (108.11 MB)
1 -Self-contained Subqueries.mp4 (20.78 MB)
2 -Correlated Subqueries.mp4 (29.6 MB)
3 -EXISTS.mp4 (21.33 MB)
4 -Introduction to Window Functions.mp4 (33.73 MB)
5 -Common Table Expressions.mp4 (35.71 MB)
6 -Avoiding the NOT IN trap.mp4 (48 MB)
7 -Subquery Challenges.mp4 (34.09 MB)
8 -Solutions to the Subquery Challenges.mp4 (102.47 MB)
1 -Concatenation in SQL Server.mp4 (22.6 MB)
2 -String Manipulation Functions.mp4 (34.55 MB)
3 -Date and Time Functions.mp4 (102.62 MB)
4 -Function Challenges.mp4 (26.1 MB)
5 -Solutions to the Function Challenges.mp4 (119.88 MB)
6 -CASE Expression.mp4 (39.01 MB)
7 -CASE Expression Challenges.mp4 (21.41 MB)
8 -Solutions to the CASE Expression Challenges.mp4 (101.75 MB)
1 -Overview of Data Types.mp4 (55.12 MB)
2 -Integer Data Types.mp4 (38.87 MB)
3 -DECIMAL Data Type.mp4 (10.98 MB)
4 -FLOAT Data Type.mp4 (57.89 MB)
5 -CREATE TABLE Statement.mp4 (78.1 MB)
6 -INSERT Statement.mp4 (18.3 MB)
7 -CREATE TABLE Challenges.mp4 (22.86 MB)
8 -Solutions to the CREATE TABLE Challenges.mp4 (63.34 MB)
9 -UNIQUEIDENTIFIER (GUID) Data Type.mp4 (41.06 MB)
10 -UPDATE Statement.mp4 (17.05 MB)
11 -DELETE Statement.mp4 (13.45 MB)
12 -TRUNCATE TABLE statement.mp4 (23.99 MB)
13 -DROP TABLE Statement.mp4 (44.73 MB)
14 -Transactions.mp4 (50.62 MB)
15 -Stored Procedures.mp4 (27.02 MB)
16 -Stored Procedures Demo.mp4 (229.94 MB)
17 -Stored Procedure Challenges.mp4 (68.03 MB)
18 -Solutions to the Stored Procedure Challenges.mp4 (126.76 MB)
19 -ALTER TABLE Statement and sp rename.mp4 (31.21 MB)
20 -ALTER TABLE Challenges.mp4 (6.13 MB)
21 -Solutions to the ALTER TABLE Challenges.mp4 (36.38 MB)
22 -UNIQUE Constraints.mp4 (63.4 MB)
23 -CHECK Constraints.mp4 (26.4 MB)
24 -Introduction to Indexes.mp4 (46.8 MB)
25 -Index Types and Indexing Guidelines.mp4 (88.87 MB)
26 -Index Types Part 2 - Composite vs Included Columns.mp4 (48 MB)
27 -Sargable Queries.mp4 (37.15 MB)
28 -Indexing and Sargable Query Challenges.mp4 (14.05 MB)
29 -Solutions to the Indexing and Sargable Query Challenges.mp4 (68.99 MB)
30 -CREATE VIEW Statement.mp4 (19.76 MB)
1 -Introduction to Data Normalization.mp4 (62.03 MB)
2 -Functional Dependencies.mp4 (23.46 MB)
3 -Functional Dependencies Exercise.mp4 (34.98 MB)
4 -Candidate Keys and Super Keys.mp4 (34.4 MB)
5 -First Normal Form.mp4 (47.65 MB)
6 -Restructuring Multi-valued and Multi-type fields.mp4 (21.71 MB)
7 -Second Normal Form.mp4 (17.13 MB)
8 -Third Normal Form.mp4 (33.15 MB)
9 -Boyce Codd Normal Form.mp4 (56 MB)
Screenshot
RapidGator
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!
