SQL SERVER 2017 TUTORIAL : PART 02 (SSMS)

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 'testdb'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 'Testdb' 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'.


User: FAST tech

Views: 4

Uploaded: 2018-05-22

Duration: 03:24

Your Page Title