SQL for Beginners Tutorial - Learn SQL in 4.2 Hours
Offered By: Amigoscode via YouTube
Course Description
Overview
Syllabus
- Intro.
- Quick Word Before we begin.
- What is Database.
- What is SQL.
- SQL Example.
- Postgres.
- Install Postgres (MAC OS).
- Setup Postgres (MAC OS).
- Install Postgres (Windows.
- PSQL (Windows).
- Learn SQL the right way.
- Create Database.
- Connecting to Databases.
- Create Table Syntax + Datatypes.
- Create Table Without Constraints.
- Create Table With Constraints.
- Insert Data.
- Insert Into.
- SELECT FROM.
- Adding Data.
- Sorting.
- Removing Duplicates.
- WHERE clause.
- Comparison Operators.
- LIMIT OFFSET and FETCH.
- IN.
- BETWEEN.
- LIKE.
- GROUP BY.
- HAVING.
- Car Table.
- MIN MAX & AVG.
- SUM.
- Arithmetic Operators.
- Working with Arithmetic Operators.
- Alias.
- Coalesce.
- NULLIF.
- Timestamps & Dates.
- Adding & Subtracting Dates.
- Extracting Fields From Dates.
- Age Function.
- Primary Keys.
- Primary Keys (Part 2).
- Adding Primary Keys Constraints.
- Unique Constraints.
- Primary Keys.
- Check Constraints.
- Deleting Records.
- Updating Records.
- On Conflict Do Nothing.
- On Conflict Do Update.
- Foreign Keys & Relationships.
- Adding Foreign Keys.
- Updating Foreign Keys.
- Inner Joins.
- Left Joins.
- Deleting Foreign Keys.
- Sequences.
- Extensions.
- UUID.
- UUID in Action.
- Exporting to CSV.
- Next steps.
- Database Design Course.
Taught by
Amigoscode
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX