Class / Schedule

Information Technology

SQL Structured Query Language Level 1 (2 Days)

01-04-T808
Structured Query Language (SQL) is the programming language for managing data in relational databases. In this course, you will practice writing your own SQL queries to retrieve, summarize and even modify data, and answer questions concerning your agency’s business information. You 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, such as Oracle, MySQL or Access.

    Performance Objectives: Upon completion of this course you should be able to:

    • Retrieve data using SELECT statement and 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.

      Compentencies covered in this course: Database Administration and Management.

          Intended Audience: This course is appropriate for anyone responsible for writing queries using SQL.

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

            Scheduled Class Location and Dates
            City Facility Date and Time Course Cost Cancel Date Instructor
            Lacey SPSCC - LACEY
            4220 6th Ave SE Bldg. 1
            Lacey, WA 98503
            • May 22 2017 8:00am-4:30pm
            • May 23 2017 8:00am-4:30pm
            $595.00 Wed, 05/03/2017 - 17:00 Jillian Bates
            Lacey SPSCC - LACEY
            4220 6th Ave SE Bldg. 1
            Lacey, WA 98503
            • Jun 13 2017 8:00am-4:30pm
            • Jun 14 2017 8:00am-4:30pm
            $595.00 Thu, 05/25/2017 - 17:00 Jillian Bates
            Lacey SPSCC - LACEY
            4220 6th Ave SE Bldg. 1
            Lacey, WA 98503
            • Jul 26 2017 8:00am-4:30pm
            • Jul 27 2017 8:00am-4:30pm
            $595.00 Sun, 07/09/2017 - 17:00 Jillian Bates
            Lacey SPSCC - LACEY
            4220 6th Ave SE Bldg. 1
            Lacey, WA 98503
            • Aug 9 2017 8:00am-4:30pm
            • Aug 10 2017 8:00am-4:30pm
            $595.00 Sun, 07/23/2017 - 17:00 Jillian Bates