Course Offerings

When it comes to query language for relational database management systems, SQL is the industry benchmark. This hands-on course will help you advance your knowledge and keep pace with today's SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.

Course Objectives

Learn the current SQL standards.

Outline of instruction

Lesson 1 - SQL Review

Lesson 2 - Joining Multiple Tables

Lesson 3 - Filtering Rows

Lesson 4 - Grouping and Summarizing Rows

Lesson 5 - Subqueries

Lesson 6 - Tables and Data Maintenance

Lesson 7 - Unions and Other Joins

Lesson 8 - Using String and Date Functions

Lesson 9 - Stored Procedures

Lesson 10 - Indexes and Views

Lesson 11 - Triggers

Lesson 12 - SQL Server Management Studio

Contact Hours

24

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

Introduction to SQL

Text and Supplies Needed

Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
SQL Server Express
SQL Server Management

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date."

Accreditation/Special Approval Requirements

N/A

Intended Audience

If you're interested in learning more about SQL, this course is for you!

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]