SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

Rating 4.55 out of 5 (14 ratings in Udemy)

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 …

Rating 4.55 out of 5 (14 ratings in Udemy)

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.

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, SELECTDISTINCT, 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.
GROUPBY statement, and HAVING clause for data analysis
JOINING multiple tables with the help of UNION, LEFT JOIN, RIGHTJOIN, INNERJOIN, OUTERJOIN.
Writing complex queries.
Advanced concepts like CASE,COALESCE,VIEWS etc.
CREATE FUNCTION command.
Window Functions.
Import/Export csv files to/fromPostgreSQL 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.

Duration 8 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

Rating 4.55 out of 5 (14 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.