AccountIcon BigDataIcon BlogIcon default_resource_icon CartIcon checkmark_icon cloud_devops_icon computer_network_admin_icon cyber_security_icon gsa_schedule_icon human_resources_icon location_icon phone_icon plus_icon programming_software_icon project_management_icon redhat_linux_icon search_icon sonography_icon sql_database_icon webinar_icon

Search UMBC Training Centers

SQL Databases

Introduction to SQL

+ View more dates & times
  • 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.

    Upon completing this course, students will be able to:

    • Explain the difference between SQL, DML, and DDL statements
    • 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
  • Who Should Take This Course

    AUDIENCE

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

  • Schedule
  • Course Outline

    Chapter 1: Database Design

    • Database Models
    • Beginnings
    • Some Introductory Terminology
    • Codd’s 12 Rules
    • Normalization
    • First Normal Form
    • Higher Order Normal Forms

    Chapter 2: Standard Interfaces

    • SQL
    • Architecture
    • Command Line Interface
    • Viewing a Sample Table

    Chapter 3: The Sample Database

    • 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

    Chapter 4: Data Definition Language

    • 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

    Chapter 5: Data Manipulation Language

    • DML Statements
    • The SELECT Statement
    • The INSERT Statement
    • The DELETE Statement
    • The UPDATE Statement

    Chapter 6: Transaction Control

    • Transactions
    • Command Classification

    Chapter 7: SQL Operators

    • Simple Selects
    • Comparison Operators
    • IN and NOT IN Operators
    • BETWEEN Operator
    • The LIKE Operator
    • Logical Operators
    • IS NULL and IS NOT NULL
    • ANY
    • ALL

    Chapter 8: SQL Functions

    • Introduction
    • The DISTINCT Keyword
    • Aliases
    • Miscellaneous Functions
    • Mathematical Functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Pseudo Columns

    Chapter 9: Joining Tables

    1. Joins
    2. Cartesian Product
    3. Inner joins
    4. Equi-Join
    5. Table Aliases
    6. Non-Equi Join
    7. Non-Key Join
    8. Reflexive Join
    9. Natural Join
    10. Outer Joins
    11. Right Outer Join
    12. Left Outer Join
    13. Full Outer Join
    14. Syntax for Outer Joins

    Chapter 10: Set Operators

    • Introduction
    • Selection Criteria
    • Union
    • Union All
    • Intersect
    • Minus

    Chapter 11: SQL Subqueries

    • Introduction
    • Using a Subquery with a DML Statement
    • Typical Subqueries
    • Subquery Operators
    • Standard vs. Correlated Subqueries
    • Correlated Subquery
    • Example Predicate Operators

    Chapter 12: Groups

    • SQL Statements
    • GROUP BY Clause
    • HAVING Clause
    • Order of a SELECT Statement

    Chapter 13: More Database Objects

    • More Database Objects
    • Relational Views
    • Updating a View
    • Create or Replace
    • Forcing a View
    • The Data Dictionary Revisited
    • Indexes
    • Synonyms
  • FAQs
    Is there a discount available for current students?

    UMBC students and alumni, as well as students who have previously taken a public training course with UMBC Training Centers are eligible for a 10% discount, capped at $250. Please provide a copy of your UMBC student ID or an unofficial transcript or the name of the UMBC Training Centers course you have completed. Online courses are excluded from this offer.

    What is the cancellation and refund policy?

    Student will receive a refund of paid registration fees only if UMBC Training Centers receives a notice of cancellation at least 10 business days prior to the class start date for classes or the exam date for exams.

Contact Us