YoVDO

SQL for Beginners Tutorial - Learn SQL in 4.2 Hours

Offered By: Amigoscode via YouTube

Tags

SQL Courses Data Analysis Courses PostgreSQL Courses Relational Databases Courses Database Design Courses Data Manipulation Courses Database Management Courses

Course Description

Overview

Embark on a comprehensive 4-hour SQL tutorial designed for beginners, covering essential concepts to jumpstart your journey with databases. Learn PostgreSQL fundamentals, from creating and connecting to databases to advanced topics like foreign keys and UUID implementation. Master SQL syntax, table creation, data manipulation, querying techniques, and database constraints. Explore practical examples, including working with timestamps, arithmetic operations, and joining tables. Gain hands-on experience with installation and setup processes for both Mac and Windows environments. By the end of this tutorial, you'll have a solid foundation in SQL and database management, preparing you for more advanced database design concepts.

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

Excel 2010
Miríadax
Intro to Data Science
Udacity
Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera
Statistical Computing with R - a gentle introduction
University College London via Independent
Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera