SQL - Table of Contents

SQL - Table: Database Tables are the foundation of every RDBMS (Relational Database Management System).

SQL - SELECT: How to use the SELECT statement to retrieve data from a SQL database.

SQL - SELECT INTO: How to use this statement to copy data between database tables.

SQL - DISTINCT: How to use this clause together with the SELECT keyword, to return a dataset with unique entries for certain database table column.

SQL - WHERE: This command is used to specify selection criteria, thus restricting the result of a SQL query.

SQL - LIKE: This clause is used along with the WHERE clause and specifies criteria based on a string pattern.

SQL - INSERT INTO: How to use INSERT INTO clause to insert data into a SQL database.

SQL - UPDATE: How to use the UPDATE statement to update data in a SQL database.

SQL - DELETE: How to use the DELETE statement to delete data from a SQL database table.

SQL - ORDER BY: How to use this statement to sort the data retrieved in your SQL query.

SQL - OR & AND: How to use these keywords together with the WHERE clause to add several conditions to your SQL statement.

SQL - IN: This clause allows you to specify discrete values in your WHERE search criteria.

SQL - BETWEEN: These keywords define a range of data between 2 values.

SQL - Aliases: Aliases can be used with database tables and/or with database table columns, depending on task you are performing.

SQL - COUNT: COUNT aggregate function is used to count the number of rows in a database table.

SQL - MAX: MAX aggregate function allows us to select the highest (maximum) value for a certain column.

SQL - MIN: MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

SQL - AVG: AVG aggregate function selects the average value for a certain table column.

SQL - SUM: SUM aggregate function allows selecting the total for a numeric column.

SQL - GROUP BY: This statement is used along with the Aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).

SQL - HAVING: This clause is used to restrict conditionally the output of a SQL statement, by a aggregate function used in your SELECT list of columns.

SQL - JOIN: The JOIN clause is used whenever we have to select data from 2 or more tables.