SQL Tutorials for Citizen Data Scientists

Beginners Guide to SQL – SQL Subqueries

(SQL Tutorials for Citizen Data Scientist) SQL Subqueries In this tutorial you will learn how to embed a query within another query in SQL. What Is a Subquery? A subquery, also known as a nested query or subselect, is a SELECT query embedded within the WHERE or HAVING clause of another SQL query. The data returned by the subquery is used by …

Beginners Guide to SQL – SQL Temporary Tables

(SQL Tutorials for Citizen Data Scientist) SQL Temporary Tables In this tutorial you will learn how to create temporary tables using SQL. Creating Temporary Tables A temporary table is a table that is visible only to the current session, and is dropped automatically when the session in which it was created is closed. Since temporary tables …

Beginners Guide to SQL – SQL CREATE VIEW Statement

(SQL Tutorials for Citizen Data Scientist) SQL CREATE VIEW Statement In this tutorial you will learn how to create, update, and delete a view using SQL. Creating Views to Simplify Table Access A view is a virtual table whose definition is stored in the database. But, unlike tables, views do not actually contain any data. Instead, it …

Beginners Guide to SQL – SQL HAVING Clause

(SQL Tutorials for Citizen Data Scientist) SQL HAVING Clause In this tutorial you will learn how to filter the groups returned by a GROUP BY clause. Filtering the Groups Based on Condition The HAVING clause is typically used with the GROUP BY clause to specify a filter condition for a group or an aggregate. The HAVING clause can only be used with the SELECT statement. To understand …

Beginners Guide to SQL – SQL GROUP BY Clause

(SQL Tutorials for Citizen Data Scientist) SQL GROUP BY Clause In this tutorial you will learn how to group rows based on column values. Grouping Rows The GROUP BY clause is used in conjunction with the SELECT statement and aggregate functions to group rows together by common column values To understand this easily, let’s look at the following employees and departments tables. +——–+————–+————+———+ | emp_id | emp_name …

Beginners Guide to SQL – SQL ALTER TABLE Statement

(SQL Tutorials for Citizen Data Scientist) SQL ALTER TABLE Statement In this tutorial you will learn how to alter or modify an existing table using SQL. Modifying Existing Tables It is quite possible that after creating a table, as you start using it, you may discover you’ve forgot to mention any column or constraint or specified a …