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.
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
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