Core Database Fundamentals
Training Provider: NTUC LEARNINGHUB PTE. LTD.
Course Reference: TGS-2024043997
S$540
Original: S$1,800
Save S$1,260
About This Course
This 5-day course is designed to provide a comprehensive foundation in database fundamentals using MySQL, a popular open-source Relational Database Management System (RDBMS).
What You'll Learn
• Explain core database concepts and the role of MySQL as a relational database management system.
• Design and implement normalized database structures using Entity-Relationship Modeling.
• Install, configure, and administer a MySQL server.
• Use MySQL clients to interact with databases.
• Write basic and advanced SQL queries to retrieve, manipulate, and analyze data.
• Understand joins, subqueries, and views for complex data manipulation.
• Implement basic techniques for optimizing query performance.
• Design and implement normalized database structures using Entity-Relationship Modeling.
• Install, configure, and administer a MySQL server.
• Use MySQL clients to interact with databases.
• Write basic and advanced SQL queries to retrieve, manipulate, and analyze data.
• Understand joins, subqueries, and views for complex data manipulation.
• Implement basic techniques for optimizing query performance.
Entry Requirements
• Some familiarity with basic file system navigation, browser, and other tools usage.
• Preferably from simple math’s or analytical background (not mandatory).
• No prior coding experience is required.
• Non-IT domain users switching to IT.
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from NTUC LEARNINGHUB PTE. LTD.
• Evaluate organisational requirements and business needs for cloud solutions
• Evaluate new a...
• Evaluate organisational requirements and business needs for cloud solutions
• Evaluate new a...
• Discuss foundation concepts of cybersecurity principles.
• Explain how organizations respond ...