Getting Started with SQL Server Management Studio: Installation, Database Creation, Tables, and Data Insertion

Introduction

In this article Alex Freeberg walks you through the first video of his "Basics of SQL" series. The focus is on setting up the development environment, creating a database, defining two tables (employee demographics and employee salary), and populating them with sample data. The tutorial is designed for absolute beginners, but seasoned users can skip ahead to the table‑creation or querying sections.

Installing SQL Server Management Studio (SSMS) and SQL Server Express

• Two downloads required:
• SQL Server Management Studio – the graphical interface for interacting with SQL Server.
• SQL Server Express – a lightweight, free edition of the database engine.
• Steps:
• Download both installers from the links provided in the video description.
• Run the SSMS installer, accept the prompts, and wait for the installation to finish.
• Run the SQL Server Express installer, choose the default (Express) edition, and complete the setup.
• Launch SSMS; it will prompt you to connect to a server. Choose the newly installed Express instance and click Connect.

Creating a New Database

1. In SSMS Object Explorer, expand the Databases node.
2. Right‑click and select New Database….
3. Name the database SQL_Tutorial (or any name you prefer) and click OK.
4. The new database appears under the Databases folder; you’ll mainly work with the Tables sub‑folder.

Defining Tables with T‑SQL Scripts

1. Employee Demographics Table

CREATE TABLE EmployeeDemographics (
    EmployeeID INT,
    FirstName VARCHAR(50),
    LastName  VARCHAR(50),
    Age       INT,
    Gender    VARCHAR(50)
);

• Columns capture basic personal information.
• Data types are simple (INT for numbers, VARCHAR(50) for text).

2. Employee Salary Table

CREATE TABLE EmployeeSalary (
    EmployeeID INT,
    JobTitle   VARCHAR(50),
    Salary     INT
);

• Links to the first table via EmployeeID (no foreign‑key constraint added in this beginner tutorial).

• Stores job title and annual salary.

• After writing each script, click Execute and refresh the Tables node to verify the tables were created.

Inserting Sample Data

Employee Demographics

INSERT INTO EmployeeDemographics VALUES (1001, 'Jim', 'Halpert', 30, 'Male');
-- Additional rows (provided in the video description/GitHub) can be pasted here.

• The video demonstrates inserting a single row, then mentions a larger batch of records that can be copied from the description.

Employee Salary

INSERT INTO EmployeeSalary VALUES (1001, 'Salesman', 45000);
-- Additional rows follow the same pattern.

• After each INSERT, the author refreshes the table view to confirm the data appears.

Tips & Tricks Mentioned

• Hard refresh the table view with Ctrl+Shift+R if the new table shows a placeholder instead of the actual schema.
• All bulk INSERT statements are available in the video description or on the author’s GitHub for easy copy‑and‑paste.
• If you already have SSMS installed, you can skip the installation steps and jump straight to the script sections.

What Comes Next?

The next video in the series will cover basic querying techniques: - SELECT statements - FROM clause - WHERE filtering - GROUP BY aggregation - ORDER BY sorting These concepts will be demonstrated using the two tables you just created.

Who Is This For?

• Beginners who need a step‑by‑step guide to get a local SQL environment up and running.
• Intermediate learners who want a quick refresher on creating tables and inserting data.
• Experienced developers who can skip the setup and use the provided scripts as a template for their own projects.

By installing SSMS and SQL Server Express, creating a simple database with two related tables, and populating them with sample data, you now have a functional SQL environment ready for querying. The foundation laid here enables you to explore SELECT, WHERE, GROUP BY, and ORDER BY clauses in the upcoming videos, turning raw data into actionable insights.