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!
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
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
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.
GitHub, Portfolio, and Project Week
• Learning GitHub to build your portfolio
• Project Preparation and Presentations
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
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
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
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
• Project Preparation
• Project Presentation
Request a detailed syllabus
Explore our payment plans and choose the best option for you.
Make 3 payments of HK$ 4,167 over 3 months with 0% interest
New users get HK$80 off when they spend HK$1000 on our courses
Make 12 payments of HK$ 1,042 over 12 months with 0% interest
New users get HK$200 cash reward for opening Livi account with code X#livi
Users can enjoy up to 8% cash back (up to $100 a month)
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 firstname.lastname@example.org 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.
Full-time immersive 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
Blockchain for Developers Course
School Ambassador Program
Future Education Foundation
COVID-19 Economic Recovery Education Fund
Women in Tech Scholarship
Hong Kong's Largest Career Switch Series 2022
Xccelerate, 3/F, Citicorp centre, 18 Whitfield Road, Tin Hau, Hong Kong
Xccelerate Global HK Limited Flat B 12/F, Wing Cheong Commercial Building, 19-25 Jervois Street, Sheung Wan, Hong Kong
10 Ubi Crescent, #05-42 Ubi Techpark, Singapore 408564