1 / 10

Access to SQL

Access to SQL. With Peter Radford and Nik Rowlands.

evette
Download Presentation

Access to SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access to SQL With Peter Radford and NikRowlands

  2. Computational Thinking (CT) is a problem solving method that uses computer science techniques. The term computational thinking was first used by Seymour Papert in 1996. Computational thinking can be used to algorithmically solve complicated problems of scale, and is often used to realize large improvements in efficiency. (Wikipedia ) Computational Thinking

  3. Analyzing and logically organizing data • Data modeling, data abstractions, and simulations • Formulating problems such that computers may assist • Identifying, testing, and implementing possible solutions • Automating solutions via algorithmic thinking • Generalizing and applying this process to other problems Computational Thinking

  4. Analyzing and logically organizing data. • How many phones are on the Orange Network? Microsoft Access

  5. Data modeling, data abstractions, and simulations • Formulating problems such that computers may assist Computational Thinking

  6. SELECT count(*) AS phones_on_orange FROM Mobile_Phones WHERE (((Mobile_Phones.Network)="orange")) GROUP BY Mobile_Phones.Network; Microsoft Access - SQL

  7. SELECT is SQL’s method of querying a database. • What do the following queries do? • SELECT * FROM Mobile_Phones; • SELECT * FROM Mobile_Phones ORDER BY Network; • SELECT * FROM Mobile_Phones WHERE ((Mobile_Phones.Contract) = “Monthly”); • SELECT Make FROM Mobile_Phones GROUP BY Make; • SELECT Manufacturer, COUNT(*) as total_phonesFROM Mobile_Phones GROUP BY Manufacturer; Microsoft Access - SQL

  8. UPDATE does exactly what it says on the tin. • Syntax: • UPDATE tableSET newvalueWHERE criteria; • UPDATE Mobile_Phones SET Network = ‘Vodafone’ WHERE Network = ‘Vodaphone’; • There are 3 Lumia phones which have been misspelt as Lumnia. Microsoft Access - SQL

  9. INSERT • Syntax • INSERT INTO target [(field1[, field2[, …]])] VALUES (value1[, value2[, …]) • MAKE SURE THE DATASHEET VIEW IS CLOSED! • INSERT INTO Mobile_Phones (ID, Manufacturer, Make, Network, Contract, CostPerMonth, PhoneCost, OperatingSystem) VALUES (31, 'Apple', 'IPhone6', 'Orange', 'Monthly', '£49.99', '£59.99', 'IOS'); Microsoft Access - SQL

  10. Identifying, testing, and implementing possible solutions • Automating solutions via algorithmic thinking • Generalizing and applying this process to other problems Computational Thinking

More Related