SQL Introduction - Online

ID : 14507   
« back to classes page

Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language. You'll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

Learning Objectives:

  • Define relational database, and understand how it relates to Structured Query Language (SQL).
  • Demonstrate SQL syntax and how to sort and retrieve data in SQL.
  • Use the ORDER BY clause and how to do wildcard-character filtering.
  • Create and implement calculated fields and functions in SQL.
  • Summarize data using the GROUP BY and HAVING clauses.
  • Create and implement subqueries.
  • Create and use table joins.
  • Insert, update, and delete data from tables.
  • Create and maintain tables using SQL.
  • Create and use views in SQL.
  • Process transactions and how to create constraints and indexes.
  • Create and implement stored procedures, triggers, and cursors.

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 any database management system that supports the execution of Structured Query Language (SQL), such as Microsoft Access, SQL Server, MySQL, or Sybase. Please be sure to install required software on your computer before the course begins.

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)
9/13/2017 - 10/20/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor 

Other Class Offerings

SQL Introduction - Online
ID: 15948

10/18/17 - 11/24/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor

SQL Introduction - Online
ID: 15949

11/08/17 - 12/15/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor