SQL for Newcomers The Full Mastery Course | F5CBB4C5395D708FE572D49640DB01062CFF195F

SQL for Newcomers The Full Mastery Course

Name	SQL for Newcomers - The Full Mastery Course	DOWNLOAD Copy Link
Total Size	3.6 GB
Total Files	374
Last Seen	2024-12-22 00:50
Hash	F5CBB4C5395D708FE572D49640DB01062CFF195F

/.../16. SQL Data Definition Language (DDL)/
1. SQL Data Types Revised.mp4	107.9 MB
9. Primary Keys.srt	15.9 KB
1. SQL Data Types Revised.srt	14.3 KB
3. Create Your First Table!.srt	9.9 KB
13. Foreign Keys.srt	9.0 KB
4. Insert Data to Your New Table.srt	8.5 KB
14. Use Foreign Keys with Joins - Books & Publishers.srt	8.1 KB
15. Foreign Keys - Properties.srt	8.1 KB
5. Change Column Data Type.srt	7.7 KB
20. Insert New Records Using Select Statement.srt	7.1 KB
10. NOT NULL Constraint.srt	5.2 KB
18. Create a New Table with Select Statement.srt	5.0 KB
23. Create & Use Schemas.srt	5.0 KB
11. UNIQUE Constraint.srt	4.7 KB
12. DEFAULT Constraint.srt	4.7 KB
7. Add a New Column to Table.srt	4.7 KB
2. Bookstore Data Set Let's Move It to Database.srt	4.4 KB
6. Rename Column.srt	4.0 KB
21. Views.srt	3.6 KB
19. A Trick to Create an Empty Table with Select Statement.srt	3.4 KB
22. Schemas.srt	1.6 KB
8. Constraints in SQL.srt	1.3 KB
17. DROP Table.srt	1.2 KB
16. Drop Column.srt	0.7 KB
9. Primary Keys.mp4	78.4 MB
13. Foreign Keys.mp4	40.2 MB
4. Insert Data to Your New Table.mp4	38.7 MB
14. Use Foreign Keys with Joins - Books & Publishers.mp4	31.0 MB
15. Foreign Keys - Properties.mp4	30.5 MB
3. Create Your First Table!.mp4	29.0 MB
5. Change Column Data Type.mp4	26.5 MB
20. Insert New Records Using Select Statement.mp4	26.4 MB
18. Create a New Table with Select Statement.mp4	26.1 MB
12. DEFAULT Constraint.mp4	24.1 MB
2. Bookstore Data Set Let's Move It to Database.mp4	23.4 MB
7. Add a New Column to Table.mp4	23.0 MB
10. NOT NULL Constraint.mp4	22.8 MB
11. UNIQUE Constraint.mp4	22.7 MB
23. Create & Use Schemas.mp4	21.2 MB
6. Rename Column.mp4	16.9 MB
21. Views.mp4	15.8 MB
22. Schemas.mp4	13.1 MB
19. A Trick to Create an Empty Table with Select Statement.mp4	9.9 MB
8. Constraints in SQL.mp4	7.6 MB
17. DROP Table.mp4	5.2 MB
16. Drop Column.mp4	4.1 MB
/
TutsNode.net.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../2. Setting Up Course Tools/
9.1 emp_dept.sql	78.6 KB
1. Download PostgreSQL.srt	2.0 KB
7.1 emp_dept.sql	68.4 KB
2. Install PostgreSQL.srt	2.4 KB
3. Download SQLectron.srt	1.6 KB
4. Install SQLectron.srt	0.4 KB
5. Connect to PostgreSQL - Credentials.srt	1.7 KB
6. Connect to PostgreSQL Using SQLectron.srt	1.7 KB
7. Import Course Data Using SQLectron.srt	2.5 KB
8. FOR WINDOWS 32-BIT USERS SQL Alternative - DBeaver.html	0.8 KB
9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data.srt	8.5 KB
9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data.mp4	91.4 MB
2. Install PostgreSQL.mp4	27.9 MB
7. Import Course Data Using SQLectron.mp4	24.8 MB
1. Download PostgreSQL.mp4	20.8 MB
6. Connect to PostgreSQL Using SQLectron.mp4	11.4 MB
3. Download SQLectron.mp4	11.1 MB
5. Connect to PostgreSQL - Credentials.mp4	6.7 MB
4. Install SQLectron.mp4	6.0 MB
/1. Introduction/
1. Introduction.srt	1.7 KB
2. Tools Used in This Course.srt	1.3 KB
1. Introduction.mp4	9.2 MB
2. Tools Used in This Course.mp4	4.1 MB
/.../10. Functions in SQL Single-Row Functions/
3. Character Functions - LPAD & RPAD.srt	15.4 KB
7. Number Functions - MOD & ROUND.srt	13.3 KB
2. Character Functions - CONCAT & LENGTH.srt	11.7 KB
5. Character Functions - REPLACE.srt	10.8 KB
6. Character Functions - SUBSTR.srt	9.8 KB
8. Number Functions - TRUNC.srt	9.0 KB
1. Character Functions - UPPER, LOWER & INITCAP.srt	8.5 KB
4. Character Functions - TRIM.srt	4.3 KB
3. Character Functions - LPAD & RPAD.mp4	65.7 MB
2. Character Functions - CONCAT & LENGTH.mp4	45.3 MB
5. Character Functions - REPLACE.mp4	41.1 MB
1. Character Functions - UPPER, LOWER & INITCAP.mp4	28.8 MB
7. Number Functions - MOD & ROUND.mp4	28.7 MB
6. Character Functions - SUBSTR.mp4	22.9 MB
8. Number Functions - TRUNC.mp4	21.5 MB
4. Character Functions - TRIM.mp4	12.5 MB
/.../15. Data Manipulation (DML)/
4.1 emp_dept.sql	68.4 KB
9.1 emp_dept.sql	68.4 KB
8. Solution Extract Employee's Email Address.srt	15.4 KB
2. Insert Without Specifying Column Names.srt	11.1 KB
1. INSERT a New Record to a Table.srt	9.5 KB
3. UPDATE a Record's Field Values.srt	8.5 KB
10. Insert Records with Nested Select Queries.srt	7.1 KB
9. DELETE a Table's Record.srt	7.0 KB
5. Update a Record Using Single-Row Functions.srt	5.2 KB
4. CAUTION! How an UPDATE Query Can Go Wrong.srt	5.1 KB
6. A Good Exercise Extract Employee's Email Address.srt	1.9 KB
7. Hints on How to Extract Employee's Email Address.html	1.2 KB
8. Solution Extract Employee's Email Address.mp4	68.7 MB
2. Insert Without Specifying Column Names.mp4	39.9 MB
1. INSERT a New Record to a Table.mp4	35.9 MB
3. UPDATE a Record's Field Values.mp4	33.0 MB
4. CAUTION! How an UPDATE Query Can Go Wrong.mp4	33.0 MB
10. Insert Records with Nested Select Queries.mp4	25.9 MB
9. DELETE a Table's Record.mp4	24.6 MB
5. Update a Record Using Single-Row Functions.mp4	16.2 MB
6. A Good Exercise Extract Employee's Email Address.mp4	8.2 MB
/.../7. Tidy Up Your Results Sorting, Alias Names, Limit Records/
4. Order Records by Multiple Columns.srt	13.2 KB
6. LIMIT Record Count Fetched by Your Query.srt	9.0 KB
2. A Report for Payroll.srt	7.4 KB
3. Order Records by Column.srt	6.3 KB
5. How Alias Names Cannot Be Used with WHERE.srt	2.1 KB
1. Give Your Report Fields A Cool Name.srt	4.4 KB
4. Order Records by Multiple Columns.mp4	107.2 MB
6. LIMIT Record Count Fetched by Your Query.mp4	59.0 MB
3. Order Records by Column.mp4	58.0 MB
2. A Report for Payroll.mp4	47.1 MB
1. Give Your Report Fields A Cool Name.mp4	22.3 MB
5. How Alias Names Cannot Be Used with WHERE.mp4	11.7 MB
/.../12. Casting & Data Conversion/
3. Cast Number to Character.srt	12.6 KB
6. Cast Character to Date & Timestamp.srt	11.9 KB
1. Auto Data Conversion in SQL.srt	11.7 KB
2. Cast Date to Character.srt	11.6 KB
5. Cast Character to Number.srt	10.0 KB
4. Cast Timestamp to Character.srt	8.5 KB
1. Auto Data Conversion in SQL.mp4	48.7 MB
2. Cast Date to Character.mp4	38.6 MB
3. Cast Number to Character.mp4	30.6 MB
6. Cast Character to Date & Timestamp.mp4	25.2 MB
5. Cast Character to Number.mp4	25.0 MB
4. Cast Timestamp to Character.mp4	23.7 MB
/.../14. Joins in SQL/
3. Cartesian Join.srt	11.7 KB
2. Entity Relationship Diagram (ERD).srt	10.8 KB
8. Outer Join - Right, Left & Full.srt	10.5 KB
5. Why I Don't Recommend Cartesian Joins.srt	9.3 KB
4. Table Aliases with Joins.srt	8.4 KB
6. Inner Join.srt	7.0 KB
7. In-Depth Look into Join Types in SQL.srt	3.4 KB
1. Employees & Departments Tables Revised.srt	3.4 KB
8.1 employees_fl.sql	0.1 KB
8. Outer Join - Right, Left & Full.mp4	58.4 MB
3. Cartesian Join.mp4	46.7 MB
5. Why I Don't Recommend Cartesian Joins.mp4	42.6 MB
4. Table Aliases with Joins.mp4	37.1 MB
6. Inner Join.mp4	35.8 MB
2. Entity Relationship Diagram (ERD).mp4	23.3 MB
1. Employees & Departments Tables Revised.mp4	19.8 MB
7. In-Depth Look into Join Types in SQL.mp4	11.6 MB
/.../3. Browsing & Filtering Data/
2. So.. What is a Database.srt	1.5 KB
3. SQL Data Types.srt	2.3 KB
4. Finally Some Fun! Extracting Data Based on Requirements.srt	1.1 KB
6. Filter Data by Range Using BETWEEN.srt	2.8 KB
13. More Filtering by Strings 2.srt	10.3 KB
10. Another Query Filtering by Date.srt	1.0 KB
5. Filtering Data using WHERE Keyword.srt	9.2 KB
14. More Filtering by Strings 3.srt	1.4 KB
1. Check Imported Data.srt	6.2 KB
8. Filter Data by Date.srt	5.9 KB
12. More Filtering by Strings.srt	5.4 KB
11. Filter Data by Strings (Names, Addresses, ...).srt	4.2 KB
15. How to Ignore Caps when Filtering by String.srt	4.1 KB
7. Filter Data by Set of Values Using IN.srt	3.9 KB
9. More Filtering by Date.srt	3.3 KB
5. Filtering Data using WHERE Keyword.mp4	67.3 MB
13. More Filtering by Strings 2.mp4	54.3 MB
8. Filter Data by Date.mp4	43.1 MB
1. Check Imported Data.mp4	36.4 MB
12. More Filtering by Strings.mp4	30.7 MB
11. Filter Data by Strings (Names, Addresses, ...).mp4	30.6 MB
9. More Filtering by Date.mp4	29.6 MB
7. Filter Data by Set of Values Using IN.mp4	20.2 MB
15. How to Ignore Caps when Filtering by String.mp4	18.7 MB
6. Filter Data by Range Using BETWEEN.mp4	17.8 MB
14. More Filtering by Strings 3.mp4	7.9 MB
10. Another Query Filtering by Date.mp4	7.9 MB
2. So.. What is a Database.mp4	7.8 MB
4. Finally Some Fun! Extracting Data Based on Requirements.mp4	4.8 MB
3. SQL Data Types.mp4	4.7 MB
/.../4. Filter Data with AND, OR, NOT Operators/
2. OR Operator.srt	11.4 KB
1. AND Operator.srt	9.6 KB
3. NOT Operator.srt	9.1 KB
4. AND, OR & NOT Operators Which Has The Highest Priority.srt	6.7 KB
2. OR Operator.mp4	68.3 MB
1. AND Operator.mp4	61.7 MB
3. NOT Operator.mp4	43.4 MB
4. AND, OR & NOT Operators Which Has The Highest Priority.mp4	35.8 MB
/.../8. NULL, DISTINCT & CASE Statements/
5. Your Knowledge So Far Under A Great Test.srt	10.8 KB
4. Build More Sophisticated Queries with CASE Statements.srt	10.3 KB
2. Using DISTINCT Keyword with Multiple Columns.srt	6.5 KB
3. What is a NULL Value Anyway.srt	5.8 KB
1. Fetch A Field's Unique Values Using DISTINCT.srt	2.6 KB
5. Your Knowledge So Far Under A Great Test.mp4	66.8 MB
4. Build More Sophisticated Queries with CASE Statements.mp4	48.5 MB
2. Using DISTINCT Keyword with Multiple Columns.mp4	34.2 MB
3. What is a NULL Value Anyway.mp4	27.0 MB
1. Fetch A Field's Unique Values Using DISTINCT.mp4	13.2 MB
/.../9. Functions in SQL Multiple-Row Functions/
9. Now For Some Tough Workout.srt	9.7 KB
10. Filter By Aggregate Functions with HAVING Clause.srt	9.1 KB
4. COUNT Function.srt	7.4 KB
7. GROUP BY Clause Use Functions with Dimensions.srt	6.0 KB
8. GROUP BY More Than One Dimension.srt	5.0 KB
2. SUM Function.srt	4.6 KB
1. Let Me Introduce You to Functions.srt	4.6 KB
3. AVG (Average) Function.srt	4.2 KB
6. How To Count Your Field's Unique Values.srt	3.8 KB
5. MIN & MAX Functions.srt	3.7 KB
10. Filter By Aggregate Functions with HAVING Clause.mp4	53.9 MB
9. Now For Some Tough Workout.mp4	50.3 MB
8. GROUP BY More Than One Dimension.mp4	29.9 MB
4. COUNT Function.mp4	23.2 MB
7. GROUP BY Clause Use Functions with Dimensions.mp4	22.4 MB
2. SUM Function.mp4	17.6 MB
3. AVG (Average) Function.mp4	12.0 MB
6. How To Count Your Field's Unique Values.mp4	11.4 MB
5. MIN & MAX Functions.mp4	11.3 MB
1. Let Me Introduce You to Functions.mp4	10.8 MB
/.../11. Nested Queries/
1. Selectception A Select Query Inside Another Select Query!.srt	7.6 KB
1. Selectception A Select Query Inside Another Select Query!.mp4	25.7 MB
/5. Math Operations/
4. Filter Data with Math Equations.srt	2.6 KB
3. It's Payday! Calculate The Net Salary for Employees.srt	6.9 KB
1. Basic Math Operations.srt	5.5 KB
2. Modulo Operator.srt	4.1 KB
3. It's Payday! Calculate The Net Salary for Employees.mp4	29.6 MB
4. Filter Data with Math Equations.mp4	14.9 MB
1. Basic Math Operations.mp4	14.2 MB
2. Modulo Operator.mp4	12.7 MB
/6. String Concatenation/
2. Concatenate Strings with Numbers.srt	1.9 KB
1. Concatenate Strings with '' Operator.srt	6.2 KB
1. Concatenate Strings with '' Operator.mp4	19.8 MB
2. Concatenate Strings with Numbers.mp4	6.3 MB
/.../17. Access Control/
6. User Groups.srt	5.7 KB
2. Create User.srt	4.0 KB
4. Grant Insert & Update to User.srt	3.5 KB
3. Grant SELECT to User.srt	2.9 KB
5. Revoke Privilege from User.srt	2.1 KB
1. Introduction to Access Control.srt	1.5 KB
6. User Groups.mp4	28.7 MB
4. Grant Insert & Update to User.mp4	24.2 MB
3. Grant SELECT to User.mp4	17.1 MB
2. Create User.mp4	13.3 MB
5. Revoke Privilege from User.mp4	13.1 MB
1. Introduction to Access Control.mp4	4.0 MB
/.../13. Combination Relationships/
1. UNION.srt	3.9 KB
2. UNION ALL.srt	2.3 KB
3. Important Note about Combining Queries.srt	2.2 KB
5. EXCEPT.srt	1.6 KB
4. INTERSECT.srt	1.3 KB
1. UNION.mp4	19.4 MB
5. EXCEPT.mp4	13.7 MB
2. UNION ALL.mp4	13.3 MB
3. Important Note about Combining Queries.mp4	11.7 MB
4. INTERSECT.mp4	5.5 MB
/.pad/
0	127.9 KB
1	818.6 KB
2	895.4 KB
3	281.9 KB
4	521.5 KB
5	955.9 KB
6	841.0 KB
7	339.2 KB
8	346.7 KB
9	135.7 KB
10	776.8 KB
11	338.4 KB
12	766.6 KB
13	208.7 KB
14	673.3 KB
15	11.5 KB
16	620.4 KB
17	813.3 KB
18	89.1 KB
19	532.0 KB
20	811.8 KB
21	590.2 KB
22	902.7 KB
23	429.5 KB
24	799.9 KB
25	717.0 KB
26	988.5 KB
27	61.6 KB
28	232.1 KB
29	631.7 KB
30	320.5 KB
31	793.1 KB
32	856.2 KB
33	939.8 KB
34	436.6 KB
35	581.3 KB
36	600.3 KB
37	494.0 KB
38	737.8 KB
39	890.8 KB
40	895.0 KB
41	930.7 KB
42	551.7 KB
43	825.0 KB
44	835.1 KB
45	393.7 KB
46	571.1 KB
47	635.9 KB
48	674.6 KB
49	383.5 KB
50	251.4 KB
51	722.4 KB
52	858.0 KB
53	65.5 KB
54	330.7 KB
55	518.1 KB
56	10.0 KB
57	177.5 KB
58	333.9 KB
59	614.0 KB
60	1.0 MB
61	1.0 MB
62	458.5 KB
63	692.1 KB
64	783.5 KB
65	896.5 KB
66	113.1 KB
67	127.4 KB
68	300.7 KB
69	321.0 KB
70	667.7 KB
71	802.0 KB
72	514.3 KB
73	847.6 KB
74	207.5 KB
75	741.2 KB
76	144.5 KB
77	162.2 KB
78	492.9 KB
79	144.5 KB
80	4.4 KB
81	183.0 KB
82	762.5 KB
83	876.3 KB
84	618.7 KB
85	954.4 KB
86	839.5 KB
87	489.4 KB
88	950.7 KB
89	301.0 KB
90	351.6 KB
91	430.8 KB
92	533.3 KB
93	541.3 KB
94	926.6 KB
95	55.6 KB
96	601.3 KB
97	864.9 KB
98	866.8 KB
99	958.6 KB
100	97.4 KB
101	182.8 KB
102	232.4 KB
103	417.0 KB
104	743.2 KB
105	590.2 KB
106	222.2 KB
107	196.1 KB
108	446.7 KB
109	486.8 KB
110	553.9 KB
111	803.5 KB
112	602.5 KB
113	1.0 MB
114	257.4 KB
115	815.3 KB
116	75.4 KB
117	422.8 KB
118	588.7 KB
119	89.0 KB
120	89.6 KB
Total files 374