This means you haven't run the creation script yet, or the script failed. Make sure you executed the query using the lightning bolt icon. If you simply opened the file without running it, the database doesn't exist yet.
If you are enrolled in the course on Code with Mosh, you can typically find the download link in the following locations:
**Importing MOSH SQL Database from a Zip File**
Go extract that ZIP file and start querying
1. Open 7-Zip and navigate to the folder where the backup file is located. 2. Select the backup file and click on the "Add to archive..." button. 3. Choose the zip format and set the compression level to your desired level. 4. Click "OK" to create the zip file.
: In the "Getting Started" or "Creating the Databases" section, scroll to the bottom of the page to find the "SQL Course Materials.zip" link. Content and Usage
```sql RESTORE DATABASE [my_database] FROM DISK = 'C:\my_database.bak' WITH REPLACE Replace `[my_database]` with the name of your database and `C:\my_database.bak` with the path to the extracted backup file.
Without this file, you cannot follow along with the coding exercises.
To import a MOSH SQL database from a zip file, follow these steps:
If you bought the course directly from his website, the process is simpler.
1. Open WinRAR and navigate to the folder where the backup file is located. 2. Select the backup file and click on the "Add to archive..." button. 3. Choose the zip format and set the compression level to your desired level. 4. Click "OK" to create the zip file.
For a quick reference while you work, Mosh also provides an SQL Cheat Sheet that summarizes core commands like SELECT , WHERE , and JOIN .