Database Foundations
Storage
Heads up! This course may be archived and/or unavailable.
Prepare for the MTA: Database Fundamentals Exam (98-364),
Storage is a database's full-time job. Yet many IT professionals never really learn how it's done. This course is designed to change that, providing a baseline understanding of databases and their mechanics. Adam Wilbert covers normalization, a table structuring technique that reduces data redundancy; primary, foreign, and composite keys—features supporting the table relationships that underlie relational databases; and indexing, which helps speed up data retrieval. Along the way, Adam will provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned.
Contents:
- Introduction
- 1. Creating Normalized Tables
- 2. Adding Key Fields
- 3. Indexing Records
- Conclusion
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1h 22m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Adam Wilbert |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | IT & Networking Data Science Programming |
| Tags | IT Databases Network Administration IT and Hardware SQL Server Database Administration Database Development Microsoft SQL Server |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Relationship Banker - Fulltime $33k
Radiologic Tech Fulltime Sunnyvale $46k
Adjunt Instructor - Databases $56k
RN -Fulltime & PRN Positions (NO Nights, Call or Weekends) $60k
RN-Angiography-St. Peter's Hospital-Fulltime Days $60k
Night Pediatric RN/LVN (Fulltime w Benefits!) $64k
Fulltime Service Bureau Representative $67k
RN -ICU -St. Peter's Hospital-Fulltime Nights $72k
Fulltime Art Director $85k
.NET Web Developer / SQL Databases Consultant $119k
UNIX/Perl Developer / Oracle / SQL Server Databases $126k
Senior Software Engineer - Databases $152k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1h 22m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Adam Wilbert |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | IT & Networking Data Science Programming |
| Tags | IT Databases Network Administration IT and Hardware SQL Server Database Administration Database Development Microsoft SQL Server |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
