Database Lesson #1 of 8 - Introduction to Databases

[@MontPyth]

This single video has covered most of what I have learned in 14 weeks of my 16 week college database class...

[@majicMix911]

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.

[@thegeneral8323]

Literally me right now taking C175 at WGU lol

[@RaspberryBerrey]

@@thegeneral8323 I just started C175 a couple of weeks ago

[@dudor89]

@@thegeneral8323 How did you end up fairing on the OA? Did these help you?

[@thegeneral8323]

@@dudor89 I passed a few days after posting this and yes, it helped tremendously.

[@edgarmarquez1823]

he's my professor at csuf

[@AlexandriaRohn]

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)

[@idontwanttoputanamehere1201]

youre not the hero we deserve but the hero we need

[@dilungmoveityafool777]

You are truly a web.

[@jimmiles33]

You sir, are a gentleman, and a scholar.

[@dilungmoveityafool777]

XD What the fuck was I writing?

[@rickyzmkuo]

you are a life saving dude. Salute

[@thomasgould3461]

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

[@khalifamak123]

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.

[@danmuoki2788]

It 's 11 years down the line and I am finding this tutorial to be invaluable. Thanks, Dr. Soper, may God bless you abundantly.

[@christineadhiambo2896]

same lol😊😊

[@danmuoki2788]

@@christineadhiambo2896 wakenya jameni 😂. You taking databases 1

[@christineadhiambo2896]

@@danmuoki2788 😅😅😅 happy that i find some one we are taking this course same time. wish you luck

[@DandelionHope]

Same from india

[@glennashcroft7950]

The most simple, comprehensive explanation of database basics I have found. So refreshing. Thankyou.

[@salmikhan]

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

[@dilungmoveityafool777]

Haha, far from it, it's not that easy.

[@PaulMaddux]

Dr. Daniel Soper, Thank you for making these videos. This has made more sense in thirty minutes than the first three weeks of class.

[@Henry_Bwalya]

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!

[@maim8002]

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!!

[@jayant9151]

owO

[@Escko]

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.

[@pysco11]

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!

[@muhammadsalisabdulsalam4016]

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.

[@manjildahal6742]

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.

[@captainkeyboard1007]

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 KZbin.

[@triceptualtendencies3330]

Thank you so much for this video and for making it free on KZbin,. 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.

[@n5jep1]

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.

[@Ragniirox]

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!

[@umbertosteindler9933]

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.

[@rahely513]

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 !!

[@yikumnycyikum9652]

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.

[@albanianspider981]

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

[@gembrian1983]

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.

[@aronfejes]

What are you up to now? How is it going??

[@jimc1499]

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.

[@bradymigel2385]

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.

[@Ghostboy401]

Any luck passing it after watching this? I have read the book. Though I feel like it did not help much.

[@lauramiramont3647]

Il H’

[@ShaneEnochs]

This is my exact situation lol.

[@ZorothTheAwesome]

yeah I like that I can take the classes as fast as I want but man that textbook is garbage.

[@serenaclairetalks]

I'm glad I found this before I take the test. I'll schedule it for when I'm done watching the series. 🤩👍

[@uark]

Dr. Soper, Thanks for providing such simple introductory lectures for beginners. Thanks for your time and efforts.

[@kishataylor6963]

You were born to teach. Well done !!

[@nevenasterikova3335]

THANK YOU THANK YOU THANK YOU. You golden. I feel like I hit the jackpot by watching this video. Be blessed.

[@auroratan2126]

much clearer than my own college professor haha thank you!

[@patientson]

Thank you, very much Dr Daniel Soper. You're the best Lecturer I have ever come across. You're a SUPER-GENIUS.

[@lucaszapico926]

Thank you for uploading these lectures. You present the material in a thorough and intuitive manor. Much appreciated.

[@Shorelinewalk]

This is such an excellent Introduction to databases. Thank you very much for putting this comprehensive presentation together.

[@kanchapagimhara584]

Great ,perfect explanation from 0 level to advance.The youtube tutorials should be like these.

[@TheUntergangMan]

Thank you. You are doing us all a public service, sir.

[@JaMonChayTa]

I went through so many videos about sql on KZbin 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.

[@careem3463]

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!

[@rahventures166]

is this still relevant if taking the C175 this year ?

[@aronfejes]

Yes absolutely

[@Anishk1]

Great Database / WH video for beginners as well as for everyone. Excellent explanation with simple examples. Thank you Sir...!

[@manueldiera6781]

This is the best database course I have seen. Thank you so much for your this!

[@maomaojin8103]

my Database professor should listen to your lecture!!!!His class is terrible!! THANK YOU FOR MAKING EVERYTHING CLEAR

[@blackpope1725]

best lecture series ive found thus far on the subject!

[@tenikapowell2282]

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

[@andreas6508]

it's really easy to understand. what a great teacher. a 38 minutes video felt like 10 minutes video

[@tuanquynet]

It's clear and easy to understand. Thanks. I will listen to all your database videos.

[@twinniwt4460]

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!!

[@danielles.3509]

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!

[@MattRhodes_Music]

Using these videos as the content in my course is sadly lacking. Very well done, I thank you!

[@video1967]

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.

[@michaeloshin8025]

I can honestly say this is the best video i've seen online so far keep up the good work.

[@learningreflux7387]

Very good explanation. Its clear and easy to understand . The lecturer had a nice pacing. Good job

[@MarkOhlson]

This sure beats paying for college courses. Free education.

[@fahimzahir9587]

Im in college and my professor gave us this video to learn LOL. Guess Im paying hahahah

[@IkKorp]

@@fahimzahir9587 wow am speechless

[@kristhomas8295]

@@IkKorp yeah they legit share links to the KZbin videos you can watch for freeeeeeeeee

[@ORION-ir5dx]

you pay for the access on the internet tho, unless it's free wifi.

[@optimalwebdesign]

@@kristhomas8295 The thing about college though: you get 'proof' that you learned it. And a network to help open doors.

[@benayadsaid5167]

Thanks for all efforts that you made to let us succeed in this course

[@deborah393]

Dr. Soper, this was a terrific lecture. Many thanks.

[@emiljanogjiriti2030]

The best tutorial I have seen on this topic. It is very clear and well-structured. Thank you.

[@MrAzeemulhaq]

finally found it. I saw it various years ago but didn't complete it. Now, I shall. Thanks Doc.

[@rekhadrdr42]

excellent content to understand the basics of DB ... thank you Dr.Spoer for sharing your knowledge ...

[@tafadiop74]

Excellent lecture, Dr. Soper. Many thanks!

[@devspirit1]

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 KZbin presentations. And I hope you can also discuss other topics, like programming.

[@nattyphysicist]

Very very well explained. I think anyone could learn this stuff from this video. Thank you.

[@SphereofTime]

26:00 Metadata; Deescribe a structure of data

[@kwizeraheritier1225]

just thank you DR.Daniel for explanation

[@svnspell6709]

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

[@TonyTigerTonyTiger]

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).

[@harkathwal7668]

Thank you for this video. Your videos are very informative and easy to understand. Please keep posting!

[@samirazalmad2748]

Thank you Dr. Daniel Soper,this course is awesome

[@morganoliveira2659]

This video is pure gold.

[@pankajparida6145]

Great tutorial Thanks Dr. Daniel Soper

[@mduduzimahlobo9364]

Well said. Clear and to the point. Perfectly pitched and well explained🎉🎉🎉🎉

[@MarinaMarina-v3k]

fantastic explain Dr.Daniel .. thank you very much

[@mariaceciliamedinagutierre567]

Thank you for sharing this knowledge Dr. Soper, greetings from Southamerica.

[@midnight161]

This is awesome. Thanks for posting these lectures Dr. Soper!

[@aliceha6029]

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!

[@FadyEilia]

Thanks for all your hard work - Are the slides available somehwere?

[@tobiassewe5322]

This's amazing Dr Soper

[@lokmanz913]

great video... is the presentation slide available for download ?

[@scienceklinic4584]

Thank you so much, Dr., for this valuable knowledge for free.

[@jean-philippeandre9177]

Thank you very much ! Can't wait to see all your lesson. Accurate, informative and enlightening

[@tkar66]

Simply, the best serie on databases. thank you very much.

[@gguazzelli]

Many thanks Dr. Soper. Great videos, nice job.

[@sarinamathis5106]

I was assigned this video as apart of my of my Database Fundamentals class!

[@ananyathyagarajan8172]

SAMEEE

[@special-a6536]

Thank you for providing us with such a clear and concise explanation about databases.

[@lovejoyslara8319]

Great Lesson. Thank you!

[@Entertaiment123]

Thanks for making my first step to DB so interesting.........

[@thegadfly4835]

An excellent introduction to database theory - clear and easy to follow. Thank you for posting.

[@KedraIrke]

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 ^_^

[@morningcommuneshow7057]

Thank you for sharing your knowledge, very clear and helped me have a better understanding of database systems!

[@kachro1302]

Just did the first lesson. Well presented! Thank you, Dr Soper.

[@babarw2006]

Loved it. Very useful concepts, explained in a simple, visual manner. Thanks

[@osun7788]

No wonder the number of views is huge. Every KZbin teacher should learn from you. Henceforth, I will take all my KZbin lectures from you,except for the courses you did not cover

[@kevinreid2890]

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!

[@linaresojedacarloselias7379]

i watched and understood it. Great video.

[@clemenceguillou9736]

Wow this is amazing! A lot clearer then what my professor teaches us. Thanks :)

[@PhamQuocViet]

Thank you very much for your helpful and easy-to-understand lecture!

[@JayantBB78]

I wish KZbin 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.

[@bobbymw9722]

Very well designed & clearly described. Thank You

[@albertj.6807]

Short, to the point, well done and interesting course. Thanks!

[@stephaniemazaka4286]

You are the best in database

[@pallawirajendra]

A simple, easy lecture to start !

[@naboo06]

Great lecture, I have a much better understanding of databases.

[@terryphillips6910]

You are the best Dr. Soper. I will be taking a data analyst class in a couple of weeks. After watching your classes I should hit the floor running. How about a video on Linux?