Actions and Detail Panel
Training Course: "Data 101: Introduction to Relational Database Management"
Wed. 9 August 2017, 9:00 am – 12:30 pm AEST
Data 101: Introduction to Relational Database Management
Wednesday 9 August 2017
Want to understand what SQLite does? This course will equip you with the concepts, tools and techniques you need to tackle relational database management.
For ODI Open Data Skill Level
This workshop will teach you about organising data, improving quality and boosting usability. You will gain an understanding of what relational databases are and gain some basic skills in SQLite. Over the course you will learn:
- What is a relational database: its strengths and weaknesses
- How it compares to other database technologies
- How information is organised in a relational database
- How to design a relational database
- How to write your own basic SQLite queries to extract information
- An overview of some advanced SQLite features
- What issues you should be concerned about when using relational databases.
The workshop is adapted from the Library Carpentry material originally developed in the UK by staff at the British Library with foundations based on Software/Data Carpentry material.
By the end of the course you will be able to
- Work more effectively with other people who are delivering technical solutions involving relational databases. Know the right questions to ask, and to understand the jargon in the answers you get back
- Have some foundational experience in writing SQLite queries and creating databases. This will allow you to take the next step to manage your data: if you have reached the limitations of using spreadsheets for managing data, a small relational database may be what you are looking for.
This course uses SQLite for its hands-on demonstrations and exercises, but the concepts and skills apply to other relational databases too.
Who is this for?
Data 101: Introduction to Relational Database Management is ideal for those starting to advance towards the Practitioner level of the level of the ODI's Open Data Skills Framework.
It is suitable for researchers, government employees, educators, consultants, policy workers, students, artists, analysts and anyone who wants to explore what data can do for them.
What prior knowledge do you need?
The workshop is designed for non-specialists. No previous data or statistical skills are required; however, comfort with using the web and good computer literacy are essential.
What to bring
- A wifi enabled laptop or iPad if you have one.
- More details will be provided on pre-installing software before the workshop.
What we provide
Morning Tea (tell us if you have any special dietary requirements)
3 hours (9.30am to 12:30pm). Arrive between 9.00 and 9.30am.
Wednesday, 9 August 2017 from 9am for a 9.30am start to 12:30pm at our training facility at the TC Beirne Building, 315 Brunswick Street, Fortitude Valley, Brisbane.
Course cost: $250 + GST
Hoylen Sue (QCIF) is a Data Specialist and experienced instructor. He has over 26 years of experience in the information technology industry, with roles ranging from developer through to technical architect and researcher. His first job was working on a Brisbane-based software company’s relational database product, and he is still using SQLite in his job today. He is impressed by how useful it is, and hopes you will benefit from knowing a tool that has stood the test of time.
Belinda Weaver (QCIF) is an experienced Software Carpentry instructor and Internet trainer. She recently coordinated the Mozilla Science Global Sprint on Library Carpentry, working with over 20 people from six countries to update the material, some of which has been repurposed for this workshop.
About the Queensland Cyber Infrastructure Foundation (QCIF)
QCIF provides the high-performance services, infrastructure and support required to achieve excellence in computation and data-driven collaborative research and its application in industry. QCIF operates with its members and partners delivering services to research throughout Queensland and increasingly via Commonwealth programs to the nation.
ODI Queensland is pleased to offer Data 101: Introduction to Relational Database Management in partnership with the Queensland Cyber Infrastructure Foundation.