Sign In   |   View Cart   |     |   Help
 
Course Catalog
 
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Community Education > Alphabetic Class List

SQL Structured Query Language Level 1  

Structured Query Language (SQL) is the programming language for managing data in relational databases. In this course, we will practice writing SQL queries to retrieve, summarize, modify data, and analyze business data. We will also discuss the theory and logic behind the language and its elements. We will use SQL Server and T-SQL (Microsoft’s SQL dialect) for class exercises, but the material is useful for anyone using other relational database systems (e.g. Oracle, MySQL, Access, MariaDB).
This course is appropriate for anyone responsible for writing queries using SQL.

At the end of this course you should be able to:
  • Retrieve data using SELECT statement
  • Use WHERE, GROUP BY, HAVING, ORDER BY, and TOP clauses
  • Handle NULL values
  • Join multiple tables using CROSS, INNER, and OUTER JOINS
  • Work with self-contained, correlated and aggregate sub queries
  • Use set operations such as UNION, INTERSECT, and EXCEPT
  • Modify data with the INSERT, DELETE and UPDATE statements
  • Use math related and other functions like SUM, AVG, GETDATE()


  • Prerequisites: A basic knowledge of relational database structures and terminology.

    Other classes you may be interested in: Business Intelligence, SQL Server Reporting Services, and SQL Server Integration Services.

 

SQL Structured Query Language Level 1

Item: C033 Jillian Lamont Bates
8:00 AM - 4:30 PM ONLINE
Sessions: 2 Tu W Location: ONLINE
, WA
7/14/2020 - 7/15/2020 Fee: $595.00

This class is offered online using Zoom and Remote Desktop.

Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.


  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    SQL Structured Query Language Level 1

    Item: C066 Jillian Lamont Bates
    8:00 AM - 4:30 PM ONLINE
    Sessions: 2 M Tu Location: ONLINE
    , WA
    8/17/2020 - 8/18/2020 Fee: $595.00

    This class is offered online using Zoom and Remote Desktop.

    Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.


  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    SQL Structured Query Language Level 1

    Item: C139 Jillian Lamont Bates
    8:00 AM - 4:30 PM ONLINE
    Sessions: 2 W Th Location: ONLINE
    , WA
    9/23/2020 - 9/24/2020 Fee: $595.00

    This class is offered online using Zoom and Remote Desktop.

    Zoom Requirements:

  • Access to a computer with speakers & microphone (or the ability to call in via phone).
  • A web camera (suggested but not required).
  • Access to high-speed internet.


  • Zoom link will be sent prior to the start of class. You must have the ability to connect via Remote Desktop on your computer to participate in the class. A second monitor is recommended.

    Refund Policy: Cancellations must be received 5 business days prior to the 1st day of class in order to receive a full refund.

     

    SQL Structured Query Language Level 1

    Item: C163 Jillian Lamont Bates
    8:00 AM - 4:30 PM Lacey Building 1
    Sessions: 2 W Th Location: Room 170
    4220 6th Avenue SE Lacey, WA 98503
    10/21/2020 - 10/22/2020 Fee: $595.00

    Registration for this class will open soon.
     

    SQL Structured Query Language Level 1

    Item: C195 Jillian Lamont Bates
    8:00 AM - 4:30 PM Lacey Building 1
    Sessions: 2 Th F Location: Room 168
    4220 6th Avenue SE Lacey, WA 98503
    11/12/2020 - 11/13/2020 Fee: $595.00

    Registration for this class will open soon.
     

    SQL Structured Query Language Level 1

    Item: C304 Jillian Lamont Bates
    8:00 AM - 4:30 PM Lacey Building 1
    Sessions: 2 Tu W Location: Room 170
    4220 6th Avenue SE Lacey, WA 98503
    12/8/2020 - 12/9/2020 Fee: $595.00

    Registration for this class will open soon.
     

    SQL Structured Query Language Level 1

    Item: C341 Jillian Lamont Bates
    8:00 AM - 4:30 PM Lacey Building 1
    Sessions: 2 W Th Location: Room 170
    4220 6th Avenue SE Lacey, WA 98503
    1/20/2021 - 1/21/2021 Fee: $595.00

    Registration for this class will open soon.