 What's going on everybody? My name is Alex Friedberg and in today's video we're going to be starting our basics of SQL series now in this series We're going to be going over everything you need just to get started and then in future videos We're going to be going over some intermediate concepts and for some more advanced concepts and then in the final series We're going to be going over some portfolio projects in this video in particular. We're going to be downloading SQL server management studio We're gonna be creating our tables inserting data into our tables and then in future videos We're gonna actually learn how to query those tables If you already have SQL server management studio downloaded You can skip ahead to where we actually create the tables and insert the data into the tables If you don't care about that at all and you're just looking at a query I would skip to the next video where we actually start querying the data that we inserted into those tables So download SQL server management studio We actually have to download two things and I have both links right here I'm gonna leave those in the descriptions that you guys have those But this one is to actually download SQL server management studio. So let's go down here I actually deleted it off my computer so I could walk through this with you guys So we're gonna download that. Let's also go over here This is actually a server. So we have to download a SQL server and if you go down right here There's a free version. Now, I don't need the developer version. I'm just gonna download the express version It's actually smaller. So let's download that as well Now once this is done running, we're gonna open it up and I'll show you what to do next So it just finished running. Let's click on it. All right, so we need to install it We're gonna click yes, and this is gonna take a little while So this popped up. I clicked install and it's been running for the past couple of minutes Apparently I was not recording so I apologize for that, but that's all I did So now it's been installed. I'm actually gonna pull it up right here And let's open it up Now when it pulls up It's gonna ask you to connect to a server and that's why we downloaded the SQL express server So let's connect to that and there you go. It's as easy as that So now we have SQL server management studio set up and we are good to go So the first thing that we need to do is actually create a database so let's go over here to databases and let's click new database and Let's just do SQL Tutorial keep it simple and If we click that it's going to create our database for us Now when you open up the database there's going to be a lot of stuff You really do not need to know all this really what we're going to be sticking to is this tables right here As of right now, we do not have any tables. So we need to create tables Now there's two ways that you can do that. You can click right here and you can go to new and create table We're not actually going to do that. We're going to create it using a script or a t-sql So we're going to go over here and do new query and we will get started on actually creating The two tables that we're going to be using for all the stuff going forward. All right So let's get rid of me because we really don't need to be seeing me anymore Let's get started by doing our very first table, which is going to be our employee demographics table So let's start off by saying Create table and we have to name it. So let's do employee Demographics and enter down we want to do an open pregnancy now We need to specify what our column names are going to be and what the data type is for each column So let's start off With employee ID and we want that to be an integer. So that'll be like one two three four Uh anything numeric Now we want to do First name And let's make that varchar 50 if you don't know what these data types are that's okay That will probably be covered in a different video. That's not really necessary for this video Let's do the last name. We'll also make that varchar 50 Let's do age Make that an integer And very last let's do gender And we will make that Varchar 50 as well so Now we have our very first table Let's run that And we'll see if it works. We'll go over here and we'll refresh our tables And there you go. So we have our very first table Let's go up here. Let's get rid of this one and now let's create our second table So we're going to do basically the exact same thing But we're going to have a little bit different information in it. This is going to be our employee salary table So let's do Create table and again, we need to name it And enter an open parentheses. So now we're going to do the same thing. We're going to do employee ID Let's make that an integer Now we want the job title Because we want to know what they do And this one is going to be Varchar 50 because we keep it pretty simple Whoops And then for our very last one, we're going to do salary and that will be integer as well Let's do here. So let's create this table Let's see If it is there And there we go So let's open up one of these tables really quick See what's in there. See what it looks like as you can see we do not have Any information in there When you create a new table sometimes when you open it up You're going to see this if you want to get rid of that you just need to Do a I think it's called a hard refresh or something like that, but you can do control shift r Let's see if it works for me. I just did it. All right. It goes away. So now it recognizes it as a table So we're good there Let's go back here And let's get rid of all this we've already created our tables Now we want to insert the data into our tables. So let's see what that looks like Let's do insert into and now we need to specify what table we're inserting our data into. So let's start off with employee demographics Let's do values But now we have to select what values we're going to put into Um into this table So now we're going to have to do the employee ID. So let's do 1001 Then we're going to do first name. So let's do gym last name Halpert And then his age, let's say he's 30 And he is a male Now just for fun, let's execute that Let's go back to this table right here and execute And as you can see all of our information actually went in there. So now we have his employee ID His first name his last name age and gender now We need a lot more information For this table in order to actually learn a lot of the concepts of querying the table So I'm actually going to go through and add a ton more information I'm not going to bore you through that But I will show you the final product before I actually hit execute So stick with me I'm actually just going to cut to the end where I insert all my stuff down here And then if you want that I'll probably leave it in the description Or maybe put it in my github or something so that you can easily just go copy and paste that if that's what you want to do So I'll see you in a few seconds All right, so I have all my values right here. I actually I'm going to take this one out because I already did that one But this is our additional information. Let's insert that into our table real quick And go back here and take a look at it and there you go This is going to be our core information that we are querying off of In future videos. So that table is completely finished. Let's go back here we're going to Get rid of this because now we want to insert our information to our other table So let's do insert into and let's do employee And now we're going to do salary so Let's do values to specify that we're inserting values into there And in this one we have employee ID. So again, let's do in 2001. That's Jim His job title is salesman And let's say his salary is 45,000 dollars And let's execute that And you can't see it, but down here it says it's done. Let's go to that table And as you can see that is inserted I'm going to do the exact same thing as I did before I am going to fill out all these and in a second it will be done On your side And then I again, I will leave it in the description or I'm going to put it on my github And you guys can just copy and paste that if that's what you want to do or you can write it out whatever you want to do All right, just like before I'm going to get rid of this first one. That is Jim. He has already done now Let's insert this information It is finished. Let's go back here And there we go Now we have both of our tables and we are good to go for future videos So thank you so much for sticking all the way through this one in the next video We're going to actually begin Queering the table and learning the select the from the where the group by And the order by statement everything is in these upcoming videos So stick around and we will learn all of that together. Thank you so much for joining me If you like this type of content, be sure to subscribe below and I'll see you in the next video