SQL Fundamentals 2022 Edition - site name

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Introduction

SQL Course – Prerequisites 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Install Sublime Text – Windows

Install Sublime Text – Mac OS X

Installing a MySQL Environment 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Installing WAMPServer on Windows

Installing XAMPP on Windows

Installing MAMP on Mac

SQL Course Notes and Files

Create and Delete a Database in SQL & PhpMyAdmin

The Basics

Create Tables in PhpMyAdmin

Assignment: Create a table

Solution: Create a table with PhpMyAdmin

Assignment: Create tables for your own app idea!

Create a Table with SQL

Insert into table with SQL

Deleting records Part 1.

Duplicating a Table

Deleting Rows in SQL

Altering Table Structure

Updating Rows in SQL

Retrieving Records with Select & Where

Inner Joins (Combining Tables)

Left & Right Joins

Outer Join & Unions

1 of 2