Learn to Communicate With Relational Databases Through SQL. Get Equipped with SQL Fundamentals and Skills and learn from industry experts to use industry-standard tools and techniques.

Datatypes in SQL

Gain information about the three major data types in SQL, String, Numeric, and Date and Time. Learn about the types and subtypes of data types in SQL.

Creating Table

This topic will talk about the creation of a basic table that involves naming the table and defining its columns and the data type of each column. Learn about creating tables in SQL with examples.

Inserting and Extracting

In this topic, the students will learn how to extract data from the table based on an SQL query. Gain information about the different ways to add new data to an extract in SQL from a file or from a data source.

Primary Key

The Primary Key Constraint in SQL deals with uniquely identifying each record in a table.

Foreign Key

Gain knowledge on how to prevent actions that would destroy the links between tables as Foreign Keys represent the relationships between tables.

Not Null

Learn how to add a constraint table with the utilization of NOT NULL as a column is capable of holding NULL values by default.

Unique

Unique and Primary Key constraints focus on guaranteeing uniqueness. Gain knowledge about the UNIQUE constraint and how to ensure that all values in a column are different.

Check

Get information about the CHECK constraint and know how to use the CHECK constraint to limit the value range that can be placed in a column.

Default

This particular constraint is used to set a default value for a column. Learn more about it in detail in the Constraints in SQL module.

Where

The main role of the SQL WHERE clause is to utilize the filter records and extract those records only that carry the potential to fulfill a particular condition.

Top

The TOP Clause deals with the specification of the number of records to return. Learn how it is useful on large tables with thousands of records.

Order By

The ORDER BY keyword is responsible for sorting the records in ascending order or descending order. However, it does sort the result in ascending order by default.

Group By

This topic will cover the GROUP BY statement that is responsible for grouping rows with the same values into summary rows.

Having

The need for the HAVING clause was raised when the WHERE keyword was unable to be used with aggregate functions. Learn how to specify conditions that filter which group results appear in the results.

And, Or, Not

Learn about the three key operators in SQL that plays a vital role in filtering records based on more than one condition. NOT negates the specified condition.

In, Between

This topic will equip the students with the knowledge of the IN and BETWEEN command that allows students to specify multiple values in a WHERE clause and select values within a given range, respectively.

Like, Alias, Wildcard

Learn about the Like, Alias, and Wildcard operator in this topic and improve your results in getting the correct results.

Distinct, Is Null, Is Not Null

This topic will discuss SQL's Distinct, Is Null, and Is Not Null operators.

Inner Join

The INNER JOIN keyword is responsible for selecting records that have matching values in both tables.

Left Join

As the name suggests, the LEFT JOIN keyword returns all records from the left table and the matching records from the right table.

Right Join

Learn in detail about the RIGHT JOIN keyword as it is responsible for all returning all records from the right table and the matching records from the left table.

Full Join

This topic will cover the FULL JOIN keyword as it returns all the rows from both joined tables, whether they have a matching row or not.

Self Join

Learn about a join in which a table is joined with itself, especially when the table has a Foreign Key, the Self Join.

Update

This topic covers everything in detail about the UPDATE statement that is used in order to modify the existing records in a table. It is responsible for bringing updates to the existing rows in a table.

Alter

Bringing modification to a table is important, and hence, the ALTER TABLE statement is utilized to add, delete, or modify columns in an existing table.

Roll Back

Learn everything you need to know about the transactional control language in SQL as it allows the users to undo the transactions that are not saved yet in the database.

Delete

This command deals with the removal of existing records in a table. It is a crucial part of the Data Manipulation Language.

Arithmetic

Arithmetic operations are utilized in SQL for performing additional operations on the data items; items include either a single column or multiple columns.

String

The String Function holds the responsibility of taking a string value as an input irrespective of the data type of the returned value.

Dates

The format of the date in an SQL table must be matched with the input date while working with dates in SQL. This topic will cover the date function for performing date arithmetic.