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.
Sur cette page du site, vous pouvez voir la vidéo en ligne How to create a database schema with SQL durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Michael Kaufmann 25 février 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 563 fois et il a aimé 2 téléspectateurs. Bon visionnage!
