❗The content presented here is sourced directly from ThaiMOOC platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 28th, 2023]
What skills and knowledge will you acquire during this course?
By the end of this course, you will have acquired the following skills and knowledge:
Understanding of the relational model and relational model concepts and constraints
Ability to use the five basic SQL statements
Knowledge of advanced SQL syntax and join statements
Ability to write SQL queries to retrieve data from a database
Understanding of database design principles
Ability to create and modify database tables
Ability to use SQL to manipulate data in a database
Ability to use SQL to create reports from a database
Ability to troubleshoot and debug SQL queries
Understanding of database security principles
How does this course contribute to professional growth?
This course significantly contributes to your professional growth by providing essential data management skills, imparting in-demand technical knowledge, improving your employability, offering practical learning experiences, creating career advancement opportunities, and granting you an industry-recognized certificate that enhances your professional profile.
Can I use the course to complement my deeper education in business or related fields?
The course complements your deeper education in business or related fields by providing practical data management skills, supporting data-driven decision-making, fostering technology-business integration, enabling business intelligence capabilities, offering a versatile skillset, and granting you an industry-recognized certificate. By taking this course, you'll gain a valuable edge in the business landscape, where data utilization and proficiency in SQL are highly valued attributes.
Course Syllabus
Module 1 -SQL and Relational Databases 101
Introduction to SQL and Relational Databases Module 2 - Relational Model Constraints and Data Objects
Information and Data Models Module 3 - Data Definition Language (DDL) and Data Manipulation Language (DML)
Types of RelationshipsModule 4 - Advanced SQL
Mapping Entities to TablesModule 5 - Working with multiple tables
Relational Model Concepts