Managing Data(bases) using SQL


You are here: [Managing Data(bases) using SQL Syllabus]

Printable Version

Managing Data(bases) using SQL: Course Syllabus Fall 2018

Currently no courses scheduled for this term.

Class 1

  • Overview of SQL
  • History of SQL
  • History of SQL Standards
  • Relational Database Theory, Normalization Rules
  • Basic CREATE TABLE statement
  • Primary/Foreign Key Constraints

Class 2

  • Basic SELECT Statement
  • ORDER BY Clause
  • WHERE Clause
  • Concept of Null
  • DISTINCT Predicate

Class 3

  • Numeric Data in SQL
  • Temporal Data in SQL
  • Character Data in SQL
  • Concept of Null

Class 4

  • Complex Filtering of Data
  • SQL Expressions
  • Intersect, Difference, and Union of Sets

Class 5

  • Inner Join
  • Inner Joins on more than 2 Tables
  • Outer Join
  • Non-Equi Join
  • Self Join

Class 6

  • Aggregate Functions
  • Grouping Data
  • Filtering Grouped Data

Class 7

  • SQL Subqueries
  • Subqueries as Column Expressions
  • Subqueries as Filter Expressions
  • Subqueries as From Clause Expressions
  • Correlated Subqueries
  • Subquery Factoring (WITH Clause)
  • Top-N Analysis

Class 8

  • INSERT Statement
  • Multi-Table INSERT Statements
  • DELETE Statement
  • UPDATE Statement
  • MERGE Statement

Class 9

  • Database Transactions and Locking
  • Overview of DDL
  • ALTER TABLE Statement
  • DROP TABLE Statement
  • Other Table DDL Statements
  • Constraints
  • Managing Views
  • Overview of DCL
  • Managing Users, System and Object Privileges

Class 10

  • Review of Final Exam
  • Hierarchical SQL
  • OLAP in SQL
  • Regular Expressions
  • GUI Tools to access Databases
  • Functions
  • Triggers and Stored Procedures