Database Lesson #3 of 8 - The Structured Query Language (SQL)

Dr. Soper gives a lecture on using the structured query language (SQL) to work with databases. Topics include CREATE, ALTER, and DROP statements, SELECT, INSERT INTO, UPDATE, and DELETE FROM statements, subqueries, and inner and outer joins.

[DaveBabler]

SELECT 'Lesson #3 of 8''
FROM 'Database Lesson'
WHERE 'Dr. Soper is awesome and these database videos have been extremely helpful' = TRUE
;

[mekabay]

I didn't see the helpful list of timings vs topics, so here's one I created -- with many thanks to Prof Soper! I'm providing links to his excellent lectures to my students in the CS240 Database course at Norwich University as a supplement to our in-class work. And BTW, I've been teaching database theory and practice since 1981! Dr Soper's clarity and detailed explanations are THE BEST!!

Notes by M. E. Kabay, PhD, CISSP-ISSMP

0:00:12 Topic Objectives
0:00:41 CRUD defined
0:01:07 Structured Query Language
0:03:28 Applications of SQL
0:05:47 SQL for Data Definition
0:06:44 CREATE
0:19:01 ALTER
0:24:08 UPDATE
0:26:54 DELETE
0:28:44 SELECT
0:42:22 BETWEEN
0:43:56 LIKE
0:46:51 ORDER
0:50:29 COUNT / MIN / MAX
0:50:59 SUM / AVG / STDEV
0:53:05 GROUP BY
0:54:48 GROUP BY with HAVING
0:56:29 Subqueries
0:57:57 Noncorrelated subquery
1:00:24 Correlated subquery
1:03:09 Joins
1:03:35 Typology of DB joins
1:05:48 INNER JOIN...ON
1:07:33 LEFT OUTER JOIN
1:11:50 FULL OUTER JOIN
1:12:25 DROP
1:13:49 ALTER & DROP
1:14:43 CHECK
1:16:01 VIEW

[skillspanda]

No words are enough to appreciate your excellent teaching!!! Thanks a ton.

[Bille]

You are not getting enough views for the quality of the videos you make. Really good job man, thanks a lot!

[chantegainey]

These are by far the best training videos i have come across period. The illustrations help out tremendously to tie  everything together. I took a practice test a couple of weeks ago and got a 40%. Just getting through your first 2 training videos and half of #3 i was able to score an 80%. I am really grateful!

[markweeks]

Dr. Soper, I have just found this series of tutorials and I am so pleased with them, so far. It is refreshing to hear things explained clearly using correct and accurate language that I don't have to mentally correct before I can understand. The pace is slow enough for me to ingest and understand the material and it makes perfect sense the way to describe everything. I am learning more from the series than I have from any instruction in a long time. Thank you SO much!

[isaacagyeman]

Dr. Soper, your tutorials clearly deserve tens of thousands of views. You display such enormous knowledge and clarity in your teaching. In fact, you're a world class tutor. No doubt.

[bop]

Super duper thankful for you and all your time and effort you pour into these. Your a lifesaver. I finally understand complex topics of database!! <3
THANK YOUUU SOOOO MUCH!!!

[kingsleyakhimien]

Fantastic video lesson. Thumbs up Dr. Soper...you are an excellent tutor. Highly recommended!

[aquilesmarcano]

This is what I call a real lecture! Well Done!

[jimc]

Thank you Dr. Soper still reviewing your course. Very deliberate material.

[karnabudhathoki]

Thank you Dr Soper for the lessons. They are very informative and crystal I am just trying to learn Database on my own, and I hope these lessons give me a good

[DeniseCovingtonJustAsIam]

By far the best intro I have heard. Is better then my prof who taught me 10 years go.

[brightforeigner]

This is so awesome! Thank you, Dr. Soper. Your lessons are so clear, and easy to understand- broken up into digestible units.

[lijessica]

Thank you so much, Dr. Soper, it is so informative. You are the best instructor.

[pordos]

Thank you for your work. I have been trying to understand how to create a database and have seen many different turtorials. This is by far the best study material.Very easy to understand and it provides the basic foundation for creating any database system. You are the best:)!
.

[iliasvlachos]

AGREE 256% with Dave Babler

SELECT 'Lesson #3 of 8''
FROM 'Database Lesson'
WHERE 'Dr. Soper is awesome and these database videos have been extremely helpful' = TRUE

[firefoxx]

Prof. Dr. Soper, Thank you very much for your time and effort in making these Excellent tutorials . Highly appreciated.

[abduihamidwaasi]

This is what I have been looking for in my entire preparatory career into web development. Thank you so much, Dr.

[JL-qfhq]

This database series is superb. Very good examples that I can easily relate to in a business function.