...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
...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
