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 SQL Language is an ANSI/ISO standard language used by all relational database products. 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.
Those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries.
This is an advanced course and knowledge of the basics of SQL at the level of Introduction to SQL Programming Training or equivalent is assumed.
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 any time after class.
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