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 33d 15:17:23
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 33d 15:17:23
60%
booked
Accelerating humanity by future-proofing workforces
Sign up to our newsletter
Featured Courses
Full-Stack Web Development Immersive
Data Science & Machine Learning Immersive
Full-Stack UX Design Immersive
Web Development for Absolute Beginners
Data Science & Machine Learning
Digital Marketing & Growth Hacking
Introduction to FinTech
Introduction to Python
User Experience Design (Fundamentals)
User Interface Design
Introduction to Product Management
Quick Links
About
Corporate Training
Hire Xccelerate Top Talent
Events
Blog
All Courses
Join Us
Teach With Us
FAQs
Entrepreneur X
School Ambassador Program
Future Education Foundation
COVID-19 Economic Recovery Education Fund
Women in Tech Scholarship
1-on-1 Career Consultation
Office Address
3/F, Citicorp Centre, 18 Whitfield Rd, Tin Hau, Fortress Hill