5/6/2018

Use a SQL commands to interrogate a multi table database
Present information in a suitable way


Learning Outcomes (what the learner will be able to do)

Import data to DBBrowser
Export data from DBBrowser
Identify how data may be suitable, accurate and relevant
Refine the search using the WHERE command
Use logical operators to be more selective in SQL
Identify specific data from multiple tables as requested
Reformat a field in a table
Identify valid but inaccurate data
Interrogate edit large sets of data to present useable information
Interrogate large sets of data to present accurate, valid and usable information
Work towards completed assignment 3Manipulate data in Excel to produce useful information


Learning Objectives (skills, knowledge & attitudes)

Develop SQL query skills
Present data for a purpose
Edit and process data for a purpose

Today I made a start on breaking apart and altering the three different tables which were part of a games sales database for unit 3. I really thought about what I could do in the database to make sure the data is kept accurate, reliable and useful to a company and I started to do things like remove blank fields and change the column titles to my liking.

The next piece of work that I have due is U35 A1T1 in which I need to put in lots of work for to hand it in on time.