Summary of How to Create Database in SQL Server
The video discusses the steps to create a database in SQL Server using SQL Management Studio.
- The speaker outlines the different types of databases available in SQL Server, such as database engine, reporting services, and integration services.
- The speaker demonstrates how to select the database engine and authentication method, connect to the database, and view the list of available databases.
- The process of creating a new database involves writing a SQL query using the "create database" command followed by the database name.
- The speaker shows how to create a new table within the newly created database by writing a SQL query using the "create table" command.
- The video also covers inserting data into the table using the "insert into" command.
- The speaker explains how to view and refresh the database to see the newly created database and table.
- The video concludes by mentioning the option to create a database using the graphical user interface in SQL Management Studio.
Notable Quotes
— 00:24 — « the sql server management studio 2017, »
— 01:07 — « so to perform the different type of, »
— 04:21 — « how to create the database simply creation of, »
— 05:28 — « create database name of database so, »
— 10:11 — « table names then we may be able to, »
Category
Educational