SQL Certification

  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
Icon Mafia