Oracle for NOOB Developers
Soren Rahbar
Assista a este curso e milhares de outros
Assista a este curso e milhares de outros
Aulas neste curso
-
-
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
-
-
- --
- Nível iniciante
- Nível intermediário
- Nível avançado
- Todos os níveis
Gerado pela comunidade
O nível é determinado pela opinião da maioria dos estudantes que avaliaram este curso. Mostramos a recomendação do professor até que sejam coletadas as respostas de pelo menos 5 estudantes.
--
--
Sobre este curso
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.
Conheça seu professor
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... Visualizar o perfil completo
Projeto prático de curso
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.
Nota do curso
Por que fazer parte da Skillshare?
Faça cursos premiados Skillshare Original
Cada curso possui aulas curtas e projetos práticos
Sua assinatura apoia os professores da Skillshare
Aprenda em qualquer lugar
Faça cursos em qualquer lugar com o aplicativo da Skillshare. Assista no avião, no metrô ou em qualquer lugar que funcione melhor para você, por streaming ou download.
Cursos relacionados
