Quality Seal Emagister EMAGISTER CUM LAUDE

IBM-CE131G - DB2 SQL Workshop for Experienced Users

Netec Colombia
En Medellín y Bogotá

US$ 1.495 - ($ 4.615.017)
+ IVA
¿O prefieres llamar directamente al centro?
17436... Ver más

Información importante

  • Curso
  • En 2 sedes
  • Duración:
    2 Días
  • Cuándo:
    A definir
Descripción

This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.

What You'll Learn
- Discuss basic relational database concepts
- Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
- Create tables, views and indexes
- Use referential integrity, check constraints and triggers
- Use outer joins, and join tables to themselves
- Use CASE expressions, and the CAST function
- Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
- Use complex subqueries
- Use a greater number of scalar SQL functions
- Use advanced SQL constructs, such as recursive SQL and table expression
- Define User-Defined Distinct Types and User-Defined Functions
- Avoid several of the most common causes for poorly-performing SQL

Información importante
Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Bogotá
carrera 13, Bogotá, Colombia
Ver mapa
A definir
Medellín
carrera 43 , Antioquia, Colombia
Ver mapa

Opiniones

Todavía no hay opiniones de este curso

¿Qué aprendes en este curso?

Capacitación
SQL
Query
Case
OLAP
Algoritmos
Calidad informática
Datamining
Explotación de sistemas
Gestión informática
Ingeniería del software
Sistemas de información
Seguridad de datos
Seguridad informática
Arquitectura de redes
Dispositivos de redes
Software de redes
Internet

Programa académico

Introduction Identify the purpose of the clauses in the SELECT statement Describe the key differences among the IBM DB2 platforms Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and the RANK, DENSE_RANK and ROW_NUMBER functions Create Objects Code statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints Identify impacts and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define and make use of INSTEAD OF triggers Join Retrieve data from more than one table via inner and outer joins Use outer joins (LEFT, RIGHT, FULL) Use ANTI JOINS Join a table to itself Use UNION and UNION ALL Use EXCEPT and INTERCEPT CASE, CAST, Summary Tables, and Materialized Query Tables

Información adicional

Este curso se impartirá mediante la combinación de: Formación guiada por un instructor - Laboratorios prácticos - Pruebas de conocimientos

Compara este curso con otros similares
Ver más cursos similares