Overview

DURATION: 2 Days

Understand how business requirements become database designs, and the basics of reading and writing to a relational database using SQL (Structured Query Language).

This course is not just for developers, but for anyone who wants to understand the impact of business requirements to complexity and cost.

Audience

Anyone that wants a high-level appreciation of managing data stored in relational databases including developers, business analysts, QA, testers, and project managers.

Prerequisite

None

Course Outline:

SQL Fundamentals

• Data Retrieval
• Restricting and Sorting Data
• Single Row and Conversion Functions
• Aggregating Data Using Group Functions
• Retrieving Data from Multiple Tables
• Using Subqueries and Set Operators
• Manipulating Data and Transactions

Frequently Asked Questions

What are the prerequisites needed before I take this training track?

None.

What skills should I expect to possess at the end of the course?

Participants will understand how business requirements become database designs.