SQL Programming Language

• SQL Basics
• Writing SQL Queries

SQL Basics

REGISTRATION

• TBD
• This training is being held virtually via Zoom
• Each daily session will start at 8:30 AM and finish at 4:30 PM. All times are in the CENTRAL Time Zone.
• Instructor: FastLane US

COST

$1199.00/Attendee

WAITLIST INFORMATION

If you cannot attend the session above, please click here to join our waitlist. Once enough demand has been built, you will be contacted with dates for the next session. Please note that submitting your information on the waitlist does not automatically reserve a space for you in the training. You will have to register/pay via a separate registration portal.

OVERVIEW 

This course provides a complete, hands-on introduction to SQL including the use of both SQL Developer and SQL*Plus, leveraging the latest editions of Oracle. A full presentation of the basics of relational databases and their use are also covered.

OBJECTIVES

This “skills-centric” course is designed to train attendees core SQL programming and database skills, coupling the most current, effective techniques with the soundest industry practices. Throughout the course students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review.

• Basic RDBMS Principles
• The SQL Language and Tools
• Using SQL Developer
• SQL Query Basics
• WHERE and ORDER BY
• Functions
• ANSI 92 JOINS
• ANSI 99 Joins
• GROUP BY and HAVING
• Subqueries 
• Regular Expressions
• Analytics

COURSE OUTLINE

1. Basic RDBMS Principles
2. The SQL Language and Tools
3. Using SQL Developer
4. SQL Query Basics
5. WHERE and ORDER BY
6. Functions
7. ANSI 92 JOINS
8. ANSI 99 JOINS
9. GROUP BY and HAVING
10. Subqueries
11. Regular Expressions
12. Analytics
13. More Analytics

For a full agenda click here.

Writing SQL Queries

REGISTRATION

• TBD
• This training is being held virtually via Zoom
• Each daily session will start at 8:30 AM and finish at 4:30 PM. All times are in the CENTRAL Time Zone.
• Instructor: FastLane US

COST

$1299.00/Attendee

WAITLIST INFORMATION

If you cannot attend the session above, please click here to join our waitlist. Once enough demand has been built, you will be contacted with dates for the next session. Please note that submitting your information on the waitlist does not automatically reserve a space for you in the training. You will have to register/pay via a separate registration portal.

OVERVIEW

The course describes the ANSI/ISO SQL standard, but also identifies deviations from the standard in the two most widely used database products, Oracle and Microsoft SQL Server. 

OBJECTIVES

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert practitioner, attendees will learn to:

• Maximize the potential of SQL to build powerful, complex and robust SQL queries
• Query multiple tables with inner joins, outer joins and self joins
• Construct recursive common table expressions
• Summarize data using aggregation and grouping
• Execute analytic functions to calculate ranks
• Build simple and correlated subqueries
• Thoroughly test SQL queries to avoid common errors
• Select the most efficient solution to complex SQL problems

COURSE OUTLINE

1. SQL Quick Refresher
2. Retrieving Data with SELECT
3. Executing Quries 
4. Implementing Various Types of Joins
5. Writing Self Joins
6. Combining Queries with Set Operators
7. Summarizing Data with Aggregate Functions
8. Grouping Data
9. Extending Group Queries
10. The OVER Clause
11. Extending the Use of Aggregates
12. Building Subqueries
13. Self-contained Subqueries
14. Correlated Subqueries
15. Common Table Expressions

For a full agenda click here.