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)
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.
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.
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!!
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.
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.
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.
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!
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 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.
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
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.
Using a relational database program is my favorite computer application. That is why I prefer Microsoft Access [2021]. However, as an avid typist, Microsoft Word is my first program and springboard. This is the most comprehensive show about databases that I have ever watched on TH-cam.
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 video and for making it free on TH-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.
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.
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 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!
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
I wish TH-cam 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.
That was not only exhilarating , but, thought - provoking, and inspiring,straight to the point. The video's where long but, clear spoken,and at a very moderate pace. I only watch three, but they were well worth it. Thank's!
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 TH-cam presentations. And I hope you can also discuss other topics, like programming.
I went through so many videos about sql on TH-cam 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.
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!!
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!
Gosh i always have trouble understanding things when i start them idk why my brain acts this way and this was so easy to understand for me as a person who knows nothing about these concepts.simple and non distracting and i finally understand !thanks:D
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 ^_^
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.
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.
Excellent lecture. However, future episodes should include mention of Postgresql. Unlike MySQL, Postgres is completely free in all situations, even for commercial bundled use. Additionally, Postgresql is much closer in feature set to the expensive commercial solutions such as Oracle or SQLServer. None of this is to say that MySQL is bad, but rather that Postgres should be mentioned as it's quite often an excellent choice for your target audience (users in smaller environments).
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 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
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.
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
The most simple, comprehensive explanation of database basics I have found. So refreshing. Thankyou.
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.
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 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
Same from india
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. 🤩👍
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!
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 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.
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 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!
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.
Using a relational database program is my favorite computer application. That is why I prefer Microsoft Access [2021]. However, as an avid typist, Microsoft Word is my first program and springboard. This is the most comprehensive show about databases that I have ever watched on TH-cam.
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 video and for making it free on TH-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.
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.
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, very much Dr Daniel Soper. You're the best Lecturer I have ever come across. You're a SUPER-GENIUS.
Thank you for uploading these lectures. You present the material in a thorough and intuitive manor. Much appreciated.
Dr. Soper,
Thanks for providing such simple introductory lectures for beginners. Thanks for your time and efforts.
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 such an excellent Introduction to databases. Thank you very much for putting this comprehensive presentation together.
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
Thank you. You are doing us all a public service, sir.
much clearer than my own college professor haha thank you!
Great Database / WH video for beginners as well as for everyone. Excellent explanation with simple examples. Thank you Sir...!
THANK YOU THANK YOU THANK YOU. You golden. I feel like I hit the jackpot by watching this video. Be blessed.
Great ,perfect explanation from 0 level to advance.The youtube tutorials should be like these.
This is the best database course I have seen. Thank you so much for your this!
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??
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
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
I wish TH-cam 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.
That was not only exhilarating , but, thought - provoking, and inspiring,straight to the point. The video's where long but, clear spoken,and at a very moderate pace. I only watch three, but they were well worth it. Thank's!
You were born to teach. Well done !!
I can honestly say this is the best video i've seen online so far keep up the good work.
The best tutorial I have seen on this topic. It is very clear and well-structured. Thank you.
it's really easy to understand. what a great teacher. a 38 minutes video felt like 10 minutes video
finally found it. I saw it various years ago but didn't complete it. Now, I shall. Thanks Doc.
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 TH-cam presentations. And I hope you can also discuss other topics, like programming.
best lecture series ive found thus far on the subject!
Thank you very much ! Can't wait to see all your lesson. Accurate, informative and enlightening
I went through so many videos about sql on TH-cam 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.
my Database professor should listen to your lecture!!!!His class is terrible!! THANK YOU FOR MAKING EVERYTHING CLEAR
Very very well explained. I think anyone could learn this stuff from this video. Thank you.
excellent content to understand the basics of DB ... thank you Dr.Spoer for sharing your knowledge ...
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!!
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!
Dr. Soper, this was a terrific lecture. Many thanks.
Very good explanation. Its clear and easy to understand . The lecturer had a nice pacing. Good job
Using these videos as the content in my course is sadly lacking. Very well done, I thank you!
It's clear and easy to understand. Thanks. I will listen to all your database videos.
Gosh i always have trouble understanding things when i start them idk why my brain acts this way and this was so easy to understand for me as a person who knows nothing about these concepts.simple and non distracting and i finally understand !thanks:D
Excellent lecture, Dr. Soper. Many thanks!
An excellent introduction to database theory - clear and easy to follow. Thank you for posting.
Thank you for providing us with such a clear and concise explanation about databases.
This is awesome. Thanks for posting these lectures Dr. Soper!
Thank you for sharing this knowledge Dr. Soper, greetings from Southamerica.
just thank you DR.Daniel for explanation
Thanks for all efforts that you made to let us succeed in this course
Thank you Dr. Daniel Soper,this course is awesome
Simply, the best serie on databases.
thank you very much.
I was assigned this video as apart of my of my Database Fundamentals class!
SAMEEE
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!
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 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 TH-cam 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 video is pure gold.
26:00 Metadata; Deescribe a structure of data
Just did the first lesson. Well presented!
Thank you, Dr Soper.
Thank you so much, Dr., for this valuable knowledge for free.
Curious why, at @21:00, you used the old way of doing joins (using the WHERE clause) instead of the newer way (using a JOIN clause).
Wow this is amazing! A lot clearer then what my professor teaches us. Thanks :)
Many thanks Dr. Soper. Great videos, nice job.
Great tutorial
Thanks Dr. Daniel Soper
Short, to the point, well done and interesting course. Thanks!
Thank you for this video. Your videos are very informative and easy to understand. Please keep posting!
Amazing lecture. The way you explained it just mind-blowing.
Thank you for sharing your knowledge, very clear and helped me have a better understanding of database systems!
This's amazing Dr Soper
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.
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.
Well said. Clear and to the point. Perfectly pitched and well explained🎉🎉🎉🎉
fantastic explain Dr.Daniel .. thank you very much
Thank you very much for your helpful and easy-to-understand lecture!
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.
A simple, easy lecture to start !
Thanks for making my first step to DB so interesting.........
Very well designed & clearly described.
Thank You
Excellent lecture. However, future episodes should include mention of Postgresql. Unlike MySQL, Postgres is completely free in all situations, even for commercial bundled use. Additionally, Postgresql is much closer in feature set to the expensive commercial solutions such as Oracle or SQLServer. None of this is to say that MySQL is bad, but rather that Postgres should be mentioned as it's quite often an excellent choice for your target audience (users in smaller environments).
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!
Thanks so much for the Lecture Dr. Daniel. I really gained a lot
Great video! Really helping me with a new position I picked up.. thank you!