Master SQL from basics to advanced concepts in this comprehensive 3-hour 40-minute tutorial. Begin with an introduction to databases and SQL Server, then progress through creating databases, writing SQL statements, and manipulating data. Learn essential techniques like filtering, sorting, and joining tables. Explore advanced topics including subqueries, regular expressions, and aggregate functions. Dive into data modification with INSERT, UPDATE, and DELETE operations. Understand table creation, alteration, and views. Gain practical skills in database management using MySQL, Oracle, and other popular systems. Follow along with detailed examples and timestamps for easy navigation through each topic.
Overview
Syllabus
Introduction to Databases
SQL Server
Creating a Database
SHOW and SELECT
Rules for SQL Statements
Getting Multiple Columns
Distinct and LIMIT
Sorting Results
Sort Direction
Data Filtering and WHERE
Advanced Filtering Using AND and OR
IN ,NOT IN
Search Engines Work
More on Wildcards
Regular Expressions
Custom Columns
Functions
Aggregate Functions
GROUP BY
Subqueries watch this https://youtu.be/iq52vhD45A4
Another Subquery Example
Join Tables
Outer Joins
UNION
Text Searching
INSERT INTO
Insert Multiple Rows
UPDATE & DELETE
CREATE TABLE
NOT NULL & AUTO INCREMENT
ALTER / DROP / RENAME TABLE
Views
General Tips
Taught by
Extern Code
