# Select and Filter Data - Running Scripts
To get started with hands-on practice, you’ll need data to populate your database. We’ll do this by running a SQL script. Follow these steps to execute the script on your database:
- Open the SQL File:
- Open the script file -> NorthwindScript (github.com). It contains the commands to create tables and insert data into them.
- Access phpMyAdmin:
- From the WebHostingForStudents Client Area, find your website and click the “Log in to cPanel” button.
- Once in cPanel, click “phpMyAdmin” under the “Databases” section.
- Connect to Your Database:
- Make sure you’re connected to the database that you want to run the script on. In this case, it will be the database you created for this class. In phpMyAdmin you can select the database by clicking on its name on the left side of the screen.
- Run the Script:
- To run SQL code, click the “SQL” tab in the horizontal menu at the top of the screen.
- Copy over the entire contents of the SQL script into the editor.
- Click the “Go” button at the bottom right. This will create the tables defined in the script and populate them with data.
- Verify the Data:
- After running the script, check to ensure that tables are created and data is inserted. You can do this by running a simple SELECT query, like `SELECT * FROM tablename;.
# Lessons
- SQL - W2 Select and Filter Data - Creating a Database
- SQL - W2 Select and Filter Data - Running Scripts