Skip to main content
Unit of study_

Managing and Analysing Data with SQL - OLET1301

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.

Assessment
through semester assessment (100%)

Prohibitions

INFO2120 OR ISYS2120 OR DATA2001

Details

Faculty: Engineering and Information Technologies

Semester 1

25 Feb 2019

Department/School: Computer Science
Study Mode: Online
Census Date: 31 Mar 2019
Unit of study level: Junior
Credit points: 2.0
EFTSL: 0.042
Available for study abroad and exchange: No
Faculty/department permission required? No
Location
Camperdown
Courses that offer this unit

Non-award/non-degree study If you wish to undertake one or more units of study (subjects) for your own interest but not towards a degree, you may enrol in single units as a non-award student. Cross-institutional study If you are from another Australian tertiary institution you may be permitted to undertake cross-institutional study in one or more units of study at the University of Sydney.

To help you understand common terms that we use at the University, we offer an online glossary.