...Pre-Class SQL Exercise Learning Objective: Since data has become one of the most valuable assets a company can have, it's a great addition to your skillset to know a little bit about SQL (pronounced “sequel”). SQL stands for Structure Query Language and is the standard language that is used to access and manipulate data and databases. With SQL you can execute commands known as “queries” that will either retrieve data, insert data, update data, or delete data. You can also do other administrative things that we’re not going to cover today like add/change tables, set permissions, and more. Why would someone use SQL? Anytime you want to store data, updated it, or retrieve it quickly in reports AND the data is too complicated (due to the amount or type) to manage in Excel, a DBMS can be used to maintain this in a database. SQL is the language you use to manage the data in the database. Examples of programs that use SQL would be Microsoft Access, SQL Server also by Microsoft, or MySQL which is a open source DBMS but there are many others) Background on the Structure of a Database and Tables A database most often contains one or more “tables”. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain “records” (rows) with data. In this lab we will use a sample company database. Below is a selection from the "Customers" table: CustomerID | CustomerName | ContactName | Address | City | PostalCode | Country | 1 | Alfreds Futterkiste | Maria...
Words: 2109 - Pages: 9
...Independent Nora (looking at her watch). It’s still not very late. Sit down here, Torvald. We have a lot to talk over. (She sits down at one side of the table.) Helmer. Nora — what is this? — That hard expression — Independent Nora. Sit down. This’ll take some time; I have a lot to say. Helmer (sits down at the opposite side of the table). You worry me, Nora! — and I don’t understand you. Independent Nora. No, that is exactly it. You don’t understand me, and I have never understood you either — until tonight. No, don’t interrupt. You must simply listen to what I say. Torvald, this is a settling of accounts. Helmer. What do you mean by that? dependent nora. You have always been so kind to me. But our home has been nothing but a playroom. I have been your doll-wife, just as at home I was papa’s doll-child; and here the children have been my dolls. I thought it was fun when you played with me, just as they thought it fun when I played with them. Independent nora. That is what our marriage has been, Torvald. Helmer. There is some truth in what you’re saying — under all the raving exaggeration. But it’ll all be different after this. Playtime is over, now for the schooling. dependent Nora. Whose schooling? Mine, or the children’s? Helmer. Both yours and the children’s, dearest. Independent Nora. Oh, Torvald, you are not the man to teach me to be a good wife for you. Helmer. And you can say that? dependent Nora. And I— how am I equipped to bring up the children? Helmer...
Words: 1815 - Pages: 8
...1) The following problems are representative of the type problems that will be on the 1st semester exam. Exam will cover Chapters 1 - 5. 2) Please solve/answer each of these - pay particular attention to the “type” solution required for each one. 3) You will not be given ANY additional material - any and all equations and/or constants that YOU think you will need must be placed on either a 3x5 or 5x8 index card. This card must be submitted to me during the exam review days and approved by me. The “approved/signed” cards may be used during the exam. 4) YOU MUST HAVE YOUR CARD, CALCULATOR and PENCILS WITH YOU WHEN THE BELL RINGS TO START THE PERIOD. YOU WILL NOT BE PERMITTED TO GO GET ANYTHING AND/OR BORROW ANYTHING FROM ANYONE!!!! 1. One year is about ____ seconds while one day is exactly ____ seconds. a) | 3.16 x 107, 86 400 | b) | 5.26 x 105, 86 400 | c) | 3.16 x 107, 8 640 | d) | 1.04 x 106, 36 000 | 2. The proton contains which of the following combination of quarks? a) | two up quarks and one down quark | b) | one up quark and two down quarks | c) | one top quark and two bottom quarks | d) | two top quarks and one bottom quark | 3. On planet Z, the standard unit of length is the foose. Ann the Astronaut is 5.90 feet tall on earth. She lands on planet Z and is measured to be 94 foosi tall. Her partner Rachael is 88 foosi tall. How tall is Rachael on Earth? a) | 5.2 feet | b) | 5.5 feet | c) | 5.8 feet | d) | 6.3 feet | 4....
Words: 5713 - Pages: 23
...As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd asdf asdf asdf asdf asdf asdfasdf asdfas fasdf asdf asd As asdfasd...
Words: 612 - Pages: 3
...asdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfva asdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd asdfasdv vvfvasdfasd...
Words: 5395 - Pages: 22
...Rthgdsfhsdfhsdf sad dfasdfas f asdfasd fs d ed d d d d d d dd d d d d d d d d d dd a das d as da sdasd as da sda sd as das d asd asd a sd asd a sd as da s d asdasd asd asd s d s a s d s d s a s d a sda sd a sd a sd a sd a sd as das d d s a sd s d a s d s ds a sd a sdas d a sd a s d a sd a s d s d erf e fgr g rt g dsg t yys t w er2345 q4 q r t 54y 5 ejkl lkj lkj klkj lk jlk j klh k jhbmn b n m b m n b m n b m n b sd fs df s df s df s df s df sd f a dfa sdfg sdh d hf hds f gs d f g d s f g d f g d f g s d f g d f g d f g sdfs d fs df s df s df sd f s df d h ty t y r ty r ty r t yr t y rt y r ty r ty rt y rt y rt y r ty rt y rtyr ty ert e rte r t er t e rte r t e rt et s df sdf s df...
Words: 256 - Pages: 2
...dfadfasf asfafdasfadfdasfasdfasdfdasfdsfsdaf dfa df asdf asdf adf asdf asdfasdfsda f sdaf asdfasd fasdfasdf sdf sdaf asdf dsaf asdfasdfas df asddfd safd afasd fasdfdsafdsa f asdfasdf adsfasdfdasf adfasf sdfasdfa sdfasdfasdf das f f ads fsdf asdf dasfadsfasdf af dfsasdfadsfasfdasdfasfasdfdfa dfdffbh j djaf jdkfjkdl;faj dklfjafijeiojaiosfjeaiofj eoi ejfaopjifeoi ajf eioaj fioejfioacafdioefj iofaj eiop jfdafj oiejidf ioefj kleajf eoiaefjp epaiofjaeiopf hepiourf ioe rioaerorejioarjeoiar jperijraeiopr ejaaer erawiope rjpoiaerjoaejiaejopieioperj ije r the bob wne to the dad and they went to the fambker and teh had i v fucking timapmfdaf more orver the place was awesome and i'm broed as hell and that his why i'm rwoiejraiopr doing this jsut for no reason at all but i oweiioapejraeoi jj like to do this dstufdioas fj myh spare tiejaprja sof i gi piasda hv ea fun time aeio ndnf this worlkd of oours ls.fjslrjeo i jliieikto to play soemnmew tjisport snad i dont' wknow whaty the vikings waisted it that mouchc how many workds is qual to 250, i fesall like iahve typed that many already but it ckeeps ssaying i have not typed that many so i will keep typing until i ahve reached the two hundred and fifty fowrds makximumn or i mean minimm and when that happens i lll be singed upa nd this message will be be posted for not reason at all. holyh shit hter is no way this iisnt' not 250 words but whatever i'll give it one more try and then if i dint;' get it iwll wjust give upa dfandfnad;kfna fthatnen...
Words: 362 - Pages: 2
