YoVDO

Working with Data and Schemas in Marten 1

Offered By: Pluralsight

Tags

PostgreSQL Courses Schema Design Courses Data Management Courses Database Optimization Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Marten is an open source library for .NET that enables the use of an underlying PostgreSQL database as a document database. Learn how to work with data and schemas in it!

Marten can be used as a replacement or alternative to other document databases such as MongoDb or RavenDb and can also be an alternative to ORMs such as Entity Framework. While Marten is easy to get started with, it also provides an array of customization, diagnostic, data manipulation, and performance related features that can be additionally employed. In this course,Working with Data and Schemas in Marten 1, you'll learn how to improve query performance, diagnose and log SQL statements, implement offline optimistic concurrency, and customize PostgreSQL schema objects. First, you'll discover how to log and diagnose SQL queries and DDL commands generated by Marten. Next, you'll learn how to prevent data loss with offline optimistic concurrency and how to soft-delete documents. Then, you'll move on to learning how to reduce database round trips, improve PostgreSQL query performance, and how to reduce client CPU costs. Finally, you'll discover how to take control over the PostgreSQL schema objects that Marten defines and creates. By the end of this course, you'll have a better understanding of how to work with data and schemas in Marten.

Syllabus

  • Course Overview 1min
  • Logging and Diagnosing SQL Commands and Schema Changes 34mins
  • Modifying Document Data 28mins
  • Improving Query Performance 33mins
  • Customizing Database Schema Objects 18mins

Taught by

Jason Roberts

Related Courses

Web Application Development: The Data Tier
University of New Mexico via Coursera
Desarrollo de Aplicaciones Web: Nivel de Datos
University of New Mexico via Coursera
Hacking PostgreSQL: Data Access Methods
Ural Federal University via edX
Spatial Data Science and Applications
Yonsei University via Coursera
RDBMS PostgreSQL
Indian Institute of Technology Bombay via Swayam