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

60 views4 pages

Document Summary

Lab introduction to sql part 2 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. 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. You"ll also need to complete part 1 of this lab before attempting these exercises. Part 1 of this lab is available in blackboard. All queries should be written in the lab03_introduction_to_sql_queries. sql file. You should have entered all of the queries from part 1.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents