Using SQL Server Management Studio we show you how to create database in SQL 2012 Server. With SSMS, you can build a data base and create table using SQL or GUI. Using SQL Management Studio we make School database. We discuss sqlserver best practices for data and log file locations in MS SQL 2012. Next we go ahead and create SQL 2012 Server tables and by using SQL command. The Database instructor discusses data type, primary key and foreign key constraints. Using the Object Explorer in SSMS 2012, we create table and assign a default value. Using object explorer, you can display the data using SQL Select command. We end the video on SQL 2012 by inserting data into a table using the Insert SQL check the data with SQL Select query.