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