Lesson Aims:
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
Identify flaws in a databases design
Manipulate 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
Lesson Objectives:
You should Know what HMRC’s role is in collecting taxes and paying benefits
You should Understand why taxes are needed – to pay for the services that are essential for the country
You should be able to explain why taxes are important to the UK economy, society, your family and you
Set yourself a new SMART target on your PDP
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
Identify flaws in a databases design
Manipulate 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
Lesson Objectives:
You should Know what HMRC’s role is in collecting taxes and paying benefits
You should Understand why taxes are needed – to pay for the services that are essential for the country
You should be able to explain why taxes are important to the UK economy, society, your family and you
Set yourself a new SMART target on your PDP
Today I have learnt how to search for duplicate data in DB browser using SQLite.
Today a strength has been understanding how to use SQLite to complete a task.
Today a weakness has been coming in 30 minutes late as I woke up late.
I think that today has been good as I have been able to work on tasks that have been set today.
Due dates: U03 A3T1 08/06/2018,
Due dates: U03 A3T1 08/06/2018,
No comments:
Post a Comment