e-Learning
Learn at your own pace with anytime, anywhere training.
Classroom Schedule
There are no classes currently scheduled
* Prices Inclusive of taxes
Virtual Schedule
| Location | Delivered By | Language | Date | Price | Action |
|---|---|---|---|---|---|
| No schedule date's available now. | |||||
* Prices Inclusive of taxes
Private / Corporate Training
Tell us a little about yourself:
Course Description
-
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.
Objectives
-
Please refer to course overview
Audience
-
Developers, Database Administrators, System Programmers
Prerequisites
-
dashDB SQL for Basic Queries or equivalent experience or knowledge
Content
-
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