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.
En esta página del sitio puede ver el video en línea How to create a database schema with SQL de Duración hora minuto segunda en buena calidad , que subió el usuario Michael Kaufmann 25 febrero 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 563 veces y le gustó 2 a los espectadores. Disfruta viendo!
