DevCourseWeb com Udemy The Complete Sql And Mysql Course From Beginner To Expert

DevCourseWeb com Udemy The Complete Sql And Mysql Course From Beginner To Expert

Name	[ DevCourseWeb.com ] Udemy - The Complete Sql And Mysql Course - From Beginner To Expert	DOWNLOAD Copy Link
Total Size	1.7 GB
Total Files	261
Last Seen	2024-07-22 00:06
Hash	0CBEB24A1A467BEF079DED0FEB46692CA73DC360

/
Get Bonus Downloads Here.url	0.2 KB
/1 - Introduction/
1 - Introduction English.vtt	4.0 KB
1 - Introduction.mp4	13.0 MB
/.../10 - Advanced SQL Transactions/
100 - Transaction example English.vtt	6.1 KB
100 - Transaction example SAVEPOINT.mp4	11.8 MB
101 - CODE savepoint.html	0.3 KB
102 - Chapter summary & source code.html	0.1 KB
102 - transactions.pdf	336.5 KB
8 - Transactions Quiz.html	0.0 KB
93 - Transactions introduction English.vtt	13.0 KB
93 - Transactions introduction locking.mp4	47.7 MB
94 - Transactions introduction English.vtt	5.4 KB
94 - Transactions introduction transactions.mp4	19.7 MB
95 - What are the ACID principles English.vtt	4.6 KB
95 - What are the ACID principles.mp4	15.3 MB
96 - Transaction example COMMIT.mp4	9.3 MB
96 - Transaction example English.vtt	5.1 KB
97 - CODE commit.html	0.2 KB
98 - Transaction example English.vtt	3.0 KB
98 - Transaction example ROLLBACK.mp4	5.6 MB
99 - CODE rollback.html	0.2 KB
/.../11 - Advanced SQL Views/
103 - What are views English.vtt	5.8 KB
103 - What are views.mp4	18.4 MB
104 - Views example English.vtt	1.9 KB
104 - Views example initialize database.mp4	3.1 MB
105 - Views example English.vtt	3.7 KB
105 - Views example create views.mp4	8.0 MB
106 - CODE creating views.html	0.1 KB
107 - Views example English.vtt	3.2 KB
107 - Views example update views.mp4	6.2 MB
108 - Views example English.vtt	1.1 KB
108 - Views example dropping views.mp4	1.9 MB
109 - CODE update and drop views.html	0.3 KB
110 - Exercise.html	0.4 KB
111 - Solution.html	0.2 KB
112 - Chapter summary & source code.html	0.1 KB
112 - views.pdf	332.6 KB
9 - Views Quiz.html	0.0 KB
/.../12 - Advanced SQL Indexes And Constraints/
10 - Indexes Quiz.html	0.0 KB
113 - What are indexes English.vtt	15.5 KB
113 - What are indexes.mp4	51.5 MB
114 - Indexes example English.vtt	5.3 KB
114 - Indexes example.mp4	9.8 MB
115 - Constraints introduction English.vtt	3.0 KB
115 - Constraints introduction.mp4	7.0 MB
116 - Primary keys English.vtt	3.4 KB
116 - Primary keys.mp4	6.2 MB
117 - Unique constraints English.vtt	3.1 KB
117 - Unique constraints.mp4	5.8 MB
118 - Check constraints English.vtt	7.5 KB
118 - Check constraints.mp4	29.4 MB
119 - What is bitmap indexing English.vtt	14.1 KB
119 - What is bitmap indexing.mp4	38.9 MB
/.../13 - Data Structures Behind Databases/
11 - Database Data Structures Quiz.html	0.0 KB
120 - External memory and paging English.vtt	9.6 KB
120 - External memory and paging.mp4	36.7 MB
121 - B tree data structures English.vtt	10.1 KB
121 - B tree data structures.mp4	29.3 MB
122 - Using B trees English.vtt	7.4 KB
122 - Using B trees.mp4	19.1 MB
/.../14 - Stored Procedures/
12 - Stored Procedures Quiz.html	0.0 KB
123 - What are stored procedures English.vtt	7.1 KB
123 - What are stored procedures.mp4	27.3 MB
124 - Creating our first stored procedure English.vtt	6.5 KB
124 - Creating our first stored procedure.mp4	29.6 MB
125 - CODE first stored procedure.html	0.2 KB
126 - Listing and removing stored procedures English.vtt	3.7 KB
126 - Listing and removing stored procedures.mp4	22.4 MB
127 - CODE listing and removing stored procedures.html	0.2 KB
128 - Variables English.vtt	5.5 KB
128 - Variables.mp4	18.9 MB
129 - Exercise.html	0.3 KB
130 - Solution.html	0.3 KB
131 - Session variables English.vtt	3.6 KB
131 - Session variables.mp4	12.0 MB
132 - Parameters English.vtt	8.2 KB
132 - Parameters.mp4	32.5 MB
133 - CODE parameters.html	0.3 KB
134 - Exercise.html	0.4 KB
135 - Solution.html	0.3 KB
136 - Conditional statements English.vtt	8.9 KB
136 - Conditional statements.mp4	48.7 MB
137 - CODE conditional statements.html	0.4 KB
138 - Loops English.vtt	9.5 KB
138 - Loops.mp4	37.7 MB
139 - ITERATE English.vtt	2.9 KB
139 - ITERATE.mp4	12.1 MB
140 - WHILE English.vtt	4.8 KB
140 - WHILE.mp4	18.3 MB
141 - CODE loops.html	0.3 KB
142 - Returning multiple values English.vtt	4.5 KB
142 - Returning multiple values.mp4	22.6 MB
143 - CODE returning multiple values.html	0.4 KB
/.../15 - Course Materials DOWNLOADS/
144 - Course materials.html	0.1 KB
sql_database.pptx	712.6 KB
/.../15 - Course Materials DOWNLOADS/sql/
country_city.txt	653.7 KB
students_university.txt	1.6 KB
/2 - Environment/
2 - Installing SQL and MySQL on Windows.html	1.1 KB
3 - Installing SQL and MySQL on Mac.html	1.1 KB
/3 - Databases Theory/
1 - Databases Theory Quiz.html	0.0 KB
4 - What are databases and database management systems DBMS English.vtt	6.8 KB
4 - What are databases and database management systems DBMS.mp4	20.8 MB
5 - The relational model English.vtt	5.9 KB
5 - The relational model.mp4	15.4 MB
6 - Data structures behind database servers English.vtt	9.8 KB
6 - Data structures behind database servers.mp4	33.0 MB
7 - Procedural and non English.vtt	4.5 KB
7 - Procedural and nonprocedural languages.mp4	14.6 MB
8 - Types of DBMS and database languages English.vtt	5.8 KB
8 - Types of DBMS and database languages.mp4	22.0 MB
/4 - Table Manipulation/
10 - Creating databases English.vtt	4.3 KB
10 - Creating databases.mp4	14.6 MB
11 - CODE creating databases.html	0.5 KB
12 - Creating a table English.vtt	5.3 KB
12 - Creating a table.mp4	20.0 MB
13 - CODE creating database tables.html	0.8 KB
14 - Inserting into a table English.vtt	5.8 KB
14 - Inserting into a table.mp4	24.9 MB
15 - Inserting multiple items in one statement English.vtt	1.7 KB
15 - Inserting multiple items in one statement.mp4	6.1 MB
16 - CODE inserting into tables.html	0.8 KB
17 - Delete row from a table English.vtt	5.3 KB
17 - Delete row from a table.mp4	25.5 MB
18 - CODE delete row.html	0.2 KB
19 - Updating a row English.vtt	2.8 KB
19 - Updating a row.mp4	11.0 MB
2 - Table Manipulation Quiz.html	0.0 KB
20 - CODE updating rows.html	0.4 KB
21 - Changing table structure English.vtt	4.2 KB
21 - Changing table structure.mp4	19.3 MB
22 - CODE change table structure.html	0.7 KB
23 - Drop tables English.vtt	2.4 KB
23 - Drop tables.mp4	3.9 MB
24 - What are primary keys English.vtt	7.0 KB
24 - What are primary keys.mp4	28.1 MB
25 - The auto increment feature English.vtt	4.9 KB
25 - The auto increment feature.mp4	23.5 MB
26 - CODE auto incremented primary keys.html	0.6 KB
27 - Enums English.vtt	4.8 KB
27 - Enums.mp4	25.2 MB
28 - Booleans English.vtt	6.2 KB
28 - Booleans.mp4	32.2 MB
29 - Floating point numbers with decimals English.vtt	6.4 KB
29 - Floating point numbers with decimals.mp4	30.9 MB
30 - Dates English.vtt	5.0 KB
30 - Dates.mp4	18.3 MB
31 - Exercise.html	1.0 KB
32 - Solution English.vtt	6.3 KB
32 - Solution.mp4	34.0 MB
33 - Chapter summary & source code.html	0.1 KB
33 - tablemanipulation.pdf	346.5 KB
9 - Data types English.vtt	11.3 KB
9 - Data types.mp4	45.8 MB
/5 - Basic SQL/
3 - Basic SQL Quiz.html	0.0 KB
34 - SQL dump English.vtt	5.9 KB
34 - SQL dump the city and country tables.mp4	54.6 MB
35 - SELECT English.vtt	4.5 KB
35 - SELECT.mp4	30.6 MB
36 - WHERE English.vtt	3.4 KB
36 - WHERE.mp4	18.1 MB
37 - IN English.vtt	2.8 KB
37 - IN.mp4	9.1 MB
38 - BETWEEN English.vtt	3.5 KB
38 - BETWEEN.mp4	8.0 MB
39 - NOT English.vtt	2.0 KB
39 - NOT negation in SQL.mp4	4.7 MB
40 - Logical operators English.vtt	3.8 KB
40 - Logical operators.mp4	8.4 MB
41 - Wildcards English.vtt	3.7 KB
41 - Wildcards.mp4	9.6 MB
42 - Functions English.vtt	6.1 KB
42 - Functions.mp4	12.3 MB
43 - ORDER BY English.vtt	5.1 KB
43 - ORDER BY.mp4	14.4 MB
44 - Code order by.html	0.2 KB
45 - GROUP BY English.vtt	3.3 KB
45 - GROUP BY.mp4	6.5 MB
46 - CODE group by.html	0.3 KB
47 - Exercise.html	0.3 KB
48 - Solution English.vtt	2.7 KB
48 - Solution.mp4	5.3 MB
49 - HAVING English.vtt	3.1 KB
49 - HAVING.mp4	6.7 MB
50 - Chapter summary & source code.html	0.1 KB
50 - basicsql.pdf	353.3 KB
/6 - Multiple Tables/
4 - Multiple Tables Quiz.html	0.0 KB
51 - What is a foreign key English.vtt	3.4 KB
51 - What is a foreign key.mp4	12.1 MB
52 - Foreign key example English.vtt	6.8 KB
52 - Foreign key example.mp4	30.9 MB
53 - CODE foreign keys.html	0.7 KB
54 - How to handle changes when dealing with multiple tables English.vtt	6.2 KB
54 - How to handle changes when dealing with multiple tables.mp4	22.1 MB
55 - Updating dependent tables example English.vtt	9.1 KB
55 - Updating dependent tables example.mp4	44.0 MB
56 - CODE updating tables.html	0.7 KB
57 - Exercise.html	1.4 KB
58 - Solution.html	0.7 KB
/7 - Database Normalization/
5 - Database Normalization Quiz.html	0.0 KB
59 - What is database normalization English.vtt	4.8 KB
59 - What is database normalization.mp4	12.9 MB
60 - The first normal form English.vtt	4.5 KB
60 - The first normal form.mp4	15.3 MB
61 - The second normal form English.vtt	5.7 KB
61 - The second normal form.mp4	19.7 MB
62 - The third normal form English.vtt	4.2 KB
62 - The third normal form.mp4	13.7 MB
/.../8 - Joining Multiple Tables/
6 - Joining Tables Quiz.html	0.0 KB
63 - Configuring the database tables English.vtt	3.1 KB
63 - Configuring the database tables PERSON and UNIVERSITY.mp4	5.9 MB
64 - Inner join introduction English.vtt	6.8 KB
64 - Inner join introduction.mp4	15.4 MB
65 - Inner join example English.vtt	5.3 KB
65 - Inner join example.mp4	25.0 MB
66 - CODE inner join.html	0.5 KB
67 - Left join introduction English.vtt	4.3 KB
67 - Left join introduction.mp4	10.9 MB
68 - Left join example English.vtt	2.7 KB
68 - Left join example.mp4	13.3 MB
69 - CODE left join.html	0.2 KB
70 - Right join introduction English.vtt	3.2 KB
70 - Right join introduction.mp4	8.1 MB
71 - Right join example English.vtt	1.5 KB
71 - Right join example.mp4	2.9 MB
72 - CODE right join.html	0.2 KB
73 - JOIN example English.vtt	5.5 KB
73 - JOIN example number of cities.mp4	11.6 MB
74 - CODE joining cities.html	0.4 KB
75 - Exercise.html	0.2 KB
76 - Solution English.vtt	3.4 KB
76 - Solution.mp4	7.6 MB
77 - Online SQL console English.vtt	1.1 KB
77 - Online SQL console.mp4	2.3 MB
78 - JOIN example English.vtt	3.2 KB
78 - JOIN example customers and orders.mp4	5.9 MB
79 - JOIN example English.vtt	3.5 KB
79 - JOIN example number of orders by customers.mp4	6.8 MB
80 - JOIN example English.vtt	2.0 KB
80 - JOIN example number of orders by country.mp4	4.1 MB
81 - Chapter summary & source code.html	0.1 KB
81 - JOIN.pdf	342.8 KB
/.../9 - Advanced SQL Subqueries/
7 - Subqueries Quiz.html	0.0 KB
82 - What are subqueries English.vtt	8.8 KB
82 - What are subqueries.mp4	31.8 MB
83 - Non English.vtt	2.3 KB
83 - Noncorrelated scalar subquery.mp4	4.8 MB
84 - CODE scalar subquery.html	0.1 KB
85 - Non English.vtt	3.1 KB
85 - Noncorrelated multiplerow subquery.mp4	6.1 MB
86 - CODE multiple row subquery.html	0.1 KB
87 - Correlated subquery English.vtt	2.9 KB
87 - Correlated subquery.mp4	6.2 MB
88 - CODE correlated subquery.html	0.2 KB
89 - Subqueries and joins English.vtt	1.6 KB
89 - Subqueries and joins.mp4	4.7 MB
90 - Transforming subquery into join English.vtt	3.0 KB
90 - Transforming subquery into join.mp4	6.6 MB
91 - CODE subquery and join.html	0.3 KB
92 - Chapter summary & source code.html	0.1 KB
92 - subqueies.pdf	335.8 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 261