SQL Crash Course: Zero experience to Jr. Full Stack Dev.

Learn everything SQL related that a Jr. Full Stack Developer needs to know.


What you'll learn
Learn the fundamentals of SQL
Develop Junior to Mid Level developer skills in MySQL
Understand the role databases have in an application
Learn how to search, create, update, delete and manage data in a full stack application.

Requirements
No experience required.
Description
In this course we're going to cover everything that a Junior Developer would need to know when working with databases and SQL. At the end of this course you will be able to confidently build the database portion of any web or mobile application.



In this course we'll cover the following:

Installing a full development environment with SQL, PHP, Apache Webserver

Creating Tables and Databases to store information

Adding and deleting rows of information in a table.

Updating data in a table

Various ways of querying and retrieving data from the tables

Duplicating tables

Altering the structure of a table, such as the column name, data type, and adding or removing columns

Foreign Key constraints and data integrity.

Joining tables together and preventing duplicate data.

One to Many Relationships

Many to Many relationships

And More tutorials coming in the future!



This SQL course is designed to be QUICK. We want to get you up to speed in SQL fast, so you can start building out your full stack application immediately.



Why Join this SQL Course?

Each lesson is self-contained. You can watch any video in any order because the full working code is included with each video.

Get started immediately. We've covered all of the most important concepts in the beginning.

Practice exercises and solutions to help you get comfortable with what you've learned.

We're always adding more content as we learn more and encounter new challenges.



Who this course is for:
Beginner programmers who have no experience, or anyone who wants to learn SQL