Writing SQL Queries

REGISTRATION

• February 17-18, 2022: Registration Link
• 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

REFUND POLICY All trainings are NONREFUNDABLE within 14 days of the training's 1st day. Additionally, attendees who wish to cancel within the 14-day nonrefundable period will have to pay the entire amount due.

 

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 AGENDA

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 more details of the course agenda, please click here.