...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
...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
...Confucianism Paper Karla Salas REL/133 Dec., Thursday, 2014 Mr.Griffen Confucianism Paper The Five Great Relationships are certain duties that Confucius believed every person should fulfill in this society. Confucianism believes that we are not simply individuals; we are also threads of relationships with people, differing with each person whether you have a friendship or family connection with them. The first is Father-son which also represents a parent-child relationship. This relationship states that parents are responsible for teaching and educating their children to have morals, respect, and obedience. The reason why some people today will not appreciate this is because the parents are expected to select a career and marriage partner for their kids. There has to be a mutual care from the parents to the children and from the child to the parent, when the parent is old the children will take care of them and they are also expected to honor their parents even after death, by putting up pictures and talk about memories experienced with them. If parents teach this to their children since they are small they grow up respecting their elders and it applies at school with their teachers and at work with their boss. The second one is Elder-brother to Younger-brother relationship; the older brother has to assume responsibility for the younger siblings. The older sibling has to be aware that his/her parents can pass away any day, and that is when they will be taking responsibility...
Words: 557 - Pages: 3
...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
