SQL Server

This repository is a collection of some useful functions of SQL Server.

Overview

It includes all the lessons that I had in SQL from w3schools, with instructions and notes in each function for a quick review. Additionally, the repository has the NORTHWND database that I used to follow these lessons.

Here are some SQL Commands covered:

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table

Usage Instructions

To use this repository, follow these steps:

1. Clone the repository to your local machine.

   git clone https://github.com/RobisonTorres/SQL_Server.git
   

2. Place northwind.bak file in this folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 19.

3. On Sql Sever, right click on "Database" and then press "Restore Database". On the windows that will open select "Device" and press the button in the right "...". On the next window, click on the button "Add". On the "Backup File location" paste this path "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19". Finally click on the name of the file and click ok.

4. The database NORTHWND should be in "Database" section. If not, right click on "Database" and press the button "Refresh".