Introduction to SQL – 3 Days
Course Description – Introduction to SQL (Structured Query Language)
This hands-on Introduction to SQL training course provides an in-depth introduction to the Structured Query Language, or SQL. Students learn key concepts of relational databases and query design, and have extensive opportunities to write database queries. The course also introduces table design and database update statements.
What You Will Learn
- Understand the structure of relational databases.
- Write simple select-from-where style queries.
- Write standard and correlated subqueries.
- Write queries that use all styles of table join.
- Build database tables, and write insert, update, and delete statements to modify data.
Prerequisites
None.
Outline
Chapter 1. Relational Databases and SQL
- Relational Databases
- SQL
- Schema
- Integrity
- DDL
- DML
Chapter 2. Tools
- Tools and Environment
- Creating the Course Schema
Chapter 3. The select Statement
- SQL Syntax
- Basic Query Structure
- Null Values
- Result Sets
Chapter 4. The select Clause
- The Expression List
- Character Expressions
- Column Headers and Aliases
- Mathematical Expressions
- Functions
- Using distinct
Chapter 5. The where Clause
- Filtering Predicates
- SQL Operators and Precedence
- Equality and Inequality Operators
- Logical Operators
- between
- like
- in
- is null
- Functions
Chapter 6. The order by Clause
- Sorting by Column Names
- Sorting by Expressions
- Sorting by Ordinal
Chapter 7. Aggregate Functions
- Aggregates
- count
- avg
- Querying Groups
- Grouping and the where Clause
- Choosing and Filtering Groups
Chapter 8. Standard Subqueries
- What is a Subquery?
- Standard Subqueries
- Using Aggregate Functions
- Subquery Operators
Chapter 9. SQL-Standard Joins
- Why Joins?
- Foreign Keys and Joins
- Qualifying Columns
- Table Aliases
- Inner and Outer Joins
Chapter 10. Correlated Subqueries
- Correlated Subqueries
- Subqueries and Scope
- Performance
Chapter 11. DDL for Tables
- Tables
- Object Names
- Data Types
- Creating a Table
- Dropping a Table
Chapter 12. Maintaining the Data in Tables
- Identifying Column Position and Data Type
- The insert Statement
- The update Statement
- The delete Statement
- Transaction Control
- Auto-Commit
Appendix A. Learning Resources
Appendix B. Course Schema
- The Entity Relationship Model
- The Schema Description
System Requirements
Hardware Requirements (Minimum) | Core 2 Duo 1.5 GHz, 1 gig RAM, 1 gig disk space. |
Hardware Requirements (Recommended) | Core 2 Duo 2.5 GHz, 1 gig RAM, 1 gig disk space. |
Operating System | Tested on Windows XP Professional and Windows 7. |
Network and Security | Limited privileges required |
Software Requirements | All free downloadable tools. |
Other courses to explore:
Oracle 12c Release 2 SQL Training – Onsite, Custom, Lowest Price
Oracle 12c Release 2 PL/SQL Development Training – Onsite, Custom
Relational Database Design Training – Onsite, Custom, Lowest Price

MindIQ.com