课程目录

• 1. Introduction and 5 Minutes of SQL
• 1. Course Introduction.en.srt
• 1. Course Introduction
• 1. Course Introduction.srt
• 2. Instructor Introduction(s).en.srt
• 2. Instructor Introduction(s)
• 2. Instructor Introduction(s).srt
• 3. Syllabus Walkthrough and Prerequisites.en.srt
• 3. Syllabus Walkthrough and Prerequisites
• 3. Syllabus Walkthrough and Prerequisites.srt
• 4. Note about SQL Editor.html
• 5. Your First 5 Minutes of SQL – Let’s Get Coding!.en.srt
• 5. Your First 5 Minutes of SQL – Let’s Get Coding!
• 5. Your First 5 Minutes of SQL – Let’s Get Coding!.srt
• 5.1 SQL Try-It Editor.html
• 5.2 Lecture Slides.html
• 6. CODE Your First 5 Minutes of SQL.html
• 7. How The Course Works.en.srt
• 7. How The Course Works
• 7. How The Course Works.srt
• 10. Revisiting Data Types
• 1. Section 10 Introduction.en.srt
• 1. Section 10 Introduction
• 1. Section 10 Introduction.srt
• 10. DATE, TIME, and DATETIME.en.srt
• 10. DATE, TIME, and DATETIME
• 10. DATE, TIME, and DATETIME.srt
• 11. Creating Our DATE data.en.srt
• 11. Creating Our DATE data
• 11. Creating Our DATE data.srt
• 12. CODE Creating Our DATE data.html
• 13. CURDATE, CURTIME, and NOW.en.srt
• 13. CURDATE, CURTIME, and NOW
• 13. CURDATE, CURTIME, and NOW.srt
• 14. Note about formatting dates.html
• 15. Formatting Dates.en.srt
• 15. Formatting Dates
• 15. Formatting Dates.srt
• 16. CODE Formatting Dates.html
• 17. Date Math.en.srt
• 17. Date Math
• 17. Date Math.srt
• 18. CODE Date Math.html
• 19. Working with TIMESTAMPS.en.srt
• 19. Working with TIMESTAMPS
• 19. Working with TIMESTAMPS.srt
• 2. CHAR and VARCHAR.en.srt
• 2. CHAR and VARCHAR
• 2. CHAR and VARCHAR.srt
• 2.1 Slides For This Section.html
• 20. CODE Working with TIMESTAMPS.html
• 21. Data Types Exercises.en.srt
• 21. Data Types Exercises
• 21. Data Types Exercises.srt
• 21.1 Slides.html
• 22. Data Types Exercises Solution.en.srt
• 22. Data Types Exercises Solution
• 22. Data Types Exercises Solution.srt
• 23. CODE Data Types Exercises Solution.html
• 3. Note about CHAR and VARCHAR.html
• 4. CODE CHAR and VARCHAR.html
• 5. DECIMAL.en.srt
• 5. DECIMAL
• 5. DECIMAL.srt
• 6. CODE DECIMAL.html
• 7. FLOAT and DOUBLE.en.srt
• 7. FLOAT and DOUBLE
• 7. FLOAT and DOUBLE.srt
• 8. CODE FLOAT and DOUBLE.html
• 9. Note about setting the timezone in Cloud9.html
• 11. The Power of Logical Operators
• 1. Section 11 Introduction.en.srt
• 1. Section 11 Introduction
• 1. Section 11 Introduction.srt
• 10. Logical AND.en.srt
• 10. Logical AND
• 10. Logical AND.srt
• 11. CODE Logical AND.html
• 12. Logical OR.en.srt
• 12. Logical OR
• 12. Logical OR.srt
• 13. CODE Logical OR.html
• 14. Between.en.srt
• 14. Between
• 14. Between.srt
• 15. CODE Between.html
• 16. In And Not In.en.srt
• 16. In And Not In
• 16. In And Not In.srt
• 17. CODE In And Not In.html
• 18. Case Statements.en.srt
• 18. Case Statements
• 18. Case Statements.srt
• 19. CODE Case Statements.html
• 2. Not Equal.en.srt
• 2. Not Equal
• 2. Not Equal.srt
• 2.1 Slides For This Section.html
• 20. Logical Operators Exercises.en.srt
• 20. Logical Operators Exercises
• 20. Logical Operators Exercises.srt
• 20.1 Slides.html
• 21. Logical Operators Exercises Solution.en.srt
• 21. Logical Operators Exercises Solution
• 21. Logical Operators Exercises Solution.srt
• 22. CODE Logical Operators Exercises Solution.html
• 3. CODE Not Equal.html
• 4. Not Like.en.srt
• 4. Not Like
• 4. Not Like.srt
• 5. CODE Not Like.html
• 6. Greater Than.en.srt
• 6. Greater Than
• 6. Greater Than.srt
• 7. CODE Greater Than.html
• 8. Less Than.en.srt
• 8. Less Than
• 8. Less Than.srt
• 9. CODE Less Than.html
• 12. Section 12 One To Many
• 1. Section 12 Introduction.en.srt
• 1. Section 12 Introduction
• 1. Section 12 Introduction.srt
• 10. CODE Inner Joins.html
• 11. Left Join.en.srt
• 11. Left Join
• 11. Left Join.srt
• 12. CODE Left Joins.html
• 13. Right Joins Pt 1.en.srt
• 13. Right Joins Pt 1
• 13. Right Joins Pt 1.srt
• 14. CODE Right Joins Part 1.html
• 15. Right Joins Pt 2.en.srt
• 15. Right Joins Pt 2
• 15. Right Joins Pt 2.srt
• 16. CODE Right Joins Part 2.html
• 17. Right and Left Joins A Common Question.en.srt
• 17. Right and Left Joins A Common Question
• 17. Right and Left Joins A Common Question.srt
• 18. CODE Right and Left Joins FAQ.html
• 19. Our First Joins Exercise.en.srt
• 19. Our First Joins Exercise
• 19. Our First Joins Exercise.srt
• 19.1 Slides.html
• 2. Real World Data Is Messy.en.srt
• 2. Real World Data Is Messy
• 2. Real World Data Is Messy.srt
• 2.1 Slides For This Section.html
• 20. Our First Joins Exercise SOLUTION.en.srt
• 20. Our First Joins Exercise SOLUTION
• 20. Our First Joins Exercise SOLUTION.srt
• 21. CODE Our First Joins Exercise.html
• 22. Our First Joins Exercise SOLUTION PT. 2.en.srt
• 22. Our First Joins Exercise SOLUTION PT. 2
• 22. Our First Joins Exercise SOLUTION PT. 2.srt
• 23. CODE Our First Joins Exercise SOLUTION PT. 2.html
• 3. Types of Data Relationships.en.srt
• 3. Types of Data Relationships
• 3. Types of Data Relationships.srt
• 4. One To Many The Basics.en.srt
• 4. One To Many The Basics
• 4. One To Many The Basics.srt
• 5. Working With Foreign Keys.en.srt
• 5. Working With Foreign Keys
• 5. Working With Foreign Keys.srt
• 6. CODE Working With Foreign Keys.html
• 7. Cross Join.en.srt
• 7. Cross Join
• 7. Cross Join.srt
• 8. CODE Cross Joins.html
• 9. Inner Join.en.srt
• 9. Inner Join
• 9. Inner Join.srt
• 13. Section 13 Many To Many
• 1. Section 13 Introduction.en.srt
• 1. Section 13 Introduction
• 1. Section 13 Introduction.srt
• 10. CODE TV Joins Challenge 3 SOLUTION.html
• 11. TV Joins Challenge 4.en.srt
• 11. TV Joins Challenge 4
• 11. TV Joins Challenge 4.srt
• 12. CODE TV Joins Challenge 4 SOLUTION.html
• 13. TV Joins Challenge 5.en.srt
• 13. TV Joins Challenge 5
• 13. TV Joins Challenge 5.srt
• 14. CODE TV Joins Challenge 5 SOLUTION.html
• 15. TV Joins Challenge 6.en.srt
• 15. TV Joins Challenge 6
• 15. TV Joins Challenge 6.srt
• 16. CODE TV Joins Challenge 6 SOLUTION.html
• 17. TV Joins Challenge 7.en.srt
• 17. TV Joins Challenge 7
• 17. TV Joins Challenge 7.srt
• 18. CODE TV Joins Challenge 7 SOLUTION.html
• 2. Many To Many Basics.en.srt
• 2. Many To Many Basics
• 2. Many To Many Basics.srt
• 2.1 Slides.html
• 3. Creating Our Tables.en.srt
• 3. Creating Our Tables
• 3. Creating Our Tables.srt
• 4. CODE Creating Our Tables.html
• 5. TV Joins Challenge 1.en.srt
• 5. TV Joins Challenge 1
• 5. TV Joins Challenge 1.srt
• 6. CODE TV Joins Challenge 1 Solution.html
• 7. TV Joins Challenge 2.en.srt
• 7. TV Joins Challenge 2
• 7. TV Joins Challenge 2.srt
• 8. CODE TV Joins Challenge 2 SOLUTION.html
• 9. TV Joins Challenge 3.en.srt
• 9. TV Joins Challenge 3
• 9. TV Joins Challenge 3.srt
• 14. Instagram Database Clone
• 1. Section 14 Introduction.en.srt
• 1. Section 14 Introduction
• 1. Section 14 Introduction.srt
• 10. CODE IG Clone Likes Schema.html
• 11. Cloning Instagram’s DB Followers Schema.en.srt
• 11. Cloning Instagram’s DB Followers Schema
• 11. Cloning Instagram’s DB Followers Schema.srt
• 12. CODE IG Clone Followers Schema.html
• 13. Note about Cloning Instagram’s DB Hashtags Part 1.html
• 14. Cloning Instagram’s DB Hashtags Part 1.en.srt
• 14. Cloning Instagram’s DB Hashtags Part 1
• 14. Cloning Instagram’s DB Hashtags Part 1.srt
• 15. Cloning Instagram’s DB Hashtags Part 2.en.srt
• 15. Cloning Instagram’s DB Hashtags Part 2
• 15. Cloning Instagram’s DB Hashtags Part 2.srt
• 16. CODE IG Clone Hashtags Schema.html
• 17. CODE Complete IG Clone Schema.html
• 2. Introduction To Instagram Clone Schema.en.srt
• 2. Introduction To Instagram Clone Schema
• 2. Introduction To Instagram Clone Schema.srt
• 2.1 Slides For This Section.html
• 3. Cloning Instagram’s DB Users Schema.en.srt
• 3. Cloning Instagram’s DB Users Schema
• 3. Cloning Instagram’s DB Users Schema.srt
• 4. CODE IG Clone Users Schema.html
• 5. Cloning Instagram’s DB Photos Schema.en.srt
• 5. Cloning Instagram’s DB Photos Schema
• 5. Cloning Instagram’s DB Photos Schema.srt
• 6. CODE IG Clone Photos Schema.html
• 7. Cloning Instagram’s DB Comments Schema.en.srt
• 7. Cloning Instagram’s DB Comments Schema
• 7. Cloning Instagram’s DB Comments Schema.srt
• 8. CODE IG Clone Comments Schema.html
• 9. Cloning Instagram’s DB Likes Schema.en.srt
• 9. Cloning Instagram’s DB Likes Schema
• 9. Cloning Instagram’s DB Likes Schema.srt
• 15. Working With Lots Of Instagram Data
• 1. Section 15 Introduction.en.srt
• 1. Section 15 Introduction
• 1. Section 15 Introduction.srt
• 10. Instagram Challenge 3 Solution CODE.html
• 11. Instagram Clone Challenge 4.en.srt
• 11. Instagram Clone Challenge 4
• 11. Instagram Clone Challenge 4.srt
• 12. Instagram Challenge 4 Solution CODE.html
• 13. Instagram Clone Challenge 5.en.srt
• 13. Instagram Clone Challenge 5
• 13. Instagram Clone Challenge 5.srt
• 14. Instagram Challenge 5 Solution CODE.html
• 15. Instagram Clone Challenge 6.en.srt
• 15. Instagram Clone Challenge 6
• 15. Instagram Clone Challenge 6.srt
• 16. Instagram Challenge 6 Solution CODE.html
• 17. Note about Instagram Clone Challenge 7.html
• 18. Instagram Clone Challenge 7.en.srt
• 18. Instagram Clone Challenge 7
• 18. Instagram Clone Challenge 7.srt
• 19. Instagram Challenge 7 Solution CODE.html
• 2. Note about Loading The JUMBO dataset.html
• 3. Loading The JUMBO dataset.en.srt
• 3. Loading The JUMBO dataset
• 3. Loading The JUMBO dataset.srt
• 4. The Instagram Clone DATASET.html
• 4.1 ig_clone_data.sql
• 5. Instagram Clone Challenge 1.en.srt
• 5. Instagram Clone Challenge 1
• 5. Instagram Clone Challenge 1.srt
• 5.1 Slides.html
• 6. Instagram Challenge 1 Solution CODE.html
• 7. Instagram Clone Challenge 2.en.srt
• 7. Instagram Clone Challenge 2
• 7. Instagram Clone Challenge 2.srt
• 8. Instagram Challenge 2 Solution CODE.html
• 9. Instagram Clone Challenge 3.en.srt
• 9. Instagram Clone Challenge 3
• 9. Instagram Clone Challenge 3.srt
• 16. Section 16 – Introducing Node
• 1. Note about Introducing Node.html
• 10. Introduction to NPM and Faker.en.srt
• 10. Introduction to NPM and Faker
• 10. Introduction to NPM and Faker.srt
• 10.1 FakerJS Github Repo.html
• 11. CODE Introduction to NPM and Faker.html
• 12. Introducing the
• MySQL
• Package.en.srt 7.70kb
• 12. Introducing the MySQL Package
• 12. Introducing the MySQL Package.srt
• 12.1 MySQL Node Package Github Repo.html
• 13. Note about connecting Node to MySQL.html
• 14. Connecting Node to MySQL.en.srt
• 14. Connecting Node to MySQL
• 14. Connecting Node to MySQL.srt
• 15. CODE Connecting Node to MySQL.html
• 16. Creating Our Users Table.en.srt
• 16. Creating Our Users Table
• 16. Creating Our Users Table.srt
• 17. CODE Creating Our Users Table.html
• 18. Selecting Using Node.en.srt
• 18. Selecting Using Node
• 18. Selecting Using Node.srt
• 19. CODE Selecting Using Node.html
• 2. Section 16 Introduction.en.srt
• 2. Section 16 Introduction
• 2. Section 16 Introduction.srt
• 20. Inserting Using Node.en.srt
• 20. Inserting Using Node
• 20. Inserting Using Node.srt
• 21. CODE Inserting Using Node.html
• 22. Some MySQLNode Magic.en.srt
• 22. Some MySQLNode Magic
• 22. Some MySQLNode Magic.srt
• 23. Bulk Inserting 500 Users – Finally!.en.srt
• 23. Bulk Inserting 500 Users – Finally!
• 23. Bulk Inserting 500 Users – Finally!.srt
• 24. CODE Bulk Inserting 500 Users.html
• 25. 500 Users Exercises.en.srt
• 25. 500 Users Exercises
• 25. 500 Users Exercises.srt
• 25.1 Slides.html
• 26. 500 Users Exercises Solutions.en.srt
• 26. 500 Users Exercises Solutions
• 26. 500 Users Exercises Solutions.srt
• 27. CODE 500 Users Exercises Solutions.html
• 3. MySQL and Other Languages.en.srt
• 3. MySQL and Other Languages
• 3. MySQL and Other Languages.srt
• 3.1 Slides For This Section.html
• 4. BUT WHAT ABOUT PHP.en.srt
• 4. BUT WHAT ABOUT PHP
• 4. BUT WHAT ABOUT PHP.srt
• 5. Introduction to JOIN US app.en.srt
• 5. Introduction to JOIN US app
• 5. Introduction to JOIN US app.srt
• 6. Note about Setting Up Cloud9 for Node.html
• 7. 5 Minute NodeJS Crash Course.en.srt
• 7. 5 Minute NodeJS Crash Course
• 7. 5 Minute NodeJS Crash Course.srt
• 8. CODE 5 Minute Node Crash Course.html
• 9. Note about Faker install.html
• 17. Section 17 – Building Our Web App
• 1. Section 17 Introduction.en.srt
• 1. Section 17 Introduction
• 1. Section 17 Introduction.srt
• 10. Connecting Express and MySQL.en.srt
• 10. Connecting Express and MySQL
• 10. Connecting Express and MySQL.srt
• 11. CODE Connecting Express and MySQL.html
• 12. Adding EJS Templates.en.srt
• 12. Adding EJS Templates
• 12. Adding EJS Templates.srt
• 13. CODE Adding EJS Templates.html
• 14. Connecting The Form.en.srt
• 14. Connecting The Form
• 14. Connecting The Form.srt
• 15. CODE Connecting the Form.html
• 16. Styling Part 1.en.srt
• 16. Styling Part 1
• 16. Styling Part 1.srt
• 17. CODE HTML AND CSS FILES.html
• 17.1 JOIN_US_HTML_AND_CSS
• 18. Styling Part 2.en.srt
• 18. Styling Part 2
• 18. Styling Part 2.srt
• 2. Join Us Completed CODE.html
• 2.1 JoinUsCompleteCode
• 3. Introducing Express.en.srt
• 3. Introducing Express
• 3. Introducing Express.srt
• 3.1 Slides.html
• 3.2 Express Documentation.html
• 4. NPM Init and package.json files.en.srt
• 4. NPM Init and package.json files
• 4. NPM Init and package.json files.srt
• 5. Note about Our First Simple Web App.html
• 6. Our First Simple Web App.en.srt
• 6. Our First Simple Web App
• 6. Our First Simple Web App.srt
• 7. CODE Our First Simple Web App.html
• 8. Adding Multiple Routes.en.srt
• 8. Adding Multiple Routes
• 8. Adding Multiple Routes.srt
• 9. CODE Adding Multiple Routes.html
• 18. Section 18 – Database Triggers
• 1. Introduction to Database Triggers.en.srt
• 1. Introduction to Database Triggers
• 1. Introduction to Database Triggers.srt
• 1.1 Lecture Slides.html
• 2. Writing Our First Trigger Part 1.en.srt
• 2. Writing Our First Trigger Part 1
• 2. Writing Our First Trigger Part 1.srt
• 2.1 Lecture Slides.html
• 3. Writing Our First Trigger Part 2.en.srt
• 3. Writing Our First Trigger Part 2
• 3. Writing Our First Trigger Part 2.srt
• 3.1 Lecture Slides.html
• 4. Note about next lecture.html
• 5. Preventing Instagram Self-Follows With Triggers.en.srt
• 5. Preventing Instagram Self-Follows With Triggers
• 5. Preventing Instagram Self-Follows With Triggers.srt
• 5.1 Lecture Slides.html
• 6. Creating Logger Triggers.en.srt
• 6. Creating Logger Triggers
• 6. Creating Logger Triggers.srt
• 6.1 Lecture Slides.html
• 7. Managing Triggers And A Warning.en.srt
• 7. Managing Triggers And A Warning
• 7. Managing Triggers And A Warning.srt
• 7.1 Lecture Slides.html
• 2. Getting Started Overview and Installation
• 1. Section Introduction.en.srt
• 1. Section Introduction
• 1. Section Introduction.srt
• 2. What Is a Database.en.srt
• 2. What Is a Database
• 2. What Is a Database.srt
• 2.1 Slides For This Section.html
• 3. SQL Vs. MySQL.en.srt
• 3. SQL Vs. MySQL
• 3. SQL Vs. MySQL.srt
• 4. Installation Overview – WATCH BEFORE INSTALLING.en.srt
• 4. Installation Overview – WATCH BEFORE INSTALLING
• 4. Installation Overview – WATCH BEFORE INSTALLING.srt
• 4.1 Installation Slides.html
• 5. Cloud9 Registration IMPORTANT – PLEASE READ!!!.html
• 6. Mac Installation.en.srt
• 6. Mac Installation
• 6. Mac Installation.srt
• 7. CODE Mac Installation.html
• 8. Windows Installation.en.srt
• 8. Windows Installation
• 8. Windows Installation.srt
• 3. Creating Databases and Tables
• 1. Section 3 Introduction.en.srt
• 1. Section 3 Introduction
• 1. Section 3 Introduction.srt
• 10. Note about INT max size.html
• 11. Basic Datatypes Challenge.en.srt
• 11. Basic Datatypes Challenge
• 11. Basic Datatypes Challenge.srt
• 12. Basic Datatypes Challenge – Solution.html
• 13. Creating Your Own Tables.en.srt
• 13. Creating Your Own Tables
• 13. Creating Your Own Tables.srt
• 14. CODE Creating Your Own Tables.html
• 15. How Do We Know It Worked.en.srt
• 15. How Do We Know It Worked
• 15. How Do We Know It Worked.srt
• 16. CODE How Do We Know It Worked.html
• 17. Dropping Tables.en.srt
• 17. Dropping Tables
• 17. Dropping Tables.srt
• 18. CODE Dropping Tables.html
• 19. Creating Your Own Tables Challenge.en.srt
• 19. Creating Your Own Tables Challenge
• 19. Creating Your Own Tables Challenge.srt
• 19.1 Slides.html
• 2. Creating Databases.en.srt
• 2. Creating Databases
• 2. Creating Databases.srt
• 2.1 Slides For This Section!.html
• 20. CODE Creating Your Own Tables Challenge.html
• 3. CODE Creating Databases.html
• 4. Dropping Databases.en.srt
• 4. Dropping Databases
• 4. Dropping Databases.srt
• 5. CODE Dropping Databases.html
• 6. Using Databases.en.srt
• 6. Using Databases
• 6. Using Databases.srt
• 7. CODE Using Databases.html
• 8. Introduction to Tables.en.srt
• 8. Introduction to Tables
• 8. Introduction to Tables.srt
• 9. The Basic Datatypes.en.srt
• 9. The Basic Datatypes
• 9. The Basic Datatypes.srt
• 4. Inserting Data (and a couple other things)
• 1. Section 4 Introduction.en.srt
• 1. Section 4 Introduction
• 1. Section 4 Introduction.srt
• 10. INSERT Challenges Solution.en.srt
• 10. INSERT Challenges Solution
• 10. INSERT Challenges Solution.srt
• 11. CODE INSERT Challenges Solution.html
• 12. NOTE MySQL Warnings.html
• 13. MySQL Warnings.en.srt
• 13. MySQL Warnings
• 13. MySQL Warnings.srt
• 14. CODE MySQL Warnings.html
• 15. NULL and NOT_NULL.en.srt
• 15. NULL and NOT_NULL
• 15. NULL and NOT_NULL.srt
• 16. CODE NULL and NOT NULL.html
• 17. Setting Default Values.en.srt
• 17. Setting Default Values
• 17. Setting Default Values.srt
• 18. CODE Setting Default Values.html
• 19. A Primer On Primary Keys.en.srt
• 19. A Primer On Primary Keys
• 19. A Primer On Primary Keys.srt
• 2. Inserting Data.en.srt
• 2. Inserting Data
• 2. Inserting Data.srt
• 2.1 Slides For This Section.html
• 20. CODE A Primer on Primary Keys.html
• 21. Table Constraints Exercise.en.srt
• 21. Table Constraints Exercise
• 21. Table Constraints Exercise.srt
• 21.1 Exercise Slides.html
• 22. Table Constraints Exercise Solution.en.srt
• 22. Table Constraints Exercise Solution
• 22. Table Constraints Exercise Solution.srt
• 23. CODE Table Constraints Exercise Solution.html
• 3. CODE Inserting Data.html
• 4. Super Quick Intro To SELECT.en.srt
• 4. Super Quick Intro To SELECT
• 4. Super Quick Intro To SELECT.srt
• 5. CODE Super Quick Intro To SELECT.html
• 6. Multiple INSERT.en.srt
• 6. Multiple INSERT
• 6. Multiple INSERT.srt
• 7. CODE Multiple Insert.html
• 8. INSERT Challenges.en.srt
• 8. INSERT Challenges
• 8. INSERT Challenges.srt
• 9. Note about using quotes inside of inserted values.html
• 5. CRUD commmands
• 1. Section 5 Introduction.en.srt
• 1. Section 5 Introduction
• 1. Section 5 Introduction.srt
• 10. SELECT Challenges.en.srt
• 10. SELECT Challenges
• 10. SELECT Challenges.srt
• 11. SELECT Challenges Solution.en.srt
• 11. SELECT Challenges Solution
• 11. SELECT Challenges Solution.srt
• 12. CODE SELECT Challenges Solution.html
• 13. Introduction to Aliases.en.srt
• 13. Introduction to Aliases
• 13. Introduction to Aliases.srt
• 14. CODE Introduction to Aliases.html
• 15. The UPDATE Command.en.srt
• 15. The UPDATE Command
• 15. The UPDATE Command.srt
• 16. CODE The UPDATE Command.html
• 17. UPDATE Challenges.en.srt
• 17. UPDATE Challenges
• 17. UPDATE Challenges.srt
• 18. UPDATE Challenges Solution.en.srt
• 18. UPDATE Challenges Solution
• 18. UPDATE Challenges Solution.srt
• 19. CODE UPDATE Challenges Solution.html
• 2. Introduction to CRUD.en.srt
• 2. Introduction to CRUD
• 2. Introduction to CRUD.srt
• 2.1 This Section’s Slides.html
• 20. Introduction to DELETE.en.srt
• 20. Introduction to DELETE
• 20. Introduction to DELETE.srt
• 21. CODE Introduction to DELETE.html
• 22. DELETE Challenges.en.srt
• 22. DELETE Challenges
• 22. DELETE Challenges.srt
• 22.1 Slides.html
• 23. DELETE Challenges Solution.en.srt
• 23. DELETE Challenges Solution
• 23. DELETE Challenges Solution.srt
• 24. CODE DELETE Challenges Solution.html
• 3. CODE Introduction to CRUD.html
• 4. Preparing Our Data.en.srt
• 4. Preparing Our Data
• 4. Preparing Our Data.srt
• 5. CODE Preparing Our Data.html
• 6. Official Introduction to SELECT.en.srt
• 6. Official Introduction to SELECT
• 6. Official Introduction to SELECT.srt
• 7. CODE Official Introduction to SELECT.html
• 8. Introduction to WHERE.en.srt
• 8. Introduction to WHERE
• 8. Introduction to WHERE.srt
• 9. CODE Introduction to WHERE.html
• 6. CRUD Challenge Section
• 1. Section 6 Introduction.en.srt
• 1. Section 6 Introduction
• 1. Section 6 Introduction.srt
• 10. CODE CRUD Exercise Delete Solution.html
• 2. CRUD Exercise Overview.en.srt
• 2. CRUD Exercise Overview
• 2. CRUD Exercise Overview.srt
• 2.1 Slides.html
• 3. CRUD Exercise Create Solution.en.srt
• 3. CRUD Exercise Create Solution
• 3. CRUD Exercise Create Solution.srt
• 4. CODE CRUD Exercise Create Solution.html
• 5. CRUD Exercise Read Solution.en.srt
• 5. CRUD Exercise Read Solution
• 5. CRUD Exercise Read Solution.srt
• 6. CODE CRUD Exercise Read Solution.html
• 7. CRUD Exercise Update Solution.en.srt
• 7. CRUD Exercise Update Solution
• 7. CRUD Exercise Update Solution.srt
• 8. CODE CRUD Exercise Update Solution.html
• 9. CRUD Exercise Delete Solution.en.srt
• 9. CRUD Exercise Delete Solution
• 9. CRUD Exercise Delete Solution.srt
• 7. The World Of String Functions
• 1. Section 7 Introduction.en.srt
• 1. Section 7 Introduction
• 1. Section 7 Introduction.srt
• 10. CODE Introducing SUBSTRING.html
• 11. Introducing REPLACE.en.srt
• 11. Introducing REPLACE
• 11. Introducing REPLACE.srt
• 12. CODE Introducing REPLACE.html
• 13. Using REVERSE.en.srt
• 13. Using REVERSE
• 13. Using REVERSE.srt
• 14. CODE Using REVERSE.html
• 15. Working with CHAR LENGTH.en.srt
• 15. Working with CHAR LENGTH
• 15. Working with CHAR LENGTH.srt
• 16. CODE Working with CHAR LENGTH.html
• 17. Changing Case with UPPER and LOWER.en.srt
• 17. Changing Case with UPPER and LOWER
• 17. Changing Case with UPPER and LOWER.srt
• 18. CODE Changing Case with UPPER and LOWER.html
• 19. Note about string functions.html
• 2. Important Note about Running SQL Files (please read).html
• 20. String Function Challenges.en.srt
• 20. String Function Challenges
• 20. String Function Challenges.srt
• 20.1 Slides.html
• 21. String Function Challenges Solution.en.srt
• 21. String Function Challenges Solution
• 21. String Function Challenges Solution.srt
• 22. CODE String Function Challenges Solution.html
• 3. Running SQL Files.en.srt
• 3. Running SQL Files
• 3. Running SQL Files.srt
• 3.1 Slides For This Section.html
• 4. CODE Running SQL Files.html
• 5. Loading Our Book Data.en.srt
• 5. Loading Our Book Data
• 5. Loading Our Book Data.srt
• 5.1 book_data.sql
• 6. CODE Loading Our Book Data.html
• 7. Working with CONCAT.en.srt
• 7. Working with CONCAT
• 7. Working with CONCAT.srt
• 8. CODE Working With CONCAT.html
• 9. Introducing SUBSTRING.en.srt
• 9. Introducing SUBSTRING
• 9. Introducing SUBSTRING.srt
• 8. Refining Our Selections
• 1. Section 8 Introduction.en.srt
• 1. Section 8 Introduction
• 1. Section 8 Introduction.srt
• 10. Better Searches with LIKE.en.srt
• 10. Better Searches with LIKE
• 10. Better Searches with LIKE.srt
• 11. CODE Better Searches with LIKE.html
• 12. LIKE Part 2 More Wildcards.en.srt
• 12. LIKE Part 2 More Wildcards
• 12. LIKE Part 2 More Wildcards.srt
• 13. CODE LIKE Part 2 More Wildcards.html
• 14. Refining Selections Exercises.en.srt
• 14. Refining Selections Exercises
• 14. Refining Selections Exercises.srt
• 14.1 Slides.html
• 15. Refining Selections Exercises Solution.en.srt
• 15. Refining Selections Exercises Solution
• 15. Refining Selections Exercises Solution.srt
• 16. CODE Refining Selections Exercises Solution.html
• 2. Seed Data Adding A Couple New Books.en.srt
• 2. Seed Data Adding A Couple New Books
• 2. Seed Data Adding A Couple New Books.srt
• 2.1 Slides For This Section.html
• 3. CODE Seed Data Adding A Couple New Books.html
• 4. Using DISTINCT.en.srt
• 4. Using DISTINCT
• 4. Using DISTINCT.srt
• 5. CODE Using DISTINCT.html
• 6. Sorting Data with ORDER BY.en.srt
• 6. Sorting Data with ORDER BY
• 6. Sorting Data with ORDER BY.srt
• 7. CODE Sorting Data with ORDER BY.html
• 8. Using LIMIT.en.srt
• 8. Using LIMIT
• 8. Using LIMIT.srt
• 9. CODE Using LIMIT.html
• 9. The Magic of Aggregate Functions
• 1. Section 9 Introduction.en.srt
• 1. Section 9 Introduction
• 1. Section 9 Introduction.srt
• 10. Using Min and Max with Group By.en.srt
• 10. Using Min and Max with Group By
• 10. Using Min and Max with Group By.srt
• 11. CODE Using Min and Max with Group By.html
• 12. The Sum Function.en.srt
• 12. The Sum Function
• 12. The Sum Function.srt
• 13. CODE The Sum Function.html
• 14. The Avg Function.en.srt
• 14. The Avg Function
• 14. The Avg Function.srt
• 15. CODE The Avg Function.html
• 16. Aggregate Functions Challenges.en.srt
• 16. Aggregate Functions Challenges
• 16. Aggregate Functions Challenges.srt
• 16.1 Slides.html
• 17. Aggregate Functions Challenges Solution.en.srt
• 17. Aggregate Functions Challenges Solution
• 17. Aggregate Functions Challenges Solution.srt
• 18. CODE Aggregate Functions Challenges Solution.html
• 2. The Count Function.en.srt
• 2. The Count Function
• 2. The Count Function.srt
• 2.1 Slides For This Section.html
• 3. CODE The Count Function.html
• 4. The Joys of Group By.en.srt
• 4. The Joys of Group By
• 4. The Joys of Group By.srt
• 5. CODE The Joys of Group By.html
• 6. Min and Max Basics.en.srt
• 6. Min and Max Basics
• 6. Min and Max Basics.srt
• 7. CODE MIN and MAX Basics.html
• 8. SUBQUERIES – A Problem with Min and Max.en.srt
• 8. SUBQUERIES – A Problem with Min and Max
• 8. SUBQUERIES – A Problem with Min and Max.srt
• 9. CODE A Problem with Min and Max.html