AI Features
Log In
0% completed
All Lessons
Free Lessons (4)
Introduction
Course Roadmap
Importance of Databases and SQL
Database Components
Tables, Schemas, Columns, and Keys
Constraints and Views
Stored Procedures and Triggers
Quiz: Database Components
Structuring the Database
Introducing Database Normalization
Advancing Database Normalization
SQL Data Types
Quiz: Structuring the Database
Data Retrieval
Query Execution Process
Guidelines for Writing Query
Basic Query Syntax
Learn Data Retrieval Through Practice
Quiz: Data Retrieval
Data Definition
Data Definition Language (DDL)
Learn DDL Through Practice
Running the DDL Script
Quiz: Data Definition
Data Manipulation
Data Manipulation Language (DML)
Learn DML Through Practice
Running the DML Script
Quiz: Data Manipulation
Transforming Data and Functions
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
Backup, Recovery, and Database Restore
Learn Backup, Recovery, and Restore Through Practice
Login, Users, and Roles
Learn Server Logins, Users, and Roles Through Practice
Quiz: Database Administration
Conclusion
Wrap Up
Appendix
Downloading and Installing SQL Server Express
Download SQL Server Management Studio (SSMS)
The Basics of SSMS and Its Features
Attaching AdventureWorks database
Home
Courses
A Practical Guide to SQL and Database Fundamentals
Wrap Up
We will wrap up this course.
We'll cover the following...
Congratulations, you’ve reached the end of
...
Ask