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
@liberumoratio17042 жыл бұрын
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.
@clo-15884 жыл бұрын
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!)
@reccosmusic35544 жыл бұрын
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!
@mikah40514 жыл бұрын
Caleb is King of the SQL Kingdom.
@maryma50443 жыл бұрын
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.
@as-q8u Жыл бұрын
The only DB video that won't put you down for a nap at 9am
@ahlamabdaljawwad35832 жыл бұрын
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
@tshepomore55524 жыл бұрын
We're blessed, from Pretoria - South Africa. Thank you Caleb.
@codeschool39644 жыл бұрын
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?
@liberumoratio17042 жыл бұрын
Great foundational video. Perfect for beginners and as a refresher.
@dotterel4 жыл бұрын
Bro, you're a life saver!
@allornutting30764 жыл бұрын
this young man is wonderful, he makes if so easy, thanks Caleb
@yahyafati3 жыл бұрын
Nutting
@anandhkumar2625 жыл бұрын
Great tutorial...simple and effective!
@vishnupratap78994 жыл бұрын
Thank you for this!
@teaspells99943 жыл бұрын
Wow, this is so refreshing!
@anthonykimani39664 жыл бұрын
very easy to understand....loved it
@huylieuxuon80324 жыл бұрын
Thanks a lot for your lessons!
@MohamedAzzam4 жыл бұрын
bro.. where's the rest of the course :((((
@sub_zero_9115 жыл бұрын
Lol u r literally everywere! #big_fan
@reccosmusic35544 жыл бұрын
Note : Also feeling like making it through your tutorials should get me some sort of certificate or something from Curry U. haha.
@zt.56774 жыл бұрын
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?
@reccosmusic35544 жыл бұрын
Hey would you be willing to do a series on MangoDB?
@brigoose79454 жыл бұрын
@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
@artlisboa17535 жыл бұрын
00:45:15
@somorost67705 жыл бұрын
Aprendí inglés para poder entender este video. And I am here. Look at me, english teacher
@AdrianHconnection4 жыл бұрын
You remind me of a young Michael from "Office Space".
@Moe_Lester_fromUptwn5 жыл бұрын
Yes!
@mohamedmossad94584 жыл бұрын
-- 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 */