3.9 Read 62 reviews
Featured byThe University of Sydney
Overview
This introductory course is suitable for those with little or no prior understanding of relational databases (Microsoft Access, Oracle Database, Microsoft SQL Server, MySQL etc), those who would like to get more value from attending SQL Course Level 2a training, or who want to demystify relational database management systems.
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
Contents include:
- Interpret the narratives that define business rules that form the basis of a databases design
- Simplify business rules to enable database design and the interpretation of database design when answering questions with SQL
- Resolve the metaphor used in relational database management systems and thus SQL
- Discuss a normalised database that stores facts in a single place and the method used to relate facts
- Name and discover the natural cardinalities in a given business narrative
- The create an ERD (Entity Relationship Diagram) for the design of a database using its symbols and their meaning that express those cardinalities to capture business rules using primary keys and foreign keys, constraints and datatypes to enforce cardinalities
Key information
Duration
- Full-time
- 1 days
- Part-time
- 2 days
Start dates & application deadlines
- StartingApplication deadline not specified.
- StartingApplication deadline not specified.
- StartingApplication deadline not specified.
- StartingApplication deadline not specified.
- StartingApplication deadline not specified.
Language
English
Delivered
On Campus, Online
Campus Location
- Newtown, Australia
Disciplines
Information Technology (IT) View 24 other Short Courses in Information Technology (IT) in AustraliaWhat students do after studying
Join for free or log in to access our complete career info list.
Academic 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.
Other requirements
General requirements
- CRICOS Number: 00026A
- Suitable for those with little to no prior understanding of relational database management.
Student Insurance via Studyportals Partner
Make sure to cover your health, travel, and stay while studying abroad. Even global coverages can miss important items like Additional medical costs, Repatriation, Liability etc. Make sure your student insurance covers your needs.
Studyportals 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 The University of Sydney and/or in Australia, please visit Student Insurance Portal.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents465 AUD / full≈ 465 AUD / full -
Domestic Applies to you
Applies to youCitizens or residents465 AUD / full≈ 465 AUD / full
Additional Details
- A$465.00 - A$495.00
Funding
Improve page content