SQL Programming Language
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
These classes can be paid for by invoice billing to your cost center or by you personally. Please obtain manager approval to use the cost center in writing (email).
**Update: Deferred payment is no longer available at the University of Memphis if you are using tuition reimbursement. You will need to pay for the course prior to the course start date (a payment link will be emailed to you) or you will not be allowed into the class. The only invoice payments that are allowed is when the course will be paid for by your cost center.**
All trainings are NONREFUNDABLE within 14 days of the training’s scheduled start date. Attendees who wish to cancel within the 14-day nonrefundable period will need to email Rami Lotay (rslotay@memphis.edu) and give a detailed explanation as to why they cannot possibly attend, as they will still be liable for payment in full.
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
- 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
- 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
These classes can be paid for by invoice billing to your cost center or by you personally. Please obtain manager approval to use the cost center in writing (email).
**Update: Deferred payment is no longer available at the University of Memphis if you are using tuition reimbursement. You will need to pay for the course prior to the course start date (a payment link will be emailed to you) or you will not be allowed into the class. The only invoice payments that are allowed is when the course will be paid for by your cost center.**
All trainings are NONREFUNDABLE within 14 days of the training’s scheduled start date. Attendees who wish to cancel within the 14-day nonrefundable period will need to email Rami Lotay (rslotay@memphis.edu) and give a detailed explanation as to why they cannot possibly attend, as they will still be liable for payment in full.
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
- SQL Quick Refresher
- Retrieving Data with SELECT
- Executing Quries
- Implementing Various Types of Joins
- Writing Self Joins
- Combining Queries with Set Operators
- Summarizing Data with Aggregate Functions
- Grouping Data
- Extending Group Queries
- The OVER Clause
- Extending the Use of Aggregates
- Building Subqueries
- Self-contained Subqueries
- Correlated Subqueries
- Common Table Expressions
For a full agenda click here.
