COVID-19

For the latest information, resources, and guidelines related to COVID-19, please visit the Coronavirus.wa.gov.

For DES operating procedures, visit the DES COVID-19 Information page.

Class / Schedule

-

Information Technology

SQL Server Fundamentals (2 Days)

01-04-T807
Would you like to have a solid foundation of the concepts of SQL Server before delving into the complexities of Microsoft’s most powerful database application? This introductory course covers the essentials for anyone who is new to SQL Server. Practical, hands-on exercises will help reinforce the key features of database design, creation, testing, and deployment.

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

    • Discuss how a SQL Server database works.
    • Install SQL Server Express.
    • Design simple tables.
    • Retrieve and manipulate data with simple T-SQL queries.
    • Make and use views.
    • Insert, update and delete in SQL Databases.
    • Have a basic understanding of triggers and functions.
    • Become familiar with indexes.
    • Have a plan of where to go from here with SQL

    Competencies covered in this class:Database Administration and Management.

    Intended Audience: Anyone who wants a basic overview of SQL Server.

    Prerequisites: Participants should be familiar with relational database concepts or have taken the Relational Database Fundamentals class.

    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 12 2020 8:00am-4:30pm
    • Aug 13 2020 8:00am-4:30pm
    $595.00 Thu, 07/23/2020 - 17:00 Bernie Benson