In this course, you will learn the essential skills for defining, creating, and managing relational database tables using SQL. The course covers the process of creating a relational table with SQL code, altering the structure of an existing table, and identifying the attributes of a relational table. Through hands-on tasks, you will become familiar with SQLiteStudio, the database management system used in the course.
Throughout the course, you will be exposed to guidelines and rules that database designers use to ensure that the tables keep the data as safe and accurate as possible. You will also learn to use SQL code to incorporate constraints that help enforce these rules. By the end of the course, you will understand how well-designed and correctly created tables improve data integrity and make data retrieval easier.
Certificate Available ✔
Get Started / More Info
Advanced MySQL Topics is a comprehensive course covering advanced database engineering skills in MySQL, including optimization techniques, data analytics, and the...
Introduction to Databases is a comprehensive course covering database concepts, SQL commands, and database design. Gain a strong foundational knowledge in database...
Use the Apache Spark Structured Streaming API with MongoDB to stream and store data, and perform dataset joins with Python.
Prep for Microsoft Azure Data Engineer Associate Cert DP-203 equips you to excel in designing, processing, securing, and optimizing data storage with Azure Databricks...