SQL ASC and DESC | Data Engineer 365

Autoplay
Autocomplete

Previous Lesson Complete and Continue

SQL for Beginners 2023 — Learn SQL Step by Step

Introduction

Course Overview (1:33)
Why Should I learn SQL? (0:57)
Why Should You Listen To Me? (1:13)

Databases

Database Overview (5:05)
Relational Databases
Healthcare System Database Use Case (1:49)

Relational Database Management System (RDBMS)

Relational Database Management System (RDBMS) (2:18)
Relational vs NoSQL Databases (3:14)
What is SQL? (0:59)

What is SQL?

SQL Fundamentals (0:58)
SQL Clauses (0:46)

SQL Command Categories

Data Definition Language - DDL (1:22)
Data Manipulation Language - DML Commands (0:36)
Data Query Language - DQL Commands (0:21)
Data Control Language - DCL Commands (0:39)

Getting Started - Install Microsoft SQL Server Database

Getting Started - Install Microsoft SQL Server Database (6:30)

SQL Commands

SQL Create Database - Healthcare System Database (1:09)
SQL Create Table Patients (3:28)
SQL Create Table Medication (2:21)
SQL Select Statement (2:46)
SQL SELECT TOP (1:31)
SQL WHERE (2:07)
SQL Distinct (2:05)
SQL Order By (1:44)
SQL Group By (3:30)
SQL Having (3:47)
Quiz : SQL Command Basics

SQL Group Functions

SQL Count, Average, Min, Max and Sum (4:48)

SQL Logical Operators

SQL AND, OR and NOT Operators (4:39)
SQL LIKE (2:49)
SQL Wildcards (4:55)
SQL BETWEEN and NOT BETWEEN (2:31)

SQL Aliases

SQL Aliases (4:35)

SQL JOINS

SQL JOIN and SQL INNER JOIN (4:26)
SQL Left and Right Join (4:02)
SQL Union (1:32)

SQL Sorting

SQL ASC and DESC (0:50)

BONUS - SQL DML - INSERT, UPDATE and DELETE

SQL Insert (1:38)
SQL Update (3:13)
SQL Delete (1:45)

Teach online with

SQL ASC and DESC

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock