dashDB SQL for Basic Queries - K04001G

Description

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.

Tables in a RDBMS
Understanding the sample database
SQL Structured Query Language
Using the WHERE clause
Using Multiple Conditions
Partial string searches
Retrieving data from multiple tables
Calculating values
String Functions
DATE, TIME and TIMESTAMP

Aim

Please refer to course overview.

Participant requirements

N/A

Participant

This course is intended for Developers, Database Administrators, and System Programmers the basics of SQL queries, including the SELECT, FROM, WHERE, and ORDER BY clauses, simple joins and scalar functions.