EncartaLabs

IBM dashDB - Essentials

( Duration: 1 Day )

The IBM dashDB - Essentials training course, teaches developers, database administrators, and system programmers various features of SQL, including object creation and alteration, views, advanced queries, and analytic constructs.

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

  • Ability to write basic SQL SELECT statements, including a SELECT list, FROM clause, WHERE clause, GROUP BY clause, HAVING clause, and ORDER BY clause.
  • Ability to perform basic SQL INSERT, UPDATE, and DELETE operations.
  • Ability to utilize basic SQL scalar functions, such as the DECIMAL function, and SQL column functions, such as SUM.
  • Ability to write basic non-correlated subqueries.

COURSE AGENDA

1

Review of SQL

  • Selecting rows and columns
  • LIKE and the ESCAPE clause
  • Column functions
  • Summarizing group values
2

OLAP functions

  • Super groups
  • GROUP BY ROLLUP
  • GROUP BY CUBE
  • Grouping function
  • GROUP BY grouping sets
  • OLAP functions for ranking
3

Create and modify tables

  • Creating tables and adding columns
4

Constraints and indexes

  • Check Constraints
  • Indexes, unique, and primary keys
  • Referential integrity
  • Information integrity constraints
5

Triggers

  • Triggers
  • More on triggers
6

MERGE

7

Views

  • Views
  • INSTEAD OF triggers
  • CHECK option
  • View merge
  • View materialization
8

Joins

  • Join (original syntax)
  • Inner Join (newer syntax)
  • Outer joins
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • Anti-join
  • Joins of more than two tables
  • Joins and local predicates
9

UNION and UNION ALL

10

EXCEPT and INTERSECT

11

CASE and CAST

  • Case
  • CAST

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