Database Lesson #1 of 8 - Introduction to Databases
Вставка
- Опубліковано 17 тра 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
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
This single video has covered most of what I have learned in 14 weeks of my 16 week college database class...
much clearer than my own college professor haha thank you!
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.
Dr. Daniel Soper, Thank you for making these videos. This has made more sense in thirty minutes than the first three weeks of class.
Thank you for uploading these lectures. You present the material in a thorough and intuitive manor. Much appreciated.
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
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 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.
Thank you very much ! Can't wait to see all your lesson. Accurate, informative and enlightening
Thank you. You are doing us all a public service, sir.
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. 🤩👍
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.
The most simple, comprehensive explanation of database basics I have found. So refreshing. Thankyou.
Dr. Soper,
Thanks for providing such simple introductory lectures for beginners. Thanks for your time and efforts.
Thank you for sharing this knowledge Dr. Soper, greetings from Southamerica.
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!
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 Dr Daniel Soper. You're the best Lecturer I have ever come across. You're a SUPER-GENIUS.
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.
Very good explanation. Its clear and easy to understand . The lecturer had a nice pacing. Good job
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.
This is the best database course I have seen. Thank you so much for your this!
Just did the first lesson. Well presented!
Thank you, Dr Soper.
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 UA-cam presentations. And I hope you can also discuss other topics, like programming.
The best tutorial I have seen on this topic. It is very clear and well-structured. Thank you.
An excellent introduction to database theory - clear and easy to follow. Thank you for posting.
Great Database / WH video for beginners as well as for everyone. Excellent explanation with simple examples. Thank you Sir...!
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 is such an excellent Introduction to databases. Thank you very much for putting this comprehensive presentation together.
I really love your videos!
thanks man!!
you're the best!
Short, to the point, well done and interesting course. Thanks!
Great ,perfect explanation from 0 level to advance.The youtube tutorials should be like these.
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 so much for this video and for making it free on UA-cam,. 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.
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
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!
best lecture series ive found thus far on the subject!
Amazing :) thank you
looking forward to watch the other lectures.
Loved it. Very useful concepts, explained in a simple, visual manner. Thanks
Thank you Dr. Daniel Soper,this course is awesome
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!
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 ^_^
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.
This is awesome. Thanks for posting these lectures Dr. Soper!
Dr. Soper, this was a terrific lecture. Many thanks.
Excellent lecture, Dr. Soper. Many thanks!
Great video! Really helping me with a new position I picked up.. thank you!
Many thanks Dr. Soper. Great videos, nice job.
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
Such a good and clear lecture! Thank you very much, this is very helpful!!!
Keep up the great quality audio and video content. Well done!
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.
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!
thank you, this is so helpful. i look forward to the next tutorial. so easy to understand
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!
That's perfect, great job Daniel.
Thanks a million.
No Name. Lol
You were born to teach. Well done !!
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
Amazing lecture. The way you explained it just mind-blowing.
Very very well explained. I think anyone could learn this stuff from this video. Thank you.
Thank you for this video. Your videos are very informative and easy to understand. Please keep posting!
Bravo! Nicely done.
thank you dr soper this lesson is greate
Wow this is amazing! A lot clearer then what my professor teaches us. Thanks :)
It's clear and easy to understand. Thanks. I will listen to all your database videos.
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!!
Very well designed & clearly described.
Thank You
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
Thank you so much! I've tried to read the books about 10 times, but still didn't understand it. But now I do!
finally found it. I saw it various years ago but didn't complete it. Now, I shall. Thanks Doc.
Thanks for all efforts that you made to let us succeed in this course
THANK YOU THANK YOU THANK YOU. You golden. I feel like I hit the jackpot by watching this video. Be blessed.
Great pace and detail, thank you
just thank you DR.Daniel for explanation
Great tutorial
Thanks Dr. Daniel Soper
Thanks for making my first step to DB so interesting.........
Thanks so much for the Lecture Dr. Daniel. I really gained a lot
it's really easy to understand. what a great teacher. a 38 minutes video felt like 10 minutes video
This video is pure gold.
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.
Thank you sir you have explain me well, i will never forget.
well well,, This is wonderful explanation I ever watch. thank alot
Thanks for this! That was my first time with databases and you got me really interested, looking forward to watch more
This's amazing Dr Soper
Thank you very much for your helpful and easy-to-understand lecture!
Thank you for providing us with such a clear and concise explanation about databases.
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.
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!
Thank you so much, Dr., for this valuable knowledge for free.
Thanks for providing such a wonderful lecture ..!! you are Awesome ..!!
awesome, thank for taking time to do this.
This was excellent! Thank you!
Well said. Clear and to the point. Perfectly pitched and well explained🎉🎉🎉🎉
clarity on top.. thank you,,
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??
Thank you for sharing your knowledge, very clear and helped me have a better understanding of database systems!
Great Lesson. Thank you!