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.
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
Optional Certificates Awarded
Certificate of Attendance
Certificate of Class Participation
Certificate of Appreciation
Certificate of Merit
Certificate of Outstanding Achievement
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).