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

/

Add to Favorites

Next Course

5.0

11 Ratings

Get a comprehensive overview of SQL and Relational Databases 101

Show All

Go to class

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

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.

Introduction to Transact SQL

4.5

Udemy 1 learners

Learn More

Explore the essentials of Introduction to Transact SQL

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

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.