SQL03FLFast LaneFL-SQL031.0<p>You can understand database designs, query correctly and efficiently (with the appropriate SQL knowledge). You can design and create simpler databases.</p><p>Good SQL knowledge as in the course SQL Standard Intensive Training</p><p>DB users who want to get into database creation. Users who want to optimize their queries. People who want to understand and evaluate databases.</p><h5>Motivation</h5><h5>Basic terms and DB concepts</h5><h5>Data dictionary and meta databases</h5><h5>Data integrity</h5><ul> <li>Data consistency</li><li>Data protection</li><li>Data security</li><li>Transactions</li></ul><h5>Overview: models</h5><ul> <li>Hierarchical model</li><li>Network model</li><li>Relational model</li><li>Object-oriented models</li></ul><h5>Normalize</h5><ul> <li>From the 1st to the 3rd normal form</li><li>BCNF, 4th, 5th normal form</li></ul><h5>Overview: Design Methods</h5><ul> <li>Objectives, principles of design methods</li><li>Method according to Zehnder</li><li>ERD from Chen</li></ul><h5>The Entity Relationship Diagram (ERD)</h5><ul> <li>Formation of entity sets and relationships between entity sets</li><li>Normalizing an ERD and mapping the ERD to data structures</li><li>Identification keys, foreign keys, global and local attributes</li></ul><h5>Definition of consistency conditions</h5><ul> <li>Inherent, external consistency conditions</li><li>Classes of consistency conditions</li></ul><h5>Reproduction of transactions</h5><h5>Outlook, trend of DBMS and trends</h5><ul> <li>Distributed database structures</li><li>Graph databases (NoSQL)</li><li>Document databases (NoSQL)</li><li>Typical cloud data structures</li></ul>You can understand database designs, query correctly and efficiently (with the appropriate SQL knowledge). You can design and create simpler databases.Good SQL knowledge as in the course SQL Standard Intensive TrainingDB users who want to get into database creation. Users who want to optimize their queries. People who want to understand and evaluate databases.Motivation Basic terms and DB concepts Data dictionary and meta databases Data integrity - Data consistency - Data protection - Data security - Transactions Overview: models - Hierarchical model - Network model - Relational model - Object-oriented models Normalize - From the 1st to the 3rd normal form - BCNF, 4th, 5th normal form Overview: Design Methods - Objectives, principles of design methods - Method according to Zehnder - ERD from Chen The Entity Relationship Diagram (ERD) - Formation of entity sets and relationships between entity sets - Normalizing an ERD and mapping the ERD to data structures - Identification keys, foreign keys, global and local attributes Definition of consistency conditions - Inherent, external consistency conditions - Classes of consistency conditions Reproduction of transactions Outlook, trend of DBMS and trends - Distributed database structures - Graph databases (NoSQL) - Document databases (NoSQL) - Typical cloud data structures2 jours1000.001590.001590.001590.001360.005520.001730.001780.002390.00