About the course

About the course

Our database design & SQL course starts you with learning the basic concepts and skills of designing a database and managing it using Oracle SQL.

The training is aimed at people who want to learn the basics of database design and working with SQL to create ad hoc reports. Familiarity with SQL is not necessary.

Like Box Hill Institute - IT & Cyber Security on Facebook Facebook
Follow Box Hill Institute - IT & Cyber Security on Instagram Instagram

Course Details

Back

Sessions Available


Course Content


Upon successful completion of this course you will be able to:

  • describe a relational database
  • describe database normalisation
  • communicate with a relational database using SQL
  • use SQL commands to:
    • create/alter/drop table or view
    • insert/select/update/delete data
    • display/filter/arrange data
    • join tables
  • write advanced SQL queries
  • use of special functions such as date, mathematical and aggregate function
  • export/import data

 

 

Prerequisites


You must have good computer skills.

Is this the course for you?
Enrol now or enquire about this course.

Courses

Interested in IT & Cyber Security?
Discover more

Discover IT & Cyber Security