Instructors: Online Quiz
Why this course?
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.
After successful purchase, this item would be added to your courses.You can access your courses in the following ways :