Join Martin Guidry for an in-depth discussion in this video Designing OLTP databases, part of SQL Server 2012: Designing Database Solutions.
- [Voiceover] In this section,…I'd like to talk about designing OLTP Databases.…OLTP stands for "On Line Transaction Processing."…So these are the types of databases…that support transactions.…And transactions mean data that changes.…Data that will have an update, insert, or delete.…The process of restructuring data into a format…that simplifies transactions is called "Normalization."…The history of normalization can be traced back…to a data scientist named E.F. Codd.…
The goals of normalization include minimizing redundancy,…in other words, not storing the same data more than once.…There are obvious inefficiencies…of storing the exact same data twice,…and it makes it more difficult to update that data.…Normalization should simplify addition, deletion,…and modifications of data.…And normalization typically leads to…having multiple tables with defined relationships.…These relationships are where we get…the word, "relational" database.…
The three most common forms of normalization…are simply called 1st Normal Form,…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- 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.Cancel
Take 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.