Capacitación Administración de bases de datos en Buenos Aires

...Course outline Exploring Applications in Lotus Domino 8 Identifying Application Types and Data Sources Examining the Lotus Domino Architecture Analyzing...

...Requisitos: Para realizar el curso el alumno debe tener conocimientos de SQL Oracle y PL/SQL, sería importante que conozca la filosofía de Data Warehose...

...Creación de tablas 4. Datos 4.1. Tipos de datos 4.2. Consultas 4.3. Transacciones y bloqueos 4.4. Tipos de datos 5. Administración 5.1. Estructura interna 5...

...implementing, and maintaining DB2 databases. Overview of DB2 9 on Linux, UNIX and Windows: Contrast the DB2 Family of products Identify the DB2 Products...

...including database statistics collection and table reorganization Analyze REORGCHK reports to determine if the table or the index reorganization would improve database efficiency...

...Altering and Deleting Databases and Tables Delete a database Delete a table Alter a table Convert a simple large object to a smart large object Create...

...and sbspaces and add chunks to these spaces Explain the purpose of physical and logical logs and monitor log activity View the individual transactions...

...an efficient structure Be able to extract basic database information using the SELECT command Be able to troubleshoot syntax and understand typical warnings...

...retrieve more detailed information Utilize SQL statements to modify the contents of database tables Write join expressions in your SQL statements to obtain...

...locking concepts and the different levels of locking in MySQL Differentiate between the multiple storage engines available in MySQL Create, Maintain...

...Herramientas utilizadas para la definición de archivos: DDS, SQL, IDDU, ventajas y desventajas. Fundamentos de diseño de archivos físicos. Formas Normales...