SQL SERVER 2017 TUTORIAL : PART 02 (SSMS)

Today we are going to learn how to install and use SQL server management studio.<br />SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for <br />configuring, managing, and administering all components within Microsoft SQL Server. <br />It includes both script editors and graphical tools which work with objects and features of the server.<br />Unlike previous versions of SQL server, management studio is not a part of SQL server installer any more.<br />we need to download latest version of SSMS from Microsoft website.<br />Installation process is very simple and easy. It needs very few clicks and 10-20 minutes.<br />As I said earlier SQL server management studio is used for managing all services of SQL server like database engine, reporting service, <br />analysis service etc..<br />now we are going to learn how to create a new database and table, so we need to connect database engine.<br />now we are connected with database engine.... <br />Left side area is object explorer. various database objects are listed here.<br />The first folder is for database. A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, <br />views and other objects.<br />To create new database, right click on database folder in object explorer and select new database. <br />Type the name of the database.. for example 'test_db'<br /><br />SQL server database requires minimum two files. one database it self and another is log file. you can add more files if necessary.<br />for this tutorial we will go for default. but gradually we will learn all...<br />Finally click OK to create the database. After few seconds.... a new database called 'Test_db' will appear in object explorer.<br />Today we have learned how to create database using SQL server management studio. In next tutorial we will learn about 'Table'.