Descripción: Curso dashDB SQL for Functions, Grouping, Union, Subqueries and Updates - eLearning
Formación en IBM dashDB
This course teaches developers, database administrators, and system programmers various features of SQL, including column functions, grouping, unions, subqueries, and maintaining data.
Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities.
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. http://www.ibm.com/training/terms
Formación IBM
Detalles
1. dashDB environment2. Column functions and grouping • SQL functions • Beware of NULLs • GROUP BY and HAVING • Important rule for column functions • Restrictions • Conceptual execution of a SELECT • SQL challenges • SQL challenges - solutions3. UNION • Single report • UNION rules • UNION vs UNION ALL • SQL challenges • SQL challenges - solutions4. Using subqueries • Subqueries • Subquery predicates • Restrictions and reminders • SQL challenges • SQL challenges - solutions5. Maintaining data • Working data • Views • Working with the data • Prototyping change SQL with a unit of work • Reminders • SQL challenges • SQL challenges - solutions
Developers, Database Administrators, System Programmers
dashDB SQL for Basic Queries or equivalent experience or knowledge
Please refer to course overview
Contáctenos a través de >éste formulario<
Precios especiales para la formación de grupos
Podemos adaptar cualquier curso a sus necesidades, e impartirlo en sus instalaciones o en nuestros centro de formación ContáctenosCursos relacionados
