Home>
Courses>

Getting Started with SQL and Relational Databases

Getting Started with SQL and Relational Databases

Beginner

62 Lessons

9h 40min

Certificate of Completion

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

108 Playgrounds
8 Quizzes

This course includes

108 Playgrounds
8 Quizzes
Course Overview
What You'll Learn
Course Content

Course Overview

Relational databases store data in a row-based table structure. Structured Query Language (SQL) is a core language used to retrieve data from the relational database. One of its most widely used extensions, MySQL, also gives you the power to edit, create, and manage the queried data. In this course, you’ll be introduced to the basics of relational database management with SQL. You’ll use MySQL to create a table, edit the data, and even change the structure. You’ll also create indexes to quickly access data...Show More

TAKEAWAY SKILLS

Database

Sql

Database Design

Data Extraction

What You'll Learn

Get a strong understanding of relational databases and Structured Query Language (SQL).

Get a working knowledge of creating, managing, and transforming a MySQL data table.

Learn to create and leverage indexes to quickly access data within a database.

Learn to filter, limit, group, and order a database using SQL queries.

Learn to merge multiple tables into a single database using advanced SQL functions.

Get hands-on experience to create, manage, sort, filter, and edit a MySQL database.

What You'll Learn

Get a strong understanding of relational databases and Structured Query Language (SQL).

Show more

Course Content

1.

Getting Started

Overview of the Course
Introduction to Relational Database Management SystemsData ModelingConceptual vs. Actual Model of a DatabaseSummaryQuiz on the Basics of RDBMS
2.

Manage MySQL Server

Get Started with the MySQL ServerCommunicate with the MySQL ServerSummaryQuiz Yourself on Installing and Communicating with MySQL server
3.

Basic SQL Commands

Introduction to SQL CommandsCreate and Select a DatabaseCreate TablesInsert Data into a TableRestricting the Specific RowsDeleting Rows from TablesUpdate Rows on a TableRetrieve Data Using the like OperatorSummaryQuiz on SQL QueriesChallenge: Create a TableSolution: Create a Table
4.

Add Columns and Indexes

Add a New ColumnIndexesCreate an IndexRemove an IndexUnique IndexesSummaryQuiz on IndexingChallenge: Create IndexesSolution: Create Indexes
5.

Count and Sort Records

Create Table Products
Insert Product DataSort ResultsLimit the Number of Resulting RecordsSummaryQuiz on Counting, Sorting, and Limiting ResultsChallenge: Limit RecordsSolution: Limit Records
6.

Foreign Keys

10 Lessons

7.

Joins, Left Joins And Subqueries

12 Lessons

8.

Conclusion

1 Lesson

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

Anthony Walker

@_webarchitect_

Evan Dunbar

ML Engineer

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Adaptive Learning

Explain with AI

AI Code Mentor

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath