SQL PostgreSQL for Beginners- Learn the SQL Fundamentals

SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals, available at $64.99, has an average rating of 4.25, with 76 lectures, based on 22 reviews, and has 89 subscribers.

You will learn about 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. This course is ideal for individuals who are Someone who deals with data on a regular basis. or Someone who is curious about learning a new programming language. or Someone who wants to be a data scientist, data analyst, etc. It is particularly useful for Someone who deals with data on a regular basis. or Someone who is curious about learning a new programming language. or Someone who wants to be a data scientist, data analyst, etc.

Enroll now: SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

Summary

Title: SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

Price: $64.99

Average Rating: 4.25

Number of Lectures: 76

Number of Published Lectures: 75

Number of Curriculum Items: 76

Number of Published Curriculum Objects: 75

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Tips Related to Udemy Interface

Lecture 3: Curriculum Overview

Lecture 4: Database Overview

Lecture 5: PostgreSQL 13 and PgAdmin 4 Installation on Windows

Lecture 6: IMPORTANT

Lecture 7: Uploading a New Database

Chapter 2: The Fundamental Statements in SQL

Lecture 1: Section Overview

Lecture 2: SELECT Statement

Lecture 3: SELECT DISTINCT

Lecture 4: LIMIT

Lecture 5: COUNT Function

Lecture 6: MAX and MIN Functions

Lecture 7: ORDER BY

Lecture 8: WHERE Statement

Lecture 9: BETWEEN Operator

Lecture 10: IN Operator

Lecture 11: LIKE and ILIKE

Lecture 12: AS Clause

Lecture 13: A Note Regarding Aliases

Lecture 14: Setting up a Practice Database

Lecture 15: Assignment

Lecture 16: Assignment Solution – Part 1

Lecture 17: Assignment Solution – Part 2

Lecture 18: Assignment Solution – Part 3

Chapter 3: Basic Functions and Operators

Lecture 1: Section Overview

Lecture 2: SUM, AVG, and ROUND Functions

Lecture 3: Mathematical Functions

Lecture 4: String Functions and Operators

Lecture 5: Time Functions and Operators

Lecture 6: EXTRACT Function

Chapter 4: Creating Your Own Tables

Lecture 1: Section Overview

Lecture 2: Data Types in SQL

Lecture 3: Primary and Foreign Keys

Lecture 4: Constraints

Lecture 5: CREATE TABLE – Part 1

Lecture 6: CREATE TABLE – Part 2

Lecture 7: INSERT INTO

Lecture 8: UPDATE Statement

Lecture 9: ALTER TABLE

Lecture 10: Deleting Tables

Lecture 11: Assignment

Lecture 12: Assignment Solution

Chapter 5: GROUP BY and HAVING

Lecture 1: Section Overview

Lecture 2: GROUP BY Statement

Lecture 3: HAVING Clause

Lecture 4: Assignment

Lecture 5: Assignment Solution

Chapter 6: Joining Multiple Tables

Lecture 1: Section Overview

Lecture 2: UNION

Lecture 3: INNER JOIN

Lecture 4: FULL OUTER JOIN

Lecture 5: LEFT OUTER JOIN

Lecture 6: RIGHT OUTER JOIN

Lecture 7: An Important Note Regarding JOINS

Lecture 8: Assignment

Lecture 9: Assignment Solution

Chapter 7: Self-join and Subquery

Lecture 1: Section Overview

Lecture 2: Subquery

Lecture 3: Self Join

Lecture 4: Assignment

Lecture 5: Assignment Solution

Chapter 8: Advanced Concepts: CASE, COALESCE, and more

Lecture 1: Section Overview

Lecture 2: VIEW

Lecture 3: CASE

Lecture 4: COALESCE

Lecture 5: CAST

Lecture 6: CREATE FUNCTION

Lecture 7: NULLIF

Lecture 8: Window Functions – Part 1

Lecture 9: Window Functions – Part 2

Lecture 10: Window Functions – Part 3

Lecture 11: Assignment

Lecture 12: Assignment Solution

Chapter 9: Importing/Exporting Tables

Lecture 1: Importing and Exporting a CSV file

Instructors

Zaki Khurshid
DWH/BI Developer || Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 3 votes

5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!