Information Technology

SQL Server Fundamentals (2 Days) - Virtual or In-person

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.

    Virtually Led Trainings: If you’re registering for a virtual training, the classroom link and materials will be sent to you separately within 1-2 business days before the scheduled class date.

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

    Virtual Training
    • Feb 10 2021 8:00am-4:30pm
    • Feb 11 2021 8:00am-4:30pm
    $595.00 Sun, 01/24/2021 - 16:00 Bernie Benson