Database and Data Engineering

Prerequisites

Introduction to Python / Basic Python Knowledge 

Career Paths

Data Engineer, Software Engineer, Data Analyst, Data Scientist 

Course overview

In this 9-week part time course, you will be exposed to the principle building blocks that you can take with you in your aspiring technical career. From computer science principles in Python to database architecture in SQL, this course can give you the complete building blocks to springboard your technical career. The topics covered in this course cover much of the requirements from a computer science degree in university with an emphasis on data.

...

Engagement at the core

Join your class on-campus or via livestream. Either way, our courses are built to keep you focused.

Online office hours

Instructors will be available via livestream on designated days to ensure you get extra help with course materials or assignments

Access course content anytime

Class content will be available for you to access throughout the duration of the course.

Feature Comparison

Hybrid Flex

HK$ 12,500

Remote Learner

HK$ 9,750

Lectures

Option to join lectures online

Option to join lectures on-campus

On-campus hotdesk

Industry-Centric Projects

Individual

Group

Curriculum Access

Unlimited during bootcamp

Lecture Recordings

24/7 Access During Bootcamp


Course plan

Unit 1

Foundations of Programming in Data: Setup, Operators / Expressions, and Control Flow

Using the terminal, Python in the CLI, Choosing an Editor, basics of programming (comments, numbers, strings, variables, naming), indentation and file management in Python

Operators, Expressions, and Control Flow

Unit 2

Data Structures, Methods, and Modularity (Functions / Modules)

Data Structures: Arrays (Lists vs Tuples), HashMap (Dictionaries), Sets and their methods

Functions, passing data to functions, scope, default values, variable arguments, practice writing functions

Unit 3

Object Oriented Programming, I/O, Exceptions

OOP: self, classes, methods, inheritance

Handling user input, dealing with exceptions, problem solving and the software development process. Project introduction.

Unit 4

GitHub, Portfolio, and Project Week

Learning GitHub to build your portfolio

Project Preparation and Presentations

Unit 5

Foundations of Databases: Data Modelling and the Conceptual Schema

Fundamental Database Concepts, Data Modelling, Entity Relationship Diagrams

Database Design, Cardinality, Normalization, Introduction to ERD project

Unit 6

Database Design, ERD Project, and the Logical Schema

ERD Guidance, Project Help, ERD Presentations (Part 1)

ERD Presentations (Part 2), Conversions into the Logical Schema

Unit 7

SQL, the Physical Schema, and Data Modification

Checking conversions, introduction to PostgreSQL, loading a sample database, modifying data, transactions, database management, & table creation. Viewing constraints and relationships

Introduction to SQL queries, filters, joins, groups, & sets

Unit 8

SQL Queries in Depth

Advanced SQL queries - subqueries and common table expressions. Exercises.

Introduction to NoSQL and BigQuery. Integrating SQL and Python via Psycopg2. Introduction to SQL injections

Unit 9

Project Week

Project Preparation

Project Presentation


Instructors and support team

Danny Vu

Database and Data Engineering Instructor


Venue

Hong Kong Island


Course schedule

Feb 22 - Apr 21, 2021

Mon & Wed: 7:30pm-9:30pm

Starts in 37d 15:16:49

60%

booked

Dates or times don't work for you?


Contact Us

Not sure if this is for you?

Feb 22 - Apr 21, 2021

Mon & Wed: 7:30pm-9:30pm

Hybrid Flex

Join class on-campus or watch via online livestream for any class

HK$ 12,500

Remote Learner

Join lectures via livestream from anywhere

HK$ 9,750

Starts in 37d 15:16:49

60%

booked