Play all

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

Description:

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.

SQL Tutorial for Beginners - Advanced SQL Tutorials

Extern Code

Add to list

#Programming #Domain-Specific Languages (DSL) #SQL #Databases #Relational Databases #MySQL #Cloud Computing #Oracle #Data Science #Data Manipulation #Computer Science #Database Management #Subqueries #Aggregate Functions

0:00 / 0:00