IST 359 Lecture Notes - Lecture 3: Microsoft Sql Server, Timesheet, Foreign Key

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

Document Summary

Lab introduction to sql part 1 of 2. In this lab, we will practice using ddl and dml sql statements using our account on. Much of what we did last week using the gui is now done this week via. Sections 1 and 2 are in this document. Sections 3 and 4 are available in blackboard. 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 it"s 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 refer to the previous to labs and practice. All queries should be written in the lab03_introduction_to_sql_queries. sql file. In section one we will explore a new aspect of the fudgemart database schema for use in the lab.