DEV Community

Cover image for SQL DATABASE
Habeeb Hameed
Habeeb Hameed

Posted on

SQL DATABASE

#sql #serverless #database #mysql

Working with SQL Server Management Studio: Step-by-Step Guide

In this guide, we’ll walk through using SQL Server Management Studio (SSMS) from installing the server, creating databases and tables, to inserting and querying data. Each step is illustrated with screenshots and notes to make it beginner-friendly.

Step 1: Open SQL Server Management Studio (SSMS)

Step 1: Open SQL Server Management Studio (SSMS)

Step 2: Create a new database named DolaDB

Step 2: Create a new database named raw `DolaDB` endraw

Step 3: Select your database with USE DolaDB; and execute

Step 3: Select your database with raw `USE DolaDB;` endraw and execute

Step 4: Create a table named Employees with columns for ID, FirstName, LastName, BirthDate, and JobTitle

Step 4: Create a table named raw `Employees` endraw with columns for ID, FirstName, LastName, BirthDate, and JobTitle

Step 5: Insert sample records into the Employees table

Step 5: Insert sample records into the raw `Employees` endraw table

Step 6: Query the table to verify the inserted data using SELECT

Step 6: Query the table to verify the inserted data using raw `SELECT` endraw

SELECT
Enter fullscreen mode Exit fullscreen mode

Top comments (0)