Introduction to Oracle SQL
Sharpen your skills in Oracle SQL including SQL basics, aggregating, combining, and customizing data.
Kurs Kostenlos Starten4 Stunden15 Videos54 Übungen12.920 LernendeLeistungsnachweis
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.Trainierst du 2 oder mehr?
Versuchen DataCamp for BusinessBeliebt bei Lernenden in Tausenden Unternehmen
Kursbeschreibung
Gain an Introduction in Oracle SQL
Oracle SQL is one of the most widely used database management systems around the world. It's well suited to power primarily commercial and enterprise applications, and is particularly popular at large companies with mission-critical databases.This introductory course will teach you all the essentials you need to master Oracle SQL. This includes SQL basics, aggregating, combining, and customizing data in Oracle. You will apply your newly acquired knowledge to solve business problems for a digital media store using the Chinook data.
Practice Essential Skills Using Chinook data
The course begins by exploring SQL Basics. In this chapter, you will familiarize yourself with topics such as what is an Oracle database and relational databases, and essentially how to retrieve, order, and filter data.The last chapter will explain how Oracle SQL interprets your queries. You will then learn how to customize your outputs, handle missing values, and how to convert data from one type to another.
Further Develop Your Oracle SQL Skills
By the end of this course, you will understand how Oracle processes SQL queries and will have a solid foundation in Oracle SQL. With the growing importance of relational databases, comes a simultaneously increasing demand of RDBMS and SQL programmers. Explore our library to discover more about SQL and its RDBMS.Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.- 1
SQL Basics
KostenlosYou're about to write your first Oracle SQL queries! At the end of this chapter, you will be able to retrieve, order and filter data.
- 2
Aggregating Data
Sometimes, you need to perform operations on a group of data, and get aggregated results. This second chapter will show you how. You will also learn about data types.
- 3
Combining Data
What if your data is spread across multiple tables? This third chapter will show you how to join several tables, and how to perform queries and operations on them.
Using joins50 xpInner joins100 xpUsing USING100 xpJoining multiple tables100 xpOuter joins50 xpPicking an outer join type50 xpLeft outer join100 xpRight outer join100 xpMore joins50 xpCross joins100 xpSelf joins100 xpSet operators50 xpI want it all100 xpUnder pressure100 xpAnother one bites the dust100 xp - 4
Taking it to the Next Level
By now, you already have some solid basics. Let's take it a step further and understand how Oracle SQL interprets your queries. You will then learn how to customize your outputs, handle missing values, and how to convert data from one type to another.
Query processing order50 xpOrder of execution of a query100 xpMistakes against query processing order100 xpCustomizing output50 xpRounding numbers100 xpWorking with the modulo100 xpManipulating strings100 xpReplacing letters100 xpWorking with NULL values50 xpTesting if a value is NULL100 xpReplacing NULL values100 xpComparing values100 xpUsing conversion functions50 xpImplicit and explicit conversion50 xpConversion functions100 xpCongratulations!50 xp
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.Datensätze
Chinook dataMitwirkende
Hadrien Lacroix
Mehr AnzeigenCurriculum Manager at DataCamp
Sara Billen
Mehr AnzeigenData Scientist at DataCamp
Was sagen andere Lernende?
Melden Sie sich an 15 Millionen Lernende und starten Sie Introduction to Oracle SQL Heute!
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.