Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Oracle Databases Training









Preferred method of contact?

SQL Programming Language Introduction

COURSE TYPE

Foundation

Course Number

925

Duration

3 Days

Enroll

About This Course: SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This course provides a solid foundation of the SQL programming language that enables you to build, query and manipulate databases. You compare the ANSI/ISO standard with the SQL implementations of both Oracle and SQL Server databases.

You Will Learn How To

  • Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures
  • Update database content with SQL and transaction handling
  • Retrieve data with filter conditions and from multiple tables using various types of join
  • Process data with row and aggregate functions

Important Course Information

Recommended Experience:

  • Knowledge of relational database at the level of:
    • Course 382, Relational Database Design, Tools & Techniques

Course Outline

  • SQL Overview
  • Outlining SQL as the cornerstone of database activity
  • Applying the ANSI/ISO standards
  • Describing the fundamental building blocks: tables, columns, primary keys and foreign keys
  • Building the Database Schema

Creating tables and columns

  • Building tables with CREATE TABLE
  • Modifying table structure with ALTER TABLE
  • Adding columns to an existing table
  • Removing tables with DROP TABLE

Protecting data integrity with constraints

  • Guaranteeing uniqueness with primary key constraints
  • Enforcing integrity with foreign key constraints
  • Imposing business rules with check constraints

Improving performance with indexes

  • Expediting data retrieval with indexes
  • Recommending guidelines for index creation
  • Manipulating Data

Modifying table contents

  • Adding table rows with INSERT
  • Changing row content with UPDATE
  • Removing rows with DELETE

Applying transactions

  • Controlling transactions with COMMIT and ROLLBACK
  • Deploying BEGIN TRANSACTION in SQL Server
  • Working with the SELECT Statement

Writing Single Table queries

  • Retrieving data with SELECT
  • Specifying column expressions
  • Sorting the result with ORDER BY
  • Handling NULL values in expressions

Restricting rows with the WHERE filter

  • Testing for equality or inequality
  • Applying wildcard characters
  • Avoiding NULL value pitfalls
  • Querying Multiple Tables

Applying the ANSI/ISO standard join syntax

  • Matching related rows with INNER JOIN
  • Including nonmatched rows with OUTER JOIN
  • Creating a Cartesian product with CROSS JOIN

Combining results with set operators

  • Stacking results with UNION
  • Identifying matching rows with INTERSECT
  • Utilizing EXCEPT to find nonmatching rows
  • Employing Functions in Data Retrieval

Processing data with row functions

  • Conditional formatting with the CASE expression
  • Utilizing the CASE expression to simulate IF tests
  • Dealing with NULL values

Performing analysis with aggregate functions

  • Summarizing data using SUM, AVG and COUNT
  • Finding the highest/lowest values with MAX and MIN
  • Defining the summary level with GROUP BY
  • Applying filter conditions with HAVING
  • Constructing Nested Queries

Applying subqueries in filter conditions

  • Correlated vs. noncorrelated subqueries
  • Testing the existence of rows

Including subqueries in expressions

  • Placing subqueries in the column list
  • Creating complex expressions containing subqueries
  • Handling subqueries that return no rows
  • Developing In-Line and Stored Views

Breaking down complex problems

  • Selecting data from a query result set
  • Subqueries in the FROM clause

Creating views in a database

  • Building reusable code
  • Updateable vs. non-updateable views
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Dec 14 - 16 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jan 4 - 6 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Feb 1 - 3 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Feb 1 - 3 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Feb 8 - 10 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Feb 22 - 24 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Apr 5 - 7 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Apr 11 - 13 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Apr 19 - 21 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

May 10 - 12 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 17 - 19 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 24 - 26 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 31 - Jun 2 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jun 7 - 9 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jun 21 - 23 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Jun 27 - 29 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Aug 2 - 4 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Aug 23 - 25 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Aug 30 - Sep 1 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 6 - 8 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 13 - 15 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 27 - 29 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Oct 4 - 6 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Oct 18 - 20 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Nov 7 - 9 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Nov 20 - 22 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2650

Government

$2355

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 17 Credits from NASBA

This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“After taking the SQL Programming Course, my turn-around time for project completion has been significantly reduced … My efficiency levels have definitely risen, and my managers are aware of the improvement.”

- S. Cope, Compliance Analyst
Depository Trust and Clearing Corp.

Prev
Next
s