First steps with SQL Server Management Studio

Log into the remote desktop vm-1.techcats.solutions

My login for this demo is tstudent but substitute your JagNetID (AU email before the @ sign) for tstudent

Double-click the SQL Server Mgmt Studio (SSMS) icon on the desktop; there is a similar icon labelled SQL Server Cmd Line which leads to a command line interface rather than the SSMS GUI

SQL Server has been configured to use Windows authentication so your remote desktop login will auto-magically connect you to SQL Server

Note that SQL Server with its current security settings lets you see but not touch other databases

Please prefix your database names with your JagNetID; SQL Server doesn't allow two or more DBs with the same name and all students will be creating, e.g., a TP00 database. This naming convention is not enforced by the current SQL Server security settings.

'At the end of the day', SSMS helps (or invisibly) creates SQL that is sent to the connected SQL Server instane.

My demo will create a database tstudentDemo and then create the share table from Watson Chapter 3

CREATE TABLE share (
  shrcode CHAR(3),
  shrfirm VARCHAR(20) NOT NULL,
  shrprice DECIMAL(6,2),
  shrqty DECIMAL(8),
  shrdiv DECIMAL(5,2),
  shrpe DECIMAL(2),
  PRIMARY KEY (shrcode));