4.6
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.
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
Show more
Content
1.
Introduction
2 Lessons
Get familiar with SQL, relational databases, essential skills, and career advancement.
2.
Database Components
4 Lessons
Get started with database components, constraints, views, stored procedures, and triggers.
3.
Structuring the Database
4 Lessons
Examine database normalization processes, SQL data types, and optimizing data integrity.
4.
Data Retrieval
5 Lessons
Enhance your skills in SQL data retrieval, query writing, execution, and practical exercises.
5.
Data Definition
4 Lessons
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.
8.
Database Administration
5 Lessons
Step through backup, recovery, logins, users, and roles in database administration.
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.
Course Author:
Developed by MAANG Engineers
Trusted by 2.8 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
Hands-on Learning Powered by AI
See how Educative uses AI to make your learning more immersive than ever before.
AI Prompt
Code Feedback
Explain with AI
AI Code Mentor
Free Resources
