Configuring Microsoft SQL Server Express (tutorial)

good morning guys and welcome to my first youtube video tutorial today I will explain how to configure Microsoft SQL Server Express I will show how to configure the server create the table fill the table with an SQL query and how to make sure that the SQL Server can be assessed remotely or from the same local machine okay so in order to download SQL Server Express just go to the website so google SQL Server Express connect today a website Microsoft website and download the program so for me actually SQL Server Express is already installed on my laptop and so let's see how we can configure the database and the server first of all go to the services and SQL and double check that SQL is running and that is the startup type is automatic the same for SQL server browser startup automatic alright so now opening the program and see how we can configure a database okay so login in Microsoft SQL Server here you can see the server which is running your databases these are the databases that are already running on my computer and important in security you can see the credentials user data to retrieve the data okay so first of all you want to double check net for your server you are able to assess the database remotely so just right-click on your server properties security and make sure that this novelty indication is set to both SQL Server and window out indication we know dedication enables you to assess the server from your local machine SQL Server for both from your local machine and remotely ok so first of all let's see how to create a new database go to databases right click new database let's call it my DB the other option can be left as default just make sure to type the right name okay so for your database in your database is now empty so you can create a table for example let's create a table with two fields name which is basically a string and bar char is for string and age which is an INT integer okay now you can save the table as people okay now you made the table I met you made a table named people with true fields name and age you can the table is now empty if you try to see the top 100 robes see that they are empty okay now create we can fill they basically we can recruit in principle import the data using the import data tool in of SQL Server but let's see now how we can simply fill in the data okay so this is a SQL query insert into DB open the people value is so the values are for example a name my name carlo age 38 execute okay my girlfriend she's with 28 and now we can see that there are the table is now filled okay now we need to grant access remotely to this database and so create go to login new login so we call is my ID for SQL Server authentication password is password which will be my password my capital letter P W we don't need the password policy and we want to map this credential to my DB so also go to a user mapping and my DB as a data reader okay good so basically we set up our database and we granted the credentials now we need to make sure that data can be retrieved remotely so go to SQL server manager and now here you have SQL Server network configuration you have tcp/ip which must be enabled go to properties IP addresses and make sure that for the all EP ep port is set to 1433 okay all right apply so as you can see now you just just need to go to services and to make sure that everything is up to date not you SQL Server and you start service ok and that's it so now your server is running and with a database that contains a table named people containing truth fields name and age in the next tutorial we will see how to retrieve these data remotely or from the same machine so see you guys

Channel: Carlo Cappello

Views: 10,612

Rating: 4.8896551 out of 5

Keywords: SQL, Microsoft SQL Server, tutorial, Windows, database

Id: DI1cXYtlQlo

Length: 9min 4sec (544 seconds)

Published: Fri Nov 03 2017