THE ULTIMATE MYSQL BOOTCAMP: GO FROM SQL BEGINNER TO EXPERT

What Will I Learn?

  • Create your own database or interact with existing databases
  • Write complex SQL queries across multiple tables
  • Build a web app using NodeJS and MySQL
  • Model real-world data and generate reports using SQL
  • Answer company performance or sales questions using data

Requirements

  • No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome to resources point.
  • 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

In this course, you will learn:

  • 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!

Size : 2.67G