HomeCoursesA Practical Guide to SQL and Database Fundamentals

Beginner

17h

A Practical Guide to SQL and Database Fundamentals

Gain insights into SQL and database fundamentals. Delve into data manipulation, administration, and normalization with practical tasks using SQL functions for backup, recovery, and user management.

Join 2.7 million developers at

Overview

Content

Reviews

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, recovery and restore followed by managing the users, roles and privileges. This course will teach you how to perform tasks related to SQL Server databases with hands-on experience. It covers the complete range of day-to-day operations.

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experi...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

An understanding of relational database fundamentals

Content

40 Lessons7 Quizzes

Introduction

2 Lessons

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

Course Roadmap

Importance of Databases and SQL

Database Components

4 Lessons

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

Tables, Schemas, Columns, and Keys

Constraints and Views

Stored Procedures and Triggers

Quiz: Database Components

Structuring the Database

4 Lessons

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

Introducing Database Normalization

Advancing Database Normalization

SQL Data Types

Quiz: Structuring the Database

Data Retrieval

5 Lessons

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

Query Execution Process

Guidelines for Writing Query

Basic Query Syntax

Learn Data Retrieval Through Practice

Quiz: Data Retrieval

Data Definition

4 Lessons

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

Data Definition Language (DDL)

Learn DDL Through Practice

Running the DDL Script

Quiz: Data Definition

Data Manipulation

4 Lessons

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

Data Manipulation Language (DML)

Learn DML Through Practice

Running the DML Script

Quiz: Data Manipulation

Transforming Data and Functions

7 Lessons

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

Aggregates and Joins

Learn Aggregates and Joins Through Practice

Data Presentation

Learn Data Presentation Through Practice

Data Transformation

Learn Data Transformation Through Practice

Quiz: Transforming Data and Functions

Database Administration

5 Lessons

Step through backup, recovery, logins, users, and roles in database administration.

Backup, Recovery, and Database Restore

Learn Backup, Recovery, and Restore Through Practice

Learn Server Logins, Users, and Roles Through Practice

Quiz: Database Administration

Conclusion

1 Lessons

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

Wrap Up

10.

Appendix

4 Lessons

Go hands-on with downloading, installing, and managing SQL Server Express and SSMS.

Downloading and Installing SQL Server Express

Download SQL Server Management Studio (SSMS)

The Basics of SSMS and Its Features

Attaching AdventureWorks database

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

Course Author:

Jacob Schulz

Developed by MAANG Engineers

Every Educative lesson is designed by our in-house team of ex-MAANG software engineers and PhD computer science educators, and developed in consultation with developers and data scientists working at Meta, Google, and more. Our mission is to get you hands-on with the necessary skills to stay ahead in a constantly changing industry. No video, no fluff. Just interactive, project-based learning with personalized feedback that adapts to your goals and experience.

Trusted by 2.7 million developers working at companies

"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"

Anthony Walker

@_webarchitect_

"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"

Evan Dunbar

ML Engineer

"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."

Software Developer

Carlos Matias La Borde

"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"

Souvik Kundu

Front-end Developer

"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."

Vinay Krishnaiah

Software Developer

Hands-on Learning Powered by AI

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

Personalized Interview Prep

Skip the LeetCode grind with a custom roadmap that adapts to your goals. Hands-on practice for Coding Interviews, System Design, and more.

Mock Interviews

Test your skills in a simulated interview setting. Receive personalized feedback based on your performance. Available for Coding Interviews, System Design, and more.

AI Prompt

Build prompt engineering skills. Practice implementing AI-informed solutions.

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.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!

Course

Simple Anomaly Detection using SQL

Gain insights into using SQL for anomaly detection. Delve into applying mean, standard deviation, and z-score to identify and investigate data anomalies, enhancing your analytical skills.

1 h

beginner

Course

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Discover common SQL antipatterns, their pitfalls, and solutions. Gain insights into logical, physical, query, and application antipatterns. Learn about effective, risk-free database practices.

6 h 45 m

beginner

Course

Practical Data Analysis with SQL

Gain insights into advanced SQL data analysis techniques. Explore producing descriptive statistics, handling missing data, and analyzing time series. Discover aggregating results and preparing data for analysis.

9 h

beginner

Course

Getting Started with SQL and Relational Databases

Gain insights into relational databases and SQL. Learn about creating, managing, and editing tables using MySQL. Explore complex queries, indexes, and join functions for efficient data handling.

9 h 40 m

beginner

Course

An Introductory Guide to SQL

Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.

13 h

beginner

Course

Database Design Fundamentals for Software Engineers

Gain insights into fundamental database concepts, relational databases, and entity-relationship diagrams. Learn about normalization techniques and basics of SQL to enhance database efficiency.

8 h

beginner

Course

Simple Anomaly Detection using SQL

beginner

1 hour

Course

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

beginner

6 hour 45 min

Course

Practical Data Analysis with SQL