Data modeling for Azure Data Services : implement professional data design and structures in Azure /

Choose the right Azure data service and correct model design for successful implementation of your data model with the help of this hands-on guide. Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Braake, Peter ter (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing, Limited, 2021.
Temas:
Windows Azure.
Windows Azure
Cloud computing.
Database design.
Computer architecture.
Infonuagique.
Bases de données > Conception.
Ordinateurs > Architecture.
Cloud computing
Computer architecture
Database design
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title page
  • Copyright and Credits
  • Contributors
  • Table of Contents
  • Preface
  • Section 1
  • Operational/OLTP Databases
  • Chapter 1: Introduction to Databases
  • Overview of relational databases
  • Files
  • Relational databases
  • Introduction to Structured Query Language
  • Different categories of SQL
  • Understanding the database schema
  • Impact of intended usage patterns on database design
  • Understanding relational theory
  • Pillar 1
  • Elements of a set are not ordered
  • Pillar 2
  • All elements in a set are unique
  • Keys
  • Types of keys
  • Choosing the primary key
  • Integrity
  • The Check and Unique constraints
  • Types of workload
  • OLTP
  • OLAP
  • Summary
  • Chapter 2: Entity Analysis
  • Scope
  • Project scope
  • Product scope
  • Understanding entity relationship diagrams
  • Entities
  • Understanding super- and sub-entities
  • Naming entities
  • Relationships
  • Types of relationships
  • Drawing conventions
  • Recap
  • Creating your first ERD
  • Context of an ERD
  • Summary
  • Exercises
  • Exercise 1
  • student registration
  • Exercise 2
  • airline
  • Chapter 3: Normalizing Data
  • When to use normalization as a design strategy
  • Considering all the details
  • Preventing redundancy
  • How to avoid redundancy
  • The normalization steps
  • Step zero
  • First normal form
  • Second normal form
  • Third normal form
  • Boyce-Codd and the fourth normal form
  • Normalizing
  • a recap
  • An alternative approach to normalizing data
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Integrating separate results
  • Entity relationship diagram
  • Summary
  • Exercises
  • Exercise 1
  • Stock management of a bicycle shop
  • Chapter 4: Provisioning and Implementing an Azure SQL DB
  • Technical requirements
  • Understanding SQL Server data types
  • Numerical data
  • Alphanumerical data
  • Varying-length data types
  • Dates
  • Other data types
  • Quantifying the data model
  • Estimating the database size
  • Analyzing expected usage patterns
  • Provisioning an Azure SQL database
  • Provisioned versus serverless
  • vCores versus DTU
  • Hyperscale and Business Critical
  • Elastic pool
  • Networking
  • Additional settings
  • Tags
  • Review + create
  • Connecting to the database
  • Azure portal
  • Azure Data Studio
  • Data definition language
  • Creating a table
  • Altering a table
  • Dropping a table
  • Inserting data
  • Indexing
  • Clustered index
  • Nonclustered index
  • Automatic tuning
  • Summary
  • Chapter 5: Designing a NoSQL Database
  • Understanding big data
  • Understanding big data clusters
  • Partitioning
  • Getting to know Cosmos DB
  • JSON
  • Modeling JSON
  • Using embedding versus referencing
  • Referring to objects
  • Cosmos DB partitioning
  • Putting it together
  • Key-value databases
  • Modeling key-value databases
  • Other NoSQL databases
  • Gremlin
  • Cassandra
  • Extra considerations
  • Polyglot persistence
  • Concurrency
  • Summary
  • Exercise

Ejemplares similares