FreeCourseSite com Udemy The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

FreeCourseSite com Udemy The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

Name	[FreeCourseSite.com] Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert	DOWNLOAD Copy Link
Total Size	2.5 GB
Total Files	548
Last Seen	2024-11-16 23:37
Hash	72C7B9503CC108E4AAA6423E069E1FABD3C156D2

/0. Websites you may like/
[CourseClub.ME].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
/1. Introduction and 5 Minutes of SQL/
1. Course Introduction.mp4	6.1 MB
1. Course Introduction.vtt	2.0 KB
2. Instructor Introduction(s).mp4	8.9 MB
2. Instructor Introduction(s).vtt	2.3 KB
3. Syllabus Walkthrough and Prerequisites.mp4	12.7 MB
3. Syllabus Walkthrough and Prerequisites.vtt	6.5 KB
4. Note about SQL Editor.html	0.5 KB
5. Your First 5 Minutes of SQL - Let's Get Coding!.mp4	19.2 MB
5. Your First 5 Minutes of SQL - Let's Get Coding!.vtt	9.5 KB
5.1 Lecture Slides.html	0.1 KB
5.2 SQL Try-It Editor.html	0.1 KB
6. CODE Your First 5 Minutes of SQL.html	1.4 KB
7. How The Course Works.mp4	23.5 MB
7. How The Course Works.vtt	5.8 KB
/10. Revisiting Data Types/
1. Section 10 Introduction.mp4	11.7 MB
1. Section 10 Introduction.vtt	2.8 KB
10. DATE, TIME, and DATETIME.mp4	5.7 MB
10. DATE, TIME, and DATETIME.vtt	5.5 KB
11. Creating Our DATE data.mp4	8.8 MB
11. Creating Our DATE data.vtt	5.8 KB
12. CODE Creating Our DATE data.html	0.4 KB
13. CURDATE, CURTIME, and NOW.mp4	8.6 MB
13. CURDATE, CURTIME, and NOW.vtt	6.8 KB
14. Note about formatting dates.html	0.3 KB
15. Formatting Dates.mp4	33.3 MB
15. Formatting Dates.vtt	15.8 KB
16. CODE Formatting Dates.html	0.9 KB
17. Date Math.mp4	19.4 MB
17. Date Math.vtt	10.4 KB
18. CODE Date Math.html	0.6 KB
19. Working with TIMESTAMPS.mp4	20.0 MB
19. Working with TIMESTAMPS.vtt	13.3 KB
2. CHAR and VARCHAR.mp4	21.6 MB
2. CHAR and VARCHAR.vtt	17.3 KB
2.1 Slides For This Section.html	0.1 KB
20. CODE Working with TIMESTAMPS.html	0.9 KB
21. Data Types Exercises.mp4	7.3 MB
21. Data Types Exercises.vtt	5.7 KB
21.1 Slides.html	0.1 KB
22. Data Types Exercises Solution.mp4	27.7 MB
22. Data Types Exercises Solution.vtt	15.4 KB
23. CODE Data Types Exercises Solution.html	1.2 KB
3. Note about CHAR and VARCHAR.html	0.3 KB
4. CODE CHAR and VARCHAR.html	0.4 KB
5. DECIMAL.mp4	11.8 MB
5. DECIMAL.vtt	7.2 KB
6. CODE DECIMAL.html	0.3 KB
7. FLOAT and DOUBLE.mp4	12.2 MB
7. FLOAT and DOUBLE.vtt	8.9 KB
8. CODE FLOAT and DOUBLE.html	0.3 KB
9. Note about setting the timezone in Cloud9.html	0.4 KB
/11. The Power of Logical Operators/
1. Section 11 Introduction.mp4	16.5 MB
1. Section 11 Introduction.vtt	3.8 KB
10. Logical AND.mp4	16.2 MB
10. Logical AND.vtt	11.7 KB
11. CODE Logical AND.html	0.6 KB
12. Logical OR.mp4	11.2 MB
12. Logical OR.vtt	8.1 KB
13. CODE Logical OR.html	0.5 KB
14. Between.mp4	19.1 MB
14. Between.vtt	12.7 KB
15. CODE Between.html	0.6 KB
16. In And Not In.mp4	23.0 MB
16. In And Not In.vtt	13.4 KB
17. CODE In And Not In.html	1.2 KB
18. Case Statements.mp4	22.1 MB
18. Case Statements.vtt	14.1 KB
19. CODE Case Statements.html	1.0 KB
2. Not Equal.mp4	8.1 MB
2. Not Equal.vtt	5.1 KB
2.1 Slides For This Section.html	0.1 KB
20. Logical Operators Exercises.mp4	11.4 MB
20. Logical Operators Exercises.vtt	8.7 KB
20.1 Slides.html	0.1 KB
21. Logical Operators Exercises Solution.mp4	34.9 MB
21. Logical Operators Exercises Solution.vtt	19.5 KB
22. CODE Logical Operators Exercises Solution.html	1.4 KB
3. CODE Not Equal.html	0.3 KB
4. Not Like.mp4	4.0 MB
4. Not Like.vtt	3.2 KB
5. CODE Not Like.html	0.3 KB
6. Greater Than.mp4	17.2 MB
6. Greater Than.vtt	12.3 KB
7. CODE Greater Than.html	0.8 KB
8. Less Than.mp4	6.4 MB
8. Less Than.vtt	4.6 KB
9. CODE Less Than.html	0.4 KB
/12. Section 12 One To Many/
1. Section 12 Introduction.mp4	13.9 MB
1. Section 12 Introduction.vtt	2.6 KB
10. CODE Inner Joins.html	1.0 KB
11. Left Join.mp4	29.8 MB
11. Left Join.vtt	19.5 KB
12. CODE Left Joins.html	1.1 KB
13. Right Joins Pt 1.mp4	21.3 MB
13. Right Joins Pt 1.vtt	12.7 KB
14. CODE Right Joins Part 1.html	1.4 KB
15. Right Joins Pt 2.mp4	21.6 MB
15. Right Joins Pt 2.vtt	11.3 KB
16. CODE Right Joins Part 2.html	1.3 KB
17. Right and Left Joins A Common Question.mp4	8.3 MB
17. Right and Left Joins A Common Question.vtt	3.7 KB
18. CODE Right and Left Joins FAQ.html	0.5 KB
19. Our First Joins Exercise.mp4	12.2 MB
19. Our First Joins Exercise.vtt	9.0 KB
19.1 Slides.html	0.1 KB
2. Real World Data Is Messy.mp4	14.8 MB
2. Real World Data Is Messy.vtt	14.6 KB
2.1 Slides For This Section.html	0.1 KB
20. Our First Joins Exercise SOLUTION.mp4	19.6 MB
20. Our First Joins Exercise SOLUTION.vtt	10.4 KB
21. CODE Our First Joins Exercise.html	0.8 KB
22. Our First Joins Exercise SOLUTION PT. 2.mp4	18.0 MB
22. Our First Joins Exercise SOLUTION PT. 2.vtt	10.9 KB
23. CODE Our First Joins Exercise SOLUTION PT. 2.html	1.6 KB
3. Types of Data Relationships.mp4	6.5 MB
3. Types of Data Relationships.vtt	6.0 KB
4. One To Many The Basics.mp4	20.0 MB
4. One To Many The Basics.vtt	16.4 KB
5. Working With Foreign Keys.mp4	23.8 MB
5. Working With Foreign Keys.vtt	14.9 KB
6. CODE Working With Foreign Keys.html	1.3 KB
7. Cross Join.mp4	15.2 MB
7. Cross Join.vtt	9.2 KB
8. CODE Cross Joins.html	0.6 KB
9. Inner Join.mp4	28.9 MB
9. Inner Join.vtt	14.3 KB
/13. Section 13 Many To Many/
1. Section 13 Introduction.mp4	13.6 MB
1. Section 13 Introduction.vtt	2.6 KB
10. CODE TV Joins Challenge 3 SOLUTION.html	0.4 KB
11. TV Joins Challenge 4.mp4	12.9 MB
11. TV Joins Challenge 4.vtt	7.0 KB
12. CODE TV Joins Challenge 4 SOLUTION.html	0.2 KB
13. TV Joins Challenge 5.mp4	10.1 MB
13. TV Joins Challenge 5.vtt	5.9 KB
14. CODE TV Joins Challenge 5 SOLUTION.html	0.3 KB
15. TV Joins Challenge 6.mp4	24.5 MB
15. TV Joins Challenge 6.vtt	13.6 KB
16. CODE TV Joins Challenge 6 SOLUTION.html	1.3 KB
17. TV Joins Challenge 7.mp4	16.3 MB
17. TV Joins Challenge 7.vtt	8.1 KB
18. CODE TV Joins Challenge 7 SOLUTION.html	0.3 KB
2. Many To Many Basics.mp4	14.9 MB
2. Many To Many Basics.vtt	13.6 KB
2.1 Slides.html	0.1 KB
3. Creating Our Tables.mp4	22.9 MB
3. Creating Our Tables.vtt	12.8 KB
4. CODE Creating Our Tables.html	2.4 KB
5. TV Joins Challenge 1.mp4	12.4 MB
5. TV Joins Challenge 1.vtt	5.6 KB
6. CODE TV Joins Challenge 1 Solution.html	0.2 KB
7. TV Joins Challenge 2.mp4	13.9 MB
7. TV Joins Challenge 2.vtt	7.9 KB
8. CODE TV Joins Challenge 2 SOLUTION.html	0.2 KB
9. TV Joins Challenge 3.mp4	12.0 MB
9. TV Joins Challenge 3.vtt	5.8 KB
/14. Instagram Database Clone/
1. Section 14 Introduction.mp4	9.9 MB
1. Section 14 Introduction.vtt	1.8 KB
10. CODE IG Clone Likes Schema.html	0.3 KB
11. Cloning Instagram's DB Followers Schema.mp4	13.3 MB
11. Cloning Instagram's DB Followers Schema.vtt	8.7 KB
12. CODE IG Clone Followers Schema.html	0.3 KB
13. Cloning Instagram's DB Hashtags Part 1.mp4	22.9 MB
13. Cloning Instagram's DB Hashtags Part 1.vtt	13.5 KB
14. Cloning Instagram's DB Hashtags Part 2.mp4	12.3 MB
14. Cloning Instagram's DB Hashtags Part 2.vtt	6.1 KB
15. CODE IG Clone Hashtags Schema.html	0.4 KB
16. CODE Complete IG Clone Schema.html	1.6 KB
2. Introduction To Instagram Clone Schema.mp4	22.8 MB
2. Introduction To Instagram Clone Schema.vtt	12.0 KB
2.1 Slides For This Section.html	0.1 KB
3. Cloning Instagram's DB Users Schema.mp4	9.9 MB
3. Cloning Instagram's DB Users Schema.vtt	7.8 KB
4. CODE IG Clone Users Schema.html	0.2 KB
5. Cloning Instagram's DB Photos Schema.mp4	12.3 MB
5. Cloning Instagram's DB Photos Schema.vtt	7.4 KB
6. CODE IG Clone Photos Schema.html	0.3 KB
7. Cloning Instagram's DB Comments Schema.mp4	13.6 MB
7. Cloning Instagram's DB Comments Schema.vtt	7.6 KB
8. CODE IG Clone Comments Schema.html	0.3 KB
9. Cloning Instagram's DB Likes Schema.mp4	21.6 MB
9. Cloning Instagram's DB Likes Schema.vtt	9.1 KB
/15. Working With Lots Of Instagram Data/
1. Section 15 Introduction.mp4	11.8 MB
1. Section 15 Introduction.vtt	2.4 KB
10. Instagram Clone Challenge 4.mp4	16.6 MB
10. Instagram Clone Challenge 4.vtt	8.2 KB
11. Instagram Challenge 4 Solution CODE.html	0.4 KB
12. Instagram Clone Challenge 5.mp4	5.7 MB
12. Instagram Clone Challenge 5.vtt	4.0 KB
13. Instagram Challenge 5 Solution CODE.html	0.2 KB
14. Instagram Clone Challenge 6.mp4	12.3 MB
14. Instagram Clone Challenge 6.vtt	5.9 KB
15. Instagram Challenge 6 Solution CODE.html	0.3 KB
16. Note about Instagram Clone Challenge 7.html	0.4 KB
17. Instagram Clone Challenge 7.mp4	11.5 MB
17. Instagram Clone Challenge 7.vtt	6.2 KB
18. Instagram Challenge 7 Solution CODE.html	0.4 KB
2. Loading The JUMBO dataset.mp4	62.1 MB
2. Loading The JUMBO dataset.vtt	11.2 KB
3. The Instagram Clone DATASET.html	0.4 KB
3.1 ig_clone_data.sql.sql	439.7 KB
4. Instagram Clone Challenge 1.mp4	9.0 MB
4. Instagram Clone Challenge 1.vtt	6.2 KB
4.1 Slides.html	0.1 KB
5. Instagram Challenge 1 Solution CODE.html	0.1 KB
6. Instagram Clone Challenge 2.mp4	12.3 MB
6. Instagram Clone Challenge 2.vtt	9.0 KB
7. Instagram Challenge 2 Solution CODE.html	0.2 KB
8. Instagram Clone Challenge 3.mp4	18.1 MB
8. Instagram Clone Challenge 3.vtt	9.7 KB
9. Instagram Challenge 3 Solution CODE.html	0.2 KB
/16. Section 16 - Introducing Node/
1. Note about Introducing Node.html	0.4 KB
10. Note about Faker install.html	0.8 KB
11. Introduction to NPM and Faker.mp4	16.7 MB
11. Introduction to NPM and Faker.vtt	11.1 KB
11.1 FakerJS Github Repo.html	0.1 KB
12. CODE Introduction to NPM and Faker.html	1.2 KB
13. Introducing the MySQL Package.mp4	7.3 MB
13. Introducing the MySQL Package.vtt	6.8 KB
13.1 MySQL Node Package Github Repo.html	0.1 KB
14. Note about connecting Node to MySQL.html	1.3 KB
15. Connecting Node to MySQL.mp4	24.2 MB
15. Connecting Node to MySQL.vtt	15.9 KB
16. CODE Connecting Node to MySQL.html	2.5 KB
17. Creating Our Users Table.mp4	14.7 MB
17. Creating Our Users Table.vtt	9.4 KB
18. CODE Creating Our Users Table.html	0.2 KB
19. Selecting Using Node.mp4	11.9 MB
19. Selecting Using Node.vtt	7.9 KB
2. Section 16 Introduction.mp4	13.8 MB
2. Section 16 Introduction.vtt	2.4 KB
20. CODE Selecting Using Node.html	0.9 KB
21. Inserting Using Node.mp4	23.0 MB
21. Inserting Using Node.vtt	14.3 KB
22. CODE Inserting Using Node.html	0.7 KB
23. Some MySQLNode Magic.mp4	18.7 MB
23. Some MySQLNode Magic.vtt	9.5 KB
24. Bulk Inserting 500 Users - Finally!.mp4	23.5 MB
24. Bulk Inserting 500 Users - Finally!.vtt	11.2 KB
25. CODE Bulk Inserting 500 Users.html	0.6 KB
26. 500 Users Exercises.mp4	3.6 MB
26. 500 Users Exercises.vtt	3.5 KB
26.1 Slides.html	0.1 KB
27. 500 Users Exercises Solutions.mp4	22.9 MB
27. 500 Users Exercises Solutions.vtt	13.1 KB
28. CODE 500 Users Exercises Solutions.html	1.3 KB
3. MySQL and Other Languages.mp4	11.7 MB
3. MySQL and Other Languages.vtt	13.0 KB
3.1 Slides For This Section.html	0.1 KB
4. BUT WHAT ABOUT PHP.mp4	15.9 MB
4. BUT WHAT ABOUT PHP.vtt	10.3 KB
5. Introduction to JOIN US app.mp4	12.5 MB
5. Introduction to JOIN US app.vtt	11.2 KB
6. Note about Setting Up Cloud9 for Node.html	1.1 KB
7. Setting Up Cloud9 for Node.mp4	11.0 MB
7. Setting Up Cloud9 for Node.vtt	9.0 KB
8. 5 Minute NodeJS Crash Course.mp4	9.8 MB
8. 5 Minute NodeJS Crash Course.vtt	8.1 KB
9. CODE 5 Minute Node Crash Course.html	0.3 KB
/17. Section 17 - Building Our Web App/
1. Section 17 Introduction.mp4	12.3 MB
1. Section 17 Introduction.vtt	2.8 KB
10. Connecting Express and MySQL.mp4	21.8 MB
10. Connecting Express and MySQL.vtt	13.7 KB
11. CODE Connecting Express and MySQL.html	0.4 KB
12. Adding EJS Templates.mp4	31.9 MB
12. Adding EJS Templates.vtt	21.3 KB
13. CODE Adding EJS Templates.html	0.4 KB
14. Connecting The Form.mp4	38.0 MB
14. Connecting The Form.vtt	23.6 KB
15. CODE Connecting the Form.html	0.4 KB
16. Styling Part 1.mp4	18.9 MB
16. Styling Part 1.vtt	10.7 KB
17. CODE HTML AND CSS FILES.html	0.1 KB
17.1 JOIN_US_HTML_AND_CSS.zip.zip	2.8 KB
18. Styling Part 2.mp4	19.3 MB
18. Styling Part 2.vtt	10.6 KB
2. Join Us Completed CODE.html	0.3 KB
2.1 JoinUsCompleteCode.zip.zip	3.9 MB
3. Introducing Express.mp4	10.0 MB
3. Introducing Express.vtt	8.5 KB
3.1 Slides.html	0.1 KB
3.2 Express Documentation.html	0.1 KB
4. NPM Init and package.json files.mp4	12.1 MB
4. NPM Init and package.json files.vtt	8.9 KB
5. Note about Our First Simple Web App.html	0.5 KB
6. Our First Simple Web App.mp4	29.6 MB
6. Our First Simple Web App.vtt	21.9 KB
7. CODE Our First Simple Web App.html	0.4 KB
8. Adding Multiple Routes.mp4	19.6 MB
8. Adding Multiple Routes.vtt	12.9 KB
9. CODE Adding Multiple Routes.html	0.5 KB
/18. Section 18 - Database Triggers/
1. Introduction to Database Triggers.mp4	29.0 MB
1. Introduction to Database Triggers.vtt	8.9 KB
1.1 Lecture Slides.html	0.1 KB
2. Writing Our First Trigger Part 1.mp4	11.9 MB
2. Writing Our First Trigger Part 1.vtt	9.4 KB
2.1 Lecture Slides.html	0.1 KB
3. Writing Our First Trigger Part 2.mp4	23.9 MB
3. Writing Our First Trigger Part 2.vtt	15.2 KB
3.1 Lecture Slides.html	0.1 KB
4. Preventing Instagram Self-Follows With Triggers.mp4	14.8 MB
4. Preventing Instagram Self-Follows With Triggers.vtt	10.4 KB
4.1 Lecture Slides.html	0.1 KB
5. Creating Logger Triggers.mp4	19.5 MB
5. Creating Logger Triggers.vtt	12.2 KB
5.1 Lecture Slides.html	0.1 KB
6. Managing Triggers And A Warning.mp4	13.2 MB
6. Managing Triggers And A Warning.vtt	8.2 KB
6.1 Lecture Slides.html	0.1 KB
/2. Getting Started Overview and Installation/
1. Section Introduction.mp4	8.4 MB
1. Section Introduction.vtt	1.7 KB
2. What Is a Database.mp4	10.8 MB
2. What Is a Database.vtt	9.5 KB
2.1 Slides For This Section.html	0.1 KB
3. SQL Vs. MySQL.mp4	8.1 MB
3. SQL Vs. MySQL.vtt	7.2 KB
4. Installation Overview - WATCH BEFORE INSTALLING.mp4	7.0 MB
4. Installation Overview - WATCH BEFORE INSTALLING.vtt	7.3 KB
4.1 Installation Slides.html	0.1 KB
5. Cloud9 Registration IMPORTANT - PLEASE READ!!!.html	2.2 KB
6. Mac Installation.mp4	23.3 MB
6. Mac Installation.vtt	15.6 KB
7. CODE Mac Installation.html	1.3 KB
8. Windows Installation.mp4	6.0 MB
8. Windows Installation.vtt	5.7 KB
/3. Creating Databases and Tables/
1. Section 3 Introduction.mp4	9.8 MB
1. Section 3 Introduction.vtt	1.8 KB
10. Note about INT max size.html	0.4 KB
11. Basic Datatypes Challenge.mp4	3.7 MB
11. Basic Datatypes Challenge.vtt	3.3 KB
12. Basic Datatypes Challenge - Solution.html	0.2 KB
13. Creating Your Own Tables.mp4	4.1 MB
13. Creating Your Own Tables.vtt	3.6 KB
14. CODE Creating Your Own Tables.html	0.2 KB
15. How Do We Know It Worked.mp4	3.7 MB
15. How Do We Know It Worked.vtt	3.4 KB
16. CODE How Do We Know It Worked.html	0.1 KB
17. Dropping Tables.mp4	2.2 MB
17. Dropping Tables.vtt	2.2 KB
18. CODE Dropping Tables.html	0.2 KB
19. Creating Your Own Tables Challenge.mp4	6.4 MB
19. Creating Your Own Tables Challenge.vtt	5.6 KB
19.1 Slides.html	0.1 KB
2. Creating Databases.mp4	7.6 MB
2. Creating Databases.vtt	6.6 KB
2.1 Slides For This Section!.html	0.1 KB
20. CODE Creating Your Own Tables Challenge.html	0.2 KB
3. CODE Creating Databases.html	0.4 KB
4. Dropping Databases.mp4	2.6 MB
4. Dropping Databases.vtt	2.3 KB
5. CODE Dropping Databases.html	0.3 KB
6. Using Databases.mp4	4.6 MB
6. Using Databases.vtt	3.5 KB
7. CODE Using Databases.html	0.1 KB
8. Introduction to Tables.mp4	7.5 MB
8. Introduction to Tables.vtt	6.8 KB
9. The Basic Datatypes.mp4	11.3 MB
9. The Basic Datatypes.vtt	10.0 KB
/4. Inserting Data (and a couple other things)/
1. Section 4 Introduction.mp4	11.3 MB
1. Section 4 Introduction.vtt	2.3 KB
10. INSERT Challenges Solution.mp4	7.5 MB
10. INSERT Challenges Solution.vtt	4.3 KB
11. CODE INSERT Challenges Solution.html	0.8 KB
12. NOTE MySQL Warnings.html	0.5 KB
13. MySQL Warnings.mp4	9.1 MB
13. MySQL Warnings.vtt	4.4 KB
14. CODE MySQL Warnings.html	0.6 KB
15. NULL and NOT_NULL.mp4	10.7 MB
15. NULL and NOT_NULL.vtt	7.3 KB
16. CODE NULL and NOT NULL.html	1.1 KB
17. Setting Default Values.mp4	10.9 MB
17. Setting Default Values.vtt	7.3 KB
18. CODE Setting Default Values.html	1.2 KB
19. A Primer On Primary Keys.mp4	19.1 MB
19. A Primer On Primary Keys.vtt	14.0 KB
2. Inserting Data.mp4	7.0 MB
2. Inserting Data.vtt	6.2 KB
2.1 Slides For This Section.html	0.1 KB
20. CODE A Primer on Primary Keys.html	1.5 KB
21. Table Constraints Exercise.mp4	2.8 MB
21. Table Constraints Exercise.vtt	2.8 KB
21.1 Exercise Slides.html	0.1 KB
22. Table Constraints Exercise Solution.mp4	8.4 MB
22. Table Constraints Exercise Solution.vtt	4.0 KB
23. CODE Table Constraints Exercise Solution.html	0.9 KB
3. CODE Inserting Data.html	0.3 KB
4. Super Quick Intro To SELECT.mp4	3.1 MB
4. Super Quick Intro To SELECT.vtt	2.9 KB
5. CODE Super Quick Intro To SELECT.html	0.0 KB
6. Multiple INSERT.mp4	4.3 MB
6. Multiple INSERT.vtt	3.6 KB
7. CODE Multiple Insert.html	0.2 KB
8. INSERT Challenges.mp4	2.3 MB
8. INSERT Challenges.vtt	2.0 KB
9. Note about using quotes inside of inserted values.html	0.5 KB
/5. CRUD commmands/
1. Section 5 Introduction.mp4	14.0 MB
1. Section 5 Introduction.vtt	2.3 KB
10. SELECT Challenges.mp4	3.2 MB
10. SELECT Challenges.vtt	2.6 KB
11. SELECT Challenges Solution.mp4	4.3 MB
11. SELECT Challenges Solution.vtt	3.2 KB
12. CODE SELECT Challenges Solution.html	0.4 KB
13. Introduction to Aliases.mp4	4.1 MB
13. Introduction to Aliases.vtt	3.5 KB
14. CODE Introduction to Aliases.html	0.2 KB
15. The UPDATE Command.mp4	5.7 MB
15. The UPDATE Command.vtt	4.7 KB
16. CODE The UPDATE Command.html	0.3 KB
17. UPDATE Challenges.mp4	876.2 KB
17. UPDATE Challenges.vtt	0.7 KB
18. UPDATE Challenges Solution.mp4	5.9 MB
18. UPDATE Challenges Solution.vtt	4.2 KB
19. CODE UPDATE Challenges Solution.html	0.6 KB
2. Introduction to CRUD.mp4	2.4 MB
2. Introduction to CRUD.vtt	2.3 KB
2.1 This Section's Slides.html	0.1 KB
20. Introduction to DELETE.mp4	6.5 MB
20. Introduction to DELETE.vtt	6.0 KB
21. CODE Introduction to DELETE.html	0.2 KB
22. DELETE Challenges.mp4	1.7 MB
22. DELETE Challenges.vtt	1.6 KB
22.1 Slides.html	0.1 KB
23. DELETE Challenges Solution.mp4	4.5 MB
23. DELETE Challenges Solution.vtt	3.0 KB
24. CODE DELETE Challenges Solution.html	0.3 KB
3. CODE Introduction to CRUD.html	0.1 KB
4. Preparing Our Data.mp4	3.9 MB
4. Preparing Our Data.vtt	3.1 KB
5. CODE Preparing Our Data.html	0.8 KB
6. Official Introduction to SELECT.mp4	6.4 MB
6. Official Introduction to SELECT.vtt	4.7 KB
7. CODE Official Introduction to SELECT.html	0.6 KB
8. Introduction to WHERE.mp4	7.2 MB
8. Introduction to WHERE.vtt	6.3 KB
9. CODE Introduction to WHERE.html	0.3 KB
/6. CRUD Challenge Section/
1. Section 6 Introduction.mp4	15.2 MB
1. Section 6 Introduction.vtt	2.9 KB
10. CODE CRUD Exercise Delete Solution.html	0.4 KB
2. CRUD Exercise Overview.mp4	11.1 MB
2. CRUD Exercise Overview.vtt	9.9 KB
2.1 Slides.html	0.1 KB
3. CRUD Exercise Create Solution.mp4	9.4 MB
3. CRUD Exercise Create Solution.vtt	6.4 KB
4. CODE CRUD Exercise Create Solution.html	0.8 KB
5. CRUD Exercise Read Solution.mp4	3.0 MB
5. CRUD Exercise Read Solution.vtt	1.9 KB
6. CODE CRUD Exercise Read Solution.html	0.2 KB
7. CRUD Exercise Update Solution.mp4	6.7 MB
7. CRUD Exercise Update Solution.vtt	4.4 KB
8. CODE CRUD Exercise Update Solution.html	0.6 KB
9. CRUD Exercise Delete Solution.mp4	5.1 MB
9. CRUD Exercise Delete Solution.vtt	3.7 KB
/7. The World Of String Functions/
1. Section 7 Introduction.mp4	11.7 MB
1. Section 7 Introduction.vtt	7.8 MB
10. CODE Introducing SUBSTRING.html	0.8 KB
11. Introducing REPLACE.mp4	12.0 MB
11. Introducing REPLACE.vtt	7.5 KB
12. CODE Introducing REPLACE.html	0.9 KB
13. Using REVERSE.mp4	5.6 MB
13. Using REVERSE.vtt	4.1 KB
14. CODE Using REVERSE.html	0.2 KB
15. Working with CHAR LENGTH.mp4	8.7 MB
15. Working with CHAR LENGTH.vtt	5.7 KB
16. CODE Working with CHAR LENGTH.html	0.3 KB
17. Changing Case with UPPER and LOWER.mp4	6.4 MB
17. Changing Case with UPPER and LOWER.vtt	4.0 KB
18. CODE Changing Case with UPPER and LOWER.html	0.3 KB
19. Note about string functions.html	1.0 KB
2. Note about Running SQL Files.html	0.5 KB
20. String Function Challenges.mp4	7.6 MB
20. String Function Challenges.vtt	7.6 MB
20.1 Slides.html	0.1 KB
21. String Function Challenges Solution.mp4	26.0 MB
21. String Function Challenges Solution.vtt	13.5 KB
22. CODE String Function Challenges Solution.html	1.4 KB
3. Running SQL Files.mp4	15.9 MB
3. Running SQL Files.vtt	12.2 KB
3.1 Slides For This Section.html	0.1 KB
4. CODE Running SQL Files.html	0.4 KB
5. Loading Our Book Data.mp4	13.7 MB
5. Loading Our Book Data.vtt	7.0 KB
5.1 book_data.sql.sql	1.3 KB
5.2 book_data.sql file available from this c9 workspace.html	0.1 KB
6. CODE Loading Our Book Data.html	1.7 KB
7. Working with CONCAT.mp4	24.1 MB
7. Working with CONCAT.vtt	13.8 KB
8. CODE Working With CONCAT.html	0.9 KB
9. Introducing SUBSTRING.mp4	16.5 MB
9. Introducing SUBSTRING.vtt	11.8 KB
/8. Refining Our Selections/
1. Section 8 Introduction.mp4	4.9 MB
1. Section 8 Introduction.vtt	0.9 KB
10. Better Searches with LIKE.mp4	11.0 MB
10. Better Searches with LIKE.vtt	9.3 KB
11. CODE Better Searches with LIKE.html	0.3 KB
12. LIKE Part 2 More Wildcards.mp4	9.9 MB
12. LIKE Part 2 More Wildcards.vtt	7.9 KB
13. CODE LIKE Part 2 More Wildcards.html	0.4 KB
14. Refining Selections Exercises.mp4	7.9 MB
14. Refining Selections Exercises.vtt	6.3 KB
14.1 Slides.html	0.1 KB
15. Refining Selections Exercises Solution.mp4	26.1 MB
15. Refining Selections Exercises Solution.vtt	14.3 KB
16. CODE Refining Selections Exercises Solution.html	0.7 KB
2. Seed Data Adding A Couple New Books.mp4	4.0 MB
2. Seed Data Adding A Couple New Books.vtt	4.1 KB
2.1 Slides For This Section.html	0.1 KB
3. CODE Seed Data Adding A Couple New Books.html	0.4 KB
4. Using DISTINCT.mp4	13.3 MB
4. Using DISTINCT.vtt	9.8 KB
5. CODE Using DISTINCT.html	0.3 KB
6. Sorting Data with ORDER BY.mp4	20.5 MB
6. Sorting Data with ORDER BY.vtt	2.0 KB
7. CODE Sorting Data with ORDER BY.html	1.0 KB
8. Using LIMIT.mp4	17.2 MB
8. Using LIMIT.vtt	11.4 KB
9. CODE Using LIMIT.html	0.9 KB
/9. The Magic of Aggregate Functions/
1. Section 9 Introduction.mp4	18.4 MB
1. Section 9 Introduction.vtt	5.7 KB
10. Using Min and Max with Group By.mp4	10.9 MB
10. Using Min and Max with Group By.vtt	7.6 KB
11. CODE Using Min and Max with Group By.html	0.4 KB
12. The Sum Function.mp4	6.7 MB
12. The Sum Function.vtt	5.1 KB
13. CODE The Sum Function.html	0.4 KB
14. The Avg Function.mp4	9.0 MB
14. The Avg Function.vtt	7.4 KB
15. CODE The Avg Function.html	0.4 KB
16. Aggregate Functions Challenges.mp4	6.1 MB
16. Aggregate Functions Challenges.vtt	5.2 KB
16.1 Slides.html	0.1 KB
17. Aggregate Functions Challenges Solution.mp4	15.6 MB
17. Aggregate Functions Challenges Solution.vtt	9.0 KB
18. CODE Aggregate Functions Challenges Solution.html	0.8 KB
2. The Count Function.mp4	13.6 MB
2. The Count Function.vtt	10.4 KB
2.1 Slides For This Section.html	0.1 KB
3. CODE The Count Function.html	0.4 KB
4. The Joys of Group By.mp4	19.8 MB
4. The Joys of Group By.vtt	15.1 KB
5. CODE The Joys of Group By.html	0.7 KB
6. Min and Max Basics.mp4	6.8 MB
6. Min and Max Basics.vtt	4.6 KB
7. CODE MIN and MAX Basics.html	0.3 KB
8. SUBQUERIES - A Problem with Min and Max.mp4	11.3 MB
8. SUBQUERIES - A Problem with Min and Max.vtt	8.2 KB
9. CODE A Problem with Min and Max.html	0.5 KB
Total files 548