The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

JUST COMPLETELY REDONE! Master SQL, Work With Complex Databases, Build Reports, and More!
The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert
File Size :
14.67 GB
Total length :
37h 33m

Category

Instructor

Colt Steele

Language

Last update

Last updated 11/2022

Ratings

4.6/5

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

What you’ll learn

Create your own database or interact with existing databases
Write complex SQL join queries across multiple tables
Master MySQL 8 Window Functions (LEAD, LAG, RANK, etc.)
Model real-world data and generate reports using SQL
Answer company performance or sales questions using data
Learns the ins and out of MySQL 8.x syntax

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

Requirements

No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
No previous programming language experience required, but it won’t hurt 🙂

Description

This course was just completely redone and rebuilt from the ground up, with over 325 brand new videos recorded. The course now uses MySQL 8.x and covers new topics including: Window Functions, Views, and SQL modes.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. The Ultimate 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 syntaxGenerate reports using sales and user dataAnalyze data using Aggregate FunctionsRun complex queries using MySQL logical operators and string functionsWrite all the common SQL joinsWork with large datasets containing thousands of entriesDesign and implement complex database schemasLearn to navigate the treacherous world of storing dates and timesClone the database structure of a photo sharing social networkWork with MySQL 8.x Window Functions: RANK, LEAD, LAG, NTILE, etc.Create MySQL database views and virtual tablesThis 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. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)Why Learn MySQLConsistently 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, Udemy, Slack, 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.Why This Course Is Different  This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.   Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.So let’s do this! Enroll today and start learning SQL!

Overview

Section 1: Introduction & 5 Minutes of SQL

Lecture 1 This Course Was Just Updated!

Lecture 2 Course Intro

Lecture 3 About Me

Lecture 4 Getting The Course Code

Lecture 5 First 5 Minutes of SQL

Section 2: Getting Started & Installation

Lecture 6 Section Introduction

Lecture 7 What Is A Database?

Lecture 8 SQL vs. MySQL

Lecture 9 Installation: START HERE!

Lecture 10 Installation: Windows Instructions

Lecture 11 Installation: Mac Instructions

Lecture 12 Mac Installation Commands

Section 3: Creating Databases & Tables

Lecture 13 Section Introduction

Lecture 14 Showing Databases

Lecture 15 CODE: Showing Databases

Lecture 16 Creating Databases

Lecture 17 CODE: Creating Databases

Lecture 18 Dropping and Using Databases

Lecture 19 CODE: Dropping and Using Databases

Lecture 20 Introducing Tables

Lecture 21 Data Types: The Basics

Lecture 22 Basic Datatypes Challenge

Lecture 23 CODE: Basic Datatypes Challenge

Lecture 24 Creating Tables

Lecture 25 CODE: Creating Tables

Lecture 26 How Do We Know It Worked?

Lecture 27 CODE: How Do We Know It Worked?

Lecture 28 Dropping Tables

Lecture 29 CODE: Dropping Tables

Lecture 30 Tables Basics Activity

Lecture 31 SOLUTION: Tables Basics Activity

Lecture 32 MySQL Comments

Section 4: Inserting Data

Lecture 33 Section Introduction

Lecture 34 INSERT: The Basics

Lecture 35 CODE: INSERT: The Basics

Lecture 36 A Quick Preview of SELECT

Lecture 37 CODE: A Quick Preview of SELECT

Lecture 38 Multi-inserts

Lecture 39 CODE: Multi-inserts

Lecture 40 INSERT Exercise

Lecture 41 SOLUTION: INSERT Exercise

Lecture 42 Working With NOT NULL

Lecture 43 CODE: Working With NOT NULL

Lecture 44 Sidenote: Quotes In MySQL

Lecture 45 Adding DEFAULT Values

Lecture 46 CODE: Adding DEFAULT Values

Lecture 47 Introducing Primary Keys

Lecture 48 CODE: Introducing Primary Keys

Lecture 49 Working With AUTO_INCREMENT

Lecture 50 CODE: Working With AUTO_INCREMENT

Lecture 51 Create Table/ Insert Exercise

Lecture 52 SOLUTION: Insert Exercise

Section 5: CRUD Basics

Lecture 53 Section Introduction

Lecture 54 Introducing CRUD

Lecture 55 Getting Our New “Dataset”

Lecture 56 CODE

Lecture 57 Officially Introducing SELECT

Lecture 58 CODE

Lecture 59 The WHERE clause

Lecture 60 CODE

Lecture 61 Rapid Fire Exercises

Lecture 62 Rapid Fire Exercises SOLUTION

Lecture 63 SOLUTION CODE

Lecture 64 Aliases

Lecture 65 CODE

Lecture 66 Using UPDATE

Lecture 67 CODE

Lecture 68 A Quick Rule Of Thumb

Lecture 69 UPDATE Exercise

Lecture 70 UPDATE Exercise SOLUTION

Lecture 71 SOLUTION CODE

Lecture 72 Introducing DELETE

Lecture 73 CODE

Lecture 74 DELETE Exercise

Lecture 75 DELETE Exercise SOLUTION

Lecture 76 SOLUTION CODE

Section 6: CRUD Challenge

Lecture 77 Section Introduction

Lecture 78 Introducing the CRUD Challenge

Lecture 79 CRUD Challenge Solution: Creating

Lecture 80 SOLUTION CODE

Lecture 81 CRUD Challenge Solution: Reading

Lecture 82 SOLUTION CODE

Lecture 83 CRUD Challenge Solution: Updating

Lecture 84 SOLUTION CODE

Lecture 85 CRUD Challenge Solution: Deleting

Lecture 86 SOLUTION CODE

Section 7: String Functions

Lecture 87 Section Introduction

Lecture 88 The World Of String Functions

Lecture 89 Loading Our Books Data

Lecture 90 CODE

Lecture 91 CONCAT

Lecture 92 CODE

Lecture 93 SUBSTRING

Lecture 94 CODE

Lecture 95 Combining String Functions

Lecture 96 CODE

Lecture 97 Sidenote: SQL Formatting

Lecture 98 REPLACE

Lecture 99 CODE

Lecture 100 REVERSE

Lecture 101 CODE

Lecture 102 CHAR_LENGTH

Lecture 103 CODE

Lecture 104 UPPER & LOWER

Lecture 105 CODE

Lecture 106 Other String Functions

Lecture 107 CODE

Lecture 108 String Functions Exercise

Lecture 109 String Functions Exerise SOLUTION

Lecture 110 SOLUTION CODE

Section 8: Refining Selections

Lecture 111 Section Introduction

Lecture 112 Adding Some New Books

Lecture 113 CODE

Lecture 114 DISTINCT

Lecture 115 CODE

Lecture 116 ORDER BY

Lecture 117 CODE

Lecture 118 More On ORDER BY

Lecture 119 CODE

Lecture 120 LIMIT

Lecture 121 CODE

Lecture 122 LIKE

Lecture 123 CODE

Lecture 124 Escaping Wildcards

Lecture 125 CODE

Lecture 126 Refining Selections Exercise

Lecture 127 Refining Selections Exercise SOLUTION

Lecture 128 SOLUTION CODE

Section 9: Aggregate Functions

Lecture 129 Section Introduction

Lecture 130 Count Basics

Lecture 131 CODE

Lecture 132 GROUP BY

Lecture 133 CODE

Lecture 134 MIN and MAX Basics

Lecture 135 CODE

Lecture 136 Subqueries

Lecture 137 CODE

Lecture 138 Grouping By Multiple Columns

Lecture 139 CODE

Lecture 140 MIN and MAX With GROUP BY

Lecture 141 CODE

Lecture 142 SUM

Lecture 143 CODE

Lecture 144 AVG

Lecture 145 CODE

Lecture 146 Aggregate Functions Docs

Lecture 147 Agg Functions Exercise

Lecture 148 Agg Functions Exercise SOLUTION

Lecture 149 SOLUTION CODE

Section 10: Revisiting Data Types

Lecture 150 Section Introduction

Lecture 151 Surveying Other Data Types

Lecture 152 CHAR vs. VARCHAR

Lecture 153 INT, TINYINT, BIGINT, etc.

Lecture 154 DECIMAL

Lecture 155 FLOAT & DOUBLE

Lecture 156 DATE and TIME

Lecture 157 Working With Dates

Lecture 158 CODE

Lecture 159 CURDATE, CURTIME, & NOW

Lecture 160 CODE

Lecture 161 Date Functions

Lecture 162 CODE

Lecture 163 Time Functions

Lecture 164 CODE

Lecture 165 Formatting Dates

Lecture 166 CODE

Lecture 167 Date Math

Lecture 168 TIMESTAMPS

Lecture 169 DEFAULT & ON UPDATE TIMESTAMPS

Lecture 170 CODE

Lecture 171 Data Types Exercise

Lecture 172 Data Types Exercise SOLUTION

Lecture 173 SOLUTION CODE

Section 11: Comparison & Logical Operators

Lecture 174 Section Introduction

Lecture 175 Not Equal

Lecture 176 CODE

Lecture 177 NOT LIKE

Lecture 178 CODE

Lecture 179 Greater Than

Lecture 180 CODE

Lecture 181 Less Than Or Equal To

Lecture 182 CODE

Lecture 183 Logical AND

Lecture 184 CODE

Lecture 185 Logical OR

Lecture 186 CODE

Lecture 187 Between

Lecture 188 CODE

Lecture 189 Comparing Dates

Lecture 190 CODE

Lecture 191 The IN Operator

Lecture 192 CODE

Lecture 193 CASE

Lecture 194 CODE

Lecture 195 IS NULL

Lecture 196 Exercise

Lecture 197 Exercise SOLUTION

Lecture 198 SOLUTION CODE

Section 12: Constraints & ALTER TABLE

Lecture 199 UNIQUE Constraint

Lecture 200 CODE

Lecture 201 CHECK Constraints

Lecture 202 CODE

Lecture 203 Named Constraints

Lecture 204 CODE

Lecture 205 Multiple Column Constraints

Lecture 206 CODE

Lecture 207 ALTER TABLE: Adding Columns

Lecture 208 CODE

Lecture 209 ALTER TABLE: Dropping Columns

Lecture 210 CODE

Lecture 211 ALTER TABLE: Renaming

Lecture 212 CODE

Lecture 213 ALTER TABLE: Modifying Columns

Lecture 214 CODE

Lecture 215 ALTER TABLE: Constraints

Lecture 216 CODE

Section 13: One to Many & Joins

Lecture 217 Section Introduction

Lecture 218 Data is Messy

Lecture 219 Relationships Basics

Lecture 220 One to Many Relationship

Lecture 221 Working with FOREIGN KEY

Lecture 222 CODE

Lecture 223 Cross Joins

Lecture 224 CODE

Lecture 225 Inner Joins

Lecture 226 CODE

Lecture 227 Inner Joins With Group By

Lecture 228 CODE

Lecture 229 Left Join

Lecture 230 CODE

Lecture 231 Left Join With Group By

Lecture 232 CODE

Lecture 233 Right Join

Lecture 234 CODE

Lecture 235 On Delete Cascade

Lecture 236 CODE

Lecture 237 Joins Exercise

Lecture 238 EXERCISE STARTER DATA

Lecture 239 Joins Exercise SOLUTION

Lecture 240 SOLUTION CODE

Section 14: Many to Many

Lecture 241 Section Introduction

Lecture 242 Many to Many Basics

Lecture 243 Creating Our Many To Many Tables

Lecture 244 CODE

Lecture 245 TV Series Challenge #1

Lecture 246 CODE

Lecture 247 TV Series Challenge #2

Lecture 248 CODE

Lecture 249 TV Series Challenge #3

Lecture 250 CODE

Lecture 251 TV Series Challenge #4

Lecture 252 CODE

Lecture 253 TV Series Challenge #5

Lecture 254 CODE

Lecture 255 TV Series Challenge #6

Lecture 256 CODE

Lecture 257 TV Series Challenge #7

Lecture 258 CODE

Section 15: Views, Modes, & More!

Lecture 259 Introducing Views

Lecture 260 CODE

Lecture 261 Updateable Views

Lecture 262 Replacing/Altering Views

Lecture 263 CODE

Lecture 264 HAVING clause

Lecture 265 CODE

Lecture 266 WITH ROLLUP

Lecture 267 CODE

Lecture 268 SQL Modes Basics

Lecture 269 CODE

Lecture 270 STRICT_TRANS_TABLES

Lecture 271 More Modes

Section 16: Window Functions

Lecture 272 Important Note (please read)

Lecture 273 Introducing Window Functions

Lecture 274 Using OVER()

Lecture 275 CODE

Lecture 276 PARTITION BY

Lecture 277 CODE

Lecture 278 ORDER BY with Windows

Lecture 279 CODE

Lecture 280 RANK()

Lecture 281 DENSE_RANK, & ROW_NUMBER()

Lecture 282 CODE

Lecture 283 NTILE()

Lecture 284 CODE

Lecture 285 FIRST_VALUE

Lecture 286 CODE

Lecture 287 LEAD and LAG

Lecture 288 CODE

Section 17: Instagram Database Clone

Lecture 289 Section Introduction

Lecture 290 IMPORTANT NOTE ABOUT THIS SECTION!

Lecture 291 Introducing Instagram Clone

Lecture 292 Users Schema

Lecture 293 CODE

Lecture 294 Photos Schema

Lecture 295 CODE

Lecture 296 Comments Schema

Lecture 297 CODE

Lecture 298 Likes Schema

Lecture 299 CODE

Lecture 300 Followers Schema

Lecture 301 CODE

Lecture 302 Note!

Lecture 303 3 Approaches for Hashtags

Lecture 304 Implementing Hashtags Table

Lecture 305 CODE

Lecture 306 Complete Instagram Schema

Section 18: Working With Lots of IG Data

Lecture 307 Section Introduction

Lecture 308 Getting Lots of Instagram Data

Lecture 309 CODE

Lecture 310 Instagram Challenge #1

Lecture 311 CODE

Lecture 312 Instagram Challenge #2

Lecture 313 CODE

Lecture 314 Instagram Challenge #3

Lecture 315 CODE

Lecture 316 Instagram Challenge #4

Lecture 317 CODE

Lecture 318 Instagram Challenge #5

Lecture 319 CODE

Lecture 320 Instagram Challenge #6

Lecture 321 CODE

Lecture 322 Instagram Challenge #7

Lecture 323 CODE

Section 19: What Next?

Lecture 324 Additional SQL Resources

Section 20: LEGACY: Introduction and 5 Minutes of SQL

Lecture 325 Course Introduction

Lecture 326 Instructor Introduction(s)

Lecture 327 Syllabus Walkthrough and Prerequisites

Lecture 328 Note about SQL Editor

Lecture 329 Your First 5 Minutes of SQL – Let’s Get Coding!

Lecture 330 CODE: Your First 5 Minutes of SQL

Lecture 331 How The Course Works

Section 21: LEGACY: Getting Started: Overview and Installation

Lecture 332 Section Introduction

Lecture 333 What Is a Database?

Lecture 334 SQL Vs. MySQL

Lecture 335 Important note about the next lecture

Lecture 336 Installation Overview – WATCH BEFORE INSTALLING

Lecture 337 Now using GoormIDE instead of Cloud9

Lecture 338 GoormIDE Registration IMPORTANT – PLEASE READ!!!

Lecture 339 MySQL Tips to Make Your Life Easier

Lecture 340 Mac Installation

Lecture 341 CODE: Mac Installation

Lecture 342 Windows Installation

Section 22: LEGACY: Creating Databases and Tables

Lecture 343 Section 3 Introduction

Lecture 344 Creating Databases

Lecture 345 CODE: Creating Databases

Lecture 346 Dropping Databases

Lecture 347 CODE: Dropping Databases

Lecture 348 Using Databases

Lecture 349 CODE: Using Databases

Lecture 350 Introduction to Tables

Lecture 351 The Basic Datatypes

Lecture 352 Note about INT max size

Lecture 353 Basic Datatypes Challenge

Lecture 354 Basic Datatypes Challenge – Solution

Lecture 355 Creating Your Own Tables

Lecture 356 CODE: Creating Your Own Tables

Lecture 357 How Do We Know It Worked?

Lecture 358 CODE: How Do We Know It Worked?

Lecture 359 Dropping Tables

Lecture 360 CODE: Dropping Tables

Lecture 361 Creating Your Own Tables Challenge

Lecture 362 CODE: Creating Your Own Tables Challenge

Section 23: LEGACY: Inserting Data (and a couple other things)

Lecture 363 Section 4 Introduction

Lecture 364 Inserting Data

Lecture 365 CODE: Inserting Data

Lecture 366 Super Quick Intro To SELECT

Lecture 367 CODE: Super Quick Intro To SELECT

Lecture 368 Multiple INSERT

Lecture 369 CODE: Multiple Insert

Lecture 370 INSERT Challenges

Lecture 371 Note about using quotes inside of inserted values

Lecture 372 INSERT Challenges Solution

Lecture 373 CODE: INSERT Challenges Solution

Lecture 374 NOTE: MySQL Warnings

Lecture 375 MySQL Warnings

Lecture 376 CODE: MySQL Warnings

Lecture 377 NULL and NOT_NULL

Lecture 378 CODE: NULL and NOT NULL

Lecture 379 Setting Default Values

Lecture 380 CODE: Setting Default Values

Lecture 381 A Primer On Primary Keys

Lecture 382 CODE: A Primer on Primary Keys

Lecture 383 Table Constraints Exercise

Lecture 384 Table Constraints Exercise Solution

Lecture 385 CODE: Table Constraints Exercise Solution

Section 24: LEGACY: CRUD commmands

Lecture 386 Section 5 Introduction

Lecture 387 Introduction to CRUD

Lecture 388 CODE: Introduction to CRUD

Lecture 389 Preparing Our Data

Lecture 390 CODE: Preparing Our Data

Lecture 391 Official Introduction to SELECT

Lecture 392 CODE: Official Introduction to SELECT

Lecture 393 Introduction to WHERE

Lecture 394 CODE: Introduction to WHERE

Lecture 395 SELECT Challenges

Lecture 396 SELECT Challenges Solution

Lecture 397 CODE: SELECT Challenges Solution

Lecture 398 Introduction to Aliases

Lecture 399 CODE: Introduction to Aliases

Lecture 400 The UPDATE Command

Lecture 401 CODE: The UPDATE Command

Lecture 402 UPDATE Challenges

Lecture 403 UPDATE Challenges Solution

Lecture 404 CODE: UPDATE Challenges Solution

Lecture 405 Introduction to DELETE

Lecture 406 CODE: Introduction to DELETE

Lecture 407 DELETE Challenges

Lecture 408 DELETE Challenges Solution

Lecture 409 CODE: DELETE Challenges Solution

Section 25: LEGACY: CRUD Challenge Section

Lecture 410 Section 6 Introduction

Lecture 411 CRUD Exercise Overview

Lecture 412 CRUD Exercise Create Solution

Lecture 413 CODE: CRUD Exercise Create Solution

Lecture 414 CRUD Exercise Read Solution

Lecture 415 CODE: CRUD Exercise Read Solution

Lecture 416 CRUD Exercise Update Solution

Lecture 417 CODE: CRUD Exercise Update Solution

Lecture 418 CRUD Exercise Delete Solution

Lecture 419 CODE: CRUD Exercise Delete Solution

Section 26: LEGACY: The World Of String Functions

Lecture 420 Section 7 Introduction

Lecture 421 Important Note about Running SQL Files (please read)

Lecture 422 Running SQL Files

Lecture 423 CODE: Running SQL Files

Lecture 424 Loading Our Book Data

Lecture 425 CODE: Loading Our Book Data

Lecture 426 Working with CONCAT

Lecture 427 CODE: Working With CONCAT

Lecture 428 Introducing SUBSTRING

Lecture 429 CODE: Introducing SUBSTRING

Lecture 430 Introducing REPLACE

Lecture 431 CODE: Introducing REPLACE

Lecture 432 Using REVERSE

Lecture 433 CODE: Using REVERSE

Lecture 434 Working with CHAR LENGTH

Lecture 435 CODE: Working with CHAR LENGTH

Lecture 436 Changing Case with UPPER and LOWER

Lecture 437 CODE: Changing Case with UPPER and LOWER

Lecture 438 Note about string functions

Lecture 439 String Function Challenges

Lecture 440 String Function Challenges Solution

Lecture 441 CODE: String Function Challenges Solution

Section 27: LEGACY: Refining Our Selections

Lecture 442 Section 8 Introduction

Lecture 443 Seed Data: Adding A Couple New Books

Lecture 444 CODE: Seed Data: Adding A Couple New Books

Lecture 445 Using DISTINCT

Lecture 446 CODE: Using DISTINCT

Lecture 447 Sorting Data with ORDER BY

Lecture 448 CODE: Sorting Data with ORDER BY

Lecture 449 Using LIMIT

Lecture 450 CODE: Using LIMIT

Lecture 451 Better Searches with LIKE

Lecture 452 CODE: Better Searches with LIKE

Lecture 453 LIKE Part 2: More Wildcards

Lecture 454 CODE: LIKE Part 2: More Wildcards

Lecture 455 Refining Selections Exercises

Lecture 456 Refining Selections Exercises Solution

Lecture 457 CODE: Refining Selections Exercises Solution

Section 28: LEGACY: The Magic of Aggregate Functions

Lecture 458 Section 9 Introduction

Lecture 459 The Count Function

Lecture 460 CODE: The Count Function

Lecture 461 The Joys of Group By

Lecture 462 Note about SQL Mode only_full_group_by

Lecture 463 CODE: The Joys of Group By

Lecture 464 Min and Max Basics

Lecture 465 CODE: MIN and MAX Basics

Lecture 466 SUBQUERIES – A Problem with Min and Max

Lecture 467 CODE: A Problem with Min and Max

Lecture 468 Using Min and Max with Group By

Lecture 469 CODE: Using Min and Max with Group By

Lecture 470 The Sum Function

Lecture 471 CODE: The Sum Function

Lecture 472 The Avg Function

Lecture 473 CODE: The Avg Function

Lecture 474 Aggregate Functions Challenges

Lecture 475 Aggregate Functions Challenges Solution

Lecture 476 CODE: Aggregate Functions Challenges Solution

Section 29: LEGACY: Revisiting Data Types

Lecture 477 Section 10 Introduction

Lecture 478 CHAR and VARCHAR

Lecture 479 Note about CHAR and VARCHAR

Lecture 480 CODE: CHAR and VARCHAR

Lecture 481 DECIMAL

Lecture 482 CODE: DECIMAL

Lecture 483 FLOAT and DOUBLE

Lecture 484 CODE: FLOAT and DOUBLE

Lecture 485 Note about setting the timezone in Cloud9

Lecture 486 DATE, TIME, and DATETIME

Lecture 487 Creating Our DATE data

Lecture 488 CODE: Creating Our DATE data

Lecture 489 CURDATE, CURTIME, and NOW

Lecture 490 Note about formatting dates

Lecture 491 Formatting Dates

Lecture 492 CODE: Formatting Dates

Lecture 493 Date Math

Lecture 494 CODE: Date Math

Lecture 495 Working with TIMESTAMPS

Lecture 496 CODE: Working with TIMESTAMPS

Lecture 497 Data Types Exercises

Lecture 498 Data Types Exercises Solution

Lecture 499 CODE: Data Types Exercises Solution

Section 30: LEGACY: The Power of Logical Operators

Lecture 500 Section 11 Introduction

Lecture 501 Not Equal

Lecture 502 CODE: Not Equal

Lecture 503 Not Like

Lecture 504 CODE: Not Like

Lecture 505 Greater Than

Lecture 506 CODE: Greater Than

Lecture 507 Less Than

Lecture 508 CODE: Less Than

Lecture 509 Logical AND

Lecture 510 CODE: Logical AND

Lecture 511 Logical OR

Lecture 512 CODE: Logical OR

Lecture 513 Between

Lecture 514 CODE: Between

Lecture 515 In And Not In

Lecture 516 CODE: In And Not In

Lecture 517 Case Statements

Lecture 518 CODE: Case Statements

Lecture 519 Logical Operators Exercises

Lecture 520 Logical Operators Exercises Solution

Lecture 521 CODE: Logical Operators Exercises Solution

Section 31: LEGACY: Section 12: One To Many

Lecture 522 Section 12 Introduction

Lecture 523 Real World Data Is Messy

Lecture 524 Types of Data Relationships

Lecture 525 One To Many: The Basics

Lecture 526 Working With Foreign Keys

Lecture 527 CODE: Working With Foreign Keys

Lecture 528 Cross Join

Lecture 529 CODE: Cross Joins

Lecture 530 Inner Join

Lecture 531 CODE: Inner Joins

Lecture 532 Left Join

Lecture 533 CODE: Left Joins

Lecture 534 Right Joins Pt 1

Lecture 535 CODE: Right Joins Part 1

Lecture 536 Right Joins Pt 2

Lecture 537 CODE: Right Joins Part 2

Lecture 538 Right and Left Joins: A Common Question

Lecture 539 CODE: Right and Left Joins FAQ

Lecture 540 Our First Joins Exercise

Lecture 541 Our First Joins Exercise SOLUTION

Lecture 542 CODE: Our First Joins Exercise

Lecture 543 Our First Joins Exercise SOLUTION PT. 2

Lecture 544 CODE: Our First Joins Exercise SOLUTION PT. 2

Section 32: LEGACY: Many To Many

Lecture 545 Section 13 Introduction

Lecture 546 Many To Many Basics

Lecture 547 Creating Our Tables

Lecture 548 CODE: Creating Our Tables

Lecture 549 TV Joins Challenge 1

Lecture 550 CODE: TV Joins Challenge 1 Solution

Lecture 551 TV Joins Challenge 2

Lecture 552 CODE: TV Joins Challenge 2 SOLUTION

Lecture 553 TV Joins Challenge 3

Lecture 554 CODE: TV Joins Challenge 3 SOLUTION

Lecture 555 TV Joins Challenge 4

Lecture 556 CODE: TV Joins Challenge 4 SOLUTION

Lecture 557 TV Joins Challenge 5

Lecture 558 CODE: TV Joins Challenge 5 SOLUTION

Lecture 559 TV Joins Challenge 6

Lecture 560 CODE: TV Joins Challenge 6 SOLUTION

Lecture 561 TV Joins Challenge 7

Lecture 562 CODE: TV Joins Challenge 7 SOLUTION

Section 33: LEGACY: Instagram Database Clone

Lecture 563 Section 14 Introduction

Lecture 564 Introduction To Instagram Clone Schema

Lecture 565 Cloning Instagram’s DB: Users Schema

Lecture 566 CODE: IG Clone Users Schema

Lecture 567 Cloning Instagram’s DB: Photos Schema

Lecture 568 CODE: IG Clone Photos Schema

Lecture 569 Cloning Instagram’s DB: Comments Schema

Lecture 570 CODE: IG Clone Comments Schema

Lecture 571 Cloning Instagram’s DB: Likes Schema

Lecture 572 CODE: IG Clone Likes Schema

Lecture 573 Cloning Instagram’s DB: Followers Schema

Lecture 574 CODE: IG Clone Followers Schema

Lecture 575 Note about: Cloning Instagram’s DB: Hashtags Part 1

Lecture 576 Cloning Instagram’s DB: Hashtags Part 1

Lecture 577 Cloning Instagram’s DB: Hashtags Part 2

Lecture 578 CODE: IG Clone Hashtags Schema

Lecture 579 CODE: Complete IG Clone Schema

Section 34: LEGACY: Working With Lots Of Instagram Data

Lecture 580 Section 15 Introduction

Lecture 581 Note about Loading The JUMBO dataset

Lecture 582 Loading The JUMBO dataset

Lecture 583 The Instagram Clone DATASET

Lecture 584 Instagram Clone Challenge 1

Lecture 585 Instagram Challenge 1 Solution CODE

Lecture 586 Instagram Clone Challenge 2

Lecture 587 Instagram Challenge 2 Solution CODE

Lecture 588 Instagram Clone Challenge 3

Lecture 589 Instagram Challenge 3 Solution CODE

Lecture 590 Instagram Clone Challenge 4

Lecture 591 Instagram Challenge 4 Solution CODE

Lecture 592 Instagram Clone Challenge 5

Lecture 593 Instagram Challenge 5 Solution CODE

Lecture 594 Instagram Clone Challenge 6

Lecture 595 Instagram Challenge 6 Solution CODE

Lecture 596 Note about Instagram Clone Challenge 7

Lecture 597 Instagram Clone Challenge 7

Lecture 598 Instagram Challenge 7 Solution CODE

Section 35: LEGACY: Introducing Node

Lecture 599 Note about Introducing Node

Lecture 600 Section 16 Introduction

Lecture 601 MySQL and Other Languages

Lecture 602 BUT WHAT ABOUT PHP

Lecture 603 Introduction to JOIN US app

Lecture 604 Note about Setting Up Cloud9 for Node

Lecture 605 5 Minute NodeJS Crash Course

Lecture 606 CODE: 5 Minute Node Crash Course

Lecture 607 Note about Faker install

Lecture 608 Introduction to NPM and Faker

Lecture 609 CODE: Introduction to NPM and Faker

Lecture 610 Introducing the MySQL Package

Lecture 611 Note about connecting Node to MySQL

Lecture 612 Connecting Node to MySQL

Lecture 613 CODE: Connecting Node to MySQL

Lecture 614 Creating Our Users Table

Lecture 615 CODE: Creating Our Users Table

Lecture 616 Selecting Using Node

Lecture 617 CODE: Selecting Using Node

Lecture 618 Inserting Using Node

Lecture 619 CODE: Inserting Using Node

Lecture 620 Some MySQL/Node Magic

Lecture 621 Bulk Inserting 500 Users – Finally!

Lecture 622 CODE: Bulk Inserting 500 Users

Lecture 623 500 Users Exercises

Lecture 624 500 Users Exercises Solutions

Lecture 625 CODE: 500 Users Exercises Solutions

Section 36: LEGACY: Building Our Web App

Lecture 626 Section 17 Introduction

Lecture 627 Join Us Completed CODE

Lecture 628 Introducing Express

Lecture 629 NPM Init and package.json files

Lecture 630 Note about Our First Simple Web App

Lecture 631 Our First Simple Web App

Lecture 632 CODE: Our First Simple Web App

Lecture 633 Adding Multiple Routes

Lecture 634 CODE: Adding Multiple Routes

Lecture 635 Connecting Express and MySQL

Lecture 636 CODE: Connecting Express and MySQL

Lecture 637 Adding EJS Templates

Lecture 638 CODE: Adding EJS Templates

Lecture 639 Connecting The Form

Lecture 640 CODE: Connecting the Form

Lecture 641 Styling Part 1

Lecture 642 CODE: HTML AND CSS FILES

Lecture 643 Styling Part 2

Section 37: LEGACY: Database Triggers

Lecture 644 Introduction to Database Triggers

Lecture 645 Writing Our First Trigger Part 1

Lecture 646 Writing Our First Trigger Part 2

Lecture 647 Note about next lecture

Lecture 648 Preventing Instagram Self-Follows With Triggers

Lecture 649 Creating Logger Triggers

Lecture 650 Managing Triggers And A Warning

Section 38: Additional Resources

Lecture 651 Links to Additional SQL Learning Resources

Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills,Anyone looking to answer complex business problems and generate reports using data,Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.,Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

Course Information:

Udemy | English | 37h 33m | 14.67 GB
Created by: Colt Steele

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top