Overview
What you will learn
By the end of this SQL Course - Level 1 course offered by University of Sydney , you should be able to:
- recognise elements of good and bad database design relevant to SQL and apply those elements when designing a database
- interpret database structures to determine the SQL required to reslove queries
- choose appropriate clauses to write an SQL query
- write SQL queries to answer specific questions
- read SQL queries to determine the result sets produced.
Programme Structure
The program focuses on:
- build a result set from one table
- alias columns in the result set
- derive columns in the result set with arithmetic, intrinsic functions and concatenation
- cull records from a result set with WHERE clause boolean predicates
- involve multiple boolean predicates in the WHERE clause with the logical operators AND and OR using their operator precedence and brackets
- sort result sets with the ORDER BY clause and nested sort orders
- state the purpose of statements and clauses, specifically a SELECT statement, SELECT clause, FROM clause, WHERE clause and ORDER BY clause
- read a statement using the SQL elements above stating what each clause consumes and produces, and the order in which the clauses execute
Key information
Duration
- Full-time
- 1 days
- Part-time
- 2 days
Start dates & application deadlines
- Face-to-face: 1 Feb, 1 Mar, 8 Apr, 9 May, 18 Jun
- Online: 21 Feb, 27 Mar, 23 Apr, 27 May
Language
Delivered
Disciplines
Information Technology (IT) View 45 other Short Courses in Information Technology (IT) in AustraliaAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Student insurance
Make sure to cover your health, travel, and stay while studying abroad. Even global coverages can miss important items, so make sure your student insurance ticks all the following:
- Additional medical costs (i.e. dental)
- Repatriation, if something happens to you or your family
- Liability
- Home contents and baggage
- Accidents
- Legal aid
We partnered with Aon to provide you with the best affordable student insurance, for a carefree experience away from home.
Get your student insurance nowStarting from €0.53/day, free cancellation any time.
Remember, countries and universities may have specific insurance requirements. To learn more about how student insurance work at University of Sydney and/or in Australia, please visit Student Insurance Portal.
Other requirements
General requirements
- CRICOS Number: 0026A
- Suitable for those with little to no prior understanding of relational database management.
Tuition Fee
-
International
450 AUD/fullTuition FeeBased on the tuition of 450 AUD for the full programme during 1 days. -
National
450 AUD/fullTuition FeeBased on the tuition of 450 AUD for the full programme during 1 days.
- Face-to-face: $450.00
- Online: $420.00
Living costs for Sydney
The living costs include the total expenses per month, covering accommodation, public transportation, utilities (electricity, internet), books and groceries.