Advanced SQL Queries in Oracle and SQL Server from Pluralsight

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;

If you aren't familiar with Oracle or Oracle databases, you may want to take

beforehand.

These advanced queries will help you to manipulate, clean, and analyze your data more effieiencly than ever before.

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

This course will describe Analytics Functions, GROUP BY, WITH, PIVOT and UNPIVOT, MERGE, and many more.

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.

What's inside

Syllabus

Analytic Functions - Part 1

Analytic Functions - Part 2

Analytic Functions - Part 3

Analytic Functions - Part 4

Extensions to GROUP BY

The WITH Clause - Part 1

The WITH Clause - Part 2

The PIVOT and UNPIVOT Features

The MERGE Statement

PARTITION BY/RIGHT OUTER JOIN

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers advanced concepts for experienced Oracle and SQL users

Ideal for learners interested in the latest SQL language functionality

Taught by Scott Hecht, a recognized expert in Oracle and SQL

Requires the latest versions of Oracle Database and SQL Server, which may pose a cost barrier

Career center

Learners who complete Advanced SQL Queries in Oracle and SQL Server will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts collect, clean, analyze, and interpret data to uncover patterns and trends. They use their findings to help businesses make better decisions. The Advanced SQL Queries in Oracle and SQL Server course can help Data Analysts to improve their data analysis skills. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN. These topics can help Data Analysts to write more efficient and effective SQL queries.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators maintain and optimize databases. They ensure that databases are running smoothly and that data is safe and secure. The Advanced SQL Queries in Oracle and SQL Server course can help Database Administrators to improve their SQL skills. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN. These topics can help Database Administrators to write more efficient and effective SQL queries.

See salaries and explore the career path for Database Administrator

Data Scientist

Data Scientists use data to build models that can predict future outcomes. They use these models to help businesses make better decisions. The Advanced SQL Queries in Oracle and SQL Server course can help Data Scientists to improve their data analysis skills. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN. These topics can help Data Scientists to write more efficient and effective SQL queries.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use data to help businesses make better decisions. They analyze data to identify trends and patterns, and then they make recommendations to improve business processes. The Advanced SQL Queries in Oracle and SQL Server course can help Business Analysts to improve their data analysis skills. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN. These topics can help Business Analysts to write more efficient and effective SQL queries.

See salaries and explore the career path for Business Analyst

Information Security Analyst

Information Security Analysts protect computer systems and networks from unauthorized access and attacks. They also investigate security breaches and develop security plans. The Advanced SQL Queries in Oracle and SQL Server course can help Information Security Analysts to improve their data analysis skills. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN. These topics can help Information Security Analysts to write more efficient and effective SQL queries.

See salaries and explore the career path for Information Security Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. They use their knowledge of programming languages and software development tools to create software that meets the needs of users. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Software Engineers who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Software Engineer

Statistician

Statisticians collect, analyze, and interpret data to uncover patterns and trends. They use their findings to help businesses and governments make better decisions. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Statisticians who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Statistician

Actuary

Actuaries use mathematics and statistics to assess risk and uncertainty. They work for insurance companies, pension funds, and other financial institutions. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Actuaries who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Actuary

Financial Analyst

Financial Analysts use data to analyze financial markets and make investment recommendations. They work for investment banks, asset management companies, and other financial institutions. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Financial Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Financial Analyst

Market Research Analyst

Market Research Analysts collect, analyze, and interpret data to understand consumer behavior. They use their findings to help businesses develop new products and services. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Market Research Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Market Research Analyst

Operations Research Analyst

Operations Research Analysts use mathematics and statistics to solve business problems. They work for a variety of industries, including manufacturing, transportation, and healthcare. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Operations Research Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Operations Research Analyst

Quantitative Analyst

Quantitative Analysts use mathematics and statistics to analyze financial markets and make investment recommendations. They work for hedge funds, investment banks, and other financial institutions. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Quantitative Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Quantitative Analyst

Risk Analyst

Risk Analysts use mathematics and statistics to assess risk and uncertainty. They work for insurance companies, banks, and other financial institutions. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Risk Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Risk Analyst

Software Tester

Software Testers test software applications to find bugs and errors. They work for a variety of industries, including software development, manufacturing, and healthcare. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Software Testers who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Software Tester

Systems Analyst

Systems Analysts analyze business processes and design and implement computer systems to improve efficiency and effectiveness. They work for a variety of industries, including manufacturing, healthcare, and finance. The Advanced SQL Queries in Oracle and SQL Server course may be useful for Systems Analysts who want to learn more about SQL. The course covers topics such as analytic functions, extensions to GROUP BY, the WITH clause, the PIVOT and UNPIVOT features, the MERGE statement, and PARTITION BY/RIGHT OUTER JOIN.

See salaries and explore the career path for Systems Analyst