SQL and PostgreSQL: Practical course for beginners

About Course

You will learn to read and write complex database queries using one of the most popular programming languages – SQL and the super popular DBMS (database management system) – PostgreSQL. All the knowledge that you will gain in the course is easily applicable to other DBMSs, such as MySQL, Microsoft SQL Server, Oracle. Learning SQL is one of the fastest ways to climb the career ladder and start earning even more. During the course, you will study and receive assignments to test yourself and improve your understanding of the material.

relational model and SQL
PostgreSQL Data Types
Creating a database and tables
Relationships 1 to 1, 1 to many, many to many
Selections - SELECT
Data filtering - WHERE
Sorting and grouping data
Operators UNION, INTERSECT, EXCEPT over sets
Table joins
Subqueries
Keys: primary and foreign
Restrictions
Sequences
Insert, delete, update
Database design
Indexes
Transactions
Safety

Course Content

Introduction to SQL

Basic Concepts
Relational model and SQL
Why PostgreSQL
Installing PostgreSQL
Data types in PostgreSQL
Creating a database
Creating tables
One-to-many relationship”
One to one relationship”
Many-to-many relationship”
Creating Northwind

Simple queries with SELECT

Full sample
Sampling and basic arithmetic operations
DISTINCT
COUNT
DZ “simple samples”
DZ “simple samples” – Solution
WHERE
AND, OR
BETWEEN
IN & NOT IN
LIKE
LIMIT
Check on NULL
GROUP BY
HAVING
UNION, INTERSECT, EXCEPT
DZ “grouping, matching, sorting”
DZ “grouping, matching, sorting” – Solution

Joins

Subqueries

DDL – managing database and tables

Database design

Views

Logic with CASE, COALESCE and NULLIF

SQL and PLpgSQL functions

Errors and their handling

Student Ratings & Reviews

No Review Yet