Join our 5-Day Coding Challenge and Build Your First Ecommerce Website! Learn More Here.
Coming Soon!
from HK$9,750
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
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 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
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
Apr 19 - Jun 23, 2021
Mon & Wed: 7:30pm-9:30pm
Course closed
100%
booked
Danny Vu
Database and Data Engineering Instructor
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 | |||
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
How is Xccelerate different from the other institutes?
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.
I do not have any tech background, are these courses suitable for me?
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.
I am not sure which full-time and/or part-time courses I should take, is there a way to erase my concern?
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.
Are there any trial classes for me to have a basic understanding of the courses?
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.
How many students in each section of the courses? Would it be possible that the instructors might not be able to take care of all the students?
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.
Featured Courses
Full-Stack Web Development Immersive
Immersive Data Science & Machine Learning
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
Hong Kong's Largest Career Switch Series 2022
Office Address
3/F, Citicorp Centre, 18 Whitfield Rd, Tin Hau, Fortress Hill
10 Ubi Crescent, #05-42 Ubi Techpark, Singapore 408564