The video provides instructions on how to install and use SQL Server and SQL Server Management Studio. It includes steps for downloading and installing the software, creating a new database and table, filling data into the table, fetching data, and copying queries. The video also suggests joining the I love automation Discord for further help.
1. To install SQL Server and SQL Server Management Studio, navigate to the provided URL and click "Download Now."
2. Run the downloaded executable file to open the installation guide.
3. Choose the basic installation option, accept the terms, and click "Install" to complete the installation.
4. To install SQL Server Management Studio, download another executable file from the provided link and run it.
5. Connect to the database server using the server name obtained from the command prompt (CMD) by typing "whoami."
6. Create a new database named "Blacklist" using the query "create database Blacklist;"
7. Create a table named "companies" with columns: "vat" (integer), "company_name" (varchar with 30 characters, not null), and "reason" (varchar with 40 characters).
8. Insert three rows of data into the "companies" table with specific values for "vat," "company_name," and "reason."
9. Retrieve all data from the "companies" table using the query "select * from companies."
10. Filter data from the "companies" table where "vat" equals 12157321.
11. Save the SQL queries for future reference.