5/7/2023 0 Comments Create join in idatabaseWhat are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making progress and save you preparation time. Filtering data in a table in DB Browser.'agentcode' of 'orders' and 'agents' table must be same, the following SQL statement. 'custcode' of 'orders' and 'customer' table must be same, 3. 'a' and 'b' and 'c' are the aliases of 'orders' and 'customer' and 'agents' table, 2. You can download the latest version of DB Browser for free from To create a view 'ordersview' by three tables 'orders', 'customer' and ' agents' with following conditions. Please note: In order to use this lesson you MUST download and install DB Browser on every computer prior to the lesson. This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time. This teaching resource includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers. Please note this lesson will NOT teach them how to interrogate an SQL database using Python and it instead teaches them how to create an external database using DB Browser.ĭownload the preview file now to read the full teacher’s lesson plan for yourself and see exactly what is covered. Each employee has a name, identification number, address, salary and birthdate. An employee is assigned to one department but can join in several projects. We need to record the start date of the employee in each project. It is perfect for pupils studying programming in Advanced Placement (AP) classes.Īlthough pupils are not using Python at all in this lesson and are instead using DB Browser it sets them up for the next lesson in the series (available from here) which does allow them to start interrogating an SQL database using Python. We also need to know the direct supervisor of each employee. It also introduces them to the concept of primary keys. In this lesson the pupils create an SQL database using DB Browser (free software) which helps them understand what tables are, the importance of field names and the data types used in an SQL database. This lesson is perfect to for students learning how to create their own SQL databases using DB Browser and SQLite.
0 Comments
Leave a Reply. |