©2007 EF Nis
Tempus Project JEP_41148_2006
"Continuous Education for Informatics Teachers in Elementary and Secondary Schools in Serbia"
» Home
» What's New


Project Overview
» Background
» Consortium

» Management Team

» Outcomes

» E-Mail

The Project
» Events
» Results

Links
» Tempus Home
» Tempus Documents
» Consortium


Last update:

February 9, 2010

Databases
Course outline
 
  1. Introduction to databases
1.1. DBMS
1.2. Data models
1.3. Relational model
1.4. Relation keys and data integrity
1.5. Schematical representation of database model
2. Introduction to SQL
2.1. Example model
2.2. Creating tables
2.3. MS access
3. SQL basics
3.1. SELECT and FROM
3.2. WHERE
3.3. ORDER BY
3.4. Arithmetical functions
3.5. Data agregation
3.6. GROUP BY and HAVING
3.7. Table merging
3.8. Multi-SQL statements result combining
4. Data manipulation using SQL
4.1. Insert
4.2. Data deletion
4.3. Scheme modification
5. Basic components of MS Access applications
5.1. Forms
5.2. Reports
5.3. Macros
5.4. Applications
6. ADO.NET
6.1. ADO.NET data provider
6.2. Direct data access
7. Windows forms in C# and ADO.NET

         

About This Site | Search | E-mail

Site contents ©2006-2010 Faculty of Electronic Engineering of Nis
Please send comments and suggestions about this site to Webmaster