Oracle SQL All-in-One Quick Start Tutorial Series (4 HOURS!)
Vložit
- čas přidán 2. 01. 2020
- Start your software dev career - calcur.tech/dev-fundamentals 💯 FREE Courses (100+ hours) - calcur.tech/all-in-ones
🐍 Python Course - calcur.tech/python-courses
✅ Data Structures & Algorithms - calcur.tech/dsa-youtube
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/newsletter
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/subscribe
👨🏻🎓 Courses - www.codebreakthrough.com
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com/shop/calebcurry
🅿 Patreon - calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - github.com/sponsors/CalebCurry
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/crypto - Věda a technologie
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.
Dont know how I’ve not seen your videos until know but you’re awesome man. Got me laughing while learning! Keep it up!
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.
"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.
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!!
You are so so good. Thank you for simplifying this. You're the best.
This is amazing, just suscribed forever to your channel.
Man Caleb is fucking awesome. He can't be better. His videos makes so much sense. Thanks boss.
Caleb you're one of the only tech CZcamsrs I respect.
Good job, Caleb.
We're waiting for your AWS tutorial
I'm sooo thankfulllll that I find your channel💙
you are just awsome 😍
Biiiig likeee 👍🏻
Hey man! you're really good teaching.
Congrats
Although i recently subscribe you . I watched your content and i instantly like your style of learning . ♥️ From India
Thanks a lot for your efforts, you are adding so much value to the community. Most importantly, you are enjoying what you are doing. ❤
thanks a lot for this awesome video, feels so easy to understand watching it!
you are the best man , funny ,unique and easy to comprehend
Just a comment of appreciation here. Great work sir!
Thanks Caleb, you rule dude, pretty nice teaching, you really know what you are doing, triple A bro, thanks again my man.
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
Greetings from Azerbaijan Caleb, your videos are amazing!
Caleb, love this video. Do you do any video training on querying oracle? Such as sql using the "with" clause?
Thank you so much. It is so helpful.
This video would have been perfect if it hand included joins, triggers and stored procedures. Love the way you explain!
Wooow, really you're amazing
I love your explain ..
and your way of teaching.
I learned and enjoyed with you
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
Thx bro, I needed this
Thanks it really helped
When a guy in youtube is better at teaching stuff than whatever the heck your educational authorities have to offer
👀👀👀
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.
You're super cool Caleb. Thanks
This channel and content is awesome
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
thanks very much
Well said; "Old is gold".
Thank you teacher
Hi Caleb! Thanks for this. My coworker sent me your way
Thank you Tech Shaggy
Bro... You are hilarious! Great job man! 😊👍
Thanks! Take care
My Savior. Thanks a ton.
Your hand writing is awesome bro ;)
I must say...
I love your charisma 😂
hey i am a visionary learner and i like ur examples
Thank you sensei
let's admit it, his handwriting is so cool
This video is great
I just downloaded Oracle and it does not look anything like this :(
I would like to have options to have an automated translating option to English and other languages. Could you please enable this option.
You are a God bro
Hello Caleb. can you use this knowledge, as a skill to work remotely?
in the first 3mins only you have cleared my doubt about outer joins..
2:09:13
"QUIT" Caleb said calmy.
I wheezed so hard at that bro lmao.
26:20 while biting some apple kinda thing hahah such a cool teacher ❤
Love from India 🇮🇳
I got a question: for specific and general attributes, wouldn't they be data and metadata respectively? Together they would be the actual information.
If Shaggy was a teacher, lol. Love it! Thank you.
24:13 "Sorry. I'm eating an apple" LoL huahuahauha
11:17 made me brake laughing!! Great job bro, thank you!!
you are the best brooooooo, I only subscribe you for your jokes and the dogs,,:)
Yeah ok this is awesome.
We need you at UNM!
THIS GUY IS good
1:02:31 "Professors- They're people sometimes" xD
Could you please active the 'auto captions' , Thank you!
1:30:15 can we just take a moment to appreciate the absolute beast humour ❤️😂
Nope, that was just cringey.
Hi Caleb, what`s the best current version to download as per now. Mar 2021?
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 !!😁
My favorite part: 2:09:13
16:41 so basically generic attributes are objects, and specific attributes are instances?
It would be helpful to number the lines so we can know which line has the error
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;
50:38 made my day 😂
Good
Why is there no decent DB for Mac?
Please what level would you rate this complete tutorial on,
Basic, intermediary, pro etc....?
Basic
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
A blow up mattress?! Of all the things in the world haha! Brilliant
01:02:35 made me laugh.
- "Professors... they are people sometimes" ;D
24:11 - How to eat an apple.
Can I use Oracle live sql
Can you share the more labs videos.
It was the air mattresses for me 😭🙌🏼🤣...
how do did you learn please help me I've tried almost everything
Is this all the tutorial, or are there more videos coming?
can I use the latest Oracle db XE?\
Hi,
May I know how to solve when the result table showing duplicate amount?
Am i the only one that gets a headache when Caleb doesn't put a semicolon after the parenthesis?
Can you please refer any website where I can find more content for deep learning...
Udemy.com
Can we all talk about how funny and cute he is?
Your right mrs
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
The way he said ''Oracle Database" at 2:17:12 is why I like watching his videos
Love the barking dogs LoL
So in 3:00:06 i was able to delete the user why is that ? Oracle Developer , and the db is 21c
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 :)
I think this is your old video
şerefine teyyyipp
28:26 I accidentally checked "Oracle Usage Tracking" do you guys know how to disable it ?