We’re offering up to 50% off our Live Online June and July offerings! 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

+ View more dates & times
  • Overview

    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.

  • Who Should Take This Course

    AUDIENCE

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

    prerequisites

    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.

  • Schedule
  • 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
    • SQL
    • 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
    • IS NULL and IS NOT NULL
    • 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

    Groups
    • 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

  • 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