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.



National Code 0008OT003
Study Areas Certifications
Software Development
Study Level Short Course

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

 

 

You must have good computer skills.

Last updated: December 12, 2018 03:35pm