Online Course: SQL Programming
Join Now | Sign In | Shopping Cart
UniversalClass™ - Why not learn something new today?

Online Class: SQL Programming

Request More Information
Tell a Friend
Want to learn SQL Programming? This is the perfect course to enroll. You don't need to have an advanced degree to be a SQL programmer. Neither you need to go to a training institute and pay over 500 bucks to learn SQL programming. But you can learn SQL online. All you need to do is to practice writing SQL queries to become an expert SQL programmer. This course will make you write real SQL queries. So you will learn SQL programming by writing SQL queries. But you will get stuck in writing SQL queries and then I will help you write correct SQL queries.
SQL Programming
We're sorry, this course is not open for enrollment.
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.

* Document your course completion with an online certificate (additional shipping/handling charges apply for hard copy delivery). Instantly download, print, and share your certificate and CEUs once awarded. 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, and a Certificate Verification Service you can use so others may view and verify the authenticity of your awards.
Add Course to Wish List

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.

Course Lessons

Tell a Friend

Lesson 1: Introduction to SQL

This lesson will introduce you with the basic terms and terminologies associated with SQL Programming.

Lesson 2: SQL Data Definition Language: CREATE

In this lesson we will discuss SQL CREATE of SQL Data Definition Language.

Lesson 3: SQL Data Definition Language: ALTER and DROP

In this lesson we will discuss SQL ALTER and SQL DROP of Data Definition Language.

Lesson 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.

Lesson 5: SQL Data Manipulation Language: INSERT

In this lesson we will discuss SQL INSERT of Data Manipulation Language.

Lesson 6: SQL Data Manipulation Language: SQL Select

In this lesson we will discuss SQL select statement with all its variations.

Lesson 7: SQL Data Manipulation Language: SQL Delete

In this lesson we will discuss all the details of SQL Delete statement.

Lesson 8: SQL Data manipulation Language: SQL Update

In this lesson we will discuss all the details of SQL Update statement.

Lesson 9: SQL Aggregate Functions

In this lesson we will discuss SQL aggregate functions including sum, avg, max, min and count.

Lesson 10: SQL Group Functions

In this lesson we will discuss group by clause , having clause and order by clause of SQL.

Lesson 11: SQL Joins

In this lesson we will discuss how to do Table Joins.

Lesson 12: SQL Views

In this lesson we will discuss how to create and use SQL views.

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
In addition to the standard Certificate of Course Completion, Merit Awards may be issued by the instructor at his/her own discretion and are based on student achievement. Merit awards also incur an additional $30.00 processing fee that covers the customization, printing, and delivery of the award, as well as access to the UniversalClass™ Portfolio Service that documents your achievements online. Official Merit Awards have a serial number that verifies the authenticity of the award (great for employers to verify your achievement).
Request Information
Have a question? Contact us for more information regarding this course.

Your Name :

Your Email:
Comments
 

Additional Information

Course Title : SQL Programming
CEU Value :

1.0 (Continuing Education Units)

Course Number : 8771
Course Type : Undergraduate
Course URL :

http://sqlprogramming.onlineclasses.com

Course Rating : Not Reviewed
Instructor :

Sadaf Mumtaz

Syllabus :

View Syllabus

Duration : Continuous: Enroll anytime!
Requirements : View Technical Requirements
Course Fee :

Basic Course: $199

   

with CEUs & Certificate: $0

NOT FOR COLLEGE CREDIT
This is a non-credit course, and is provided for your personal enrichment. This course is not intended to be a substitute for any state, government, licensing, or educational requirements.

Choose from 5 Payment Methods

Credit Card Online Credit Card through FAX
Check/Money Order through Mail Credit Card over the Phone
PayPal  
To use any of these methods you must press the "Join this Course" button on this screen and go through the online registration process in order to generate the correct order form and correctly process your enrollment.
We're sorry, this course is not open for enrollment.
Instructor Blog: I am a highly motivated educator with a determination to make a difference in online teaching. I myself have taken online courses and I know what is important for online learners. In short this course will prepare you with all the fundamentals of SQL programming language, which you can use to write SQL queries for any database including Oracle, Sybase etc. I will teach you SQL programming through SQL programming exercises, SQL programming quizes, SQL programming exams, discussing your SQL programming problems with you through email, answering your questions on SQL programming and in zillion of ways. Learn SQL programming, and you can easily move to the job of Database Administrator. This is one of the top reviewed courses (3 stars) on UniversalClass.com and I am among top 100 instructor on Universalclass.com. And I was able to achieve this high rank only in last 3 years with my dedication to online teaching. And my ranking is getting better with each passing day because enrolled students are enjoying my course so much. Learn SQL Programming from anywhere in the world. Compare it with courses offered elsewhere, you won't find such a personalized instruction at this price. You can learn SQL programming from your computer sitting in your home or office in any corner of the world. To learn SQL programming you don't need to see your instructor, face to face but you need your instructor's help. And in this course you will get my help all the time through email.

Featured Courses in Programming SQL

Adobe Flash 101

1. Adobe Flash 101

($75.00) Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. more
  Adobe Photoshop 101

2. Adobe Photoshop 101

($60.00) Adobe Photoshop is a complex graphics and image editing software and paint program. more
     
Business Math 101

3. Business Math 101

($55.00) This course takes you through an overview of the wonderful world of business mathematics. more
  Computer Basics 101

4. Computer Basics 101

($55.00) Do you find yourself intimidated by computer jargon?. more

Other Related Classes in Programming SQL

  • Adobe Flash 101 Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. It's very easy to get lost in the interface and confused by the many features it offers. This course was designed to solve the mysteries of Adob...
  • Adobe Photoshop 101 Adobe Photoshop is a complex graphics and image editing software and paint program. Chances are, you've heard of Photoshop frequently in the past even if this will be the very first time that you use the program. Adobe's Photoshop program has become a ...
  • Business Math 101 This course takes you through an overview of the wonderful world of business mathematics. The course is designed for a person of any age and anywhere in the world. All that is required of the learner are a computer, a connection to the internet, a c...
  • Computer Basics 101 Do you find yourself intimidated by computer jargon? Would you like to have a clearer understanding (in non-jargon language) of how your computer works? Computer Basics 101 will both demonstrate and explain how your computer works in an easy-to-follow, ...
  • Dreamweaver 101 Whether this is your first time using Dreamweaver or you've used it in the past, this course will walk you through the program step-by-step and teach you how to use its many features and options to create professional web pages with little more than ...
  • Electronics 101 Whether performing a minor repair, such as your phone or DVD player, or applying for a new and technology focused career, an understanding of the principles directing basic electronics will prove helpful throughout life. This course in basic electronics ...
  • Excel 2007 Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. Microsoft Excel is often packaged as part of Microsoft Office that includes other applications such as M...
  • How to Create Web Pages These days, everyone can benefit from an online presence, and that means developing a website. This course covers a basic introduction of how to create your own website page-by-page using HTML, a common website coding process. From basic HTML defin...
  • Internet Fundamentals 101 Are you in the dark about how the Internet works? Do you wonder how in the world it is possible to communicate with someone on another continent in the blink of an eye? This straightforward course clearly and plainly lays out the basics of the Internet...
  • Managerial Accounting 101 Managerial accounting is not as widely used as other forms of accounting, nor is it as known. While companies concern themselves with financial accounting methods like audits, budgets and financial statements, they often completely ignore the forward-th...
  • Microsoft Publisher 2007 Microsoft Publisher can be an amazing tool. It can help us complete impressive tasks in a fraction of the time, and help to accomplish things that we could never have done on our own. But you have to know how to use this program. This course will sho...
  • MS Office 2003: Word, Excel, PowerPoint This all in one training course will provide comprehensive instruction on three popular MS Office programs: MS Word 2003, MS Excel 2003, PowerPoint 2003. MS Word 2003 T his course teaches you all the basics of MS Word, from doing simply functions li...
  • MS Office 2007: Word, Excel, PowerPoint and Outlook MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook. MS Word 2007 It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as w...
  • MS Word 2003 It doesn't matter if you've never used MS Word before or you just want to familiarize yourself with MS Word 2003. This course teaches you all the basics of MS Word, from doing simply functions like typing in the text area to formatting text, to give the ...
  • MS Word 2007 This Microsoft Word 2007 course is not only designed to give the experienced MS Word user a tour of the new version of Word, but to also introduce new MS Word users to a comprehensive look at the features and utilities that this word processing software...
  • Outlook 2007 The purpose of this course is to help you understand what Outlook 2007 can do for you, whether you are familiar with Outlook 2003 or new to the application altogether. This course has been developed to be of benefit to new users of Outlook, individuals ...
  • Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. Lesser priced, it contains all the features of Photoshop, but contains fewer options that are much easier to understand. Elements was designed with the consum...
  • PowerPoint 2003 MS PowerPoint 2003 is probably one of the most convenient software applications in the Office suite because it allows you to do so much – easily. Whether you want to create professional presentations for the office or just brush up on your skills...
  • PowerPoint 2007 The purpose of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsof...
  • Quicken Deluxe 2010 Quicken Deluxe is a personal finance management tool that provides features that we all need to keep track of where our money is going. However, this software gives you more than just the power to log your finances and manage your bills. It can also ...
  • Typing and Keyboarding 101 Today, knowing how to type fast is almost a necessity in the business world. More and more corporate-world employees are being asked to create reports, sales letters, business plans, blogs, web content, forecasts and more. Knowing how to type can sav...
 
Request More Information   Tell a Friend