|
|
 |
12 Classes - 4 Hours, 1 Day per Week for 3 Months
Course Description
Hands-on programming course designed for SQL language and Relational Databases. Covers the basics and more advanced concepts of relational philosophy, presented from a practitioner’s point of view, as well as the SQL language structure.
| Course Schedule |
| |
| Week One |
| 1. |
Introduction |
|
- |
relational database vs. flat file management systems |
|
- |
the ANSI/SPARC model of data abstraction |
|
- |
internal level |
|
- |
conceptual level |
|
- |
external level |
|
- |
domains and relations |
| |
|
|
| Week Two |
| 2. |
Relational model |
|
- |
tables |
|
- |
keys (primary, foreign, candidate) |
|
- |
normalization: 1st, 2nd, 3rd normal form |
|
- |
higher normal forms |
|
- |
relational database design |
| |
|
|
| Week Three |
| 3. |
Relational model |
|
- |
tables |
|
- |
keys (primary, foreign, candidate) |
|
- |
normalization: 1st, 2nd, 3rd normal form |
|
- |
higher normal forms |
|
- |
relational database design (continue) |
| |
|
|
| Week Four |
| 4. |
SQL basics |
|
- |
SELECT statement |
|
- |
INSERT statement |
|
- |
Database components |
|
- |
Creating tables |
|
- |
Creating indexes |
|
- |
Understanding indexes |
|
- |
Indexes and database engines |
| |
|
|
| Week Five |
| 5. |
More SQL statements |
|
- |
data types |
|
- |
DDL and DML |
|
- |
UPDATE statement |
|
- |
Using WHERE clause with UPDATE |
|
- |
DELETE statement |
|
- |
ALTER statement |
| |
|
|
| Week Six |
| 6. |
SELECT statement |
|
- |
WHERE clause in detail |
|
- |
LIKE |
|
- |
INTO |
|
- |
Sorting information |
|
- |
ORDER BY clause |
|
- |
GROUP BY clause |
|
- |
HAVING clause |
|
- |
SUB-SELECTs |
| |
|
|
| Week Seven |
| 7. |
Joins |
|
- |
what are joins and why do we need them? |
|
- |
INNER joins |
|
- |
OUTER joins |
|
- |
LEFT joins |
|
- |
RIGHT joins |
| |
|
|
| Week Eight |
| 8. |
Key SQL functions |
|
- |
Strings and substrings: UPPER, LOWER, LENGTH, TRIM |
|
- |
Arithmetic functions: SUM, AVG, MIN, MAX |
| |
|
|
| Week Nine |
| 9. |
SQL DDL (Data Definition Language) |
|
- |
creating tables |
|
- |
modifying tables |
|
- |
creating and dropping indexes |
| |
|
|
| Week Ten |
| 10. |
Transaction processing |
|
- |
what are and why do we need transactions |
|
- |
ACID properties |
|
- |
Locking |
|
- |
Isolation levels |
| |
|
|
| Week Eleven |
| 11. |
Views |
|
- |
creating a view |
|
- |
querying a view |
|
- |
updating a view |
| |
|
|
| Week Twelve |
| 12. |
API interfaces to RDBMS |
|
- |
C/C++, Perl, PHP |
|
- |
ODBC |
|
- |
JDBC |
| |
|
|
|
|
|
|
|
