access
Lifetime
content
5 Hours
enrolled
179
Description
Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to solving complex business problems using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges. It’s a course with ample opportunity for you to get your hands dirty writing code.- Access 34 lectures & 5 hours of content 24/7
- Learn the ins & outs of SQL syntax
- Analyze data using Aggregate Functions
- Run complex queries using MySQL logical operators & string functions
- Write all the common SQL joins
- Work w/ large datasets containing thousands of entries
- Clone the database structure of a photo-sharing social network
- Write Javascript code to generate fake data sets
Instructor
Colt Steele is a developer with a serious love for teaching. In 2016, he launched his Web Developer Bootcamp course, which has since gone on to become one of the best selling and top-rated courses on StackSkills. He was also voted StackSkills Best New Instructor of 2019.Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- PC or Mac
- Internet access required
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Introduction and 5 Minutes of SQL
- Course Introduction - 1:08
- Instructor Introduction(s) - 1:25
- Syllabus Walkthrough and Prerequisites - 4:18
- Your First 5 Minutes of SQL - Let's Get Coding! - 6:13
- CODE: Your First 5 Minutes of SQL
- How The Course Works - 3:44
- Getting Started: Overview and Installation
- Section Introduction - 1:02
- What Is a Database? - 7:16
- SQL Vs. MySQL - 5:50
- Installation Overview - WATCH BEFORE INSTALLING - 5:10
- Setting Up Cloud9 - 4:47
- Cloud9 What If I Dont Have a Credit Card
- Exploring The Cloud9 Interface - 5:51
- Cloud9 Interface Challenge - 2:42
- Installing MySQL on Cloud9 - 8:35
- CODE: Installing MySQL on Cloud9
- Your First MySQL Activity - 3:58
- CODE: Your First MySQL Activity
- Mac Installation - 11:41
- CODE: Mac Installation
- Windows Installation - 3:32
- Creating Databases and Tables
- Section 3 Introduction - 1:09
- Creating Databases - 5:20
- CODE: Creating Databases
- Dropping Databases - 1:46
- CODE: Dropping Databases
- Using Databases - 3:00
- CODE: Using Databases
- Introduction to Tables - 5:09
- The Basic Datatypes - 7:52
- Basic Datatypes Challenge - 2:35
- Basic Datatypes Challenge - Solution
- Creating Your Own Tables - 3:06
- CODE: Creating Your Own Tables
- How Do We Know It Worked? - 2:33
- CODE: How Do We Know It Worked?
- Dropping Tables - 1:36
- CODE: Dropping Tables
- Creating Your Own Tables Challenge - 4:29
- CODE: Creating Your Own Tables Challenge
- Inserting Data (and a couple other things)
- Section 4 Introduction - 1:40
- Inserting Data - 5:03
- CODE: Inserting Data
- Super Quick Intro To SELECT - 2:07
- CODE: Super Quick Intro To SELECT
- Multiple INSERT - 3:00
- CODE: Multiple Insert
- INSERT Challenges - 1:35
- INSERT Challenges Solution - 4:43
- CODE: INSERT Challenges Solution
- MySQL Warnings - 5:35
- CODE: MySQL Warnings
- NULL and NOT_NULL - 6:54
- CODE: NULL and NOT NULL
- Setting Default Values - 7:17
- CODE: Setting Default Values
- A Primer On Primary Keys - 12:21
- CODE: A Primer on Primary Keys
- Table Constraints Exercise - 1:51
- Table Constraints Exercise Solution - 3:34
- CODE: Table Constraints Exercise Solution
- CRUD commmands
- Section 5 Introduction - 1:30
- Introduction to CRUD - 1:44
- CODE: Introduction to CRUD
- Preparing Our Data - 2:29
- CODE: Preparing Our Data
- Official Introduction to SELECT - 4:18
- CODE: Official Introduction to SELECT
- Introduction to WHERE - 5:04
- CODE: Introduction to WHERE
- SELECT Challenges - 2:00
- SELECT Challenges Solution - 2:45
- CODE: SELECT Challenges Solution
- Introduction to Aliases - 2:55
- CODE: Introduction to Aliases
- The UPDATE Command - 3:58
- CODE: The UPDATE Command
- UPDATE Challenges - 0:37
- UPDATE Challenges Solution - 3:58
- CODE: UPDATE Challenges Solution
- Introduction to DELETE - 4:41
- CODE: Introduction to DELETE
- DELETE Challenges - 1:10
- DELETE Challenges Solution - 2:45
- CODE: DELETE Challenges Solution
- CRUD Challenge Section
- Section 6 Introduction - 1:52
- CRUD Exercise Overview - 7:26
- CRUD Exercise Create Solution - 5:55
- CODE: CRUD Exercise Create Solution
- CRUD Exercise Read Solution - 1:48
- CODE: CRUD Exercise Read Solution
- CRUD Exercise Update Solution - 4:10
- CODE: CRUD Exercise Update Solution
- CRUD Exercise Delete Solution - 3:21
- CODE: CRUD Exercise Delete Solution
- The World Of String Functions
- Section 7 Introduction - 2:04
- Running SQL Files - 10:15
- CODE: Running SQL Files
- Loading Our Book Data - 5:25
- CODE: Loading Our Book Data
- Working with CONCAT - 11:07
- CODE: Working With CONCAT
- Introducing SUBSTRING - 10:04
- CODE: Introducing SUBSTRING
- Introducing REPLACE - 6:39
- CODE: Introducing REPLACE
- Using REVERSE - 3:39
- CODE: Using REVERSE
- Working with CHAR LENGTH - 4:54
- CODE: Working with CHAR LENGTH
- Changing Case with UPPER and LOWER - 3:20
- CODE: Changing Case with UPPER and LOWER
- String Function Challenges - 4:42
- String Function Challenges Solution - 13:08
- CODE: String Function Challenges Solution
- Refining Our Selections
- Section 8 Introduction - 0:35
- Seed Data: Adding A Couple New Books - 2:47
- CODE: Seed Data: Adding A Couple New Books
- Using DISTINCT - 8:24
- CODE: Using DISTINCT
- Sorting Data with ORDER BY - 11:19
- CODE: Sorting Data with ORDER BY
- Using LIMIT - 9:03
- CODE: Using LIMIT
- Better Searches with LIKE - 7:42
- CODE: Better Searches with LIKE
- LIKE Part 2: More Wildcards - 6:09
- CODE: LIKE Part 2: More Wildcards
- Refining Selections Exercises - 4:52
- Refining Selections Exercises Solution - 12:29
- CODE: Refining Selections Exercises Solution
- The Magic of Aggregate Functions
- Section 9 Introduction - 3:56
- The Count Function - 8:38
- CODE: The Count Function
- The Joys of Group By - 12:22
- CODE: The Joys of Group By
- Min and Max Basics - 4:12
- CODE: MIN and MAX Basics
- SUBQUERIES - A Problem with Min and Max - 7:14
- CODE: A Problem with Min and Max
- Using Min and Max with Group By - 6:39
- CODE: Using Min and Max with Group By
- The Sum Function - 4:27
- CODE: The Sum Function
- The Avg Function - 6:00
- CODE: The Avg Function
- Aggregate Functions Challenges - 4:27
- Aggregate Functions Challenges Solution - 9:10
- CODE: Aggregate Functions Challenges Solution
- Revisiting Data Types
- Section 10 Introduction - 1:56
- CHAR and VARCHAR - 14:29
- Note about CHAR and VARCHAR
- CODE: CHAR and VARCHAR
- DECIMAL - 6:07
- CODE: DECIMAL
- FLOAT and DOUBLE - 7:44
- CODE: FLOAT and DOUBLE
- DATE, TIME, and DATETIME - 4:31
- Creating Our DATE data - 5:49
- CODE: Creating Our DATE data
- CURDATE, CURTIME, and NOW - 5:15
- Formatting Dates - 14:29
- CODE: Formatting Dates
- Date Math - 9:40
- CODE: Date Math
- Working with TIMESTAMPS - 10:54
- CODE: Working with TIMESTAMPS
- Data Types Exercises - 4:50
- Data Types Exercises Solution - 13:58
- CODE: Data Types Exercises Solution
- The Power of Logical Operators
- Section 11 Introduction - 2:44
- Not Equal - 4:26
- CODE: Not Equal
- Not Like - 2:34
- CODE: Not Like
- Greater Than - 10:04
- CODE: Greater Than
- Less Than - 3:48
- CODE: Less Than
- Logical AND - 9:47
- CODE: Logical AND
- Logical OR - 6:41
- CODE: Logical OR
- Between - 10:57
- CODE: Between
- In And Not In - 11:47
- CODE: In And Not In
- Case Statements - 11:20
- CODE: Case Statements
- Logical Operators Exercises - 6:45
- Logical Operators Exercises Solution - 17:46
- CODE: Logical Operators Exercises Solution
- Section 12 One To Many
- Section 12 Introduction - 1:57
- Real World Data Is Messy - 10:28
- Types of Data Relationships - 4:36
- One To Many: The Basics - 12:33
- Working With Foreign Keys - 12:04
- CODE: Working With Foreign Keys
- Cross Join - 7:36
- CODE: Cross Joins
- Inner Join - 12:44
- CODE: Inner Joins
- Left Join - 15:17
- CODE: Left Joins
- Right Joins Pt 1 - 10:36
- CODE: Right Joins Part 1
- Right Joins Pt 2 - 9:51
- CODE: Right Joins Part 2
- Right and Left Joins: A Common Question - 3:09
- CODE: Right and Left Joins FAQ
- Our First Joins Exercise - 6:58
- Our First Joins Exercise SOLUTION - 9:10
- CODE: Our First Joins Exercise
- Our First Joins Exercise SOLUTION PT. 2 - 9:21
- CODE: Our First Joins Exercise SOLUTION PT. 2
- Section 13 Many To Many
- Section 13 Introduction - 1:54
- Many To Many Basics - 10:48
- Creating Our Tables - 10:57
- CODE: Creating Our Tables
- TV Joins Challenge 1 - 4:49
- CODE: TV Joins Challenge 1 Solution
- TV Joins Challenge 2 - 6:22
- CODE: TV Joins Challenge 2 SOLUTION
- TV Joins Challenge 3 - 4:59
- CODE: TV Joins Challenge 3 SOLUTION
- TV Joins Challenge 4 - 5:59
- CODE: TV Joins Challenge 4 SOLUTION
- TV Joins Challenge 5 - 4:56
- CODE: TV Joins Challenge 5 SOLUTION
- TV Joins Challenge 6 - 11:57
- CODE: TV Joins Challenge 6 SOLUTION
- TV Joins Challenge 7 - 7:08
- CODE: TV Joins Challenge 7 SOLUTION
- Instagram Database Clone
- Section 14 Introduction - 1:19
- Introduction To Instagram Clone Schema - 8:31
- Cloning Instagram's DB: Users Schema - 6:08
- CODE: IG Clone Users Schema
- Cloning Instagram's DB: Photos Schema - 6:37
- CODE: IG Clone Photos Schema
- Cloning Instagram's DB: Comments Schema - 6:39
- CODE: IG Clone Comments Schema
- Cloning Instagram's DB: Likes Schema - 7:41
- CODE: IG Clone Likes Schema
- Cloning Instagram's DB: Followers Schema - 7:20
- CODE: IG Clone Followers Schema
- Cloning Instagram's DB: Hashtags Part 1 - 10:34
- Cloning Instagram's DB: Hashtags Part 2 - 5:25
- CODE: IG Clone Hashtags Schema
- CODE: Complete IG Clone Schema
- Working With Lots Of Instagram Data
- Section 15 Introduction - 1:41
- Loading The JUMBO dataset - 8:30
- The Instagram Clone DATASET
- Instagram Clone Challenge 1 - 4:52
- Instagram Challenge 1 Solution CODE
- Instagram Clone Challenge 2 - 6:41
- Instagram Challenge 2 Solution CODE
- Instagram Clone Challenge 3 - 7:22
- Instagram Challenge 3 Solution CODE
- Instagram Clone Challenge 4 - 7:05
- Instagram Challenge 4 Solution CODE
- Instagram Clone Challenge 5 - 3:13
- Instagram Challenge 5 Solution CODE
- Instagram Clone Challenge 6 - 5:29
- Instagram Challenge 6 Solution CODE
- Instagram Clone Challenge 7 - 5:14
- Instagram Challenge 7 Solution CODE
- Section 16 - Introducing Node
- Section 16 Introduction - 1:36
- MySQL and Other Languages - 8:59
- BUT WHAT ABOUT PHP - 7:34
- Introduction to JOIN US app - 8:00
- Setting Up Cloud9 for Node - 6:30
- 5 Minute NodeJS Crash Course - 6:12
- CODE: 5 Minute Node Crash Course
- Introduction to NPM and Faker - 9:11
- CODE: Introduction to NPM and Faker
- Introducing the MySQL Package - 4:53
- Connecting Node to MySQL - 12:46
- CODE: Connecting Node to MySQL
- Creating Our Users Table - 6:54
- CODE: Creating Our Users Table
- Selecting Using Node - 6:15
- CODE: Selecting Using Node
- Inserting Using Node - 11:31
- CODE: Inserting Using Node
- Some MySQL/Node Magic - 7:41
- Bulk Inserting 500 Users - Finally! - 8:40
- CODE: Bulk Inserting 500 Users
- 500 Users Exercises - 2:30
- 500 Users Exercises Solutions - 11:55
- CODE: 500 Users Exercises Solutions
- Section 17 - Building Our Web App
- Section 17 Introduction - 1:52
- Join Us Completed CODE
- Introducing Express - 5:40
- NPM Init and package.json files - 6:38
- Our First Simple Web App - 16:33
- CODE: Our First Simple Web App
- Adding Multiple Routes - 9:56
- CODE: Adding Multiple Routes
- Connecting Express and MySQL - 11:08
- CODE: Connecting Express and MySQL
- Adding EJS Templates - 16:02
- CODE: Adding EJS Templates
- Connecting The Form - 18:32
- CODE: Connecting the Form
- Styling Part 1 - 8:24
- CODE: HTML AND CSS FILES
- Styling Part 2 - 8:16
- Section 18 - Database Triggers
- Introduction to Database Triggers - 6:10
- Writing Our First Trigger Part 1 - 7:27
- Writing Our First Trigger Part 2 - 11:36
- Preventing Instagram Self-Follows With Triggers - 8:16
- Creating Logger Triggers - 10:17
- Managing Triggers And A Warning - 6:12
access
Lifetime
content
5 Hours
enrolled
179
