Information Technology (IT)beginner
Database Fundamentals and SQL
A practical introduction to relational databases and SQL for IT professionals, covering data modeling, table design, queries, joins, transactions, indexing, normalization and basic database administration. Completion certifies course training, not a vendor certification.
9h13 lessonsCertificate included
$244.00
Enroll now- Rich lessons, games & a final exam
- Lifetime access to course content
- Verifiable certificate (valid 24 months)
What you'll learn
- Explain relational database concepts and how data is organized in tables
- Write SQL queries to retrieve, filter, sort and aggregate data
- Join multiple tables and design a normalized schema
- Use transactions and indexes to protect and speed up data operations
- Understand basic database administration and backup practices
Syllabus
1. Introduction to Databases · 1 lessons
- Read: Introduction to Databases7 min
2. Tables, Rows and Columns · 1 lessons
- Read: Tables, Rows and Columns7 min
3. Basic SQL Queries with SELECT · 1 lessons
- Read: Basic SQL Queries with SELECT7 min
4. Aggregating and Grouping Data · 1 lessons
- Read: Aggregating and Grouping Data7 min
5. Joining Multiple Tables · 1 lessons
- Read: Joining Multiple Tables7 min
6. Data Modeling and Normalization · 1 lessons
- Read: Data Modeling and Normalization7 min
7. Modifying Data with INSERT, UPDATE and DELETE · 1 lessons
- Read: Modifying Data with INSERT, UPDATE and DELETE7 min
8. Transactions and Data Integrity · 1 lessons
- Read: Transactions and Data Integrity7 min
9. Indexes and Query Performance · 1 lessons
- Read: Indexes and Query Performance7 min
10. Database Security and Access Control · 1 lessons
- Read: Database Security and Access Control7 min
11. Database Administration Basics · 1 lessons
- Read: Database Administration Basics7 min
12. Database Careers and Next Steps · 1 lessons
- Read: Database Careers and Next Steps7 min
13. Final exam · 1 lessons
- Final exam (25 questions)25 min