» » » Advanced SQL Queries in Oracle and SQL Server

Information of news
  • Author: davida
  • Date: 15-11-2013, 13:53
15-11-2013, 13:53

Advanced SQL Queries in Oracle and SQL Server

Category: Tutorials » Other


Advanced SQL Queries in Oracle and SQL Server | 934MB
Duration: 4h 25m | Video: AVC (.mp4) 1024x768 15fps | Audio: AAC 44.1KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

This course details recent additions to the standard SQL language and includes topics such as Analytic Functions and Extensions to GROUP BY, to name a few.
This 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 Analytic Functions, 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.


Site BBcode/HTML Code:

Tags to an Article: Advanced, SQL, Queries, Oracle, and

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.