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.
In questa pagina del sito puoi guardare il video online How to create a database schema with SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Michael Kaufmann 25 febbraio 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 563 volte e gli è piaciuto 2 spettatori. Buona visione!
