You have no items in your shopping cart.
Course Details
Topic 1 Data Modeling
- Data Sources
- Data Modeling
- SQL Data Types
- Install MariaDB
- Create and Manage Databases
Topic 2 Data Processing and Analysis
- SQL Queries
- SQL Operators
Topic 3 Data Transformation
- Aggregate Data
- Join Data
- Group Data
Topic 4 Introduction to Data Warehouse
- Overview of Data Warehouse
- Relational Databases
- Stored Procedure
Course Info
Prerequisite
This is a beginner course. No SQL or programming language knowledge is required.
Software Requirement
Please download and install MariaDB from the link below
HRDF Funding
Please refer to this video https://youtu.be/Kzpd-V1F9Xs
1- HRD Corp Grant Helper
How to submit grant applications for HRD Corp Claimable Courses
2- Employers are required to apply for the grant at least one week before training commences.
Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.
3- First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my
Second, Click Application
4- Click Grant on the left side under Applications
5- Click Apply Grant on the left side under Applications
6- Click Apply
7- Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply
8- Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:
9- Select your Immediate Officer and click Next
10- Select a Training Provider, then click Next
11- Please select a training programme from the list, then key in all the required details and click Next
Select your desired training programme.
Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.
Explain the background and objective of this training.
Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.
12- If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next
Insert MiCAS Application number
13- Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:
14- Please select a Course Title and Type of Training
15- Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:
16- Please key in the Training Location and click Next
17- Please select the Level of Certification and click Next
18- Please follow the instructions and key in trainee details
19- Click Add Batch, then click Save
20- Click Add Trainee Details
21- Please key in all the required details, then click Add
22- Click Add if there are more participants. Once done, click Save
23- Click Next
24- Please key in the course fees and allowance details, then click Save
25- Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.
26- Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next
27- Complete the declaration form and select a desired officer
28- Add all the required documents, then click Add Attachment. Then, click Save and Submit Application
29- Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.
The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.
Job Roles
- Frontend Developer
- Backend Developer
- Full Stack Developer
- API Developer
- Web Application Developer
- Software Engineer
- Data Engineer
- System Architect
- DevOps Engineer
- Mobile Application Developer
- Cloud Solutions Architect
- Data Analyst
- Product Manager
- UI/UX Designer
- IT Consultant
- Security Specialist
- Database Administrator
- Quality Assurance Engineer
- Technical Lead
- Project Manager
Trainers
Yam Chuan Wee: Yam Chuan Wee is an ICT Consultant at Sustainable Energy Development Authority (SEDA) Malaysia. He has been involved in software development, web development and internet marketing for the last 15 years. He has sold more than 1 million ringgit worth of products as an Amazon Affiliate in 10 months as a part-time hobby. His interest in Software Design, Behavioral Psychology, Social Dynamics, Novel Business Strategies.
Dr Atabak: Dr Atabak has Total of 15 years of experience in software development/architecture and system integration. Broad experience in commercial software architecture and development. Experience in all stages of the software development lifecycle, high performance, and high-availability secure reliable systems. Experienced team and project lead of 10-15 through SDLC iterations, Agile and eXtreme Programming practitioner mentored fellow developers on the various aspects of application architecture and development, work well with customers. Architects solutions in agile and scrum development environments. Deep understanding of technology with a focus on delivering business solutions. Externalizes configuration and business logic to ease client software implementations. Expertise in full project life cycle development including implementation and integration. Successful background working with stakeholders to develop an architecture framework that aligns strategy, processes, and IT assets with a business goal. Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within the organization.
Muhammed Siraj: Muhammed Siraj is an IT executive, lecturer, trainer, security expert, developer, hardware technician, and entrepreneur with over 15 years of experience in the IT profession. He is an experienced IT instructor who has delivered several lecturers in the area of Cybersecurity, Computer Forensics, and Fraud detection to the military, police, CID, Financial Institutions, among others. In addition to training, he provides consultancy services to Educational and Governmental Institutions in the area of computer security and adoption of Open Source solutions. His experience and knowledge acquired from Ghana, Mali, Denmark, South Africa, and Malaysia, enables him to interact with people of different cultural backgrounds very well.
Skillset:
- Degrees in IT, Economics, Psychology. Currently pursuing his PhD in Computer Science (Security in Computing field)
- Certified CEH, CHFI, Hardware repairs and maintenance.
- Data mining, Office automation, filemaker, Fraud detection, Blockchain, Hardware repairs, Google Power Searcher, Drupal/Laravel/CakePHP developer.
- Proficient in Python, Ruby, PHP, Java, Solidity, VBA, Google Apps Script, Javascript, HTML, CSS, SQL.
Cheah Kam Yen: Cheah Kam Yen has more than 10 years project management experience in implementing PMO, software development and ICT infrastructure projects. He gained his structured planning and project management skills through real-life, hands-on experience with the guidance from various mentors and lessons learned from project challenges throughout his career. In his pursuit of improvement, he has been certified as Project Management Professional (PMP) by Project Management Institute (PMI) and PROJECT+ Certified Professional by CompTIA (Computer Technology Industry Association). Currently, he is attached to Mesiniaga as a Project Manager in the Project Management Unit (PMU).
Ghoncheh Babanejad: Ghoncheh Babanejad is a Ph.D. student at Faculty of Computer Science & Information Technology at Universiti Putra Malaysia. She is working on recommender systems in the field of Skyline evaluation for a group of mobile users for her Ph.D. thesis. She is also working on PHP, HTML, Adobe Photoshop, Cpanel, Rational Rose, MS Visio, Microsoft Project, MySQL, Dream Weaver, Word Press. She received several certificates in Web Site Preliminary Design(Jihad Daneshgahi), Client-Side Web Programming(Jihad Daneshgahi) and MongoDB for DBAs (MongoDB Inc). She has more than 5 years experience in IT Department And Project Control Department of ACP (Amin Chemical Processes) company
Mohammad Reza Aminian: Mohammad Reza Aminian is a software engineer and PhD candidate in field of Artificial Intelligence with more than 4 years experience of teaching web technologies and scripting languages. skilled in PHP, JavaScript, system design, Laravel and Vue.js frameworks. He has been involved in development and implementation of web based management systems, web applications and APIs in different organizations and companies.
