Introduction to SQL Programming Training
PDF Add to WishList
The ability to write the SQL language — the cornerstone of all relational database operations — is essential for anyone who develops database applications. The SQL Language is an ANSI/ISO standard language used by all relational database products. In this training course, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This course describes the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. For the hands-on exercises, the course environment allows the students to choose between working with the PostgreSQL database product or Microsoft SQL Server.
Key Features of This SQL Programming Training:
- SQL programming training taught by a real-world SQL expert instructor
- After-course instructor coaching benefit
- After-course computing sandbox included
- Learning Tree end-of-course exam included
You Will Learn How To
- Write SQL code based on ANSI/ISO standards to build 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
SQL Programming Course Description:
This SQL Class includes 17 hours of Instructor-Led Training (ILT) or Virtual Instructor-Led Training (VILT) presented by a real-world SQL expert instructor.
Recommended Experience:
- Knowledge of relational database at the level of:
- Course 382, Relational Database Design, Tools & Techniques
Software
For the hands-on exercises, the course environment allows the students to choose between working with PostgreSQL database product or Microsoft SQL Server.
Industry Credits & Certification
This course offers you the opportunity to earn the following industry credits and certifications
- 17 NASBA Credits (live, in-class attendance required)
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
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
In the Classroom
Live, Online
Private Team Training
In the Classroom — OR — Live, Online
Tuition — Standard: $2650 Government: $2355
May 9 - 11
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
May 23 - 25
(3 Days)
9:00 AM - 4:30 PM MDT
*
Online (AnyWare)
Reserve Your Seat
Jun 6 - 8
(3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Jun 20 - 22
(3 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Jul 11 - 13
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Jul 18 - 20
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Jul 25 - 27
(3 Days)
9:00 AM - 4:30 PM EDT
Washington, DC
Reserve Your Seat
Aug 8 - 10
(3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Aug 22 - 24
(3 Days)
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Reserve Your Seat
Aug 29 - 31
(3 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Reserve Your Seat
Sep 5 - 7
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Sep 12 - 14
(3 Days)
9:00 AM - 4:30 PM MDT
*
Online (AnyWare)
Reserve Your Seat
Sep 19 - 21
(3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Sep 26 - 28
(3 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Oct 24 - 26
(3 Days)
9:00 AM - 4:30 PM EDT
Washington, DC
Reserve Your Seat
Oct 31 - Nov 2
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Nov 14 - 16
(3 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Nov 28 - 30
(3 Days)
9:00 AM - 4:30 PM MST
*
Online (AnyWare)
Reserve Your Seat
Dec 5 - 7
(3 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Jan 2 - 4
(3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Jan 23 - 25
(3 Days)
9:00 AM - 4:30 PM EST
Washington, DC
Reserve Your Seat
Jan 30 - Feb 1
(3 Days)
9:00 AM - 4:30 PM EST
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Feb 6 - 8
(3 Days)
9:00 AM - 4:30 PM EST
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Feb 20 - 22
(3 Days)
9:00 AM - 4:30 PM MST
*
Online (AnyWare)
Reserve Your Seat
Feb 27 - Mar 1
(3 Days)
9:00 AM - 4:30 PM EST
Online (AnyWare)
Reserve Your Seat
Mar 6 - 8
(3 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare)
Reserve Your Seat
Mar 13 - 15
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Mar 20 - 22
(3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Mar 27 - 29
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Apr 24 - 26
(3 Days)
9:00 AM - 4:30 PM EDT
Washington, DC
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed. *This event is available remotely Mountain Time. Due to the time difference, these events are not available for attendance at our AnyWare Centers.Private Team Training
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click Here »
Tuition
Standard
Government
In Classroom or
Online
Standard
$2650
Government
$2355
Private Team Training
Course Tuition Includes:
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
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. NOTE: Only live, in-class attendance qualifies for NASBA CPEs. Read more ...