Sitemap

** Stay Tuned for Exciting Live Classes at Tansy Academy!            ** Stay Tuned for Exciting Live Classes at Tansy Academy!            ** Stay Tuned for Exciting Live Classes at Tansy Academy!

HOME

Home
SQL Training Intro
Courses
About Us
Contact Us
Subscriptions
Terms & Conditions
Testimonials
Internship
Privacy Policy
Sitemap
Live Zoom Class
Refund Policy
SQL Database Projects
Online SQL Query Editor/Tool
MySQL Interview Questions
PostgreSQL Interview Questions
Oracle Interview Questions
MS SQL Server Interview Questions
MySQL Database Quiz Questions
PostgreSQL Database Quiz Questions
Oracle Database Quiz Questions
MS SQL Database Quiz Questions

ONLINE COURSES

MySQL
PostgreSQL
Oracle
MS SQL

ONLINE MYSQL TRAINING COURSE

Live SQL Training
Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Tansy Cloud Business Application
Assignment - Zoom Business Application
Assignment - Facebook Social Application
Assignment - WhatsApp Mobile Application
Database Table
ROWs and COLUMNs
SQL
Assignment - List Tables and Columns - Company Management System
Assignment - List Tables and Columns - Student Management System
Online SQL Editor
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
DDL ASSIGNMENT - Company Management System
DDL ASSIGNMENT - Student Management System
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
DML ASSIGNMENT - Company Management System
DML ASSIGNMENT - Student Management System
SELECT *
WHERE Clause
LIMIT
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
DQL ASSIGNMENT - Company Management System
DQL ASSIGNMENT - Student Management System
DQL ASSIGNMENT - Dashboard Reporting in a Company Management System
DQL ASSIGNMENT - Dashboard Reporting in a Student Management System
Database View
MySQL Stored Procedure
DB Function
DB Trigger
Common Table Extensions (CTE)
SQL Window Functions
Final Capstone Project - Company Management System
Final Capstone Project - Student Management System
SQL Certifications

ONLINE POSTGRESQL TRAINING COURSE

Live SQL Training
Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Tansy Cloud Business Application
Assignment - Salesforce Business Application
Assignment - Instagram Social Application
Assignment - Snapchat Mobile Application
Database Table
ROWs and COLUMNs
SQL
Assignment - List Tables and Columns - Banking Management System
Assignment - List Tables and Columns - Hospital Management System
Online SQL Editor
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
DDL ASSIGNMENT - Banking Application System
DDL ASSIGNMENT - Hospital Management System
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
DML ASSIGNMENT - Banking Application System
DML ASSIGNMENT - Hospital Management System
SELECT *
WHERE Clause
LIMIT OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
DQL ASSIGNMENT - Banking Application System
DQL ASSIGNMENT - Hospital Management System
DQL ASSIGNMENT - Dashboard Reporting in a Banking Application
DQL ASSIGNMENT - Dashboard Reporting in a Hospital Management System
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
SQL Data Model Assignment - Banking Application System
SQL Data Model Assignment - Hospital Management System
Database View
Stored Procedure
DB Function
DB Trigger
SQL Window Functions
Common Table Extensions (CTE)
Final Capstone Project - Banking System
Final Capstone Project - Hospital Management System
SQL Certifications

ONLINE ORACLE TRAINING COURSE

Live SQL Training
Application Software
Software Development Life Cycle
Database Components
Database Platforms
Tansy Cloud Business Application
Assignment - Slack Business Application
Assignment - Twitter Social Application
Assignment - Uber Mobile Application
Database Table
ROWs and COLUMNs
SQL
Assignment - List Tables and Columns - Library Management System
Assignment - List Tables and Columns - Facebook-like Social Media Application
Online SQL Editor
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
DDL ASSIGNMENT - Library Management System
DDL ASSIGNMENT - Facebook Application
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
DML ASSIGNMENT - Library Management System
DML ASSIGNMENT - Facebook Application System
SELECT *
WHERE Clause
FETCH OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
DQL ASSIGNMENT - Library Management System
DQL ASSIGNMENT - Facebook Application System
DQL ASSIGNMENT - Dashboard Reporting in a Library Management System
DQL ASSIGNMENT - Dashboard Reporting in a Facebook Application
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
SQL Data Model Assignment - Library Management System
SQL Data Model Assignment - Facebook Application
Database View
Stored Procedure
DB Function
DB Trigger
Common Table Extensions (CTE)
SQL Window Functions
Final Capstone Project - Library Management System
Final Capstone Project - Facebook App
SQL Certifications

ONLINE MS SQL SERVER TRAINING COURSE

Live SQL Training
Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Tansy Cloud Business Application
Assignment - LinkedIn Business Application
Assignment - Netflix Social Application
Assignment - Gmail Mobile Application
Database Table
ROWs and COLUMNs
SQL
Assignment - List Tables and Columns - Store Management System
Assignment - List Tables and Columns - Food Delivery Application
Online SQL Editor
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
DEFAULT Constraint
CHECK Constraint
UNIQUE Constraint
AUTO INCREMENT
DDL ASSIGNMENT - Store Management System
DDL ASSIGNMENT - Food Delivery System
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
DML ASSIGNMENT - Store Management System
DML ASSIGNMENT - Food Delivery System
SELECT *
WHERE Clause
TOP FETCH OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
DQL ASSIGNMENT - Store Management System
DQL ASSIGNMENT - Food Delivery System
DQL ASSIGNMENT - Dashboard Reporting in a Store Management System
DQL ASSIGNMENT - Dashboard Reporting in a Food Delivery System
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
SQL Data Model Assignment - Store Management System
SQL Data Model Assignment - Food Delivery System
Database View
Stored Procedure
DB Function
DB Trigger
Common Table Extensions (CTE)
SQL Window Functions
Final Capstone Project - Store Management System
Final Capstone Project - Food Delivery System
SQL certifications

MYSQL DATABASE INTERVIEW QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
LIMIT
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
CAST
COALESCE
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
MySQL Stored Procedure
DB Function
DB Trigger

POSTGRESQL DATABASE INTERVIEW QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
NOT IN Operator
IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
Stored Procedure
DB Function
DB Trigger

ORACLE DATABASE INTERVIEW QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
DISTINCT
FETCH OFFSET
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE Functions
NUMERIC functions
SQL Execution Order
CAST
COALESCE
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
Oracle Stored Procedure
DB Function
DB Trigger

MSSQL DATABASE INTERVIEW QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
LIMIT OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
DATE functions
STRING functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
Stored Procedure
DB Function
DB Trigger

MYSQL DATABASE QUIZ QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
LIMIT
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
MySQL Stored Procedure
DB Function
DB Trigger

POSTGRESQL DATABASE QUIZ QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
LIMIT
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
LIKE Operator

ORACLE DATABASE QUIZ QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
FETCH OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
SQL Aliases
GROUP BY
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
What is RDBMS
Primary Key
Cardinality
Foreign Key
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
Stored Procedure
DB Function
DB Trigger

MSSQL DATABASE QUIZ QUESTIONS

Application Software
Software Development Life Cycle
Database Components
Database Platforms
GUI tools for SQL Development
Database Table
ROWs and COLUMNs
SQL
Database Hosting
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Types
JSON Data Type
NUll vs NOT NULL
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
AUTO INCREMENT
INSERT
SELECT INTO
UPDATE
UPSERT
DELETE
TRUNCATE
SELECT *
WHERE Clause
TOP FETCH OFFSET
DISTINCT
ORDER BY
BETWEEN Operator
CONCAT
IN Operator
NOT IN Operator
IS NULL Operator
IS NOT NULL Operator
'AND' and 'OR' Operators
'>' and '<' Operator
'< >' or '!=' Operator (not equal)
'=' (equal to) Operator
LIKE Operator
NOT LIKE Operator
EXISTS, ANY and ALL Clause
GROUP BY
SQL Aliases
HAVING Clause
COUNT, SUM, AVG, MIN, MAX Functions
CASE statement
INNER JOIN
LEFT JOIN
RIGHT JOIN
UNION and UNION ALL
PIVOT
Sub Queries
GROUP RANK
JSON SELECT
Arithmetic Operators
Comparison Operators
Logical Operators
STRING functions
DATE functions
NUMERIC functions
SQL Execution Order
COALESCE
CAST
What is RDBMS
Primary Key
Foreign Key
Cardinality
Normalization
Second Normal Form
Third Normal Form
Business key, Natural key and Candidate Key
Surrogate Key
Database Index
Index Types
Structured VS Unstructured
ERD (Data Model)
Database View
Stored Procedure
DB Function
DB Trigger

VIDEOS

Food Delivery System
Store Management System
Facebook Application
Library Management System
Hospital Management System
Banking System
Student Management System
Company Management System
Serverless Setup PostgreSQL
Serverless Setup MySQL
DB Server Setup
MySQL Query Editor
Assignment
SQL
ROWs and COLUMNs
Database Table
Tansy Cloud Business Application
GUI tools for SQL Development
Database Platforms
Database Components
Software Development Life Cycle
Application Software
Introduction
COALESCE
CAST
SQL Execution Order
NUMERIC functions
DATE functions
STRING functions
Logical Operators
Comparison Operators
Arithmetic Operators
JSON SELECT
Group Rank
Sub Queries
PIVOT
UNION and UNION All
RIGHT JOIN
Tansy Cloud Assignments
LEFT JOIN
INNER JOIN
CASE Statement
COUNT, SUM, AVG, MIN, MAX Functions
HAVING Clause
GROUP BY
SQL Aliases
EXISTS, ANY and ALL Clause
NOT LIKE Operator
LIKE Operator
Not Equal to Operator
Greater than and Less than Operator
AND' and 'OR' Operators
IS NOT NULL Operator
IS NULL Operator
NOT IN Operator
IN Operator
CONCAT
BETWEEN Operator
ORDER BY
DISTINCT
LIMIT
WHERE Clause
SELECT *
TRUNCATE
DELETE
UPSERT
UPDATE
SELECT INTO
INSERT
Foreign Key
Primary Key
AUTO INCREMENT
UNIQUE Constraint
DEFAULT Constraint
CHECK Constraint
NUll vs NOT NULL
JSON Data Type
Data Types
DROP TABLE
ALTER TABLE
CREATE TABLE
Tansy Academy SQL Training Introduction

OTHER PAGES

Courses
Subscriptions
Internship
SQL Database Projects
Online SQL query Editor/Tool
MSSQL Quiz Questions
Oracle Interview Questions
About Us
Terms & Conditions
Privacy Policy
Refund Policy
MySQL Quiz Questions
PostgreSQL Quiz Questions
MSSQL Interview Questions
Sitemap
Contact Us
Testimonials
SQL Training Intro
Oracle Quiz Questions
MySQL Interview Questions
PostgreSQL Interview Questions