This Oracle advanced SQL course provides an overview of the recent additions to the SQL language that have been added over the last few years, but that may have slipped under your radar.
We will describe;
Extensions to GROUP BY
The WITH Clause (Oracle's Subquery Factoring Clause/SQL Server's Common Table Expressions)
The PIVOT and UNPIVOT Features
The MERGE Statement
And, finally, the PARTITION BY/RIGHT OUTER JOIN syntax.
If you aren't familiar with Oracle or Oracle databases, you may want to take this course beforehand.
What are advanced SQL queries used for?
These advanced queries will help you to manipulate, clean, and analyze your data more effieiencly than ever before.
Who is this advanced SQL course for?
This course is ideal for advanced Oracle and SQL users who want to learn about all the newest functionality. Beginners may be more interested in our Oracle Database Fundamentals course.
What advanced SQL queries will I learn in this course?
This course will describe Analytics Functions, GROUP BY, WITH, PIVOT and UNPIVOT, MERGE, and many more.
What software is required for this advanced SQL course?
You will want to have the latest version of Oracle Database and a client software such as Toad or the Oracle SQL developer tool. You will also want to have the latest version of Microsoft SQL Server Database and its client tool - SQL Servers Management Studio.
Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!