Database Lesson #1 of 8 - Introduction to Databases

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.

[majicMix]

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.

[MontPyth]

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

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

[bradymigel]

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.

[thomasgould]

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

[danmuoki]

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

[manjildahal]

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.

[khalifamak]

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.

[glennashcroft]

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

[rahely]

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

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

[maim]

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

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

[pysco]

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!

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

[muhammadsalisabdulsalam]

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.

[njep]

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.

[triceptualtendencies]

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