HomeCoursesA Practical Guide to SQL and Database Fundamentals

AI-powered learning

Save

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.

4.6

40 Lessons

17h

Join 2.9 million developers at

LEARNING OBJECTIVES

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

Learning Roadmap

40 Lessons7 Quizzes

Introduction

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

Course Roadmap

Importance of Databases and SQL

Database Components

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.

Data Retrieval

5 Lessons

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

Data Definition

4 Lessons

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

Data Manipulation

4 Lessons

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

Transforming Data and Functions

7 Lessons

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

Database Administration

5 Lessons

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

Conclusion

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.

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

Developed by MAANG Engineers

ABOUT THIS COURSE

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.

ABOUT THE AUTHOR

Jacob Schulz

Driven by finding solutions with technology and automating/scripting where possible to best utilize resources and time, as well as being a fan of learning in many areas of life.

Learn more about Jacob

Trusted by 2.9 million developers working at companies

These are high-quality courses. Trust me the price is worth it for the content quality. Educative 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

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