We're offering 20% off September Live Online classes! See which courses are applicable.   |   Details

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

Group Training + View more dates & times


Through hands-on labs, students will explore the SQL standard, giving users an understanding of the SQL Language. The course introduces the concepts of database design and data modeling. Students will be able to distinguish between DDL statements and DML statements and their uses in building queries. Standard SQL operators and functions will be used to learn how to filter queries. Students will learn how to use joins, set operations, and sub-queries to gather information distributed among several tables.
This course provides a foundation for anyone looking to delve deeper into the world of databases.

This is a 4-day course.

Who Should Take This Course


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


A strong desire, passion and commitment to learn SQL and database fundamentals. Students should have basic computer literacy including use of a browser and a basic text editor such as Atom.

Course Outline

Database Design
• Introduction to Databases
• The Relational Data Model
• Introductory Relational Database Terminology
• Codd’s 12 Rules
• Normalization
• First Normal Form
• Second Normal Form
• Third Normal Forms

Data Modeling
• The Entity Relationship Model
• Entity Relationship Diagrams
• Entity Relationship Diagrams (1:1)
• Entity Relationship Diagrams (1:M)
• Entity Relationship Diagrams (M:N)
• A Sample Database

Using MySQL
• Introduction to MySQL
• The MySQL Command Line Interface
• Getting Help
• MySQL Workbench
• Navigating MySQL Workbench
• Creating a Database and Sample Tables
• Displaying Information About Tables

Data Definition Language
• Categories of SQL Statements
• SQL Data Types
• The CREATE Statement
• The DROP Statement
• The ENUM Data Type
• The ALTER Statement
• Integrity Constraints
• Domain Integrity Constraints
• Creating a Table with Domain Constraints
• Entity Integrity Constraints
• Referential Integrity Constraints
• Altering a Table’s Constraints

Data Manipulation Language
• DML Statements
• The SELECT Statement
• The ORDER BY Clause
• The INSERT Statement
• The DELETE Statement
• The UPDATE Statement

Transaction Control
• Transactions
• The ROLLBACK Statement
• The COMMIT Statement
• The SAVEPOINT Statement

SQL Operators
• Comparison Operators
• IN and NOT IN Operators
• BETWEEN Operator
• The LIKE Operator
• Logical Operators
• CASE Statements

SQL Functions
• Introduction
• The DISTINCT Keyword
• Aliases
• Miscellaneous Functions
• Mathematical Functions
• String Functions
• Date Functions

Joining Tables
• Joins
• Cross Join
• Inner joins
• Equi-Join
• Non-Equi Join
• Non-Key Join
• Self Join
• Natural Join
• The USING Clause
• Outer Joins
• Right Outer Join
• Left Outer Join

Set Operators
• Introduction
• Selection Criteria
• Creating Sample Data
• Union
• Union All

SQL Subqueries
• Introduction
• Using a Sub-query with a DML Statement
• Typical Sub-queries
• Sub-query Operators
• Standard vs. Correlated Sub-queries
• Correlated Sub-query Example
• Predicate Operators

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

Stored Procedures
• Objectives
• Creating Stored Procedures
• Executing Stored Procedures
• Stored Procedures with Parameters
• Dropping Stored Procedures

More Database Objects
• More Database Objects
• Relational Views
• Updating a View
• Indexes

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. Asynchronous 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