How to create database and name it professionally

To keep the project organized, you should create a brand new, empty database inside SQL Server Management Studio (SSMS) specifically for this portfolio project. Do not mix it with any system databases or sample databases you used for your practice.

Step 1: Open SSMS and Connect

1. Open SQL Server Management Studio.
2. Click Connect to access your local server instance.

Step 2: Create Your New Portfolio Database

You can do this visually with a couple of clicks:

1. In the Object Explorer panel on the left side of the screen, look for the folder named Databases.
2. Right-click on that Databases folder.
3. Click New Database… from the menu that pops up.

Step 3: Name Your Database Professionally

Use clean naming conventions

1. In the Database name box, type: Portfolio_Bible_Analytics
2. Click OK at the bottom of the window.

---

Verifying and Using Your New Database

You will now see Portfolio_Bible_Analytics listed inside your Databases folder.

When you open a New Query window to run T-SQL scripts or when you open the Import Flat File Wizard, always make sure your target database is set to this new one. In a query window, you can force this by typing and running this command first:

sql

USE Portfolio_Bible_Analytics;
GO

Now, when you use the Import Flat File wizard to load your cleaned CSV, select Portfolio_Bible_Analytics as your destination database.