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.