SQL Certification

Chapters :

1. "Aliases
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
   • Constraints and Clauses"
2. "Understanding Triggers
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
   • Cursors and Stored procedures"
3. Introduction to SQL
   • What is a Database?
   • Introduction to DBMS
   • Advantages and Disadvantages of DBMS
   • Types of Database Management Systems
   • Introduction to SQL
   • History of SQL
   • SQL Statement Classes
   • SQL Process
   • SQL Language Elements and PL/SQL
   • Dynamic SQL
   • Summary
   • Self Study Descriptive Questions
   • Self Study Multiple Choice Questions
4. Introduction to Views and Complex Queries
   • Views
   • Advantages and Disadvantages of Views
   • Nested Queries or Subqueries Contd.
   • Complex Queries
   • Nested Queries or Subqueries
   • Examples of Complex Queries
   • Summary
   • Self Study Descriptive Questions
   • Self Study Multiple Choice Questions
5. Joins and Functions
   • The JOIN Clause
   • Inner Join
   • Outer Join
   • Functions
   • Summary
   • Self Study Descriptive Questions
   • Self Study Multiple Choice Questions
   • Cross Join
   • Aggregate Functions
   • Scalar Functions
6. Maintenance and Control of table
   • Introduction
   • SELECT Statement
   • INSERT Statement
   • UPDATE Statement
   • DELETE Statement
   • GRANT Statement
   • REVOKE Statement
   • Summary
   • Self Study Multiple Choice Questions
   • Self Study Descriptive Questions
7. Relational Algebra
   • Basics of Relational Algebra
   • Projection
   • Selection
   • Renaming and Union
   • Intersection and Assignment
   • Summary
   • Self Study Descriptive Questions
   • Self Study Multiple Choice Questions
   • Cartesian Product
8. Schemas and Different Types of Commands
   • Introduction of Schema
   • "Creating
   • Data Definition Language
   • Altering Various Database Objects
   • Data Control Language
   • Summary
   • Self Study Descriptive Questions
   • Self Study Multiple Choice Questions
   • "Data Manipulation Language-Inserting
   • Metadata
   • "Derived Tables
9. Self Study Answer Key
   • Chapter 1: Answers
   • Chapter 2: Answers
   • Chapter 3: Answers
   • Chapter 4: Answers
   • Chapter 5: Answers
   • Chapter 6: Answers
   • Chapter 7: Answers
   • Chapter 8: Answers
   • Chapter 9: Answers
   • Chapter 10: Answers
   • asdasd
   • Chapter 1: Answers
   • Chapter 2: Answers
   • Chapter 3: Answers
   • Chapter 4: Answers
   • Chapter 5: Answers
   • Chapter 6: Answers
   • Chapter 7: Answers
10. SQL Basic Objects
    • SQL Basic Objects
    • Datatypes
    • Operators
    • Summary
    • Self Study Descriptive Questions
    • Self Study Multiple Choice Questions
    • Self Study Multiple Choice Questions
11. Sub Queries and Normalization
    • Introduction to Sub Query
    • Building Nested Sub Query
    • Normalization
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
    • Other Normal Forms
    • Fourth Normal Form
    • Fifth Normal Form
    • Summary
    • Self Study Descriptive Questions
    • Self Study Multiple Choice Questions
    • Correlated Sub Query
12. Understanding Transactions and Indexes
    • Multiuser Databases
    • Transaction
    • Index
    • Types of Index
    • Summary
    • Self Study Descriptive Questions
    • Self Study Multiple Choice Questions