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

Focused View

John s Curry

3:36:06

2 View

1. Introduction & Setup

1. Introduction.mp4

02:27

2. Installing Sublime Text - Windows.mp4

02:36

3. Installing Sublime Text - Mac OS X.mp4

03:20

4. Installing WampServer on Windows.mp4

08:42

5. Installing Mamp on Mac OS X.mp4

11:01

2. Tables & Databases

1.1 create-and-delete-databases-in-sql-phpmyadmin.txt

1. Create and Delete Databases in Sql and PhpMyAdmin.mp4

07:04

2. Create Tables in PhpMyAdmin.mp4

11:27

3. Assignment Create a table with phpmyadmin.mp4

00:52

4. Solution Create a table with PhpMyAdmin.mp4

05:37

5.1 create-table-with-sql.txt

5. Create Table with SQL.mp4

09:53

3. Working with Data

1.1 insert-into-table-with-sql.txt

1. Insert into table with SQL.mp4

05:34

2. Note about duplicating tables video.html

3.1 duplicate-tables.txt

3. Duplicating Tables.mp4

03:36

4.1 delete-rows-sql.txt

4. Deleting Rows in SQL.mp4

06:34

5.1 alter-table-structure.txt

5. Alter Table structure.mp4

17:23

6.1 updating-rows.txt

6. Updating Rows.mp4

09:34

7.1 select-where.txt

7. Retrieve data with SELECT & Where.mp4

19:25

4. JOINS & Relationships

1.1 inner-joins.txt

1. Inner Joins.mp4

17:36

2.1 left-right-joins.txt

2. Left & Right Joins.mp4

12:28

3.1 outer-joins.txt

3. Outer Joins & Unions.mp4

05:14

4.1 foreign-key-constraints.txt

4. Foreign Key Constraints.mp4

16:14

5.1 one-to-many.txt

5. One to Many Relationships.mp4

14:26

6.1 many-to-many.txt

6. Many to Many Relationships.mp4

25:03

Description

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.

Who is this for?

Beginner programmers who have no experience, or anyone who wants to learn SQL

What You Need to Know?

No experience required.

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Hello!My name is John. I have around 5 years experience in web development technologies. I've mostly worked in React & GraphQL, but also have professional experience with Node.js, PHP, WordPress, and C++I work at a software agency where we manage the needs of various clients with multiple programming languages.I've been working with GraphQL for about one year and have used it in a few work-related projects.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.