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

    Performance Objectives: Upon completion 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()

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


        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.

        Scheduled Class Location and Dates
        City / Facility Date and Time Course Cost Cancel Date Instructor
        1 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Aug 26 2019 8:00am-4:30pm
        • Aug 27 2019 8:00am-4:30pm
        $595.00 Wed, 08/07/2019 - 17:00 Jillian Bates
        2 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Sep 17 2019 8:00am-4:30pm
        • Sep 18 2019 8:00am-4:30pm
        $595.00 Thu, 08/29/2019 - 17:00 Jillian Bates
        3 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Oct 16 2019 8:00am-4:30pm
        • Oct 17 2019 8:00am-4:30pm
        $595.00 Sun, 09/29/2019 - 17:00 Jillian Bates
        4 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Nov 13 2019 8:00am-4:30pm
        • Nov 14 2019 8:00am-4:30pm
        $595.00 Sun, 10/27/2019 - 17:00 Jillian Bates
        5 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Dec 9 2019 8:00am-4:30pm
        • Dec 10 2019 8:00am-4:30pm
        $595.00 Wed, 11/20/2019 - 16:00 Jillian Bates
        6 Lacey

        SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Jan 13 2020 8:00am-4:30pm
        • Jan 14 2020 8:00am-4:30pm
        $595.00 Wed, 12/25/2019 - 16:00 Jillian Bates