Course Code: K04003G
Duration: 8 Hours
Price: SGD 1000.00
Tell us a little about yourself:
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
Please refer to course overview
Developers, Database Administrators, System Programmers
dashDB SQL for Basic Queries or equivalent experience or knowledg
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
• SQL challenges
• SQL challenges - solutions
3. UNION
• Single report
• UNION rules
• UNION vs UNION ALL
• SQL challenges
• SQL challenges - solutions
4. Using subqueries
• Subqueries
• Subquery predicates
• Restrictions and reminders
• SQL challenges
• SQL challenges - solutions
5. Maintaining data
• Working data
• Views
• Working with the data
• Prototyping change SQL with a unit of work
• Reminders
• SQL challenges
• SQL challenges - solutions