YoVDO

SQL Crash Course - Beginner to Intermediate

Offered By: Traversy Media via YouTube

Tags

SQL Courses Relational Databases Courses Database Management Courses Table Joins Courses

Course Description

Overview

Learn the fundamentals of SQL (Structured Query Language) in this comprehensive video tutorial. Cover essential topics from beginner to intermediate level, including database and table creation, data manipulation, querying with various operators, data types, and record management. Explore advanced concepts such as table joins, aliases, constraints (primary and foreign keys), and indexes. Gain hands-on experience with practical examples using popular database systems and tools like MySQL and phpMyAdmin. Master SQL skills to effectively manage and analyze data, preparing you for real-world database management scenarios.

Syllabus

Introduction
What Youll Learn
What is SQL
Popular Databases
SQL Tools
Installing SQL
Setting up PHP MyAdmin
Creating a Database
Creating a Table
Inserting Data
Updating Data
Deleting Customers
Alter Table
Select
Operators
Indexes
Insert Data
Inner Join
aliases
aggregate functions
group by
you case


Taught by

Traversy Media

Related Courses

Introduction to Databases
Meta via Coursera
Intro to Relational Databases
Udacity
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Web Application Development: Basic Concepts
University of New Mexico via Coursera