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.
Auf dieser Seite können Sie das Online-Video How to create a database schema with SQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Michael Kaufmann 25 Februar 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 563 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
