How to create a database schema with SQL
#sql #databases #bigdata #datamodeling
In this chapter, you'll learn to
analyze the structure of a data source,
identify entities, properties, and relationships,
design a data model,
create a table on the database server using SQL,
implement relationships between tables, and
normalize a table structure.
Get the book:
Kaufmann, Michael & Meier, Andreas: SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management, 2nd Edition.
👉🏼 https://www.amazon.com/SQL-NoSQL-Data...
This book offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques, and examine coming innovations.
The book opens with a broad look at data management, including an overview of information systems and databases, and an explanation of contemporary database types:
SQL and NoSQL databases, and their respective management systems
The nature and uses of Big Data
A high-level view of the organization of data management
Michael Kaufmann is a professor at the Lucerne University of Applied Sciences and Arts. He teaches database systems, and researches intelligent data management. Michael Kaufmann studied computer science, law and psychology at the University of Fribourg. With a part-time dissertation, he earned a doctorate in computer science in 2012 on the topic of inductive fuzzy classification in marketing analytics. He worked at PostFinance as a data warehouse power user in business development. Later at Mobiliar Insurance as a data architect in enterprise architecture; and as a business analyst at FIVE Informatik AG. Since 2014 he works at the Lucerne University of Applied Sciences and Arts in teaching and research. He is married and father of three sons.
Nesta página do site você pode assistir ao vídeo on-line How to create a database schema with SQL duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Michael Kaufmann 25 Fevereiro 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 563 vezes e gostou 2 espectadores. Boa visualização!
