Useful links
Unit of study_
OLET1301: Managing and Analysing Data with SQL
2023 unit information
Data is the gold of the 21st century. Across all disciplines it is crucial to be able to effectively share and analyse large data collections. Managing data in spreadsheets however only works for small data sets and easily ends in 'Excel Hell'. This OLE introduces databases for scientists and other non-IT disciplines, and will teach the SQL database query language with a focus on developing practical skills for data analysis. Database systems (for example SQL Server or MySQL) are widely used in industry and academia, and are essential for effective sharing of large data collections. The SQL language is a powerful tool for analysing big data without the need to programming. The OLE will be delivered using an interactive online tutorial platform with auto-grading support, and (for 2CP students) online guidance from a human tutor. It is complementary to other OLEs about data-focused computation and programming for data analysis.
Unit details and rules
Managing faculty or University school:
Computer Science
| Code | OLET1301 |
|---|---|
| Academic unit | Computer Science |
| Credit points | 2 |
|
Prerequisites:
?
|
None |
|---|---|
|
Corequisites:
?
|
None |
| Prohibitions:
?
|
INFO2120 OR ISYS2120 OR DATA2001 OR DATA2901 |
| Assumed knowledge:
?
|
None |
At the completion of this unit, you should be able to:
- LO1. create and modify data schemas
- LO2. understand basic integrity constraints and NULL values
- LO3. insert and update information in a database
- LO4. query and analyse the data contained in a database.
Unit availability
This section lists the session, attendance modes and locations the unit is available in. There is a unit outline for each of the unit availabilities, which gives you information about the unit including assessment details and a schedule of weekly activities.
The outline is published 2 weeks before the first day of teaching. You can look at previous outlines for a guide to the details of a unit.
There are no availabilities for this year.
Modes of attendance (MoA)
This refers to the Mode of attendance (MoA) for the unit as it appears when you’re selecting your units in Sydney Student. Find more information about modes of attendance on our website.
