SQL and Relational Databases 101

Course Feature
  • Cost
    Free
  • Provider
    ThaiMOOC
  • Certificate
    No Information
  • Language
    English
  • Start Date
    On-Demand
  • Learners
    No Information
  • Duration
    3.00
  • Instructor
    /
Next Course
5.0
11 Ratings
Get a comprehensive overview of SQL and Relational Databases 101
Show All
Course Overview

❗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 Relationships

Module 4 - Advanced SQL

Mapping Entities to Tables

Module 5 - Working with multiple tables

Relational Model Concepts
Show All
Recommended Courses
free sql-for-data-science-16126
SQL for Data Science
2.5
Coursera 0 learners
Learn More
This course, SQL for Data Science, is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will learn how to retrieve and work with data, and use SQL to select data from tables, create new tables, filter and pare down results, combine data, and use case statements. You will also discuss topics on data governance and profiling, and practice using real-world programming assignments. By the end of this course, you will be able to interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes.
free introduction-to-transact-sql-16127
Introduction to Transact SQL
4.5
Udemy 1 learners
Learn More
Explore the essentials of Introduction to Transact SQL
free implementing-etl-with-sql-server-integration-services-16128
Implementing ETL with SQL Server Integration Services
2.0
Edx 278 learners
Learn More
Gain an introduction to Implementing ETL with SQL Server Integration Services
free sql-tutorial-full-database-course-for-beginners-16129
SQL Tutorial - Full Database Course for Beginners
5.0
freeCodeCamp 13 learners
Learn More
This SQL Tutorial - Full Database Course for Beginners is an online course designed to teach beginners the basics of SQL. It covers topics such as what a database is, tables and keys, SQL basics, MySQL installation, creating tables, inserting data, constraints, updating and deleting data, basic queries, company database introduction, creating a company database, more basic queries, functions, wildcards, union, joins, nested queries, on delete, triggers, ER diagrams introduction, designing an ER diagram, and converting ER diagrams to schemas. This course is comprehensive and provides a great introduction to SQL for beginners.
Favorites (0)
Favorites
0 favorite option

You have no favorites

Name delet