SQL

SQL

OVERVIEW

This course is designed to give users an understanding of SQL Language. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.

After completing this course, students will be able to:

  • Write basic SQL queries to retrieve desired data
  • Use DML statements (insert, update, and delete)
  • Use DDL statements (create, alter, and drop)
  • Use transaction control statements to commit and rollback
  • Write advanced queries
  • Write scripts to perform queries and display reports
  • Control access to your database objects
  • Explain the difference between SQL, DML, and DDL statements

WHO SHOULD TAKE THIS COURSE

This course is suitable for application designers and developers, database administrators and operators, and end users

Course Contents

  • Database Models
  • Beginnings
  • Some Introductory Terminology
  • Codd’s 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms
  • SQL
  • Architecture
  • Command Line Interface
  • Viewing a Sample Table
  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • ER Diagram for Sample Database
  • Creating the Sample Data
  • Viewing Sample Data Data
  • Types of the Sample Data
  • Categories of SQL Statements
  • Datatypes
  • The CREATE Statement
  • The DROP Command
  • The ALTER Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Modifying Table to Use Constraints
  • Checking Constraints
  • The Data Dictionary
  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • Transactions
  • Command Classification
  • Simple Selects
  • Comparison Operators
  • IN and NOT IN Operators
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL
  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Pseudo Columns
  • Joins
  • Cartesian Product
  • Inner joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Syntax for Outer Joins
  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus
  • Introduction
  • Using a Subquery with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs. Correlated Subqueries
  • Correlated Subquery
  • Example Predicate Operators
  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement
  • More Database Objects
  • Relational Views
  • Updating a View
  • Create or Replace
  • Forcing a View
  • The Data Dictionary Revisited
  • Indexes
  • Synonyms