Version: 15.0
Team Members: Roland Aroche, Janeth Arriola, Ekaterina Banks, Anthony Benitez, Zachary Garcia, Adriano Herrera, Akeem Lake, Ismael Peña
Product Owner(s): Jason Cohen
Mentor(s): Frank Alvarado
Instructor: Masoud Sadjad
IntelliJ Download
Timestamp: 8:00
Link: www.jetbrains.com/idea/download/
Visual Studio Code Frontend Installation
Timestamp: 20:20
Link: code.visualstudio.com/download
Node and NPM
Timestamp: 20:36
Link: docs.npmjs.com/downloading-an...
MACOS INSTALLATION
Commands:
1. sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
2. docker run -d --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=reallyStrongPwd123' -p 1433:1433 microsoft/mssql-server-linux
3. docker ps
4. Sudo npm install -g sql-cli
5. mssql -u sa -p reallyStrongPwd123
6. select @@version
Azure Data Studio:
Timestamp: 4:32
docs.microsoft.com/en-us/sql/...
Azure Data Studio Database Commands:
--start
USE master
GO
IF NOT EXISTS (
SELECT [name]
FROM sys.databases
WHERE [name] = N'your_db'
)
CREATE DATABASE your_db
GO
use [your_db]
go
CREATE LOGIN your_user WITH PASSWORD = 'pass@123';
CREATE USER your_user FOR LOGIN your_user;
ALTER ROLE db_ddladmin ADD MEMBER [your_user];
ALTER ROLE db_datareader ADD MEMBER [your_user];
ALTER ROLE db_datawriter ADD MEMBER [your_user];
go
--end
WINDOWS INSTALLATION
Timestamp: 11:00
SQL Server download:
www.microsoft.com/en-us/sql-s...
MSSQL Server Studio download:
docs.microsoft.com/en-us/sql/...