In this course, students will learn the fundamentals of the structured query language (SQL) and how to use SQL to store, extract and present information. Lecture, numerous hands-on lab exercises using Microsoft Access and Oracle 11g, along with an excellent textbook (which students keep) are used to provide students with a solid understanding of SQL.
This is the perfect course for anyone who frequently queries data or works with databases or query/reporting tools: business analysts, report writers, programmers new to SQL, data quality specialists, QA testers. While the course is taught using Access and Oracle, the focus of the course is on database-independent SQL statements and concepts.
- Storing Information in Tables
- Inserting, Updating, and Deleting Information in Tables
- Getting Information from a Table
- Compound Conditions in the Where Clause
- Inner Joins
- Introduction to Row Functions
- Using Row Functions
- Controlling the Level of Summarization
- Outer Joins
- Union and Union All
- Self Joins
- If/then/else Subqueries
Participants should be comfortable with Windows and MS Office, but do not need prior experience with databases.
E-mail email@example.com or call (443) 692-6599:
- if you have any questions about this course,
- to be notified when this course and any closely related courses are scheduled for open enrollment,
- to request a quote for group training at your location or ours.