Objectives
Course Outline
Upon completing this course, the learner will be able to meet these overall objectives:

  • Enhance the knowledge and understanding of Database analysis and design.
  • Enhance the knowledge of the processes of Database Development and Administration using SQL
  • Enhance Programming and Software Engineering skills and techniques using SQL
  • Preparation of background materials and documentation needed for Technical Support using SQL
  • Use the Relational model and how it is supported by SQL
  • Course Overview
  • Writing Basic SQL SELECT Statements
  • Restricting and Sorting Data
  • Single-Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data Using Group Functions
  • Subqueries
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Controlling User Access
  • Using SET Operators
  • Enhancements to the GROUP BY Clause
  • Hierarchical Retrieval
  • Extensions to DML and DDL Statements