Oracle for NOOB Developers
Soren Rahbar
Schau dir diesen Kurs und Tausende anderer Kurse an
Schau dir diesen Kurs und Tausende anderer Kurse an
Einheiten dieses Kurses
-
-
1.
Introduction
0:53
-
2.
What is oracle?
1:16
-
3.
What is Relational Database?
2:27
-
4.
Preparing The Practice Environment
9:22
-
5.
Basic Architecture
3:52
-
6.
Tablespace, Schema and User
3:24
-
7.
DML DDL
1:19
-
8.
Create Table
5:27
-
9.
ID and Primary Key
4:13
-
10.
"Alter" Command
3:31
-
11.
What is a Constraint?
5:58
-
12.
Commit or Rollback?
3:32
-
13.
Query 1.0
5:04
-
14.
Query 1.1
10:09
-
15.
TO_DATE Function
4:46
-
16.
What is Null
2:04
-
17.
Insert, Update and Delete
6:09
-
18.
What is a Sequence?
4:28
-
19.
Relationship and Foreign Key
10:10
-
20.
Inner Join
6:06
-
21.
Left-Right-Full Outer Join
5:15
-
22.
What is the Dual Table?
1:08
-
23.
What does "Group by" clause?
9:11
-
24.
Create a View
2:25
-
25.
What is an Index?
3:56
-
26.
What is a Transaction?
1:43
-
27.
How to Create a Trigger?
10:05
-
28.
Good Night!
1:47
-
-
- --
- Anfänger-Niveau
- Fortgeschrittenes Niveau
- Fortgeschrittenes Niveau
- Jedes Niveau
Von der Community generiert
Das Niveau wird anhand der mehrheitlichen Meinung der Teilnehmer:innen bestimmt, die diesen Kurs bewertet haben. Bis das Feedback von mindestens 5 Teilnehmer:innen eingegangen ist, wird die Empfehlung der Kursleiter:innen angezeigt.
--
Teilnehmer:innen
--
Projekte
Über diesen Kurs
Are you an Administrator or a developer new to Oracle Database? This course is the perfect starting point. Designed specifically for beginners, you'll learn what Oracle is, how to install and use Oracle XE, and how to write and run SQL queries using Oracle SQL Developer. We’ll cover key concepts like users, schemas, data types, tables, constraints, relationships, joins, views, aggregate functions, indexes, transactions, triggers, and more. You’ll even practice inserting and querying dates and working with real-world examples. No prior experience with Oracle is required—just basic programming or database knowledge. By the end of this course, you’ll feel confident using Oracle as a developer and ready to dive deeper into PL/SQL or advanced topics.
Triff deine:n Kursleiter:in
Hey! I'm Soren, a Database Administrator by day, and a passionate teacher by night (and sometimes by day too, because who needs sleep when there are databases to explore?). With six years of wrangling data under my belt, I've learned that databases, much like houseplants, thrive on a little bit of structure, a lot of care, and the occasional debugging when things get... well, tangled.
When I'm not knee-deep in SQL queries or making peace with Oracle (yes, even databases have moods), you'll find me sharing my love for all things data with anyone willing to listen--or at least pretend to. My mission? To make the mysterious world of Database Technology as clear as a well-executed SELECT statement.
I'm here to demystify, de-stress, and (hopefully) delight you with the wonders of d... Vollständiges Profil ansehen
Praxisnahes Kursprojekt
This hands-on project helps you practice creating tables, using constraints, inserting and updating data, writing queries, working with views, indexes, and even triggers. You’ll build a basic product management system for a fictional shop and perform various operations on it.
This project is optional, but I strongly recommend giving it a try. It’s a great way to test your understanding and gain real-world practice.
Once you’re done, send me your solutions and I'll check it and send you a review on it.
Kursbewertung
Warum lohnt sich eine Mitgliedschaft bei Skillshare?
Nimm an prämierten Skillshare Original-Kursen teil
Jeder Kurs setzt sich aus kurzen Einheiten und praktischen Übungsprojekten zusammen
Mit deiner Mitgliedschaft unterstützt du die Kursleiter:innen auf Skillshare
Lerne von überall aus
Ob auf dem Weg zur Arbeit, zur Uni oder im Flieger - streame oder lade Kurse herunter mit der Skillshare-App und lerne, wo auch immer du möchtest.
