Database Foundations
Core Concepts
Heads up! This course may be archived and/or unavailable.
Prepare for the MTA: Database Fundamentals Exam (98-364),
Understand the core concepts every IT professional should know to start working with databases. This course, the first in a four-part series with database consultant Adam Wilbert, is designed to provide a solid foundation that will serve you throughout your IT career. Learn about the different data storage models and find out how to build your first database with SQL Server—the Express edition, which requires no hardware or special connections for setup. Then discover how to create database objects with the data definition language (DDL) and edit data in your tables with data manipulation language (DML). Adam also covers critical relational database concepts, such as relationships, indexes, and schemes.
Contents:
- Introduction
- 1. Understanding Data Storage Models
- 2. Building Your Server
- 3. Understanding Data Definition Language (DDL)
- 4. Understanding Data Manipulation Language (DML)
- 5. Understanding Relational Database Concepts
- Conclusion
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 2h 14m |
| 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 | Programming IT & Networking Data Science |
| Tags | Developer IT Network Administration IT and Hardware SQL Server 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.
CORE Coordinator $32k
Experis CORE Recruiter $43k
Assistant CORE Administrator $69k
Core Sales $72k
Core Systems Analyst $81k
Core FP&A Analyst $86k
Core Technology Engineer $96k
Core Management $102k
Research Scientist - Advanced Concepts Group $110k
Core Data Engineer $121k
Core Solutions Architect $179k
Principal Core Faculty $192k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 2h 14m |
| 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 | Programming IT & Networking Data Science |
| Tags | Developer IT Network Administration IT and Hardware SQL Server 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
