Learn SQL and PostgreSQL completed course from scratch!

What you'll learn?

Make logical connections between database tables
Limit the amount of data received from a table
Filter data using logical operators
Retrieve various data from the database using commands and queries
Add, update and delete data from database tables
Build, replace and delete tables from the database environment
Design and build relational databases from zero to one hundred

Chosen for the Etdemy for Business collection

Requirements

For beginners (No previous knowledge of SQL or PostgreSQL is needed for this course)

Get your team access to Etdemy's courses

Try Etdemy for Business

Description

This beginner-friendly course helps you master SQL queries and the PostgreSQL database, one of the most powerful and secure database systems used by companies like Apple, Netflix, Spotify, and Cisco. SQL is an essential skill not only for software development but also for data analytics and big data fields. Start your journey today and build a strong foundation for your career in databases and data-driven industries!

Who this course is for:

For beginners (No previous knowledge of SQL or PostgreSQL is needed for this course)

Show more Show less

Course content

Total: 107 lectures Total hours: 12

Introduction 03:09
Course Curriculum 03:09

What is a Database? 03:09
Installing PostgreSQL for Mac and Windows 03:09

Section Introduction and Database tables 03:09
Datatypes and Primary keys 03:09
Unique, Not Null and Check Constraints 03:09
Creating Our First Table 03:09
Creating the Actors Table and a Table with Foreign key 03:09
Movie Revenues and Junction Table 03:09
Modifying Tables Part 1 Adding Columns 03:09
Modifying Tables Part2 and Changing 03:09
Solution Data Definition Language 03:09
Summary 03:09

Section Introduction and Inserting Data into a Table 03:09
Updating Data in and Deleting Data from a Table 03:09
Inserting Data into Data Database 03:09
Solution Data Manipulation Language 03:09
Summary 03:09

Intro_Select Queries & Where Clauses 03:09
Logical Operators 03:09
Solution 1 Select Queries 03:09
In and Not In 03:09
Like 03:09
Between query 03:09
Solution 2 Select Queries 03:09
Order By 03:09
Limiting the Number of Results & Fetch 03:09
Distinct Values and Challenge 3 03:09
Null Values Setting a Column Name Alias 03:09
Concatenation 03:09
Challenge 4 Select Queries & Solutions 03:09
Summary 03:09

Aggregate Functions & Count 03:09
Sum, Min, & Max Aggregate Function 03:09
Average, Challenge 1 Aggregate Functions 03:09
Solution 1 Aggregate Functions 03:09
Grouping Data 03:09
Having Clauses 03:09
Challenge 2 Aggregate Functions 03:09
Solution 2 Aggregate Functions 03:09
Mathematical Operators 03:09
Section Summary 03:09

Database Relationships one to one and one to many 03:09
Many to Many Relationships 03:09
Challenge & Solution Database Relationships 03:09

Section Introduction 03:09
SQL Joins Explained 03:09
Inner Joins Part 1 03:09
Inner Joins Part 2 03:09
Inner Joins Part 3 03:09
Challenge 1 Joins with solutions 03:09
Left & Right Joins 03:09
Full Joins 03:09
Joining More Than Two Tables 03:09
Challenge 3 Joins and solutions 03:09
Union and Union All 03:09
Challenge 4 Joins and solutions 03:09
Intersect and Except 03:09
Challenge 5 Joins and Solutions 03:09
Section Summary 03:09

Introduction 03:09
Uncorrelated Subqueries Part 1 03:09
Uncorrelated Subqueries Part 2 03:09
Challenge 1 Subqueries with solutions 03:09
Correlated Subqueries 03:09
Challenge 2 Subqueries with Solution 03:09
Summary 03:09

Introduction and Cloning a Database 03:09
Upper and Lower String Functions 03:09
Initcap Function 03:09
Left and Right String Functions 03:09
Reverse Function 03:09
Challenge 1 String Functions 03:09
Solution 1 String Functions 03:09
Substring Function 03:09
Replace Function 03:09
Split Part Function 03:09
Using the Cast Operator to Apply String Functions to Non-String Data Types 03:09
Challenge 2 String Functions with Solutions and Summary 03:09

Section Introduction and Conditional Statements in SQL 03:09
Basic CASE Expressions 03:09
Order of WHEN Clauses in CASE Expressions & challenge 1 conditional statement 03:09
Solution 1 Conditional Statements and Functions 03:09
Case Expressions with Aggregate Functions 03:09
Further Case Expressions with Aggregate Functions and Challenge 2 Conditional Statements 03:09
Solution 2 Conditional Statements and Functions 03:09
COALESCE Function and NULLIF Function 03:09
Challenge 3 Conditional Statements and Functions and Solutions 03:09
GREATEST and LEAST Functions 03:09
Section Summary 03:09

Section Introduction and Window Functions 03:09
Basic Window Functions 03:09
Multiple Window Functions 03:09
Running Totals Using Window Functions 03:09
Solution of Challenge 1 Window Functions 03:09
ROW_NUMBER Function, RANK and DENSE_RANK Functions 03:09
FIRST_VALUE and LAST_VALUE Functions and Challenge 2 Window Functions 03:09
Solution 2 Window Functions 03:09
LAG Function 03:09
LEAD Function 03:09
NTH_VALUE Function 03:09
Challenge 3 Window Functions and Solutions 03:09
PERCENT_RANK Function 03:09
NTILE Function and Challenge 4 Window Functions 03:09
Solution 4 Window Functions 03:09
Section Summary 03:09

About the instructor

5 Instructor Rating
9 Courses

etd

Joined 1 second ago

meekmate@gmail.com

After learning the hard way, etd was determined to become the best teacher he could, and to make his training as painless as possible, so that you, or anyone else with the desire to become a proficient, could become one.

If you want to become an expert in this field, etd's courses are the perfect course to start.

Show more Show less

Student feedback

(4) Course Rating

5 stars

100.00%

4 stars

0.00%

3 stars

0.00%

2 stars

0.00%

1 stars

0.00%

Reviews

User

1 month ago

impressive

Was this review helpful? Report

Beriso Lenchamo

1 month ago

I am pleased with the availability of this on online platforms for Ethiopians.

Was this review helpful? Report

User

1 month ago

Star

Was this review helpful? Report

etd

1 month ago

Sql era

Was this review helpful? Report

For Add Course Review. You need to login first Login Here

Preview this course

ETB 170 ETB 500 66% off

Limited-time offer – enroll now for the best deal!

30-Day Money-Back Guarantee

This course includes

12 hours on-demand video
Full lifetime access
Access on PC, mobile and TV

Training 5 or more people?

Get your team access to Etdemy top courses anytime, anywhere.

Try Etdemy for Business

Course Features

Duration 12 hours
Downloadable Resources 28
Preview Lessons1
Language English
Skill level Middle
Studentslive
Certificate No

Course Categories

Related Courses

View All Courses

What you'll learn?

Chosen for the Etdemy for Business collection

Requirements

Description

Who this course is for:

Course content

About the instructor

etd

Student feedback

Reviews

User

Beriso Lenchamo

User

etd

This course includes

Training 5 or more people?

Course Features

Course Categories

Related Courses

API Essentials for Beginners

H5_Checkout Integration with downloadable source code

Over view of H5 C2B telebirr Integration

SQL and PostgreSQL: The Complete Tips and Guide in 10 minutes

Become a Teacher, Share your knowledge

Connect with us

Company

Courses