java programming


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.




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 SystemTested on Windows XP Professional and Windows 7.
Network and SecurityLimited privileges required
Software RequirementsAll 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

Oracle SQL
Oracle and SQL training 


Print Friendly, PDF & Email