Class Syllabus: SQL Programming
|  | | 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 Requirements
Basic familiarity with computer is required. 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.
Course Goals
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 Course Materials
Introduction to SQL
What is SQL?
Where is SQL used?
What is a Database?
What is Relational Database?
What is DBMS?
What is a Table?
What is a column in a Table?
What is a row in Table?
What is DDL?
What is DML?
SQL Keywords
What is a Primary Key?
What is a Foreign Key?
General Rules for writing SQL queries
A little Introduction to MySQL
SQL Data Definition Language: CREATE
Create Database
Use Database
Create Table
Create Index
SQL Data Definition Language: ALTER and DROP
Alter Database
Alter Table
Drop Database
Drop Table
Drop Index
SQL Data Definition Language: Table Constraints
NOT NULL Constraint
UNIQUE Constraint
Primary Key Constraint
Foreign Key Constraints
SQL Data Manipulation Language: INSERT
Insert one complete row
Insert one partial row
Insert Multiple rows
SQL SELECT Statement
Basic Structure
Select *
Select Distinct
Conditional Select
Relational Operators for SQL
LIKE clause
IN clause
SQL AND & OR
SQL DELETE Statement
Delete *
Conditional Delete
SQL UPDATE Statement
Updating one column
Updating multiple columns
SQL Aggregate Functions
Average
Count
Max
Min
Sum
SQL Group Functions
Group By clause
Having clause
Order By clause
SQL Joins
SQL Views Grading Policy
Assignments: 68
Quiz 22
Final Exam: 10
A = 86 +
B = 76 +
C = 66 +
D = 55 +
E = 50 +
F = below 50 in which case you fail the course
Copyrights
This course, or parts thereof, may not be reproduced in any form without written permission from the instructor.
Other Related Classes in Programming SQL - 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 demonstrate and explain in an easy-to-follow self-paced format. This cl...
- 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...
- 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 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 ...
- 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 skill...
- 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...
- 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...
| | | |
| |
| |
