Database Lesson #1 of 8 - Introduction to Databases
HTML-код
- Опубликовано: 25 июл 2024
- Dr. Soper gives an introductory lecture on database technologies. Topics covered include the reasons for using a database, the components of a database system, the elements of a database, the purpose of database management systems (DBMS), and the functions of a database application.
I love how this guy made this tutorial series 9 years ago and lots of colleges like WGU send their students like me here to learn about DBs. Thats how you know this is excellent.
Literally me right now taking C175 at WGU lol
@@thegeneral8323 I just started C175 a couple of weeks ago
@@thegeneral8323 How did you end up fairing on the OA? Did these help you?
@@dudor89 I passed a few days after posting this and yes, it helped tremendously.
he's my professor at csuf
This single video has covered most of what I have learned in 14 weeks of my 16 week college database class...
00:30 Course Objectives
01:40 What's the purpose of a database? Multiple: 1) Store data 2) Organizational structure 3) Mechanism for CRUD
04:30 Problems with storing data in lists: redundancy and multiple themes.
08:00 Modification issues arise in lists. "Update anomalies"
13:00 What is a relational database? Store data in a table composed of columns and rows. Columns represent attributes of an entity and each row represents an entity.
14:50 Each informational theme is stored in its own table. e.g. A project table and a customer table.
17:56 The Structured Query Language (SQL): the primary tool for performing CRUD operations.
20:25 SELECT statement allows us to combine tables together.
22:55 Four components of a DB system:
1) Users - people or other software programs
2) DB Applications - programs that rely on the DB (e.g. a website forum)
3) DBMS - controls and administrates the DB (e.g. MySQL, PostgreSQL, Oracle)
4) DB - the database itself where the raw data is stored
32:50 Types of Database Systems: - Personal DB system (e.g. Microsoft Access) - Enterprise level DB system (What we'll be focusing on)
youre not the hero we deserve but the hero we need
You are truly a web.
You sir, are a gentleman, and a scholar.
XD
What the fuck was I writing?
you are a life saving dude. Salute
I would sincerely like to thank you for your time, devotion regarding this videos. This video will be an excellent resource for all globally who want to study Database. Your teaching style is the best, materials are very clear. We owe you big. Thank you sir. God bless you.
much clearer than my own college professor haha thank you!
Dr. Soper:
I am currently working on my Bachelors in Cybersecurity. I am studying Data Management. This lecture was invaluable. You broke down hard to understand topics into easy to digest and learn pieces of information. Thank you
It is beautiful to find a human like yourself who really - with no fake praise- is a real human model for international knowldge sharing unit - as your lectures are great and their impact is definitely global. Thanks a lot and best wishes throughout as that is the only thing I could offer.
I am always grateful when I find videos like yours that are so full of knowledge and well explained as they are truly helpful when someone is trying to learn a new and foreign concept to them...thank you for making this playlist available to not only me but anyone that has access to it.
It 's 11 years down the line and I am finding this tutorial to be invaluable. Thanks, Dr. Soper, may God bless you abundantly.
same lol😊😊
@@christineadhiambo2896 wakenya jameni 😂. You taking databases 1
@@danmuoki2788 😅😅😅 happy that i find some one we are taking this course same time. wish you luck
Thank you Dr. Soper for a great introduction into modern day databases. It's been 25 years since I've delved into this aspect of the industrial world and I look forward to viewing the other videos.
The most simple, comprehensive explanation of database basics I have found. So refreshing. Thankyou.
Dr. Daniel Soper, Thank you for making these videos. This has made more sense in thirty minutes than the first three weeks of class.
I just failed my first objective assessment through WGU; looking for additional materials, I stumbled across your series. I absolutely love this first video, and if the others are anything like it, man... I just want to thank you. I like how you aren't just reading from a script and you are speaking like you know the material... that's because you do haha. Thank you so much.
Any luck passing it after watching this? I have read the book. Though I feel like it did not help much.
Il
H’
This is my exact situation lol.
yeah I like that I can take the classes as fast as I want but man that textbook is garbage.
I'm glad I found this before I take the test. I'll schedule it for when I'm done watching the series. 🤩👍
Thank you for uploading these lectures. You present the material in a thorough and intuitive manor. Much appreciated.
This is hands down the best tutorial I've found so far! It's maybe the one tutorial that actually takes the time to explain the reasoning behind databases and their structures instead of delving in in the middle and leaving you stranded. Also love how complex ideas are broken down by real world examples, makes it very easy to relate to. Thanks so much!!
owO
Getting my life together and have a passion for computers and helping .Currently using this to help me study to be SQL Certified ,thank you so much for this easy to follow series !!
Thank you very much ! Can't wait to see all your lesson. Accurate, informative and enlightening
I am contemplating a career in Database Administration and this course is exactly what I need to get acquainted with this world. Thank you so much!
The eight lessons are an outstanding example of rare didactic perfection, based on a deep knowledge and command of the subject and an extraordinary ability to focus on the most important aspects.
i start watching it with 0 level knowledge of database but after watching all videos i think am expert of DBMS. thank you v much dr Daniel. you are legend
Haha, far from it, it's not that easy.
I have an exam tomorrow and Database is the last UNIT. I cannot commend enough how helpful this video has been. in less than an hour I feel confident to face the exam.
Thank you!
Dr. Soper,
Let me thank you so much. English is a second language for me and I appreciate you taking time to speak clearly and articulate your words. It makes it so easy for me to follow up. Thank you for such a great learning material. Thumbs up and Hat off!
Merci beaucoup!
Thank you very much, Dr. Soper, for these lectures and for those in the Information Security. They are really very helpful. I hope more people will discover your RUclips presentations. And I hope you can also discuss other topics, like programming.
Very good explanation. Its clear and easy to understand . The lecturer had a nice pacing. Good job
The best tutorial I have seen on this topic. It is very clear and well-structured. Thank you.
Dr. Soper,
Thanks for providing such simple introductory lectures for beginners. Thanks for your time and efforts.
Thank you, very much Dr Daniel Soper. You're the best Lecturer I have ever come across. You're a SUPER-GENIUS.
This is the best database course I have seen. Thank you so much for your this!
Dr. Soper, there is no doubt you are a great lecturer. I wasted my time listening other videos and reading some books that all ended up confusing me even more and more. But now I'm happy because I have gone from 0-100. Thank you for allowing us benefit from your exceptional quality.
Thank you. You are doing us all a public service, sir.
Our world is a better place because of people like you.
I am just on lesson #1 and already liked your simple explanation and teaching.
Thank you for sharing your intellectual knowledge and time. Much thanks.
Thank you so much for this video and for making it free on RUclips,. I just started a python class anbd a database class at San Diego State University with a professor who speaks in 0.25 speed and I haven't been able to learn anything from him at all during the first week of classes. You are a life saver.
Great Database / WH video for beginners as well as for everyone. Excellent explanation with simple examples. Thank you Sir...!
This is such an excellent Introduction to databases. Thank you very much for putting this comprehensive presentation together.
An excellent introduction to database theory - clear and easy to follow. Thank you for posting.
I really love your videos!
thanks man!!
you're the best!
Thank you for sharing this knowledge Dr. Soper, greetings from Southamerica.
Just did the first lesson. Well presented!
Thank you, Dr Soper.
Thank you so much for this excellent lecture! I'm learning programming on my own and this has answered a lot of questions I had about data storage, structure and databases. Now I'll be able to use what the rest of the world is using instead of making my own systems ^_^
Simply, the best serie on databases.
thank you very much.
excellent content to understand the basics of DB ... thank you Dr.Spoer for sharing your knowledge ...
This has been one of the most amazing tutorials I have ever seen time flew by quickly and much information was gained thank you Dr Soper.
Thank you sir! You can`t even imagine how much this means to me being able to get this knowledge so easily. Thank you for your time! Your work very much appreciated!
is this still relevant if taking the C175 this year ?
Yes absolutely
Thanks for this! That was my first time with databases and you got me really interested, looking forward to watch more
Loved it. Very useful concepts, explained in a simple, visual manner. Thanks
I usually never make any comment, but this is such a great lesson! Thank you Dr. We need more and more courses teach by you. Thanks again!
best lecture series ive found thus far on the subject!
Great ,perfect explanation from 0 level to advance.The youtube tutorials should be like these.
Short, to the point, well done and interesting course. Thanks!
Such a good and clear lecture! Thank you very much, this is very helpful!!!
I am adding your link to my schools chat board for Data Management Foundations. The quality of your work really just puts my class resources to complete embarrassing shame. UGG I have Network Security Foundations and Information Systems. If only I had you for those classes:). Fantastic teaching. I will be a forever subscriber! Thank you so much!
I have this Course coming up for my IT cert at Penn Foster so to get a good glimpse of what my course would look like is awesome. Its so simple a baby could catch on! Thanks
It's a wonderful and well explained DATABASE tutorial, it's easy to understand and has been perfectly presented, it has really helped me in the study of database, thank you, and keep up the good work.
I am very interested in learning database, but I had no idea!!! Watching this video I learned and I really want to move to the next one! Great lecture!!
This sure beats paying for college courses. Free education.
Im in college and my professor gave us this video to learn LOL. Guess Im paying hahahah
@@fahimzahir9587 wow am speechless
@@IkKorp yeah they legit share links to the RUclips videos you can watch for freeeeeeeeee
you pay for the access on the internet tho, unless it's free wifi.
@@kristhomas8295 The thing about college though: you get 'proof' that you learned it. And a network to help open doors.
This is awesome. Thanks for posting these lectures Dr. Soper!
This guy is good. i have learned more in 2 videos than my lecturer was able to teach me in 12 weeks. very good at explaining things.
What are you up to now? How is it going??
I wish RUclips had recommended me this as you published this series.
Thanks a million.
Waiting for your series for Postgre SQL.
Your language, presentation skills, topics selected, sequence of topics and other endless things in this are AWESOME.
Amazing lecture. The way you explained it just mind-blowing.
Amazing :) thank you
looking forward to watch the other lectures.
Thank you so much! I've tried to read the books about 10 times, but still didn't understand it. But now I do!
needed this to understand what was actually written in my book cuz the way he transfers information to you is so organized that you get it in a flash
Hi Friend, and thanks so much for sharing! For some needs... I just enter to the world of DB ! ... I certainly continue to chapter 2!
Keep up the great quality audio and video content. Well done!
Dr. Soper, this was a terrific lecture. Many thanks.
Thank you Dr. Daniel Soper,this course is awesome
That's perfect, great job Daniel.
Thanks a million.
No Name. Lol
thank you, this is so helpful. i look forward to the next tutorial. so easy to understand
Great video! Really helping me with a new position I picked up.. thank you!
THANK YOU THANK YOU THANK YOU. You golden. I feel like I hit the jackpot by watching this video. Be blessed.
Wow this is amazing! A lot clearer then what my professor teaches us. Thanks :)
Excellent lecture, Dr. Soper. Many thanks!
it's really easy to understand. what a great teacher. a 38 minutes video felt like 10 minutes video
Thank you for providing us with such a clear and concise explanation about databases.
Thanks for providing such a wonderful lecture ..!! you are Awesome ..!!
Thanks for all efforts that you made to let us succeed in this course
well well,, This is wonderful explanation I ever watch. thank alot
Very very well explained. I think anyone could learn this stuff from this video. Thank you.
Doc... this was PERFECT !
I hope you will expand your ability to teach, in other directions (like teaching to deal with Visual Studio applications).
Thanks.
Have a perfect 2015.
my Database professor should listen to your lecture!!!!His class is terrible!! THANK YOU FOR MAKING EVERYTHING CLEAR
I went through so many videos about sql on RUclips and didn't realize that this one could be the best choice to start with. After seeing the first video, I would suggest everyone to go for it.
It's clear and easy to understand. Thanks. I will listen to all your database videos.
Thanks! I'm working on a pet project and you could say I'm in a bit over my head. This helped me find some much needed footing.
Many thanks Dr. Soper. Great videos, nice job.
Thank you sir you have explain me well, i will never forget.
You were born to teach. Well done !!
Superb presentation skill, clear pronunciation and very easy to follow. Subject is well organized and fundamental principles are clearly explained. Thank you so much for your effort and I am quite inspired by your presentation skill.
I can honestly say this is the best video i've seen online so far keep up the good work.
great video...
is the presentation slide available for download ?
finally found it. I saw it various years ago but didn't complete it. Now, I shall. Thanks Doc.
This video was very helpful. Your amazing at explaining! Thank you so much. Please continue to make Great videos such as this!.
Thanks so much for the Lecture Dr. Daniel. I really gained a lot
Great Video that explains what can be a very difficult concept to grasp.
Bravo! Nicely done.
I was assigned this video as apart of my of my Database Fundamentals class!
SAMEEE
I have some db experience but am here to get deeper for a WGU class - wholy cow you are good. I hope you're a full time teacher.
thank you dr soper this lesson is greate
such a great lecture!! the examples really help!
respect from TW, better than my colleage instructor, i think my colleage instructor should learn teaching skill from you lol
Well said. Clear and to the point. Perfectly pitched and well explained🎉🎉🎉🎉