How to create a database in Microsoft Sql Server

We will focus on:

1. How to create a database

2. How to write basic SQL

3. How to create a table

4. How to query tables

5. Client-Server Architecture and TDS packets

This is a DIY(Do it yourself) session so please bring your laptop with you and install MS SQL server 2014/2016 with SSMS (SQL server Management Studio) before the event.

The link for MS SQL server 2014/2016 https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 After then please follow these steps.

Step 1: Register with Microsoft Site from above link >> Download SQL Server 2016 CAB file

Step 2: Double Click the downloaded cab file >> You will see a folder containing two files

Step 3: Double Click ENU exe file to extract the .box files

Step 4: Double Click the Setup.Exe Application File and Start the Installation Process.

For Installations of SSMS the link is

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

In case you have a problem finding us or you will be late, please call us on 9163 4228