Database Lesson #3 of 8 - The Structured Query Language (SQL)
Вставка
- Опубліковано 29 тра 2013
- 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.
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
THANK YOU SO MUCH Michael, you don't know how tremendously this list helps!
SELECT 'Lesson #3 of 8''
FROM 'Database Lesson'
WHERE 'Dr. Soper is awesome and these database videos have been extremely helpful' = TRUE
;
putting names from the big bang theory was the awesomest xD
Great comment 👏
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!!
No words are enough to appreciate your excellent teaching!!! Thanks a ton.
You are not getting enough views for the quality of the videos you make. Really good job man, thanks a lot!
He is now getting
Not many people used database management
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!
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!
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.
Thank you Dr. Soper still reviewing your course. Very deliberate material.
This is what I call a real lecture! Well Done!
By far the best intro I have heard. Is better then my prof who taught me 10 years go.
Fantastic video lesson. Thumbs up Dr. Soper...you are an excellent tutor. Highly recommended!
This is so awesome! Thank you, Dr. Soper. Your lessons are so clear, and easy to understand- broken up into digestible units.
Thank you Dr Soper for the lessons. They are very informative and crystal clear.......... I am just trying to learn Database on my own, and I hope these lessons give me a good understanding.....
Thank you so much, Dr. Soper, it is so informative. You are the best instructor.
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:)!
.
This is what I have been looking for in my entire preparatory career into web development. Thank you so much, Dr.
loved the pace of delivery and the quality of content. really helpful!!! Thank you so much! I finally understood those right/left/full joins. believe in impossible!
I love this series! So straight and clear. I could say, It must acquire a lot of effects! THX, sincerely.
Thank you Daniel. This series has been superb thus far!
Prof. Dr. Soper, Thank you very much for your time and effort in making these Excellent tutorials . Highly appreciated.
I have learned so much about SQL and DBMS in his videos, and I am about to start the fourth video in this series. Great instructional videos . Thank you!
I enjoyed the hidden gems of tv show references. :)
Thank you so much, Dr. Soper, for giving a very clear instruction of this subject. All lessons are helping me tremendously!
Wow, this is an outstanding lecture!
This database series is superb. Very good examples that I can easily relate to in a business function.
this is a fantastic tutorial, very high quality, much appreciated!
Watch these videos at 2x video speed
Great tutorial. Learned more here than from instructor!
Hi doc this is my 3rd lesson wow your so ezy to understand and you really explain things in simple terms thank you ..wish i had teachers like you back in my school days
Just as all other tutorials on DB by Dr Soper, this too surpasses all similar tutorials by others I've come across.
BEST SQL LECTURE EVERRRRR
Really high quality lessons, thank you so much Dr.
this is the best thing i seen on youtube so far
Dr Soper , thank you very much for such a great tutorial , you explained perfectly in details and examples , very great well structured slides , and you used every seconds efficiently ! These are not only true for this section it is also true for all of the rest 7 tutorials . I have final exam in database ahead which these series are perfect to help me ! You also have a comforting, nice and clear voice 😉
Thank you, I have a midterm tomorrow on databases and I'm at work so I can't study. I've been listening to ALL of these database videos while I work. They've been very helpful
Wonderful explanation. Thanks, Daniel Soper.
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
Really amazing set of lectures. Thanks so much!
Thank you very much Dr Daniel Soper!
I really enjoy your class, easy, clear, fun.👍It's powerful, helpful!
+Julie Jiang nothing fun my stupid girl
you are a life saver DR.Soper
Thank you so much! This is more well-organized than our lecture
Excellent lesson Dr Soper. Thank you for you help.
Very helpful. You make complex things easy to understand. Thanks a lot.
Thanks for sharing this video, this is great for learning!
your way of explaining is really awesome, thanks for the video. looking forward for more videos on java as well
I learned a lot from these videos , thank you.
Thank you, Dan! Also, I enjoyed the reference and chuckled at your Skills self-assessment :)
this is the best video and training for any student who have no idea about SQL...!!!!
I bet there is no better crash course video than this that too in such a small time period.. now i need not look at the book also😍😍😍 thank u soo mch❤😊😊😊😊
Awesome job Dr. Soper
cleanly and clearly explained !!!
THANK YOU SO MUCH FOR THIS VIDEO BECAUSE MY PROFESSOR IS TRASH...DOESNT EVEN TEACH IT THROUGH THE ACTUAL SOFTWARE OR THE ACTUAL CODES
HE JUST LECTURES AND ASSUMES WE KNOW HOW TO DO THIS.
Same here
You are doing way better job in explaining than my teacher!
Excellent information!! Thank you!!
very helpfull series so far, thanx!
Am really enjoying the Database Lesson
wow great teacher thanks for the video . you really can explain things clearly
Thank you! Awesome videos!
Thank you very much for posting these videos..
It is really intersting video. Thank you providing such interesting topics.
you are just awesome! thanks for the video
One of my classes that I am taking is similar to what you are teaching it is called Hands on Database. This video is helping me to understand more of the concepts. thank you
You are the best thank you for making supper clear and helpful videos
A wonderful tutorial!
Excellent lecture!
Very Helpful video..., Thank you so much... Hat off for you, Sir...
hi you are too much, God bless u I learn a lot from u. more of these sir.
excellent tutorials about database.
Thank you very much for sharing this video.👍
Thanks Dr. Soper, it was very interesting.do you have text notes for the lesson.I am also interested if you are teaching online full course on SQL and oracle database 11g fundamental I and II. free or paid.
Thank you for sharing this video.
Very nice Tutorial!
Watch this series at 2x speed. As a person on the spectrum, this helps processing the speech patterns.
Thanks...Dr...I learned....a lot.....
too good! thanks so much!
just excellent.
Thank you Sir for your incredible natural.
awesome excellence thank you
Thank you so much great learning
wow ..simply wow.
Dr you too good, wish you run an online school. just cant wait to join
very good database tutorial
meets the expectations of learners :)
Thanks! I am getting more info in your videos than I am in my school book. Also like the Big Bang subliminal messaging!
I am so pleased to learn from Dr. Sopers lesson. From lesson 3, I feel that I need to do some exercises. Is there any proposition for exercises?
Excellent
Very helpful :)
Love this series so far. On other videos I have seen people add say PK or FK without actually typing constraint. Is it required?
i just wanna tell u Dr: daniel you funtastic and than u so much for prepared this great lucture
==============================
**INITIAL INTRO TO SQL, TABLES, KEYS AND REFERENCING OTHER TABLES**
==============================
3:42
A. What are the three major components of SQL?
6:05
B. What are the data definition statements? What do they do?
6:51
C. How do you [CREATE] a [TABLE]?
D. How do you add PK or FK [CONSTRAINTS]?
10:20
E. [primary key]
13:10
F. [foreign key]
16:05
G. [REFERENCES DELETE CASCADE]
H. [REFERENCES UPDATE CASCADE]
==============================
**MAKING CHANGES TO A TABLE**
==============================
19:13
I. How do you ALTER a table?
J. How do you change data in a table?
21:45
K. INSERT INTO
24:13
L. UPDATE
27:00
M. DELETE FROM
1:13:00
N. DROP
O. ALTER TABLE
==================================
**HOW DO YOU QUERY A TABLE?**
==================================
P.
28:55
Q. SELECT single column
31:25
R. What is the result of a SELECT query?
32:51
S. SELECT multi columns
34:40
T. SELECT DISTINCT
35:30
U. WHERE
36:34
V. Available comparisons/filtering
46:52
W. ORDER BY
==================================
**HOW DO YOU IMPLEMENT THESE KEYWORDS/ FUNCTIONS**
==============================
37:30
X. AND / OR
40:00
Y. IN / NOT IN
42:32
Z. BETWEEN
44:00
AA. LIKE
44:35
BB. Wildcards
CC. How do you use these built in functions?
50:40
DD. COUNT / MIN / MAX
EE. SUM / AVG / STDEV
==================================
**MISC**
==================================
53:10
FF. GROUP BY
55:10
GG. HAVING
56:30
HH. SUBQUERIES
II. What are NON-CORRELATED subqueries?
1:00:22
JJ. What are CORRELATED subqueries?
==================================
**MISC**
==================================
1:03:12
KK. JOINS
1:07:00
LL. What is the difference between INNER and OUTER JOINS
1:15:00
MM. CHECK
1:16:10
NN. What are VIEWS?
Thanks !!!
Thank you Sir
Hello, can you use ‘HAVING totalSales >=10000’ as you already assigned an alias to the result of SUM? Thank you
database is so much easier for me after watching these 8 lectures, thank you so much. just want to know if there is some place i can down load your ppt?
Dear Professor,
is it possible to get the power point slides?
and thank you for the videos, they are great...
I wonder how this video got 1 dislike, must be a dummy
or someone with envy of his teaching skills.
4 years later, the dumbasses count got up to 21
😄😂
ManBearPig Now it’s 29. New dumbasses stumble on this video every year lol
hi dr. soper, thank you for your tutorial! just wondering if you provide the slides for us to download?
thank you sir
After watching the first two tutorials liked it before watching it
if i use auto increment statement(suppose for studentID) then how can i insert at that database?