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: 33 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

About the instructor

5 Instructor Rating
2 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 software developer, 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

(2) Course Rating

5 stars

100.00%

4 stars

0.00%

3 stars

0.00%

2 stars

0.00%

1 stars

0.00%

Reviews

User

2 days ago

Star

Was this review helpful? Report

etd

2 days ago

Sql era

Was this review helpful? Report

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

Preview this course

ETB 40 ETB 500 92% off

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

30-Day Money-Back Guarantee

This course includes

12 hours on-demand video
4 resources
Full lifetime access
Access on 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
Resources 4
Preview Lessons1
Language
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

etd

This course includes

Training 5 or more people?

Course Features

Course Categories

Related Courses

Over view of H5 C2B telebirr Integration

SQL and PostgreSQL: The Complete Developer's Guide

Telebirr H5 Web Payment Integration

Become a Teacher, Share your knowledge

Connect with us

Company

Courses