EncartaLabs

IBM dashDB - SQL

( Duration: 1 Day )

The IBM dashDB SQL training course, teaches developers, database administrators, and system programmers various features of SQL, including column functions, grouping, unions, subqueries, and maintaining data.

This IBM dashDB SQL workshop is ideal for Developers, Database Administrators, System Programmers

  • Knowledge of dashDB

COURSE AGENDA

1

dashDB environment

2

Column functions and grouping

  • SQL functions
  • Beware of NULLs
  • GROUP BY and HAVING
  • Important rule for column functions
  • Restrictions
  • Conceptual execution of a SELECT
3

UNION

  • Single report
  • UNION rules
  • UNION vs UNION ALL
4

Using subqueries

  • Subqueries
  • Subquery predicates
  • Restrictions and reminders
5

Maintaining data

  • Working data
  • Views
  • Working with the data
  • Prototyping change SQL with a unit of work
  • Reminders

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top