General Guidelines

1. The Entity Relational Models (RDBMS) - El Modelo Entidad/Relacion

2. Relational Databases / Bases de datos Relacionales

3. ERD ( E. R. D. Entity Relation Diagram ) ( Diagrama Entidad Relacion )

4. RATIONAL ROSE

5. SQL SERVER / El Gestor de base de datos SQL SERVER

6. TRANSACT SQL

7. The Three Layer Model / Modelado 3 capas

8. C++ Object Oriented Programming on Builder compiler / Programación orientada a objetos C++

9. Creating users in SQL SERVER and granting them permissions. Also granting permissions
 using SQL statements. Generating an executable in C++ Builder to be able to
  take the product elsewhere. Examples of ini and ini reading file.
 Backup and recovery both in SQL SERVER and a procedure for it in Builder

10. SQL Progrmmin over Oracle 9i

11. Advanced PL/SQL programming

Particular Points Made During The Class

15 June Partial notes - ERD cardinalidad

16 June Partial notes - some tables used - Ejercicio Entidad relacion diagrama

17 June uploaded a rational .mdl file Partial notes -

18 June

21 June

22 June Non of the notes have been uploaded, but I uploaded SQL script files that generate tables

23 June A txt file containing spanish language reminders on SQL

24 June

June 25 SQL query examples

June 28 You can also hear the teachers voice Explicacion Modelado Tres Capas CMR

June 29   not uploaded yet

June 30You can also hear the teachers voice Also. Search button. Which text boxes have been filled, etc.
July 1   not uploaded yet

July 2 Text box in object oriented programming. Constructing a SQL statement embeded in C++ to be sent to the ADO in SQL Server

July5   not uploaded yet
July 7   not uploaded yet
July8   not uploaded yet
July 9   not uploaded yet

July 13 You can also hear the teachers voice Procedures in SQL Server, etc.

July 16   not uploaded yet
Juy 19   not uploaded yet
July 20   not uploaded yet
July 21   not uploaded yet
July 22   not uploaded yet
July 23   not uploaded yet

July 26 Search button code & explanation. cpp code. View C++Builder screen shot.

July 27 & 28 Inserting Method. You can also hear the teachers voice
July 29   not uploaded yet

July 30CURSOR used in a procedure. You can also hear the teachers voice Temporary Table funcion in SQL SERVER

August 2 You can also hear the teachers voice : TRIGGERS also Function that returns a table that has a join of fields from different tables

August 3 Has Trigger that writes log of DML. Has a review SQL Server excersize that includes creating tables and restrictions and ERDYou can also hear the teachers voice :

August 4 Creating users in SQL SERVER and granting them permissions.   Also granting permissions using SQL statements Generatin an executable in C++ Builder to be able to   take the product elsewhere. Examples of ini and ini reading file.   You can also hear the teachers voice

August 5  ini read backup and recovery in SQL SERVER and backup procedure in C++Builder  You can also hear the teachers voice

August 6  Log and Data files. Exporting Tables .Having Tables written in Two different files. Reducing log files

August 30  review , repetition, Modelado Entidad relacion

September 1 & 2  Visual Case Analyst

September 3  ERD