Home>Courses>A Practical Guide to SQL and Database Fundamentals

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.

Beginner

40 Lessons

17h

Certificate of Completion

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.

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

16 Playgrounds

7 Quizzes

Course Overview

What You'll Learn

Course Content

Recommendations

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

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

Course Content

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

Course Author

Jacob Schulz

Trusted by 2.5 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."

Carlos Matias La Borde

Software Developer

"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

"I've tried probably 5-7 different sites and Educative is easily the best. It perfectly blends explanation with interactivity"

Eric Downs

Musician/Entrepeneur

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

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

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!

Recommended before starting this course

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.

beginner

9 hours 40 mins

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.

beginner

13 hours

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.

beginner

8 hours

Course

Getting Started with SQL and Relational Databases

beginner

9 hour 40 min

Course

An Introductory Guide to SQL

beginner

13 hour

Course

Database Design Fundamentals for Software Engineers

beginner

8 hour

Related Courses and Skill Paths

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.

beginner

1 hour

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.

beginner

6 hours 45 mins

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.

beginner

9 hours

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