Online · Self-pacedFreeIT & SoftwareIntermediateEnglish
Databases and SQL Fundamentals
Storing and querying data properly. Covers the relational model, keys and normalisation, schema design, the SQL query language from SELECT through joins and aggregation, writing and updating data safely, transactions, indexes and performance, and an orientation to NoSQL and analytical stores.
Taught by Icompetent Solutions
- Modules
- 7
- Lessons
- 28
- Duration
- 5h 34m
- Level
- Intermediate
- Quizzes
- 7 graded
- Enrolled
- 1
Industries
Course content
7 modules · 28 lessons · 5h 34m
Understand the intermediate landscape of database engines, workload characteristics, and secure operational patterns.
- Understanding Intermediate Data ArchitecturePreview11 min
- Relational Engine Operation and Foundations10 min
- Preventing SQL Injection and Access Vulnerabilities12 min
- Selecting Workload Patterns: OLTP vs OLAP12 min
- Navigating Relational and Analytical Data Systems Quiz10 questions · pass 70%
Topics covered
Databases
SQL
Data Modelling
Queries
Performance
Prefer to learn with a trainer?
We deliver the same material as classroom and in-house programmes, tailored to your team and your site.
Browse classroom coursesReviews
No one has reviewed this course yet. If you have taken it, yours would be the first.
There are no published reviews for this course yet.
Write a review
Checking your account…