uAdvance

SQL 1A

This is a jampacked day where you will move from not having worked with databases on SQL to creating, updating, querying and deleting your own tables. You will learn how to extract your required data efficiently and in good practice This course uses sqlite3 syntax may vary slightly depending on database management system (DBMS) used at your work. There is a strong focus on data governance.
Participants will learn and introduction to SQL including the following key concepts:

  • Database concepts and terminology
  • Learning about the database and schema
  • Data governance and security concepts
  • Database concepts and terminology
  • Basic syntax including:
  • SELECT | WHERE | IN | ORDER BY | GROUP BY | INSERT | UPDATE | DELETE | JOIN (INNER, LEFT, RIGHT, FULL)
    NULL | LIMIT | LIKE | INTERSECT | UNION | EXCEPT | HAVING | PRIMARY KEY | FOREIGN KEY

    The amount for the SQL 1A single day session is: $670 + GST

    SQL 1B

    This is another jampacked day, however, basic concepts from 1A are assumed knowledge and we dive right in to:

  • Data Manipulation
  • Advanced SQL Techniques
  • Subqueries and nested queries
  • Common table expressions (CTEs)
  • Performance Optimization
  • Indexing and query optimization
  • Handling large datasets
  • Practical Exercises
  • Real-world financial database scenarios
  • Hands-on practice and troubleshooting
  • The amount for the SQL 1B single day session is: $670 + GST

    Course Materials

    This course is an adaptation of Harvard university’s CSS50’s Introduction to Databases with SQL.
    It has been adapted for the financial services industry in Australia.
    If students are looking to attain a verified certificate or transfer credit and accreditation, this course will supplement and prepare them for the course’s problem sets and final project.