IST 359 Lecture Notes - Lecture 3: Microsoft Sql Server, Lookup Table, Timesheet

• School: Syracuse University
• Department: Information Studies
• Course: IST 359
• Professor: nosky

Document Summary

In this lab, we will practice using ddl and dml sql statements using our account on. Upon completion of this learning unit you should be able to: Describe and use basic sql commands on sql server. Explain how and why sql is used, and why its important. Use sql commands to create metadata structures (tables and constraints) and perform. By now you should be proficient at logging on to your hosted sql server. If you aren"t i suggest practice, practice, practice! Hopefully by now, you mastered connecting to your sql server instance. In part one we will explore a new aspect of the fudgemart database schema for use in the lab. In part two; you will follow along entering and executing the sql commands that are displayed in the screen shots. This lab will give you a brief explanation of what the commands are doing to help you through the muddy points.