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
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!
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. :)
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.
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!!!!!!!!!
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.
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!!
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.
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
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
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
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.
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 :)
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
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💪🏼
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.
thnks man
02:11:17 Create Table
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!
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. :)
Totally love the simplicity/Fun in his style of teaching it's like being entertained and learning at the same time.
"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
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.
yeah
Caleb you're one of the only tech TH-camrs I respect.
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!!!!!!!!!
Man Caleb is fucking awesome. He can't be better. His videos makes so much sense. Thanks boss.
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.
Dont know how I’ve not seen your videos until know but you’re awesome man. Got me laughing while learning! Keep it up!
Thanks a lot for your efforts, you are adding so much value to the community. Most importantly, you are enjoying what you are doing. ❤
Super down to Earth and helping me get used to Oracle for a new job I’m getting that uses that enterprise software
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!!
Although i recently subscribe you . I watched your content and i instantly like your style of learning . ♥️ From India
I'm sooo thankfulllll that I find your channel💙
you are just awsome 😍
Biiiig likeee 👍🏻
Greetings from Azerbaijan Caleb, your videos are amazing!
Just a comment of appreciation here. Great work sir!
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.
Thanks Caleb, you rule dude, pretty nice teaching, you really know what you are doing, triple A bro, thanks again my man.
I just downloaded Oracle and it does not look anything like this :(
You are so so good. Thank you for simplifying this. You're the best.
Hey man! you're really good teaching.
Congrats
you are the best man , funny ,unique and easy to comprehend
When a guy in youtube is better at teaching stuff than whatever the heck your educational authorities have to offer
👀👀👀
This is amazing, just suscribed forever to your channel.
26:20 while biting some apple kinda thing hahah such a cool teacher ❤
Your hand writing is awesome bro ;)
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
Good job, Caleb.
We're waiting for your AWS tutorial
Hi Caleb! Thanks for this. My coworker sent me your way
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
I'm in a SQL course now... This video helps
thanks a lot for this awesome video, feels so easy to understand watching it!
I would like to have options to have an automated translating option to English and other languages. Could you please enable this option.
I must say...
I love your charisma 😂
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
Bro... You are hilarious! Great job man! 😊👍
2:09:13
"QUIT" Caleb said calmy.
I wheezed so hard at that bro lmao.
This channel and content is awesome
Love from India 🇮🇳
Thank you Tech Shaggy
thanks very much
Well said; "Old is gold".
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
I've found that in Windows Registry you can find the correct database values
Wooow, really you're amazing
I love your explain ..
and your way of teaching.
I learned and enjoyed with you
16:41 so basically generic attributes are objects, and specific attributes are instances?
let's admit it, his handwriting is so cool
you are the best brooooooo, I only subscribe you for your jokes and the dogs,,:)
So in 3:00:06 i was able to delete the user why is that ? Oracle Developer , and the db is 21c
Thx bro, I needed this
Caleb, love this video. Do you do any video training on querying oracle? Such as sql using the "with" clause?
This video would have been perfect if it hand included joins, triggers and stored procedures. Love the way you explain!
Thanks it really helped
My Savior. Thanks a ton.
Thank you sensei
Thanks! Take care
hey i am a visionary learner and i like ur examples
You're super cool Caleb. Thanks
24:13 "Sorry. I'm eating an apple" LoL huahuahauha
Thank you teacher
Thank you so much. It is so helpful.
The way he said ''Oracle Database" at 2:17:12 is why I like watching his videos
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.
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;
Hi Caleb, what`s the best current version to download as per now. Mar 2021?
28:26 I accidentally checked "Oracle Usage Tracking" do you guys know how to disable it ?
This video is great
Please what level would you rate this complete tutorial on,
Basic, intermediary, pro etc....?
Basic
My favorite part: 2:09:13
Do you do this kind of training on software like Vena and Xeras?
in the first 3mins only you have cleared my doubt about outer joins..
I was trying to install, downloading looked fine , but its asking for proxy information. what to put?
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 :)
If Shaggy was a teacher, lol. Love it! Thank you.
Hello Caleb. can you use this knowledge, as a skill to work remotely?
11:17 made me brake laughing!! Great job bro, thank you!!
Why is there no decent DB for Mac?
1:30:15 can we just take a moment to appreciate the absolute beast humour ❤️😂
Nope, that was just cringey.
I got a question: for specific and general attributes, wouldn't they be data and metadata respectively? Together they would be the actual information.
50:38 made my day 😂
THIS GUY IS good
You are a God bro
Can you please refer any website where I can find more content for deep learning...
Udemy.com
1:02:31 "Professors- They're people sometimes" xD
Is this all the tutorial, or are there more videos coming?
We need you at UNM!
Can I use Oracle live sql
Am i the only one that gets a headache when Caleb doesn't put a semicolon after the parenthesis?
Yeah ok this is awesome.
can I use the latest Oracle db XE?\
What to do for MAC?
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 !!😁
01:02:35 made me laugh.
- "Professors... they are people sometimes" ;D
how do did you learn please help me I've tried almost everything
24:11 - How to eat an apple.
Could you please active the 'auto captions' , Thank you!
Hi,
May I know how to solve when the result table showing duplicate amount?
When do we get your tutorials on querying tables, creation of stored procedures and functions, table views? Writing complex queries etc...
Thanks Aravind for asking what i had thought of too
It would be helpful to number the lines so we can know which line has the error
Can you share the more labs videos.
Can we get some Swagdog merch? 🙃
I think this is your old video