QuizTestOm
Home
About Us
Syllabus for Course: SQL
SQL
Database Design Concepts
Normalization
Start Quiz
ER Modeling
Start Quiz
Primary Key vs Foreign Key
Start Quiz
Schema Design Best Practices
Start Quiz
Schema Design & Best Practices
Start Quiz
Data Manipulation Language
DELETE
Start Quiz
INSERT
Start Quiz
MERGE
Start Quiz
UPDATE
Start Quiz
Views & Indexes
Views
Start Quiz
Updateable vs Non-Updateable Views
Start Quiz
Indexes
Start Quiz
Creating and Dropping Indexes
Start Quiz
SQL Operators
LIKE Operator
Start Quiz
Comparison Operators
Start Quiz
Logical Operators
Start Quiz
BETWEEN
Start Quiz
IN
Start Quiz
LIKE
Start Quiz
IS NULL
Start Quiz
Transactions and TCL
COMMIT and ROLLBACK
Start Quiz
COMMIT
Start Quiz
ROLLBACK
Start Quiz
SAVEPOINT
Start Quiz
RELEASE SAVEPOINT
Start Quiz
SET TRANSACTION
Start Quiz
Introduction to SQL
Types of SQL Commands
Start Quiz
What is SQL?
Start Quiz
SQL Syntax
Start Quiz
Case Sensitivity
Start Quiz
SQL Data Types Overview
Start Quiz
SQL History & Standards
Start Quiz
SAVEPOINT
Start Quiz
Data Control Language
GRANT
Start Quiz
REVOKE
Start Quiz
User Privileges and Roles
Start Quiz
Data Control Language (DCL)
GRANT
Start Quiz
REVOKE
Start Quiz
User Privileges and Roles
Start Quiz
Grouping and Filtering
GROUP BY Clause
Start Quiz
WHERE Clause
Start Quiz
HAVING Clause
Start Quiz
ORDER BY Clause
Start Quiz
DISTINCT Keyword
Start Quiz
GROUP BY
Start Quiz
Subqueries
Correlated Subquery
Start Quiz
Single Row Subquery
Start Quiz
Multiple Row Subquery
Start Quiz
Subqueries in SELECT Clause
Start Quiz
Subqueries in FROM Clause
Start Quiz
Subqueries in WHERE Clause
Start Quiz
Data Definition Language (DDL)
CREATE Table
Start Quiz
CREATE
Start Quiz
ALTER
Start Quiz
DROP
Start Quiz
TRUNCATE
Start Quiz
RENAME
Start Quiz
Stored Procedures & Triggers
Triggers
Start Quiz
Stored Procedure Basics
Start Quiz
Creating Stored Procedures
Start Quiz
Executing Stored Procedures
Start Quiz
Triggers - Basics
Start Quiz
Trigger Events
Start Quiz
BEFORE vs AFTER Trigger
Start Quiz
Set Operators
UNION vs UNION ALL
Start Quiz
UNION
Start Quiz
INTERSECT
Start Quiz
EXCEPT & MINUS
Start Quiz
Rules & Requirements
Start Quiz
UNION ALL
Start Quiz
Advanced SQL
Window Functions
Start Quiz
Common Table Expressions (CTE)
Start Quiz
Recursive CTEs
Start Quiz
Pivoting Data
Start Quiz
Ranking Functions
Start Quiz
SQL Joins
INNER JOIN
Start Quiz
LEFT JOIN
Start Quiz
RIGHT JOIN
Start Quiz
FULL OUTER JOIN
Start Quiz
SELF JOIN
Start Quiz
CROSS JOIN
Start Quiz
NATURAL JOIN
Start Quiz
SQL Functions
COUNT() Function
Start Quiz
Aggregate Functions
Start Quiz
Scalar Functions
Start Quiz
String Functions
Start Quiz
Numeric Functions
Start Quiz
Date Functions
Start Quiz
Conversion Functions
Start Quiz
Data Query Language (DQL)
SELECT Statement
Start Quiz
SELECT Basics
Start Quiz
Filtering with WHERE
Start Quiz
Sorting with ORDER BY
Start Quiz
Limiting with LIMIT & TOP & ROWNUM
Start Quiz
SELECT with Expressions
Start Quiz