Learn SQL for Database Programming

 

Course Details and Syllabus

 Enroll
Course: Learn SQL for Database Programming
Tuition: $398
Time Frame: Due to our monthly lab fee system, this course is completely self-paced. You can expect to work approximately 40 hours on this course.
Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world.
CEUs: 4 Continuing Education Units with official letter from the University of Illinois Office of Continuing Education.
Software: The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you'll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.
Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.
Book: All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you'll receive the free book SQL in a Nutshell, Second Edition as a complimentary reference from O'Reilly.
Certificates: Completion of this course counts toward both the Web Programming Certificate Series and the Open Source Programming Certificate Series.
Prerequisites: Introduction to HTML and CSS and Learn Perl for CGI Programming, or equivalent skills in HTML and Perl. This course is meant for the beginning or intermediate programmer.
Topics: Creating Databases and Tables, Inserting Information, Retrieving Information, PERL DBI, Searching, Application Development, etc.
Syllabus:
  • SQL Lab 1 -- Introduction
    • Brief Introduction to SQL

  • SQL Lab 2 -- A Quick Overview of MySQL
    • Getting Familiar with MySQL Environment
    • Alternative Method of Logging In
    • MySQL Syntax

  • SQL Lab 3 -- Creating a Database
    • Structure of SQL
    • Creating Databases and Tables
    • Checking Tables
    • Inserting Values into Tables
    • Retrieving Data from Tables

  • SQL Lab 4 -- Searching Through Tables
    • Further Study on Insert
    • Exploring the Select Keyword

  • SQL Lab 5 -- More SQL Syntax
    • Dealing with Time and Date
    • Date Manipulation

  • SQL Lab 6 -- Managing Tables
    • Deleting Tables
    • Altering Tables
    • Renaming Tables
    • Deleting Table Entries

  • SQL Lab 7 -- Getting Familiar with DBI
    • What is DBI?
    • Exploring DBI
    • Changing single quotes to \'

  • SQL Lab 8 -- Project Address/Phone Book, Part 1
    • Project Description
    • Database Layout
    • Setting Up Database:

  • SQL Lab 9 -- Project Address/Phone Book, Part 2
    • Starting with the HTML Form
    • Storing the Data into SQL through PERL/DBI
    • Breaking Down addentry.cgi

  • SQL Lab 10 -- Project Address/Phone Book, Part 3
    • Construction of viewbook.cgi

  • SQL Lab 11 -- Advanced SQL Syntax, Part 1
    • Date and Time Functions

  • SQL Lab 12 -- Advanced SQL Syntax, Part 2
    • Math Functions

  • SQL Lab 13 -- Advanced SQL Syntax, Part 3
    • String and Character Functions

  • SQL Lab 14 -- Relational Databasing
    • Quick Overview of Relational Databasing
    • Setup for Relational Databasing
    • Inner Joins
    • Aliases
    • Natural Join
    • Left Outer Join/Right Outer Join

  • SQL Lab 15 -- Refining SQL Syntax
    • Preparation
    • Group By
    • Order By
    • General SQL Syntax
Enroll
Learn and Achieve - Enroll Now

Earn a Certificate

for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.

Illinois