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

[@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

[@arashaadd]

Thanks you so much man, I really appreciate the work you put in so people can learn. I wish u all of the best and nothing but success💪🏼

[@jensberckmoes9993]

First of all, great series, loved watching this as it taught me a lot! I just realised that your create table timestamp is off by an hour.

[@mudilichaitanya3689]

thnks man

[@invincibleme5273]

02:11:17 Create Table

[@wellsnolan2599]

Sorry to be off topic but does someone know a method to log back into an instagram account..? I somehow lost the account password. I appreciate any tricks you can give me!

[@aci25v]

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.

[@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

[@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.

[@K.I.N.G234]

yeah

[@archimedeschotsky2032]

3:59:15 I think a good example for CHAR() is when you are referencing a State as its typically 2 characters long (e.g. TX, FL, etc). Caleb you are amazing love your work!!!!!!!!!

[@richsinger6818]

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.

[@muhammadalam8928]

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

[@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!

[@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!!

[@NobleAbsinthe]

Caleb you're one of the only tech KZbinrs I respect.

[@anirbansarkar3226]

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

[@luckymagethaumia94]

When a guy in youtube is better at teaching stuff than whatever the heck your educational authorities have to offer 👀👀👀

[@nirazmaamari3738]

I just downloaded Oracle and it does not look anything like this :(

[@renoma111]

2:09:13 "QUIT" Caleb said calmy. I wheezed so hard at that bro lmao.

[@elshannur4512]

Greetings from Azerbaijan Caleb, your videos are amazing!

[@tsuyaosone1535]

Just a comment of appreciation here. Great work sir!

[@kamalk0107]

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

[@LinhNguyen-zw5wu]

The Oracle site has completely changed compared to the time of this comment FYI (18c express) Still a good tutorial to get into for a refresher/beginner. Thanks man.

[@spctvl03]

Super down to Earth and helping me get used to Oracle for a new job I’m getting that uses that enterprise software

[@azigtovmasian207]

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

[@edgarcastaneda1538]

Hey man! you're really good teaching. Congrats

[@maurabbit]

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

[@ivanjakic1587]

I would like to have options to have an automated translating option to English and other languages. Could you please enable this option.

[@Linuxkat]

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

[@tequishamcdearmon9152]

I'm in a SQL course now... This video helps

[@324Kela]

Hi Caleb! Thanks for this. My coworker sent me your way

[@josecarlos9289]

This is amazing, just suscribed forever to your channel.

[@brendanbriody9268]

Great Tutorials! The short jokes and goofing do make it more entertaining. I polished up my theoretical Database knowhow with this course having more than 20 Years of work experience. like it ..cheers

[@nayeemuddin8960]

Your hand writing is awesome bro ;)

[@paryanatahiri3433]

26:20 while biting some apple kinda thing hahah such a cool teacher ❤

[@Abdoul810]

Hi Caleb, thanks for this tutorial and I really like your style. I’m currently trying to learn on oracle 18c Express edition and was wondering if there are any differences I should be aware of. Thanks in advance

[@babarhassan7726]

I liked your swag in the start of videos thumbs up and keep it up. Rest topic was very well structured and demonstrated. Wishing you best of luck in future

[@aaibrahim448]

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

[@marcelomcustodio]

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

[@dennisnjenga2364]

I must say... I love your charisma 😂

[@fncel]

24:13 "Sorry. I'm eating an apple" LoL huahuahauha

[@fabiofrasson566]

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

[@splint3rsec]

let's admit it, his handwriting is so cool

[@mci2000]

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

[@abdullahnaser9041]

Wooow, really you're amazing I love your explain .. and your way of teaching. I learned and enjoyed with you

[@nileshsharma3998]

This channel and content is awesome

[@nadraibrahim6400]

Love from India 🇮🇳

[@cardanousa]

Bro... You are hilarious! Great job man! 😊👍

[@ericsonbandilla9196]

Hello Caleb. can you use this knowledge, as a skill to work remotely?

[@ssGoalTalk]

Please what level would you rate this complete tutorial on, Basic, intermediary, pro etc....?

[@jesus2621]

Basic

[@aaryanshrestha7559]

Quick question in SQL, I have 3 tables table_a, table_b, table_c. table_a has one column that is unique for either table_b or table_c, Need a join query that can get the data eg. table_a has a column with data [ 201, 202, 203, 102, 103, 104...], table_b has a column with data [201, 202, 203, ....] and table_c has a column with data [101, 102, 103, ....], if i do where table_a.column = 102 . then it should join with table_c. if i do where table_a.column = 201 then it should join with table_b. table_c column data and table_b column data will never be same. and the table_a should only be joined with either table_b or table_c not both.

[@uruttuulagam103]

Select A.no,B.no,C.no from table_a A, table_b B,table_c C where A.no=B.no and A.no=C.no;

[@arwamais]

Is this all the tutorial, or are there more videos coming?

[@whoaskedforthisbs]

If Shaggy was a teacher, lol. Love it! Thank you.

[@KellieLee77]

Do you do this kind of training on software like Vena and Xeras?

[@eduardofernandezdiaz5264]

This video would have been perfect if it hand included joins, triggers and stored procedures. Love the way you explain!

[@agentoothpick]

11:17 made me brake laughing!! Great job bro, thank you!!

[@شوارعالعالمالعربي-ظ1ط]

hey i am a visionary learner and i like ur examples

[@cesaraugustomari3676]

Hello! At 29:40 , I get an error from SQL Developer telling me it doesn't find any SID name "xe" .... why is that? Thanks

[@cesaraugustomari3676]

I've found that in Windows Registry you can find the correct database values

[@dolvinjohn5001]

Hi. Do I need to know SQL before watching and learning from this video. Or SQL is fully covered in this too. Am new to this !!😁

[@treydevillier4985]

My favorite part: 2:09:13

[@TheCivildecay]

16:41 so basically generic attributes are objects, and specific attributes are instances?

[@splyraville1346]

01:02:35 made me laugh. - "Professors... they are people sometimes" ;D

[@sukana2222]

you are the best brooooooo, I only subscribe you for your jokes and the dogs,,:)

[@raimiralvarez6998]

I got a question: for specific and general attributes, wouldn't they be data and metadata respectively? Together they would be the actual information.

[@MrDarkogaucho]

thanks very much

[@farmanhussain2676]

Can you please refer any website where I can find more content for deep learning...

[@Rich20109]

Udemy.com

[@vibeeshkamalakannan2017]

1:02:31 "Professors- They're people sometimes" xD

[@KatieAJMagill]

You're super cool Caleb. Thanks

[@malivendors]

Hi Caleb, what`s the best current version to download as per now. Mar 2021?

[@m.osamanawaz9780]

Well said; "Old is gold".

[@chrischris6359]

So in 3:00:06 i was able to delete the user why is that ? Oracle Developer , and the db is 21c

[@krishnakumarchavan6042]

The way he said ''Oracle Database" at 2:17:12 is why I like watching his videos

[@driesvdg8743]

Thx bro, I needed this

[@worldofprograming4422]

how do did you learn please help me I've tried almost everything

[@ishaanj8023]

Thanks it really helped

[@t.l.e.e.]

Thank you Tech Shaggy

[@vikrantharne9345]

in the first 3mins only you have cleared my doubt about outer joins..

[@IMdAbdulquadirKhan]

Can I use Oracle live sql

[@cameriqueTV]

Why is there no decent DB for Mac?

[@mraravind1111]

My Savior. Thanks a ton.

[@kirkolayer652]

Thank you teacher

[@blessedchild2879]

Thank you so much. It is so helpful.

[@bukeeyhamilton9313]

Thanks! Take care

[@endone3661]

28:26 I accidentally checked "Oracle Usage Tracking" do you guys know how to disable it ?

[@OptionsOwnsU]

Am i the only one that gets a headache when Caleb doesn't put a semicolon after the parenthesis?

[@vimukthiwanigathunga3710]

Could you please active the 'auto captions' , Thank you!

[@gelliankeiracalimlim256]

Thank you sensei

[@mraravind1111]

When do we get your tutorials on querying tables, creation of stored procedures and functions, table views? Writing complex queries etc...

[@southtechtutorials4865]

Thanks Aravind for asking what i had thought of too

[@Asuresh392]

I was trying to install, downloading looked fine , but its asking for proxy information. what to put?

[@frvnciscvm]

i'm guessing this happened when you try to create a data base connection, if that's the case and you don't have an external database to use I suggest downloading oracle express as well so you can have a local one. there are also some tutorials on installing everything in the oracle website. hope this helps if you still have this problem :)

[@thibautjose9726]

This video is great

[@nimet8315]

50:38 made my day 😂

[@vishwajeetohal9137]

1:30:15 can we just take a moment to appreciate the absolute beast humour ❤️😂

[@amansinghbhadauria2818]

Nope, that was just cringey.

[@mr.spymonster3475]

Can you share the more labs videos.

[@tenshi_tries]

can I use the latest Oracle db XE?\

[@booshuyi4388]

Hi, May I know how to solve when the result table showing duplicate amount?

[@santoshkumardoodala2535]

What to do for MAC?

[@fadhilinayituriki1678]

You are a God bro

[@mariyam9932]

Can we all talk about how funny and cute he is?

[@zamin1673]

Your right mrs

[@XZIL_R8ED]

I'll agree that he's funny and he's a great teacher but I'm not gay so I'm not going to comment on the other part

[@jerraldglaser4414]

We need you at UNM!

[@runbabyRHAN]

24:11 - How to eat an apple.

[@hiuyi6350]

This is super outdated, the website you showed and the Windows 7 OS. I'm using Windows 11 and downloaded OracleXE213_Win64, couldn't follow at all.

[@worldofprograming4422]

THIS GUY IS good

[@ramidaoud4323]

It would be helpful to number the lines so we can know which line has the error

[@emilygraham3440]

Yeah ok this is awesome.