|
|
|
|
Course Number:
|
RSSQL |
 |
Course Title:
|
Basic SQL Programming |
No classes scheduled.
|
Know someone who
needs this course? |
 |
|
|
Length:
|
5 Day(s)
|
|
|
Compare To:
|
|
RealSolutions Custom Course - No Comparison
|
Description:
Structured Query Language (SQL) is the standard for accessing data in relational databases. Now, in just five days, you can become fluent in this indispensable language. Our training emphasizes the use of SQL to solve nontrivial business problems by ‘thinking in SQL.’ Our strategy is to teach syntax early and then concentrate on applying SQL to business questions. RealSolutions SQL Programming class includes a suite of hands-on lab exercises that reinforce the concepts and technology. You learn from professionals with real-world experience developing and enhancing applications using SQL
What you will learn:
- At the completion of the labs, you’ll have worked with all the major concepts and tools of SQL. You’ll leave the course able to use SQL to generate business intelligence as you retrieve data, create queries, generate reports, and program applications.
Audience:
This class is for business analysts and system developers who want to raise their knowledge of SQL to an expert level.
Prerequisites:
- Prerequisites include a working knowledge of databases.
Outline:
- A Little Background
- Creating and Populating a Database
- Query Primer
- Filtering
- Querying Multiple Tables
- Working with Sets
- Data Generation, Conversion, and Manipulation
- Grouping and Aggregates
- Subqueries
- Joins Revisited
- Conditional Logic
- Transactions
- Indexes and Constraints
|
|
|