A Practical Guide to SQL and Database Fundamentals
Beginner
40 Lessons
17h
Certificate of Completion
Takeaway Skills
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
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
Course Content
Introduction
Database Components
Structuring the Database
Data Retrieval
Data Definition
Data Manipulation
4 Lessons
Transforming Data and Functions
7 Lessons
Database Administration
5 Lessons
Conclusion
1 Lesson
Appendix
4 Lessons
How You'll Learn
You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.
Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.
Learn faster and smarter with adaptive AI tools embedded in every Educative course.
Built-in assessments let you test your skills. Completion certificates let you show them off.
Recommended Courses
BEFORE STARTING THIS COURSE
AFTER FINISHING THIS COURSE