{"action":"closed","issue":{"url":"https://api.github.com/repos/agustus9/assignments/issues/21","repository_url":"https://api.github.com/repos/agustus9/assignments","labels_url":"https://api.github.com/repos/agustus9/assignments/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/agustus9/assignments/issues/21/comments","events_url":"https://api.github.com/repos/agustus9/assignments/issues/21/events","html_url":"https://github.com/agustus9/assignments/issues/21","id":312987640,"number":21,"title":"Week 6 Day 2 - Intro to SQL - ","user":{"login":"mdewey","id":1793923,"avatar_url":"https://avatars2.githubusercontent.com/u/1793923?v=4","gravatar_id":"","url":"https://api.github.com/users/mdewey","html_url":"https://github.com/mdewey","followers_url":"https://api.github.com/users/mdewey/followers","following_url":"https://api.github.com/users/mdewey/following{/other_user}","gists_url":"https://api.github.com/users/mdewey/gists{/gist_id}","starred_url":"https://api.github.com/users/mdewey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdewey/subscriptions","organizations_url":"https://api.github.com/users/mdewey/orgs","repos_url":"https://api.github.com/users/mdewey/repos","events_url":"https://api.github.com/users/mdewey/events{/privacy}","received_events_url":"https://api.github.com/users/mdewey/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-10T15:58:44Z","updated_at":"2018-04-11T23:54:00Z","closed_at":"2018-04-11T23:54:00Z","author_association":"NONE","body":"# Welcome to SQL!\n\nGet your feet wet with SQL and Databases. You will be creating 2 databases for me and writing some simple queries to gather from information. Use your best Judgement for data types the columns should be. \n\n## Objectives\n- Practice Creating, Querying and using SQL databases\n- Get your Local Dev set up. \n\n\n### Setup\n\n- Download SQL Management Studio\n  - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms\n- Download SQL Express 2017\n  - https://www.microsoft.com/en-us/download/confirmation.aspx?id=55994\n\n### Explorer Mode\n\n- [ ] Create a database to store Movies\n  - [ ] There shoudl be a Movie table with the follow columns: \n      - Id (PK)\n      - Title\n      - YearReleased\n      - Genre\n      - Tagline\n      - Rating\n  - [ ] Create a query that inserts a new Movie\n  - [ ] Create a query that Updates all Movies that were  Released in the year 1988 to have a rating of 10\n  - [ ] Create a query that Deletes all Movies that are titled \"The Neverending Story\"\n  - [ ] Create a query that finds all horror Movies\n\n- [ ] Create a Database that will store a log of Bank Transactions for an account\n  - [ ] This should a table for Transactions with the follow columns: \n    - Id (PK)  \n    - Timestamp\n    - Action\n    - AccountNumber\n    - AmountChanged\n    - newAmount\n  - [ ] Create a query that finds all transaction from Today\n  - [ ] Create a query that finds the 10 mist recent transaction for a Given User\n  - [ ] Create a query that Inserts a new Item into the table \n  - [ ] Create a query that counts all transactions for a Given Day and given day\n\n  \n### Adventure Mode\n\n- [ ] Using SQLCommand, Try to query your database from a C# program. Try to implement the logging from your bank App to log into the database instead of a file. This a preview for Thursday topic. \n\n## Turning In\n\nYour homework will be assigned to you via `issues` on your `assignments` repository. Once you are\n\nThese steps will be followed for almost every assignment going forward. Once you've completed at least _explorer_ mode and you're satisfied with your work, let's get it published. First let's get it up on GitHub.\n\n- First, let's add all our work to git, and ask it to commit it:\n\n  ```sh\n  git add .\n  git commit -m \"My first webpage\"\n  ```\n\n  Feel free to replace _\"My first webpage\"_ with a more meaningful message.\n\n- Push our local commits to GitHub:\n\n  ```sh\n  git push -u origin master\n  ```\n\nThe files I am looking for are:\n  - A Script to recreate your database and tables\n  - A Script for each of the queries.\n   \n\nFor SQL only Assignments, Add `.sql` containing your queries to your repo. \n\n\n## Additional Resources\n- https://blog.hubspot.com/marketing/sql-tutorial-introduction\n- https://technet.microsoft.com/en-us/library/bb264565(v=sql.90).aspx\n\n"}}
{"actor":{"display_login":"agustus9"}}