Why this course?

Description

Syllabus of the SQL Test

Unit - 1
Introduction on SQL: Characteristics of SQL, Advantage of SQL. SQL Data Type and Literals. Types of SQL Commands. SQL Operators and Their Procedure, DDL, DML, DCL, TCL.

Unit - 2
Tables: Creating, Modifying, Deleting. Indexes, Updating. SQL DML Queries: SELECT Query and clauses, Index and Sequence in SQL. Views: Creating, Dropping, Updating using Indexes, Set Operations

Unit - 3
Predicates and Joins, Unions, Set membership, Intersection, Minus, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, SQL Functions, Nested Queries.PL/SQL: Concept of Stored Procedures and Functions, Cursors, Triggers, Assertions, Roles and Privileges.