One Month Sql

Go from a Beginner to Intermediate in SQL & Databases

What you'll learn

Become fluent in the fundamentals of SQL

Learn how to create a SQL database from scratch

Read, write, query, and analyze data

Learn how to use 20+ of the most popular SQL commands including SELECT, INSERT, JOIN, WHERE, ORDER BY, LIMIT, and more.

Requirements

Beginners welcome!

Description

Learn SQL in just 30 DaysHi! My name is Chris Castiglione, and I'm going to be your instructor for this One Month course!I’ve been teaching SQL courses in person for the past eight years to thousands of people worldwide, including developers, CEOs, and MBA students. After all that time one-on-one with my students, I’m excited to finally bring my SQL course online to the students here at One Month like you!In One Month's Learn SQL you will:Become fluent in the fundamentals of SQLLearn how to create a SQL database from scratchRead, write, query, and analyze dataLearn how to use 20+ of the most popular SQL commands including SELECT, INSERT, JOIN, WHERE, ORDER BY, LIMIT, and more.In Learn SQL we’ll cover everything you need to be proficient enough to comfortably use SQL in your applications or in performing data analysis. And the good news is, there are hardly any prerequisites to get started—you don’t have to have previous coding skills, you just need a computer and I’ll help you get your first database up and running.See you in class! Chris1. What's SQL?SQL is the language of databases. If you plan to pursue machine learning, artificial intelligence, build websites or apps, or work with data analytics, you need to know SQL.2. What companies use SQL?Netflix, Airbnb, Uber, Twitter, Amazon, Google, Dropbox, and Shopify.3. How popular is SQL?SQL is the third most popular programming language (according to Stack Overflow).4. What's the difference between Python and SQL?SQL and Python serve different functions. You need to learn them both! The five fundamental languages of the web are: HTML, CSS, JavaScript, Python, and SQL. Together, if you learn all five, you will have superpowers.5. Can an absolute beginner learn SQL?Yes! You don’t need any previous coding experience to start learning SQL. All you need is access to a MYSQL database, and some datasets to play with (we'll give those to you!). SQL works on Mac, Windows, Chromebook and Linux.

Overview

Section 1: Section 1: Week 1: Learn SQL in One Month

Lecture 1 Step 1: Welcome to Learn SQL at One Month!

Lecture 2 Step 2: How Does SQL Work With a LAMP, PHP or Python Tech Stack?

Lecture 3 Step 3: 6 Reasons to Learn SQL

Lecture 4 Step 4: What is SQL?

Lecture 5 Step 5: Getting Setup With a SQL Database

Lecture 6 Step 6: How to Set Up Web Hosting and a MYSQL Database

Lecture 7 Step 7: How to Use cPanel

Lecture 8 Step 8: How to Create a New Database

Section 2: Section 2: WEEK 2: Basic SQL Commands

Lecture 9 Step 2: How to IMPORT Data into a Database

Lecture 10 Step 1: Download Course Files

Lecture 11 Step 3: How to EXPORT Data from a Database

Lecture 12 Step 4: SQL SELECT Statements

Lecture 13 Step 5: Using a SELECT Statement on Big Data

Lecture 14 Step 6: SQL SELECT LIMIT

Lecture 15 Step 7: SQL WHERE

Lecture 16 Step 8: SQL LIKE

Lecture 17 Step 9: AGGREGATE OPERATORS in SQL

Lecture 18 Step 11: SQL Code Quiz!

Lecture 19 Step 10: How PHP and Python Scripts Use SQL

Lecture 20 Step 12: Answers to the SQL Code Quiz

Lecture 21 Step 13: SQL INSERT INTO

Lecture 22 Step 14: SQL UPDATE Statement

Lecture 23 Step 15: SQL DELETE Statement

Lecture 24 Step 16: CRUD Examples

Section 3: Section 3: WEEK 3: Intermediate SQL Commands

Lecture 25 Step 1: How to Create a New Table with SQL CREATE TABLE

Lecture 26 Step 2: Building a Facebook Users Table

Lecture 27 Step 3: SQL Structure Command

Lecture 28 Step 4: Data Types in SQL

Lecture 29 Step 5: SQL Join

Lecture 30 Step 6: SQL Join Part II

Lecture 31 Step 8: Assignment #1: JOIN our Comments Table

Lecture 32 Step 7: AS in SQL

Lecture 33 Step 9: Answer #1: JOIN our Comments Table

Lecture 34 Step 10: Assignment #2: A New Table for our E-Commerce Store

Lecture 35 Step 11: Answer #2: A New Table for our E-Commerce Store

Lecture 36 Step 12: Assignment #3: Display Zero Comments (Make Chris Cry)

Lecture 37 Step 13: Answer #3 Display Zero Comments

Section 4: Section 4: WEEK 4: Advanced SQL Commands

Lecture 38 Step 1: FULL OUTER JOIN

Lecture 39 Step 2: UNION Statement

Lecture 40 Step 3: GROUP BY

Lecture 41 Step 4: Subquery and IN

Lecture 42 Step 5: Truncate vs. Drop

Lecture 43 Step 6: What to do next with your new Superpowers!

Section 5: Section 5: Extra Tutorials

Lecture 44 Step 2: How to Install MAMP (Mac or Windows)

Lecture 45 Step 3: MySQL with MAMP

Lecture 46 Step 4: MAMP as a Server

Lecture 47 Step 1: Why Do We Need a Server?

Beginners