A Practical Guide to SQL and Database Fundamentals

A Practical Guide to SQL and Database Fundamentals

Learn databases by knowing the basics of SQL server, data normalization, components, the syntax of SQL statements, and managing databases.

Beginner

40 Lessons

17h

Certificate of Completion

Learn databases by knowing the basics of SQL server, data normalization, components, the syntax of SQL statements, and managing databases.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

16 Playgrounds
7 Quizzes

This course includes

16 Playgrounds
7 Quizzes

Course Overview

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experience with the fundamentals of the SQL Server database including database administration. The course covers the fundamentals of relational databases and database normalization. It offers a practical learning experience of retrieval, definition, manipulation, presentation and transformation of data through SQL functions. You will also learn database administration for backup, recove...Show More

What You'll Learn

An understanding of relational database fundamentals

Hands-on experience with SQL queries and functions on SQL Server

Familiarity with five normal forms illustrated through examples

An understanding of the fundamentals of database administration

What You'll Learn

An understanding of relational database fundamentals

Show more

Course Content

1.

Introduction

Get familiar with SQL, relational databases, essential skills, and career advancement.
2.

Database Components

Get started with database components, constraints, views, stored procedures, and triggers.
3.

Structuring the Database

Examine database normalization processes, SQL data types, and optimizing data integrity.
4.

Data Retrieval

Enhance your skills in SQL data retrieval, query writing, execution, and practical exercises.
5.

Data Definition

Solve problems in defining and managing SQL database structures using DDL commands.
6.

Data Manipulation

4 Lessons

Tackle modifying data with DML, practice through exercises, and run DML scripts accurately.
7.

Transforming Data and Functions

7 Lessons

Master the steps to transform data using aggregates, joins, data presentation, and transformation in SQL.
9.

Conclusion

1 Lesson

Get started with SQL fundamentals, query syntax, data manipulation, and recovery techniques.

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