PDF Add to WishList
SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation.
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.
Retrieving data with SELECT
Implementing various types of joins
Writing self joins
Combining queries with set operators
Summarizing data with aggregate functions
Extending group queries
The OVER clause
Extending the use of aggregates
Common table expressions
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 Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."
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:
Our instructor was very clear and effective in her delivery. A large part of my job is accessing and analyzing data, and I was immediately able to apply the new skills I learned in class at work. I am now running queries and developing reports like a pro! With the new skills and knowledge I gained from this course, I feel like I’m on my way to meeting my professional goals.
- M. Flanagan, Administrative Assistant