2022-Basics of SQL using PostgreSQL
- Description
- Curriculum
- FAQ
- Reviews
Structured Query Language (SQL) is THE language of relational databases.
Every software developer and data analytics engineer WILL interact with a relational database at some point in their career and SQL is the language of choice when talking to these databases.
Employers desire SQL language skills and it is a great resume enhancer if you know anything beyond just the basics.
In this course, you will learn the basics of SQL and some fairly advanced topics that will make you a valuable addition to any software team.
Most of the course (90%) will be spent on demos and problem solving rather than power point presentations and there are multiple quizzes, assignments and projects.
Finally, we will build a 3-tier web application using a PostgreSQL backend database which will teach you the advanced skills required to perform such a task.
If you have ever felt that you would like to learn more about SQL but are not sure about what course to take, Basics of SQL using PostgreSQL is an excellent course to try out.
There is no risk. This course has a 30-day money back guaranteed by Udemy.
I wish you the best of luck and hope you will have as much fun learning about SQL as I had teaching this course.
-
9
SELECT columns and ROWS FROM tablesWe learn how to select some or all columns from a single table. Learn about aliases for column names.
-
10
More SELECT using ALIASes
We see some more uses of the SELECT keyword and use aliases to change column names using the AS keyword.
-
11
ORDER rows in ASCENDING or DESCENDING order
-
12
Exercises with SELECT and ORDER BY
-
13
Selecting unique entries using DISTINCT
-
14
Exercises with DISTINCT clause
-
15
Filtering rows using the WHERE clause
-
16
Exercises using the WHERE clause
-
17
Limiting the number of rows using the LIMIT clause
-
18
The Basics-Quiz -
19
Using the SELECT and ALIAS statements. -
20
Assignment-1: Using the WHERE clause
-
21
Assignment-2: Using WHERE clause
-
22
INNER JOINS- Explanation
Explain what an INNER JOIN is and why we need it and how it works.
-
23
INNER JOINS - Example
A practical example of an INNER JOIN.
-
24
INNER JOINS - A more complex example
We look at an example where we need to join more than two tables.
-
25
OUTER JOINS
Explains what are outer joins, why we need them and examples.
-
26
SELF JOINS
Explain what a self join is and two examples where we can use them.
-
27
JOINS - Quiz
-
28
Simple JOINs
-
29
Use JOINs to determine the names of all the actors in Club Graffiti in one SQL q
-
30
Use JOINs to determine the films that Emily Dee has acted in
-
31
Basic Datatypes in SQL
In this video we look at some basic datatypes in SQL such as VARCHAR, CHAR, INT and REAL (and their variations).
-
32
Basic CRUD on databases, tables and rows
-
33
Manipulating columns in SQL
-
34
Constraints on columns: PRIMARY KEY and SERIAL
-
35
Constraints on columns: NOT NULL, DEFAULT, UNIQUE and CHECK
-
36
Foreign Keys Constraints and their implications
-
37
CRUD-Quiz
-
38
CRUD Operations
-
43
Basic grouping of data using the GROUP BY and HAVING clauses
We group our rows into groups based on distinct values of a column and get data about the groups.
-
44
Aggregate calculation deep dive
Since aggregate calculations are very important, we take a deeper look into when exactly these aggregates are calculated.
-
45
Complex grouping using multiple columns and extracted data
We group our rows using more than one column and data that is not immediately available in the table as a simple column.
-
46
Combine many grouping operations into a single query
We look at how we can combine multiple types of grouping operations into a single SQL query and how we read the result set.
-
47
Common SET operations to stack rows on top of each other.
Here we look at ways to combine multiple tables with compatible datatypes using SET type operations: UNION, INTERSECT and EXCEPT.
-
48
Quiz - GROUPS
-
50
Use Sub-queries to construct complex queries.
Here we look at ways that we can use a sub-query which is essentially feeding the result set of one query to another.
-
51
Use the CASE statement to take decisions
We use the CASE statement along with WHEN, THEN to produce results based on the values of a column.
-
52
Common Table Expressions (CTE)
We explore CTEs and apply them to two problems.
-
53
Virtual Tables using VIEWS
We create virtual tables called VIEWS and show how we can use it for ease of use and some security feature.
-
54
Virtual Tables with MATERIALIZED VIEWS
We discuss MATERIALIZED VIEWS which are nothing but VIEWS with actual data backing them. They can be used as a regular table and are useful for storing results are requested frequently.
