SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

Name: SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals
Rating: 4.6 (26 reviews)

A comprehensive course on SQL and postgreSQL: Become an SQL expert by writing queries using pgAdmin

Created byZaki Khurshid

Last updated 7/2021

English

What you'll learn

Learn the fundamentals of SQL.
The fundamental statements/keywords like SELECT, SELECT DISTINCT, WHERE, ORDER BY, LIMIT , and more.
Learn how to use mathematical, string, and time functions and operators.
The use of EXTRACT function.
Learn the key concepts regarding Data types, Primary and Foreign keys, and Constraints.
Create new tables, insert values into the tables, and also modify the rows and columns in a table.
Learn GROUP BY statement, and HAVING clause.
How to join mutiple tables. UNION, INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN will be covered.
Learn how to write complex queries with Self-join and Subquery.
Learn the advanced concepts like CASE, COALESCE, NULLIF, VIEWS etc.
Learn how to Create your own functions.
Learn how to use Window Functions.
Learn how to import and export csv files.

Course content

9 sections • 75 lectures • 8h 55m total length

Introduction2:39
Explore the fundamentals of sql with postgresql, learn why sql is the industry standard for data storage and analysis, and explore career options.
Tips Related to Udemy Interface2:41
Curriculum Overview2:45
Database Overview4:40
PostgreSQL 13 and PgAdmin 4 Installation on Windows9:42
Install PostgreSQL 13 and PgAdmin 4 on Windows, set up the server and password, then connect using PgAdmin to manage your local database.
IMPORTANT0:22
Uploading a New Database7:49

Section Overview0:49
SELECT Statement7:55
SELECT DISTINCT4:28
LIMIT3:55
Explore how the limit clause restricts the number of rows in a query’s output, using examples that show limiting to five or fifteen rows and selecting specific columns.
COUNT Function4:23
MAX and MIN Functions7:40
Master max and min functions in SQL and PostgreSQL to return the largest or smallest values from numeric, date, and string columns using select max and select min.
ORDER BY5:18
Learn how to use the order by segment to sort a column in ascending or descending order in sql, with practical examples sorting by title and rental rate.
WHERE Statement15:46
BETWEEN Operator9:14
IN Operator7:52
Learn how to use the in operator in sql to filter by multiple values and not in to exclude them, with examples that simplify queries and improve efficiency.
LIKE and ILIKE7:38
Explore the local operator and pattern matching with like and ilike, using % and _ wildcards to filter rows by starting, ending, or containing characters.
AS Clause9:13
A Note Regarding Aliases0:10
Setting up a Practice Database8:50
Assignment0:23
Assignment Solution - Part 111:19
Explore essential SQL tasks in PostgreSQL: query languages, distinct payments, rental return windows, pattern matching in film titles, counting actors by last name, and category lists.
Assignment Solution - Part 212:02
Assignment Solution - Part 38:56

Section Overview1:16
Data Types in SQL21:21
Primary and Foreign Keys12:03
Learn about primary keys and foreign keys, their uniqueness and non-null requirements, how they reference and join tables, with examples from the payment, customer, staff, and rental tables.
Constraints6:28
CREATE TABLE - Part 112:44
CREATE TABLE - Part 26:53
Learn to create tables with foreign keys in SQL, defining columns, primary keys, and references to parent tables such as the student_info and course_info for proper data linking.
INSERT INTO22:21
UPDATE Statement10:13
ALTER TABLE12:50
Master alter table to add or drop columns, modify column types, and rename tables or columns, using practical examples. Apply and manage constraints, including default values, on existing columns.
Deleting Tables7:59
Assignment0:09
Assignment Solution1:08

Section Overview0:30
VIEW11:04
Learn to create and manage views as virtual tables to reuse queries, including creating, replacing, querying, dropping, renaming, and checking existence with examples like a customer info view.
CASE20:04
COALESCE9:10
CAST5:04
Learn to cast a column to a data type in SQL using cast(column as type), with examples like rental_rate to varchar and 82 to integer. Casts are temporary, not permanent.
CREATE FUNCTION13:48
NULLIF5:19
Window Functions - Part 114:15
Window Functions - Part 210:31
Window Functions - Part 38:48
Assignment0:06
Assignment Solution0:04

Requirements

This course is for absolute beginners, so no prior knowledge or experience is required.
You should have a working computer. The computer can have Windows, MacOS, or Linux installed.

Description

Learn one of the most in-demand skills in tech industry in 2021!

SQL, also known as Structured Query Language is a computer language that is designed to store, manage, manipulate, and extract data from a database. Learning SQL is actually one of the top skills in 2021, and can significantly improve your career prospects.

This course is designed in such a way that it will taught effectively, and the concepts you learn here can easily be applied to real-world scenarios.

In this course, you will learn the following:

The Fundamental Statements of SQL like SELECT, SELECT DISTINCT, LIMIT, and much more.
Basic Aggregate functions like SUM, AVG, COUNT, MAX, and MIN.
Basic mathematical, string, and time functions and operators.
Data types, Primary & Foreign Keys, Constraints.
Creating your own tables, inserting values in them, and also modifying the rows and columns of the tables.
GROUP BY statement, and HAVING clause for data analysis
JOINING multiple tables with the help of UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN.
Writing complex queries.
Advanced concepts like CASE,COALESCE, VIEWS etc.
CREATE FUNCTION command.
Window Functions.
Import/Export csv files to/from PostgreSQL server.

We will not only cover the concepts, but also perform practical examples by writing queries on pgAdmin. This will help you a lot in understanding the topics that we will discuss throughout this course. I will also give you assignments throughout this course, which will help you cover all the concepts that we will discuss.

By the end of this course, you would have acquired all the knowledge necessary for real-world scenarios.

I wish you all the best for this course, and Good Luck.

Who this course is for:

Someone who deals with data on a regular basis.
Someone who is curious about learning a new programming language.
Someone who wants to be a data scientist, data analyst, etc.

SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

What you'll learn

Explore related topics

Course content

Introduction7 lectures • 31min

The Fundamental Statements in SQL18 lectures • 2hr 6min

Basic Functions and Operators6 lectures • 44min

Creating Your Own Tables12 lectures • 1hr 55min

GROUP BY and HAVING5 lectures • 27min

Joining Multiple Tables9 lectures • 58min

Self-join and Subquery5 lectures • 26min

Advanced Concepts: CASE, COALESCE, and more12 lectures • 1hr 39min

Importing/Exporting Tables1 lecture • 10min

Requirements

Description

Who this course is for: