Free SQL for Data Science Course

This section will demonstrate the HAVING clauses mentioned in the previous section with examples through which you will understand when and where to use the HAVING clause.

Alias is used to make table and column names more readable. You will learn to assign a temporary name to a table or a column in a table in this section.

This section briefs Joins in SQL and discusses statements that fetch all the results in different tables meeting the condition.

This section defines Right Join, Left Join, Inner Join, Full Outer Join, Self Join, and Cross Join. You will understand how all of these joins return values based on the input statement and conditions.

You will learn to return the expected values in different tables based on the input condition using demonstrated examples using the INNER JOIN statement.

This section briefs on how to return all the elements in the first table and the common elements in the other tables based on the input condition with demonstrated examples using the LEFT JOIN statement.

In this section, you will learn to return all the elements in the last table and the common elements in the other tables based on the input condition with demonstrated examples using the RIGHT JOIN statement.

You will learn to return all the values in both the tables based on the input condition, regardless of their commonalities, using demonstrated examples using the FULL JOIN statement.

You will learn to return the values of the same table depending on the input condition given by the user using demonstrated examples using the SELF JOIN statement.

It is also called Sub-Selects or Nested Queries. This section helps you learn to write a query within another query.

A problem statement is a scenario with defined elements to be achieved at the end of the query processing. You will learn to solve and work with problem statements in this section.

A subquery is a nested query command within another query. It is also called Sub-Selects, and it returns the value that meets the requirements of both queries. You will understand the details in this section.

Each subquery is executed for every row of the outer query. A correlated subquery evaluated each row processed by the parent statements. SELECT, UPDATE, and DELETE statements are the parent statements. You will understand how a subquery executes in this section.

This section discusses single-row subquery, multiple row subquery, multiple columns subquery, correlated subquery, and nested subquery to understand the subquery concept.

This section will help you understand each subquery with demonstrated examples.

This section discusses how to use SQL queries written on Oracle in Python. You will also learn how SQL can alternatively be used directly in Python in the latter part of this section.

This section comprehends the history of Python programming. It talks about the simplicity and user-friendly language exhibits with inbuilt libraries used to develop user-friendly applications.

Python is the most uncomplicated and sophisticated programming language, both easy to learn and use. It also reduces time spent on coding since it has built-in libraries to support high-end applications.

Python is popular since it is coded like the English communication language, and it is simple to learn and code. You will understand other reasons why Python programming is prevalent in this section.

This section will demonstrate how to install Python with step-by-step explanations. You can follow the steps to install it on your PC.

You will learn how to use MySQL with Python with a demonstrated sample problems.