SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals
A comprehensive course on SQL and postgreSQL: Become an SQL expert by writing queries using pgAdmin
4.58 (24 reviews)
91
students
9 hours
content
Jul 2021
last update
$64.99
regular price
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.
Related Topics
4045846
udemy ID
5/13/2021
course created date
5/29/2021
course indexed date
Bot
course submited by