Oracle SQL All-in-One Quick Start Tutorial Series (4 HOURS!)

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[codebreakthrough]

Timestamps
00:00:00 - Intro to Oracle Database
00:10:16 - Entities and Attributes
00:20:33 - Downloading Oracle Database and Installing SQL Developer
00:30:50 - Beginner Terms - Database Design Primer 1
00:45:00 - Database Integrity - Database Design Primer 2
00:57:17 - Relationships and Primary and Foreign Keys - Database Design Primer 3
01:26:54 - Normalization - Database Design Primer 4
01:47:31 - Indexes - Database Designer Primer 5
01:58:36 - Intro to Queries
02:03:29 - Whitespace, Case Sensitivity, and Comments
01:11:17 - CREATE TABLE
02:16:20 - Intro to Constraints
02:22:32 - How to Add Column Constraints (Attributes)
02:28:26 - Column-Level and Table-Level Constraints
02:32:40 - How to Add Primary Key Constraints
02:35:33 - Parent Child Relationships
02:41:41 - Designing Our Foreign Keys
02:49:27 - How to Create Foreign Keys
02:56:35 - ON DELETE (SET NULL and CASCADE)
03:02:33 - How to Create Composite Primary Keys
03:09:34 - How to Create - Drop Indexes
03:13:31 - Why Primary Keys Shouldn’t Change
03:20:44 - Intro to Data Types
03:25:47 - Important Data Types
03:31:55 - UTF-8 and UTF-16
03:37:40 - CHAR Part 1
03:41:31 - CHAR Part 2
03:45:03 - NCHAR Part 1
03:50:00 - UTF-8 and UTF-16 Character Sets
03:54:01 - NCHAR Part 2
03:57:12 - VARCHAR2 and NCARCHAR2
04:00:17 - NUMBER Data Type

[aciv]

I just got to 43 minutes of the 4 hours and 8 seconds and love the way you teach. I will continue watching the whole class but wanted to stop here and say thank you for your time and for such great content. Ok, back to the class. :)

[ssGoalTalk]

Totally love the simplicity/Fun in his style of teaching it's like being entertained and learning at the same time.

[Final_M]

Dont know how I’ve not seen your videos until know but you’re awesome man. Got me laughing while learning! Keep it up!

[richsinger]

Thank you for these videos buddy. I'm just now getting back into the technology field in which i have a college degree in Database Information Systems but was never able to use once having kids. I'm into learning from scratch again about this and learning SQL since I didn't before and this is helping me while I was able to get my first job in this field. I appreciate you being able to break it down for us in order to help it make more sense.

[abcdeabcdeable]

Great fun tutorial thanks!! @2:28:02 Yes you are correct a default value only initially sets the default value when the row is inserted. So for example you could have a column called 'Message' as a string(varchar) column with a default value 'bla', so when you add a new row if 'Message' column value is blank(NULL) 'bla' will be inserted instead of NULL. But you can always go back and run an update statement and set the 'Message' value to NULL for the newly inserted row. So it is not a constraint just a default value for the FIRST time the row is inserted.

[khalilderouich]

"If you can't explain it simply, you don't understand it well enough " Elbert Einstein
@Caleb Curry you're the best on easy_explaining . Keep going

[srihurry]

congratulations on 400k Caleb. Im almost 80% done with the beginner tutorial in oracle dbms and it has really helped me in understanding the topic very well. Good job!!

[josecarlos]

This is amazing, just suscribed forever to your channel.

[muhammadalam]

Man Caleb is fucking awesome. He can't be better. His videos makes so much sense. Thanks boss.

[anirbansarkar]

Although i recently subscribe you . I watched your content and i instantly like your style of learning . ♥️ From India

[Linuxkat]

You are so so good. Thank you for simplifying this. You're the best.

[azigtovmasian]

I'm sooo that I find your channel💙
you are just awsome 😍
Biiiig likeee 👍🏻

[edgarcastaneda]

Hey man! you're really good teaching.
Congrats

[marcelomcustodio]

Good job, Caleb.
We're waiting for your AWS tutorial

[fabiofrasson]

thanks a lot for this awesome video, feels so easy to understand watching it!

[KrishnaKamal]

Thanks a lot for your efforts, you are adding so much value to the community. Most importantly, you are enjoying what you are doing. ❤

[mci]

Caleb, love this video. Do you do any video training on querying oracle? Such as sql using the "with" clause?

[maurabbit]

Thanks Caleb, you rule dude, pretty nice teaching, you really know what you are doing, triple A bro, thanks again my man.

[aaibrahim]

you are the best man, funny, unique and easy to comprehend