Join our 5-Day Coding Challenge and Build Your First Ecommerce Website! Learn More Here.

Coming Soon!

from HK$9,750

Database and Data Engineering

9 weeks, Part-time

Coming Soon!

Taught in:

Hybrid Flex

Join class on-campus or watch via online livestream

HK$ 12,500

or 12 payments of

HK$1,042

over 12 months with

or 3 payments of

HK$4,167

over 3 months with

Remote Learner

Join lectures via livestream from anywhere

HK$ 9,750

or 12 payments of

HK$813

over 12 months with

or 3 payments of

HK$3,250

over 3 months with


Course overview

In this 9-week part time database and data engineering 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 SQL database 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.

Upon completion of the database and data engineering course, students will obtain practical experience in doing data engineering practice projects, and a database and data engineering certificate. If you are looking for improvement in database and data management knowledge, join the Xccelerate database and data engineering course now!

...

Course Delivery

Course schedule - Monday to Friday

Daily lectures on course material

Weekly face-to-face tutorials

Co working space available

Offline mentor support (5 days a week)

Campus hot desk available to all students

Access anytime or anywhere

Access to all recordings in case you miss a lecture

Online support from mentors

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

Course schedule

Apr 19 - Jun 23, 2021

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

Course closed

100%

booked

Dates or times don't work for you?


Instructors and support team

Danny Vu

Database and Data Engineering Instructor

Feature Comparison

Hybrid Flex

 icon

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

8 Months extended access

Lecture Recordings

24/7 Access During Bootcamp

Career Opportunities

Profile listing on Xccelerate talent database

Hong Kong Tech Career Guide

Access to the Xccelerate Hiring Network

Personal Interview Prep

Personal CV Review

Personal LinkedIn Review

Soft Skills Training

Receive job posts from Xccelerate network

Job Negotiation Training

Tech Industry Speaker Series

Coming Soon!

Taught in:

Hybrid Flex

Join class on-campus or watch via online livestream

HK$ 12,500

or 12 payments of

HK$1,042

over 12 months with

or 3 payments of

HK$4,167

over 3 months with

Remote Learner

Join lectures via livestream from anywhere

HK$ 9,750

or 12 payments of

HK$813

over 12 months with

or 3 payments of

HK$3,250

over 3 months with


Frequently Asked Questions

Xccelerate was founded to address the main concerns that our students found lacking in traditional offline and even online learning environments. What you will find with us that does not come standard with a majority of other options is: - Our dedication to practical hands-on training environments that keep you accountable to your own success but also provide access to a modern curriculum with the aid of expert instructors. - For our immersive programs, we provide an in-house career support team as opposed to many other institutes where you are left to fend for yourself. Your job search progress will be closely followed up by our career consultants throughout the duration of the immersive program and even after graduation. - Our career team organizes various career events, e.g. networking evenings, guest sharing, workshops, etc. With such a commitment, we have achieved 91% successful hiring rate in the previous cohorts. Your success is our success! - Access to an always growing tech community. All Xccelerate students are invited to join our exclusive learning community, which is a platform of sharing and receiving news related to tech, such as the latest tech inventions, tech-talent roles openings, etc, allowing alumni and all stakeholders to discuss.

Our bootcamp programs are completely immersive. We teach from zero and expect you to have job-ready skills after the course. While it is not fully required to have pre-existing hard tech skills before the course, we highly recommend completing pre-course prep work that will be assigned before the course begins to best set you up to succeed.\n\nThe immersive courses are engineered to produce the best possible outcomes within 16 weeks, therefore students should fully understand the commitment and work ethic required to complete the program.

You can schedule a free course consultation with us by emailing admissions@xccelerate.co where we will address your current career situation as well as your desired outcomes to help point you in the right direction.

We do not offer trial classes at the moment as it turns out to be quite distracting for current students and instructors, but we recommend you to schedule a campus tour with our Admissions Manager at +852 68838583. You can observe the class and talk to our instructors if necessary to learn more about the course.

There are usually 15-20 students within each full time immersive course. In terms of in-house support offered by Xccelerate, our instructors are constantly available through dedicated channels that we have so that students can be walked through the course on a step by step level.

Accelerating humanity by educating workforces