Webinar: Introduction to SQL and Databases
Dates: | 26 March 2020 |
Times: | 15:00 - 16:00 |
What is it: | Webinar |
Organiser: | Cathie Marsh Institute for Social Research |
How much: | Free |
|
For large datasets, e.g. millions of records, a dedicated database environment would be the storage medium of choice. A database environment is designed to store data efficiently while at the same time making the retrieval of the data you want very straight forward using simple to learn SQL queries. The often hidden advantage of a database system is that the actual database storage can be on a remote server whilst the query environment is on your desktop. The only data that takes up memory on your machine are the records returned by your queries.
This free webinar, organised by the UK Data Service, will explain various different database environments and storage regimes and show you how easy it can be to start retrieving data using standard SQL queries.
Book a place at https://www.ukdataservice.ac.uk/news-and-events/eventsitem/?id=5591
About the webinar series: getting data, storing data, manipulating data
All projects need data. You either generate it yourself via surveys or the like, you get some from the UK Data Service, or you find some means to beg, borrow or steal it. If you didn’t generate it yourself, the chances are it is not quite what you wanted but you can adapt it to your needs. You adapt the data by a variety of means; cleaning the data, extracting parts of the data (and ignoring the rest) and trickiest of all joining data from different sources.
This series of three webinars will cover some ways of dealing with these data issues using both familiar software tools such as Excel and others that you be aware of but haven’t had any direct experience of.
Travel and Contact Information