Get 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.
Objectives
Practice Creating, Querying and using SQL databases
[x] There shoudl be a Movie table with the follow columns:
Id (PK)
Title
YearReleased
Genre
Tagline
Rating
[x] Create a query that inserts a new Movie
[x] Create a query that Updates all Movies that were Released in the year 1988 to have a rating of 10
[x] Create a query that Deletes all Movies that are titled "The Neverending Story"
[x] Create a query that finds all horror Movies
[x] Create a Database that will store a log of Bank Transactions for an account
[x] This should a table for Transactions with the follow columns:
Id (PK)
Timestamp
Action
AccountNumber
AmountChanged
newAmount
[x] Create a query that finds all transaction from Today
[x] Create a query that finds the 10 mist recent transaction for a Given User
[x] Create a query that Inserts a new Item into the table
[x] Create a query that counts all transactions for a Given Day and given day
Adventure Mode
[ ] 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.
Turning In
Your homework will be assigned to you via issues on your assignments repository. Once you are
These 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.
First, let's add all our work to git, and ask it to commit it:
git add .
git commit -m "My first webpage"
Feel free to replace "My first webpage" with a more meaningful message.
Push our local commits to GitHub:
git push -u origin master
The files I am looking for are:
A Script to recreate your database and tables
A Script for each of the queries.
For SQL only Assignments, Add .sql containing your queries to your repo.
agustus9
commented
6 years ago 
mdewey
commented
6 years ago 
Welcome to SQL!
Get 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.
Objectives
Setup
Explorer Mode
[x] Create a database to store Movies
[x] Create a Database that will store a log of Bank Transactions for an account
Adventure Mode
Turning In
Your homework will be assigned to you via
issueson yourassignmentsrepository. Once you areThese 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.
First, let's add all our work to git, and ask it to commit it:
Feel free to replace "My first webpage" with a more meaningful message.
Push our local commits to GitHub:
The files I am looking for are:
For SQL only Assignments, Add
.sqlcontaining your queries to your repo.Additional Resources