Author
Released
3/28/2019- Relational databases
- Keys and unique values
- Planning a database
- Creating tables
- Defining relationships
- Normalization and denormalization
- Writing queries
- Sorting results
- Joining tables
- Modifying data
Skill Level Beginner
Duration
Views
- Databases let us work with large amounts of data efficiently. They make updating data easy and reliable, and they help to ensure accuracy. They offer security features to control access to information, and they help us avoid redundancy. A database is a structure that stores information in an organized, consistent, reliable, and searchable way. And there are different kinds of databases intended for different use cases. The kind we'll focus on here is the relational database. These are found in many places, from banking and order processing systems, to mobile apps, to content management systems like WordPress, and beyond. Most of the concepts we'll need to understand when it comes to relational databases are interconnected, and in this course, I'll take a sort of progressive approach to explaining them. We'll cover the very basics of relational databases, and then look at the foundational concepts we'll need to understand how they work. After that, we'll dig into the details more to build on those concepts. So the first or second time I mention something, know that we'll get into more detail as we go. I'm Scott Simpson, and I hope you'll join me in this LinkedIn Learning Course to explore the fundamentals of databases.
Related Courses
-
Learning SQL Programming
with Scott Simpson1h 27m Beginner -
Access 2016 Essential Training
with Adam Wilbert6h 45m Beginner -
Microsoft SQL Server 2016 Essential Training
with Martin Guidry3h 18m Intermediate
-
Introduction
-
Why use a database?1m 4s
-
-
1. Database Foundations
-
Relational databases2m 12s
-
Keys and unique values2m 25s
-
Relationships2m 19s
-
ACID and transactions3m 10s
-
Basic SQL3m 54s
-
-
2. Tables
-
Naming tables1m 36s
-
Columns and data types2m 52s
-
Numbers and other types3m 17s
-
Primary and foreign keys2m 48s
-
3. Relationships
-
Creating relationships1m 4s
-
One-to-many relationships2m 33s
-
One-to-one relationships1m 33s
-
-
4. Database Optimization
-
Normalization1m 5s
-
First normal form2m 39s
-
Second normal form2m 10s
-
Third normal form2m 19s
-
Denormalization1m 51s
-
-
5. Querying a Database
-
Creating a database1m 38s
-
Creating tables2m 35s
-
Writing SQL queries2m 37s
-
Narrowing query results3m 25s
-
Sorting results1m 53s
-
Aggregate functions2m 30s
-
Joining tables3m 20s
-
Modifying data4m 11s
-
-
6. Querying a Database
-
Software options2m 38s
-
Conclusion
-
Next steps1m 5s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Why use a database?