Timestamps 00:00:00 - Intro to SQL Server 00:09:21 - Installing SQL Server 2016 00:12:42 - How to Install SSMS 00:16:44 - Beginner Terms Part 1 00:23:56 - Beginner Terms Part 2 00:35:33 - One-to-One Relationship 00:42:15 - One-to-Many Relationships 00:49:33 - Many-to-Many Relationships 00:54:44 - Database Relationships Summary 01:02:21 - Entity Integrity 01:09:41 - Referential Integrity 01:14:55 - Domain Integrity 01:18:36 - Primary Key 01:25:25 - Composite Key 01:33:21 - Foreign Key 01:41:23 - ON DELETE and ON UPDATE 01:49:36 - Intro to Normalization 02:00:02 - 1NF 02:12:54 - 2NF 02:28:09 - 3NF 02:35:37 - Normalization Summary 02:40:16 - Intro to Queries 02:46:48 - CREATE TABLE 02:51:47 - Drop Table 02:55:31 - PRIMARY KEY, NOT NULL, UNIQUE 02:59:07 - How to Create FOREIGN KEY Constraints 03:03:32 - Composite Primary Key 03:08:26 - How to Name Constraints 03:12:08 - How to INSERT Data 03:17:56 - How to SELECT Data 03:20:35 - How to Create an Alias with AS 03:24:00 - Indexes 03:31:41 - How to Create and Drop Indexes
This is an awesome video. Goes over the basics of SQL development in a clear and to-the-point style. If you are a beginner start here. For those old timers, this is a great review to prompt your memory.
Hello! I just wanna thank you - I watched all of the videos in this series, and now I feel like I have a better understanding of SQL. You're a great teacher. Keep up the good work (and I'll definitely look at your other series!)
The only thing I am sad about is that you are done with this series haha. You do nice work my friend. Thank you so much for the hard work you put in. I feel so much better about stating I know SQL now and can make it work how I want it too. Will you be adding more content on actually manipulating the data and getting into how to do real time practice? Would be cool to add a movie or two taking larger data sets and doing joins and indexing them to be faster with some before and after timing. Thanks again!
Thank you Caleb for posting your educational videos, I am new in IT, just interested in these industry, I have watched 10 of your videos, ssooooo helpful. I will be keep watching more, just send you a thank you note.
thank you so much, Caleb !! you really helped me improve concepts that I didn't understand before and that really helped me in my work. I now understand Databases well. I am grateful to you
@Caleb Curry righty, ive been learning sql in my spare time, used in MySQL and sql server, Ive built a large working database. Is it possible to build a GUI, or something like that to run it on. I worked for a bit in a truck transport office, they had a crappy Excel one, even to me it was crappy but the db ive got does what theirs did. Just wondering as I honestly don't have a clue
Dear Caleb, This was very good. However I had the feeling that something was missing from the end. You mentioned joins, but never showed it. Also what is "the videomaker two"? Was there a videomaker one?
-- Great work CREATE a rich content for SQL Server, but I assume we only scratched the surface /* Do you have an intermediate/advanced Series. I am an accountant and find it difficult to watch pure IT stuff but your way is fun and encouraging to break the ice with RDBMS */
Timestamps
00:00:00 - Intro to SQL Server
00:09:21 - Installing SQL Server 2016
00:12:42 - How to Install SSMS
00:16:44 - Beginner Terms Part 1
00:23:56 - Beginner Terms Part 2
00:35:33 - One-to-One Relationship
00:42:15 - One-to-Many Relationships
00:49:33 - Many-to-Many Relationships
00:54:44 - Database Relationships Summary
01:02:21 - Entity Integrity
01:09:41 - Referential Integrity
01:14:55 - Domain Integrity
01:18:36 - Primary Key
01:25:25 - Composite Key
01:33:21 - Foreign Key
01:41:23 - ON DELETE and ON UPDATE
01:49:36 - Intro to Normalization
02:00:02 - 1NF
02:12:54 - 2NF
02:28:09 - 3NF
02:35:37 - Normalization Summary
02:40:16 - Intro to Queries
02:46:48 - CREATE TABLE
02:51:47 - Drop Table
02:55:31 - PRIMARY KEY, NOT NULL, UNIQUE
02:59:07 - How to Create FOREIGN KEY Constraints
03:03:32 - Composite Primary Key
03:08:26 - How to Name Constraints
03:12:08 - How to INSERT Data
03:17:56 - How to SELECT Data
03:20:35 - How to Create an Alias with AS
03:24:00 - Indexes
03:31:41 - How to Create and Drop Indexes
This is an awesome video. Goes over the basics of SQL development in a clear and to-the-point style.
If you are a beginner start here. For those old timers, this is a great review to prompt your memory.
Hello! I just wanna thank you - I watched all of the videos in this series, and now I feel like I have a better understanding of SQL. You're a great teacher. Keep up the good work (and I'll definitely look at your other series!)
The only thing I am sad about is that you are done with this series haha. You do nice work my friend. Thank you so much for the hard work you put in. I feel so much better about stating I know SQL now and can make it work how I want it too. Will you be adding more content on actually manipulating the data and getting into how to do real time practice?
Would be cool to add a movie or two taking larger data sets and doing joins and indexing them to be faster with some before and after timing. Thanks again!
Caleb is King of the SQL Kingdom.
The only DB video that won't put you down for a nap at 9am
We're blessed, from Pretoria - South Africa. Thank you Caleb.
Thank you Caleb for posting your educational videos, I am new in IT, just interested in these industry, I have watched 10 of your videos, ssooooo helpful. I will be keep watching more, just send you a thank you note.
thank you so much, Caleb !!
you really helped me improve concepts that I didn't understand before and that really helped me in my work.
I now understand Databases well.
I am grateful to you
Great foundational video. Perfect for beginners and as a refresher.
Thanks Caleb. You are a great and a funny teacher. Are there any other videos in this series that you didn't include in this video?
bro.. where's the rest of the course :((((
Bro, you're a life saver!
@Caleb Curry righty, ive been learning sql in my spare time, used in MySQL and sql server, Ive built a large working database. Is it possible to build a GUI, or something like that to run it on. I worked for a bit in a truck transport office, they had a crappy Excel one, even to me it was crappy but the db ive got does what theirs did. Just wondering as I honestly don't have a clue
this young man is wonderful, he makes if so easy, thanks Caleb
Nutting
Great tutorial...simple and effective!
Thank you for this!
very easy to understand....loved it
Thanks a lot for your lessons!
Wow, this is so refreshing!
Hey would you be willing to do a series on MangoDB?
Lol u r literally everywere! #big_fan
How to INSERT value if all my table have a FK?
I used 2016 2 there was no 1, is that ok?
Note : Also feeling like making it through your tutorials should get me some sort of certificate or something from Curry U. haha.
Dear Caleb, This was very good. However I had the feeling that something was missing from the end. You mentioned joins, but never showed it. Also what is "the videomaker two"? Was there a videomaker one?
00:45:15
Yes!
Aprendí inglés para poder entender este video. And I am here. Look at me, english teacher
You remind me of a young Michael from "Office Space".
-- Great work CREATE a rich content for SQL Server, but I assume we only scratched the surface
/* Do you have an intermediate/advanced Series.
I am an accountant and find it difficult to watch pure IT stuff
but your way is fun and encouraging to break the ice with RDBMS */
Hape new year
Big Subscribe for you ^.^
🥺💙🥺
i came here first (like comment and view )
and I came here to disliked your comment.