Programming & Development

LM111 MySQL Bootcamp (LM111)


Description
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

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 answering complex business problems and questions using insights from data. MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.

In this course, you will:

Learn the ins and outs of SQL syntax

Generate reports using sales and user data

Analyze data using Aggregate Functions

Run complex queries using MySQL logical operators and string functions

Write all the common SQL joins

Work with large datasets containing thousands of entries

Build a web app using MySQL and NodeJS

Design and implement complex database schemas

Learn to navigate the treacherous world of storing dates and times

Clone the database structure of a photo sharing social network

Write Javascript code to generate fake data sets

And more!

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 such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site.

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.
Content
  • LM111.1 Overview and Installation
  • LM111.1.1 What Is a Database.mp4
  • LM111.1.2 SQL vs MySQL.mp4
  • LM111.1.3 Installation Overview - Watch Before Installing.mp4
  • LM111.1.4 First SQL Activity.mp4
  • LM111.1.5 Code First MySQL Activity
  • LM111.1.6 Mac Installation.mp4
  • LM111.1.7 Windows Installation.mp4
  • Feedback - LM111.1
  • LM111.2 Create Databases and Tables
  • LM111.2.1 Create Databases.mp4
  • LM111.2.2 CODE Creating Databases
  • LM111.2.3 Dropping Databases.mp4
  • LM111.2.4 CODE Dropping Databases
  • LM111.2.5 How to use Databases.mp4
  • LM111.2.6 CODE Using Databases
  • LM111.2.7 Introducing Tables.mp4
  • LM111.2.10 Basic Datatype Challenge.mp4
  • LM111.2.11 Create your own Tables.mp4
  • LM111.2.12 CODE Creating Your Own Tables
  • LM111.2.13 How to know it Worked.mp4
  • LM111.2.14 CODE How do we know it worked
  • LM111.2.15 Dropping Tables.mp4
  • LM111.2.16 CODE Dropping Tables
  • LM111.2.17 Create your Table Challenge.mp4
  • LM111.2.18 CODE Creating Tables Challenges
  • Feedback - LM111.2
  • LM111.3 Insert Data and more
  • LM111.3.1 Inserting Data.mp4
  • LM111.3.2 CODE for Inserting Data
  • LM111.3.3 Intro To SELECT.mp4
  • LM111.3.4 CODE to Intro To SELECT
  • LM111.3.5 Multiple SELECT.mp4
  • LM111.3.6 CODE fro Multiple Insert
  • LM111.3.7 Insert Challenges.mp4
  • LM111.3.8 Insert Challenges Solution.mp4
  • LM111.3.9 CODE for Insert Challenges Solution
  • LM111.3.10 MySQL Warnings.mp4
  • LM111.3.11 CODE fro MySQL Warnings
  • LM111.3.12 NULL and NOT NULL.mp4
  • LM111.3.13 Code for NULL and NOT NULL
  • LM111.3.14 Setting Default Values.mp4
  • LM111.3.15 CODE for Setting Default
  • LM111.3.16 Primer on Primary Keys.mp4
  • LM111.3.17 Code a Primer on Primary Keys
  • LM111.3.18 Table Constraints Exercise.mp4
  • LM111.3.19 CODE for Table Constraints Exercise Solution
  • Feedback - LM111.3
  • LM111.4 CRUD commands
  • LM111.4.1 CODE Introduction to CRUD
  • LM111.4.2 Prepare Data.mp4
  • LM111.4.3 CODE Preparing Our Data
  • LM111.4.4 Officially Introducing SELECT.mp4
  • LM111.4.5 CODE Official Introduction to SELECT
  • LM111.4.6 Introducing WHERE.mp4
  • LM111.4.7 SELECT Challenges.mp4
  • LM111.4.8 Introduction to WHERE
  • LM111.4.9 SELECT Challenge Solution.mp4
  • LM111.4.9 CODE SELECT Challenges Solutions
  • LM111.4.10 Introducing Aliases.mp4
  • LM111.4.11 CODE Introduction to Aliase
  • LM111.4.12 The UPDATE Commad.mp4
  • LM111.4.13 CODE The UPDATE Command
  • LM111.4.14 UPDATE Challenges.mp4
  • LM111.4.15 UPDATE Challenges Solution.mp4
  • LM111.4.16 CODE UPDATE Challenges Solution
  • LM111.4.17 Intoducing DELETE.mp4
  • LM111.4.18 CODE Introduction to DELETE
  • LM111.4.19 DELETE Challenges.mp4
  • LM111.4.20 DELETE Challenge Solution.mp4
  • LM111.4.21 CODE DELETE Challenges Solution
  • Feedback - LM111.4
  • LM111.5 CRUD Challenge Section
  • LM111.5.1 CRUD Exercise Overview.mp4
  • LM111.5.2 CRUD Exercise Create Solution.mp4
  • LM111.5.3 CODE CRUD Exercise Create Solution
  • LM111.5.4 CRUD Exercise Read Solution.mp4
  • LM111.5.5 CODE CRUD Exercise Read Solution
  • LM111.5.6 CRUD Exercise Delete Solution.mp4
  • LM111.5.7 CODE CRUD Exercise Delete Solution
  • LM111.5.8 CRUD Exercise Update Solution.mp4
  • LM111.5.9 CODE CRUD Exercise Update Solution
  • Feedback - LM111.5
  • LM111.6 World of string functions
  • LM111.6.1 Running SQL Files.mp4
  • LM111.6.2 CODE Running SQL Files
  • LM111.6.3 Load Our Book Data.mp4
  • LM111.6.4 CODE Loading Our Book Data
  • LM111.6.5 Work with CONCAT.mp4
  • LM111.6.6 CODE Working with CONCAT
  • LM111.6.7 Introduction to SUBSTRING.mp4
  • LM111.6.8 CODE Introducing SUBSTRING
  • LM111.6.9 Introduction to REPLACE.mp4
  • LM111.6.10 CODE Introducing REPLACE
  • LM111.6.11 How to use REVERSE.mp4
  • LM111.6.12 CODE Using REVERSE
  • LM111.6.13 Work with CHAR LENGTH.mp4
  • LM111.6.14 CODE Working with CHAR LENGHT
  • LM111.6.15 Changing Case with UPPER and LOWER.mp4
  • LM111.6.16 CODE Changing Case with UPPER and LOWER
  • LM111.6.17 String Function Challenges.mp4
  • LM111.6.18 CODE String Function Challenges Solution
  • Feedback - LM111.6
  • LM111.7 Refining Section
  • LM111.7.1 Seed Data Adding Couple New Books.mp4
  • LM111.7.2 CODE Seed Data Adding A couple New Books
  • LM111.7.3 Using DISTINCT.mp4
  • LM111.7.4 CODE Using DISTINCT
  • LM111.7.5 Sort Data with ORDER BY.mp4
  • LM111.7.6 CODE Sorting Data with ORDER BY
  • LM111.7.7 Use LIMIT.mp4
  • LM111.7.8 CODE Using LIMIT
  • LM111.7.9 Better Searches with LIKE.mp4
  • LM111.7.10 CODE Better Searches with LIKE
  • LM111.7.11 LIKE Part 2 More Wildcards.mp4
  • LM111.7.12 CODE LIKE Part 2 More Wildcards
  • LM111.7.13 Refine Selections Exercises.mp4
  • LM111.7.14 Refine Selections Exercises Solutions.mp4
  • LM111.7.15 CODE Refining Selections Exercises Solutions
  • Feedback - LM111.7
  • LM111.8 Aggregate Functions
  • LM111.8.1 The Count Function.mp4
  • LM111.8.2 CODE The Count Function
  • LM111.8.3 The Joys of Group By.mp4
  • LM111.8.4 CODE The Joys of Group By
  • LM111.8.5 Min and Max Basics.mp4
  • LM111.8.6 CODE Min and Max Basics
  • LM111.8.7 Subqueries - a Problem with Min and Max.mp4
  • LM111.8.8 CODE a Problem with Min and Max
  • LM111.8.9 Using Min and Max with Group By.mp4
  • LM111.8.10 CODE Using Min and Max with Group By
  • LM111.8.11 The Sum Function.mp4
  • LM111.8.12 CODE The Sum Function
  • LM111.8.13 The Avg Function.mp4
  • LM111.8.14 CODE The Avg Function
  • LM111.8.15 Aggregate Functions Challenges.mp4
  • LM111.8.16 Aggregate Functions Challenges Solution.mp4
  • LM111.8.17 CODE Aggregate Functions Challenges Solution
  • Feedback - LM111.8
  • LM111.9 Revisiting Data Types
  • LM111.9.1. Char and Varchar.mp4
  • LM111.9.2 CODE Char and VARCHAR
  • LM111.9.3 Decimal.mp4
  • LM111.9.4 CODE for Decimal
  • LM111.9.5 Float and Decimal.mp4
  • LM111.9.6 CODE FLOAT and DOUBLE
  • LM111.9.7 Date Time and DateTime.mp4
  • LM111.9.8 Creating our Date Data.mp4
  • LM111.9.9 CODE for Creating Our Date data
  • LM111.9.10 Curdate Curtime and Now.mp4
  • LM111.9.11 Note about formatting dates
  • LM111.9.12 Formatting Dates.mp4
  • LM111.9.13 CODE for Formatting Dates
  • LM111.9.14 Date Math.mp4
  • LM111.9.15 CODE for Date Math
  • LM111.9.16 Working with Timestamps.mp4
  • LM111.9.17 CODE for Working with Timestamps
  • LM111.9.18 Data Types Exercises .mp4
  • LM111.9.19 Data Types Exercises Solution.mp4
  • LM111.9.20 CODE for Data Types Exercises Solutions
  • Feedback - LM111.9
  • LM111.10 Power of logical operators
  • LM111.10.1 Not Equal.mp4
  • LM111.10.2 CODE Not Equal
  • LM111.10.3 Not Like.mp4
  • LM111.10.4 CODE Not Like
  • LM111.10.5 Greater Than.mp4
  • LM111.10.6 CODE Greater Than
  • LM111.10.7 Less Than.mp4
  • LM111.10.8 CODE Less Than
  • LM111.10.9 Logical And.mp4
  • LM111.10.10 CODE Logical And
  • Feedback - LM111.10
  • LM111.11 one to many
  • LM111.11.1 Real World Data is Messy.mp4
  • LM111.11.2 Types of Data Relationships.mp4
  • LM111.11.3 Basics of One To Many.mp4
  • LM111.11.4 Working with Foreign Keys.mp4
  • LM111.11.5 CODE Working With Keys
  • LM111.11.6 Cross Join.mp4
  • LM111.11.7 CODE Cross Joins
  • LM111.11.8 Inner Join.mp4
  • LM111.11.9 CODE Inner Joins
  • LM111.11.10 Left Join.mp4
  • LM111.11.11 CODE Left Joins
  • LM111.11.12 Right Join Pt1.mp4
  • LM111.11.13 CODE Right Joins Part1
  • LM111.11.14 Right Join Pt2.mp4
  • LM111.11.15 CODE Right Joins Part2
  • LM111.11.16 Right and Left Joins A common Question.mp4
  • LM111.11.17 CODE Right and Left Joins FAQ
  • LM111.11.18 First Joins Exercise.mp4
  • LM111.11.19 First Joins Exercise SOLUTION.mp4
  • LM111.11.20 CODE First Joins Exercise
  • LM111.11.21 First Joins Exercise SOLUTION PT_2.mp4
  • LM111.11.22 CODE First Exercise SolutionsPT_2
  • Feedback - LM111.11
  • LM111.12 Many to Many
  • LM111.12.1 Many To Many Basics.mp4
  • LM111.12.2 Create Our Tables.mp4
  • LM111.12.3 CODE Creating Our Tables
  • LM111.12.4 TV Joins Challenge 1.mp4
  • LM111.12.5 CODE TV Joins Challenge 1 Solution
  • LM111.12.6 TV Joins Challenge 2.mp4
  • LM111.12.7 CODE TV Joins Challenge 2 SOLUTION
  • LM111.12.8 TV Joins Challenge 3.mp4
  • LM111.12.9 CODE TV Joins Challenge 3 SOLUTION
  • LM111.12.10 TV Joins Challenge 4.mp4
  • LM111.12.11 CODE TV Joins Challenge 4 SOLUTION
  • LM111.12.12 TV Joins Challenge 5.mp4
  • LM111.12.13 CODE TV Joins Challenge 5 SOLUTION
  • LM111.12.14 TV Joins Challenge 6.mp4
  • LM111.12.15 CODE TV Joins Challenge 6 SOLUTION
  • LM111.12.16 TV Joins Challenge 7.mp4
  • LM111.12.17 CODE TV Joins Challenge 7 SOLUTION
  • Feedback - LM111.12
  • LM111.13 Instagram Database Clone
  • LM111.13.1 Cloning Instagram DB Users Schema.mp4
  • LM111.13.2 CODE IG Clone Users Schema
  • LM111.13.3 Cloning Instagram DB Photos Schema.mp4
  • LM111.13.4 CODE IG Clone Photos Schema
  • LM111.13.5 Cloning Instagram DB comments schema.mp4
  • LM111.13.6 CODE IG Clone Comments Schema
  • LM111.13.7 Cloning Instagram DB LIkes Schema.mp4
  • LM111.13.8 CODE IG Clone Likes Schema
  • LM111.13.9 Cloning Instagram DB Followers Schema.mp4
  • LM111.13.10 CODE IG Clone Followers Schema
  • LM111.13.11 Cloning Instagrams DB Hashtags Part 1.mp4
  • LM111.13.12 CODE IG Clone Hashtags Schema
  • LM111.13.12 Cloning Instagrams DB Hashtags Part 2.mp4
  • LM111.13.14 CODE Complete IG Clone Schema
  • Feedback - LM111.13
  • LM111.14 working with instagram data
  • LM111.14.1 Loading The JUMBO dataset.mp4
  • LM111.14.2 Instagram Clone Challenge 1.mp4
  • LM111.14.3 CODE Instagram Challenge 1 Solution
  • LM111.14.4 Instagram Clone Challenge 2.mp4
  • LM111.14.5 CODE Instagram Challenge 2 Solution
  • LM111.14.6 Instagram Clone Challenge 3.mp4
  • LM111.14.7 CODE Instagram Challenge 3 Solution
  • LM111.14.8 Instagram Clone Challenge 4.mp4
  • LM111.14.9 CODE Instagram Challenge 4 Solution
  • LM111.14.10 Instagram Clone Challenge 5.mp4
  • LM111.14.11 CODE Instagram Challenge 5 Solution
  • LM111.14.12 Instagram Clone Challenge 6.mp4
  • LM111.14.13 CODE Instagram Challenge 6 Solution
  • LM111.14.14 Instagram Clone Challenge 7.mp4
  • LM111.14.15 CODE Instagram Challenge 7 Solution
  • Feedback - LM111.14
  • Lm111.15 Introduction to Nodes
  • LM111.15.1 MySQL and Other Languages.mp4
  • LM111.15.2 Introducing JOIN US app.mp4
  • LM111.15.4 Minute NodeJS Crash Course.mp4
  • LM111.15.5 CODE 5 Minute Node Crash Course
  • LM111.15.6 Introducing NPM and Faker.mp4
  • LM111.15.7 CODE Introduction to NPM and Faker
  • LM111.15.8 Introduction to MySQL Package.mp4
  • LM111.15.9 Connecting Node to MySQL.mp4
  • LM111.15.10 CODE Connecting Node to MySQL
  • LM111.15.12 CODE Creating Our Users Table
  • LM111.15.13 Selecting Using Node.mp4
  • LM111.15.14 CODE Selecting Using Node
  • LM111.15.15 Selecting Using Node.mp4
  • LM111.15.16 CODE Inserting Using Node
  • LM111.15.17 Some MySQL Node Magic.mp4
  • LM111.15.18 Bulk Inserting 500 Users.mp4
  • LM111.15.19 CODE Bulk Inserting 500 Users
  • LM111.15.20 500 Users Exercise.mp4
  • LM111.15.21 500 Users Exercises Solutions.mp4
  • LM111.15.22 CODE 500 Users Exercises Solutions
  • Feedback - LM111.15
  • LM111.16 Building Web App
  • LM111.16.1 Introduction to Express.mp4
  • LM111.16.2 NPM Init and package_json files.mp4
  • LM111.16.3 First Simple Web App.mp4
  • LM111.16.4 CODE First Simple Web App
  • LM111.16.5 Adding Multiple Routes.mp4
  • LM111.16.7 CODE Adding Multiple Routes
  • LM111.16.8 Connecting Express and MySQL.mp4
  • LM111.16.9 CODE Connecting Express and MySQL
  • LM111.16.10 Adding EJS Templates.mp4
  • LM111.16.10 Adding EJS Templates.mp4
  • LM111.16.11 CODE Adding EJS Temlates
  • LM111.16.12 Connecting The Form.mp4
  • LM111.16.13 CODE Connecting the Form
  • LM111.16.14 Styling Part 1.mp4
  • LM111.16.15 Styling Part 2.mp4
  • Feedback - LM111.16
  • LM111.17 Database Triggers
  • LM111.17.1 Introducing Database Triggers.mp4
  • LM111.17.2 Writing Trigger Part1.mp4
  • LM111.17.3 Writing Trigger Part 2.mp4
  • LM111.17.4 Preventing Instagram Self-Follows with Triggers.mp4
  • LM111.17.5 Creating Logger Triggers.mp4
  • LM111.17.6 Manage Triggers and a Warning.mp4
  • Course Feedback
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever