Online Course: SQL Programming - Certificate and CEUs
UniversalClass - Connecting Teachers and Learners WorldwideJoin Now | Sign In | Shopping Cart
Friday, May 16, 2008
You Are Here: Home > School of Technology > Programming SQL >
Learn Online: SQL Programming
Home Course Catalog A - Z List Teach Online My Transcript My Classes

- Areas of Study -

Course Information Syllabus Request Information Tell a Friend Similar CoursesMore Options
 

Online Class: SQL Programming

Use this form to join this online class.

- OR -
Course Cost
Basic Course: $199.00
with Certificate & CEUs: $224.00
This course is for everybody who wants to learn SQL programming. You don't need to have programming or database experience to take this course. This course will teach you basic concepts of databases and then teach how to access and manipulate information stored in the databases using SQL. Topics include SQL create, SQL select, SQL insert, SQL where clause, SQL distinct clause, SQL aggregate functions, SQL group functions, SQL joins, Foreign key, Primary Key etc. By the end of this course, you will be able to create, delete and modify databases, tables, indexes. You will be able to retrieve information from databases using SQL queries and will be proficient in writing and understanding SQL queries. Each lesson would be followed by a SQL programming assignment to master all the concepts taught in the lesson. Each assignment will require you to write a couple of SQL queries. Enroll today! This is a self-paced, online course. You have 6 months to finish. An instructor will monitor your progress and assess your body of work at course completion. UniversalClass™ offers many wonderful learning tools to help you get the most out of your online course, including an online portfolio service that manages all your course completions.

If you would like to receive more information regarding this course, scroll down and fill out the "Request More Information" form and we'll try to answer any of your questions within the day.

Continuing Education Units (CEU)
1.0 CEUs

Course Description

This course is for everybody who wants to learn SQL programming. You don't need to have programming or database experience to take this course. This course will teach you basic concepts of databases and then teach how to access and manipulate information stored in the databases using SQL. Topics include SQL create, SQL select, SQL insert, SQL where clause, SQL distinct clause, SQL aggregate functions, SQL group functions, SQL joins, Foreign key, Primary Key etc. By the end of this course, you will be able to create, delete and modify databases, tables, indexes. You will be able to retrieve information from databases using SQL queries and will be proficient in writing and understanding SQL queries. Each lesson would be followed by a SQL programming assignment to master all the concepts taught in the lesson. Each assignment will require you to write a couple of SQL queries. I will be there to assist in doing the programming assignments. Learn SQL Programming, the language used with every relational database. This course is not a SQL tutorial but an instructor led online course to learn SQL Programming . Students also need to take online quiz after completing each lesson. Quiz will test you on SQL Programming concepts taught in the class lessons. I will be there to answer all your questions related to class lessons, programming assignments, quiz and exams. You can complete this course as early as in ten weeks and start programming in SQL or complete at your own pace.
This course is for everybody who wants to learn SQL programming and you don't need to have programming or database experience. Basic familiarity with computer is required though. You also need to have access to a DBMS. You can download MySql free from www.mysql.com . A link is provided in the course Netlinks.

By the end of this course you will be able to: 1. Create and Delete Databases, 2. Create, Alter and Delete Tables, 3. Create and Delete Indexes, 4. Retrieve data using SELECT, 5. Use SQL aggregate functions, 6. Use SQL Group Functions, 7. Create, Modify and use SQL Views, 8. Write and understand complex SQL queries.

Instructor Sadaf Mumtaz also teaches Introduction To Computer Programming in C and Object Oriented Programming in C++ for UniversalClass.


This course offers 1.0 CEUs upon successful completion. You may take this online course with or without CEU documentation. An online and hard-copy Certificate of Course Completion displaying your coursework and CEUs earned is included with the CEU Option. We also offer an expedited Transcript Service for sending your accomplishments to a third party.

Course Lessons

  1. Introduction to SQL - This lesson will introduce you with the basic terms and terminologies associated with SQL Programming.
  2. SQL Data Definition Language: CREATE - In this lesson we will discuss SQL CREATE of SQL Data Definition Language.
  3. SQL Data Definition Language: ALTER and DROP - In this lesson we will discuss SQL ALTER and SQL DROP of Data Definition Language.
  4. SQL Data Definition Language: Table Constraints - In this lesson we will discuss how to incorporate constraints like NOT NULL, UNIQUE, Primary Key, Foreign Key etc.
  5. SQL Data Manipulation Language: INSERT - In this lesson we will discuss SQL INSERT of Data Manipulation Language.
  6. SQL Data Manipulation Language: SQL Select - In this lesson we will discuss SQL select statement with all its variations.
  7. SQL Data Manipulation Language: SQL Delete - In this lesson we will discuss all the details of SQL Delete statement.
  8. SQL Data manipulation Language: SQL Update - In this lesson we will discuss all the details of SQL Update statement.
  9. SQL Aggregate Functions - In this lesson we will discuss SQL aggregate functions including sum, avg, max, min and count.
  10. SQL Group Functions - In this lesson we will discuss group by clause , having clause and order by clause of SQL.
  11. SQL Joins - In this lesson we will discuss how to do Table Joins.
  12. SQL Views - In this lesson we will discuss how to create and use SQL views.
Request More Information
About this Course

Have a question? Contact us for more information regarding this course.

Your Name :

Your Email:

Comments:

Optional Certificates Awarded

  1. Certificate of Attendance
  2. Certificate of Class Participation
  3. Certificate of Appreciation
  4. Certificate of Merit
  5. Certificate of Outstanding Achievement
  6. Certificate of Academic Excellence

Certificates awarded by the instructor will vary and are based upon student merit. Any awards you earn are considered unofficial (or temporary) unless you decide to make the award official. To make an award official, there is a $30.00 processing fee that covers the customization, printing, and shipping of a hard copy of the certificate as well as access to the UniversalClass™ Transcript Service. Official awards include a serial number that verifies the authenticity of the award you earned for a lifetime (great for employers to verify your achievement).

Additional Information

Course Title : SQL Programming
CEU Value : (Continuing Education Units)
Course Number : 8771
Course Type : Undergraduate
Course URL : http://sqlprogramming.onlineclasses.com
Course Review : Reviewed & Approved on August 27, 2003
Instructor : Sadaf Mumtaz
Syllabus : View Syllabus
Duration : Continuous: Enroll anytime!
Course Fee :
Basic Course: $199.00
with CEUs & Certificate: $224.00
NOT FOR COLLEGE CREDIT
This is a non-credit course. This course may not fulfill any local, state, government, licensing, or educational requirements.
Tell a Friend
About this Course
Name:

Email:
Choose from 5 Payment Methods
  • Credit Card Online
    (through our Verisign approved, secured servers)
  • Credit Card over the Phone
  • Credit Card through FAX
  • Check/Money Order through Mail
  • PayPal
To use any of these methods you must press the "Join Class" button on this screen and go through the online registration process in order to generate the correct order form and correctly process your enrollment.

Promotional Code:  
(if you do not have a promotional code leave this blank)
I have read and accepted the General Disclaimer and Terms of Service.

   

Document your coursework with a Certificate of Course Completion. Pre-pay now for the Certificate Option and receive a $5.00 discount off the regular certificate price (normally $30.00). Includes both an online version and a hard-copy of your certificate, verified and tracked by a unique serial number.


Other Related Classes in Programming SQL

  • C Programming (Beginner to Advanced) This is a Beginner to Advanced level C Programming course offered in an online setting. This course will first introduce you with the fundamentals of programming techniques and then will teach you the more advanced topics in programming like pointers, dy...
  • Understanding Technology This is an introductory technology course on using and understanding information technology for people who use computers as everyday tools both at home and at workplace, not for individuals aiming to learn programming and designing computer systems. This...
  • Using a Protocol Analyzer How to utilize a Protocol Analyzer to troubleshoot LAN traffic. This Course is intended for Network Professionals , Network Administrators or Anyone who wants to start learning more about what's going on their network connection. A Protocol A...




About Us | Having a Problem? | Contact Us
Disclaimer | Terms of Service | Privacy Policy

© 2008 UniversalClass™ All rights reserved.