Course Details
Course Details
What You'll Learn
Topic 1: AI-Assisted SQL Data Modelling and Database Design
Topic 2: SQL Data Processing, Querying and Analysis
Topic 3: SQL Data Aggregation and Transformation
Topic 4: Data Mapping, Warehousing and Dashboard Development
Course Info
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
You will need the following for this course:
- MySQL Community Server – free
- MySQL Workbench – free
- Visual Studio Code – free
- An AI coding assistant with a free tier, e.g. GitHub Copilot Free in Visual Studio Code
Hardware: Windows PC or Mac laptop
Job Roles
Job Roles
- Database Administrator
- Data Analyst
- Business Analyst
- Systems Analyst
- IT Support Specialist
- Back-End Developer
- Report Developer
- Data Scientist (beginner level)
- Financial Analyst (working with databases)
- CRM Administrator
- ERP Specialist
- Marketing Analyst
- HRIS Specialist
- Product Manager (data-driven products)
- Technical Project Manager
Trainers
Trainers
Dr. Alfred Ang has spent much of his recent engineering work inside relational databases, designing the schemas behind the platforms he builds and runs. He is the founder of Tertiary Courses and the Managing Director, CIO, CTO and Chief Instructional Designer of Tertiary Infotech Academy Pte Ltd, and he works hands-on as a full-stack AI developer, Agentic AI solution architect, courseware developer and corporate trainer. His data credentials include Microsoft Certified Power BI Data Analyst (PL-300) and Data Scientist (DP-100), together with Neo4j Certified Professional and AWS Certified Solutions Architect. He is also an IBM certified instructor for the AI Practitioners course and has worked in the defence, electronics and semiconductor industries, and he holds a PhD in Electrical Engineering from NUS, an MSc in Electrical and Electronic Engineering from NTU and a B.Sc (Hons) in Physics from NUS. Among his 300+ public GitHub repositories, ai-mms is a course-registration LMS and TMS running on OpenMage, PHP and MySQL that handles funding workflows and automatic class formation, while ai-exams and tertiary-hrms rely on PostgreSQL for exam bundles, checkout, leave accrual and Singapore CPF payroll. Smaller builds show the same thinking at teaching scale: cnbacademy includes a browser-based SQLite course assistant, and kacificlogistics turns CSV stock data into a filterable, sortable inventory dashboard with derived stock status. He builds with AI coding assistants such as Claude Code, for which he has published his own skills, so he knows first-hand where they write excellent SQL and where a human still has to check the joins and question the numbers.
In AI Vibe Coding for SQL, Dr. Ang shows analysts, developers and business users how to describe what they need in plain English and let assistants such as Claude, ChatGPT, Cursor and GitHub Copilot write the SQL, while making sure every learner understands what the code is doing. The course opens with AI-assisted data modelling and database design, where learners ask the AI to propose tables, data types, keys and relationships, then challenge its choices before creating a working database. They move on to processing, querying and analysing data, then to aggregation and transformation, grouping and summarising records into the figures a business actually needs, and finish with data mapping, a simple warehouse structure and a dashboard built on the results. Drawing on his PL-300 background, he connects the dashboard topic to the reporting work most learners already do. His teaching style is practical and iterative: write a prompt, run the query, inspect the output, spot the mistake and refine, which is exactly how he works on his own systems. He pays particular attention to the habits that keep AI-generated SQL safe, such as testing on sample data, checking row counts and never running an unreviewed update against live tables. As an ACTA-certified trainer and DACE-certified curriculum developer, he keeps the pace comfortable for non-programmers while giving technical learners enough depth to apply the skills immediately. To explore his database-backed systems, view his GitHub portfolio at https://github.com/alfredang and connect with him on LinkedIn at https://www.linkedin.com/in/angchewhoe/
Ken Hiong is an ACTA-certified trainer with scripting and database experience, having worked on projects using MySQL, PHP, HTML, CSS, WordPress, VBA and Power BI. His career in the healthcare and pharmaceutical industry spans functional and managerial roles in sales, marketing, business development, finance, business analysis and planning, and he is a proven expert Excel user who has improved data analysis and the quality of business planning and reporting for organisations. He graduated with a Pharmacy degree and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. Ken holds the MS Office Master qualification and continually upgrades his IT skills.
In AI Vibe Coding for SQL, Ken brings his MySQL and business analysis background to designing and querying relational databases with AI coding assistants such as Claude, ChatGPT, Cursor and GitHub Copilot. Learners start with AI-assisted data modelling and database design, then move on to SQL data processing, querying and analysis. They practise aggregating and transforming data, and finish with data mapping, warehousing and dashboard development, connecting naturally to Ken's experience with Power BI and business reporting. Throughout, participants describe what they need, review the SQL the AI writes and refine it until the results are right. Learners leave with a solid understanding of SQL and a faster, AI-assisted way to answer business questions from data.
Dr. Alvin Ang is an ACTA-certified trainer focused on real-world data science. He completed his PhD, master's and bachelor's degrees at NTU, Singapore, and while he is an operational researcher by study, his passion for practical applications outweighs his academic background. He has worked as a Principal Consultant in data science and as an Assistant Professor, and he spent eight years as an adjunct lecturer at SUSS. He also owns a startup, which keeps his teaching anchored in the way data is actually used to run a business.
In AI Vibe Coding for SQL, Dr. Ang brings his data science perspective to designing, querying and managing relational databases by giving natural-language instructions to AI coding assistants such as Claude, ChatGPT, Cursor and GitHub Copilot. Learners begin with AI-assisted data modelling and database design, then move to SQL data processing, querying and analysis, followed by aggregation and transformation. The course closes with data mapping, warehousing and dashboard development. His practical, analysis-first approach helps learners frame the right business question, check that the AI's queries return correct results and turn data into usable insight. Participants leave able to work productively with SQL without memorising every piece of syntax.
Mohamed Afiq is an ACTA-certified trainer and web developer whose closest expertise for this course is building data-driven web applications. He has built multiple web apps using MEAN or similar stacks, and he spent three years as a startup CTO, building a proprietary delivery system from scratch and then managing a team of 20 developers. He is the founder and sole developer of PlayTours, and he is a lead instructor at CodeNinja, teaching coding to children aged 9 to 16 and teaching adults front-end and back-end web development.
In AI Vibe Coding for SQL, Afiq brings this back-end development experience to designing, querying and managing relational databases through natural-language instructions to AI coding assistants such as Claude, ChatGPT, Cursor and GitHub Copilot. Learners begin with AI-assisted data modelling and database design, then work through SQL data processing, querying and analysis, followed by aggregation and transformation. The course closes with data mapping, warehousing and dashboard development. His experience building the data layer behind real applications helps learners think about how the database will be used before asking the AI to create it, and to check that its queries return the right results. Participants leave able to work productively with SQL without memorising syntax.
Fritz Lim is an ACTA-certified trainer and software developer with more than 15 years of teaching experience in IT, programming and web development. He has delivered training across polytechnics, private academies and professional institutions, specialising in React, JavaScript, Node.js and Firebase. His real-world projects include a seat allocation system web app built with React, Firebase and Node.js.
Fritz brings his application development background, rather than a specialist database administration career, to AI Vibe Coding for SQL. His experience building web applications on Firebase and Node.js helps learners understand why good data models and well-formed queries matter to the applications that depend on them. He guides participants as they give natural-language instructions to AI coding assistants for SQL data modelling and database design, querying and analysis, aggregation and transformation, and data mapping, warehousing and dashboard development. His hands-on, project-based teaching encourages learners to review and test every query the AI writes, so they leave able to work with relational databases confidently and accurately. Learners also see how well-structured data feeds the warehouses and dashboards that support everyday business decisions.
Review
Write Your Own Review
- Recommended Courses