Pearson Vue Certified IT Specialist Databases

Topic 1 Database Design

• Given a scenario, design tables for storing data
• Given a scenario, identify the appropriate primary key
• Given a scenario, choose data types to meet the requirements
• Given a scenario, design relationships between tables
• Normalize a database
• Given a scenario, identify data protection measures

Topic 2 Database Object Management using DDL

• Construct and analyze queries that create, alter, and drop tables
• Construct and analyze queries that create, alter, and drop views
• Construct and analyze stored procedures and functions
• Given a scenario, choose between clustered and non-clustered indexes

Topic 3 Data Retrieval

• Construct and analyze queries that select data
• Construct and analyze queries that sort and filter data
• Construct and analyze queries that aggregate data

Topic 4 Data Manipulation using DML

• Construct and analyze INSERT statements
• Construct and analyze UPDATE statements
• Construct and analyze DELETE statements

Topic 5 Troubleshooting

• Troubleshoot data object management query failures
• Troubleshoot data retrieval query failures
• Troubleshoot data manipulation query failures

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

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:

TBD

Hardware: Window or Mac Laptops

• Database Administrator
• SQL Developer
• Data Analyst
• Junior Data Engineer
• Business Intelligence Analyst
• IT Support Specialist
• Software Developer
• Application Developer
• Systems Analyst
• Backend Developer
• Data Quality Analyst
• ETL Developer
• Report Developer
• QA Engineer (Data Focused)
• Junior Database Designer
• Technical Support Engineer
• Junior DevOps Engineer
• Technical Business Analyst
• Information Systems Technician
• Database Tester

Terence Ee: Terence Ee is a ACTA certified trainr that has delivered IT training in Singapore and Myanmar. He has also facilitated faith formation courses for Christians in Singapore and Myanmar. As a trainer, his mission is to co-create insightful and actionable learning experiences with his learners.His current areas of focus include project management, information security management, quality management and office productivity applications.

Terence has more than 25 years of corporate IT experience. He has held senior management roles in the public and private sectors. He holds a Master of Science in Technology Management, a Bachelor of Science in Computer and Information Sciences, a Diploma in Family Education, and the Advanced Certificate in Training and Assessment (ACTA). Part of his spare time goes towards tutoring his children in their studies (while learning a thing or two along the way). He is also imparting to them the essential skills for thriving in a digital world.

Praveen Dayal: Praveen Dayal is a ACTA certified trainer. Praveen Dayal have over 30 years of experience in PMP,PMI-ACP,CISA,CISM,CRISC and CDPSE. Praveen Dayal  Have designed solutions for Banking & Finance, ICT, Manufacturing industry verticals and are facilitating training programs such as Project Management (PMP, ACP, ASM, pMF), Risk Management (PMI-RMP, CRISC), Information and Cyber Security (CISM, CSA) and IS Audits and Compliance (CISA).

Agus Salim: Agus Salim is a professional with more than 10 years of experience in Project Management, IT Solutions Management, and Systems Integration both in waterfall and agile methodology. He started out his career as a Web Developer before moving on to Business Analyst/Project Manager. He has strong leadership and the capability of leading a team with a proven ability to deliver projects with tight timelines. Besides his experiences in managing projects, he has good knowledge in Cybersecurity and hands-on experience in Next Generation Firewall such as Check Point. During his free time, he likes to explore Cloud Technology, especially on Microsoft Azure. Agus has obtained AZ-104, AZ-500 and other Microsoft certifications. I am also a ALCP certified trainer.

Truman Ng: Truman Ng is a ACTA certified trainer that graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project.

Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States.

Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philipines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc.