Loading...

Course Description

This course will introduce you to SQL (Structured Query Language), the standard language for requesting, modifying, and maintaining information in a relational database; you will learn the basics of SQL, such as the syntax (or rules) of using SQL and how to use SQL for database queries to answer business questions. You also will learn how to retrieve, group, filter, and summarize data, including information from multiple tables in a database.

See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."

Related Courses

Other Courses

Who Should Attend

This course is designed for business analysts, information specialists, and application developers who need to write SQL data manipulation statements. You will learn ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 LUW and z/OS, MySQL, and Access, with emphasis on SQL Server and Oracle.

Attend and You Will Receive

Upon successful completion of this course, you will receive a certificate of completion from NC State University.

Prerequisites

  • Experience using the editor in which the class is taught: TSO/ISPF in an IBM mainframe environment, any version of Microsoft Windows, or other editor
  • Experience with any programming or query language
  • Basic knowledge of databases

Attend and You Will Learn / Expected Outcome

Expected Outcomes

Individuals who successfully complete this course will understand and be able to use the basic functions of SQL.

 

Attend And You Will Learn

Introduction

  • Relational database concepts
  • Overview of SQL: syntax, using editors
  • Getting acquainted with the course database

SELECT Statements

  • Selecting columns and expressions, using aliases
  • Selecting from various objects, including tables and views
  • Using a Where clause to narrow the search: comparisons 
  • including Between, In, and Like
  • Sorting data with the Order By clause

Functions and Expressions

  • Functions for handling nulls, character strings, numbers and date/time values
  • Miscellaneous operators, including arithmetic and concatenation
  • Case logic, using simple and searched variations

Updating

  • Brief overview of transactions, commit, rollback, locking, column constraints, referential integrity, and identity keys
  • Inserting rows
  • Updating and merging rows
  • Deleting

Joins

  • Inner joins: traditional and ISO standard
  • Outer joins
  • Self-joins

Subqueries and Unions

  • Subqueries as alternatives to certain joins, using In and Exists
  • Using Not In and Not Exists to find the difference of two sets of rows
  • Set operators, including Union, Union All, Intersect and Minus/Except

Summarization

  • Aggregate functions, including Count, Max, Min, Sum, and Avg
  • Using the Group By clause to summarize data
  • Filtering groups with the Having clause

Applying SQL to Real-World Problems

  • Techniques for understanding and solving the problem: re-wording, diagramming, using other people, using a systematic approach to writing SQL queries
  • Final group lab
  • Additional exercises for continued learning
Loading...

Enroll Now - Select a section to enroll in

Section Title
SQL Level 1
Type
Online
Days
M, T, W
Time
9:00AM to 4:00PM
Dates
Sep 14, 2020 to Sep 16, 2020
Schedule and Location
Contact Hours
21.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Registration Fee non-credit $1,099.00