SQL Intermediate - Online

ID : 13044   
« back to classes page

Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. In this course, you’ll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. You’ll explore how to write and implement complex queries on multiple tables simultaneously, and you’ll discover advanced filtering, update, and insertion techniques. You’ll also find out how to create queries that accept input from users and queries that perform complicated searches on strings and dates. By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.

Prerequisite: SQL Introduction (or equivalent experience)

Learning Objectives:

  • Review basic concepts of SQL.
  • Review the basics of subqueries and learn to write and implement complex subqueries.
  • Learn how to create advanced joins to query multiple tables simultaneously.
  • Learn advanced filtering techniques that implement the LIKE operator.
  • Learn how to use string functions to manipulate strings.
  • Create and implement parameter queries.

This course is part of the Advanced Web Design & Development Certificate.

View a course demo

For our online course refund policy, click here.

Requirements: Internet access, e-mail, Firefox or Internet Explorer web browser, and Microsoft Access 2003 or later. Software is not included in course fee.

You will need to create a login for your online classroom. Go to www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the ‘Add to Cart’ button (this site does not accept payments - you will not be charged here). Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.

If you have questions about this course, please contact the online coordinator at 470-578-3355 or online@kennesaw.edu.

Class Details

38 Sessions
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor 

CEUs : 2.4

Fee: 

$179.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/12/2017 - 5/19/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor 

Other Class Offerings

SQL Intermediate - Online
ID: 13045

05/17/17 - 06/23/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor

SQL Intermediate - Online
ID: 13046

06/14/17 - 07/21/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor