آموزش کامل SQL – از مبتدی تا حرفه‌ای (Bootcamp)

Introduction

Course Curriculum Overview

Overview of Databases

Windows Installation PostGreSQL and PgAdmin with Database Setup

MacOS Installation PostgreSQL and PgAdmin with First Query

pgAdmin Overview

Overview of Challenges

SQL Statement Fundamentals

SELECT Statement

Challenge SELECT

SELECT DISTINCT

Challenge SELECT DISTINCT

COUNT

SELECT WHERE Part One

SELECT WHERE Part Two

Challenge SELECT WHERE

ORDER BY

LIMIT

Challenge ORDER BY

BETWEEN

IN

LIKE and ILIKE

General Challenge 1

Introduction to GROUP BY

Aggregation Functions

GROUP BY Part One

GROUP BY Part Two

GROUP BY Challenge

HAVING

HAVING Challenge Tasks

Overview of Assessment Test 1

Introduction to JOINs

AS Statement

Inner Joins

Full Outer Joins

Left Outer Join

Right Joins

UNION

JOIN Challenge Tasks

Overview of Advanced SQL Commands

Timestamps and Extract Part One

Timestamps and Extract Part Two

Timestamps and Extract Challenge Tasks

Mathematical Functions and Operators

String Functions and Operators

SubQuery

SelfJoin

Setting up New Database for Assessment Exercises

Solutions to Assessment Test 2

Introduction to Section

Data Types

Primary Keys and Foreign Keys

Constraints

CREATE Table

INSERT

UPDATE

DELETE

ALTER Table

DROP Table

CHECK Constraint

Assessment Test 3 - ویدیو ندارد این جلسه فقط فایل را بررسی کنید

Conditional Expressions and Procedures Introduction

CASE

CASE Challenge Task

COALESCE

CAST

NULLIF

Views

Import and Export

Psycopg2 Example Usage