{"course":{"productid":21409,"modality":1,"active":true,"language":"en","title":"Relational Database Design","productcode":"SQL03","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-SQL03","courseware":{"has_ekit":false,"has_printkit":true,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/training-sql03","objective":"<p>You can understand database designs, query correctly and efficiently (with the appropriate SQL knowledge). You can design and create simpler databases.<\/p>","essentials":"<p>Good SQL knowledge as in the course SQL Standard Intensive Training<\/p>","audience":"<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>","contents":"<h5>Motivation<\/h5><h5>Basic terms and DB concepts<\/h5><h5>Data dictionary and meta databases<\/h5><h5>Data integrity<\/h5><ul>\n<li>Data consistency<\/li><li>Data protection<\/li><li>Data security<\/li><li>Transactions<\/li><\/ul><h5>Overview: models<\/h5><ul>\n<li>Hierarchical model<\/li><li>Network model<\/li><li>Relational model<\/li><li>Object-oriented models<\/li><\/ul><h5>Normalize<\/h5><ul>\n<li>From the 1st to the 3rd normal form<\/li><li>BCNF, 4th, 5th normal form<\/li><\/ul><h5>Overview: Design Methods<\/h5><ul>\n<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>\n<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>\n<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>\n<li>Distributed database structures<\/li><li>Graph databases (NoSQL)<\/li><li>Document databases (NoSQL)<\/li><li>Typical cloud data structures<\/li><\/ul>","summary":"<p>Together with your trainer you will work out the basics, implementations and applications of relational database techniques and DWH structures<\/p>","objective_plain":"You can understand database designs, query correctly and efficiently (with the appropriate SQL knowledge). You can design and create simpler databases.","essentials_plain":"Good SQL knowledge as in the course SQL Standard Intensive Training","audience_plain":"DB users who want to get into database creation. Users who want to optimize their queries. People who want to understand and evaluate databases.","contents_plain":"Motivation\n\nBasic terms and DB concepts\n\nData dictionary and meta databases\n\nData integrity\n\n\n- Data consistency\n- Data protection\n- Data security\n- Transactions\nOverview: models\n\n\n- Hierarchical model\n- Network model\n- Relational model\n- Object-oriented models\nNormalize\n\n\n- From the 1st to the 3rd normal form\n- BCNF, 4th, 5th normal form\nOverview: Design Methods\n\n\n- Objectives, principles of design methods\n- Method according to Zehnder\n- ERD from Chen\nThe Entity Relationship Diagram (ERD)\n\n\n- Formation of entity sets and relationships between entity sets\n- Normalizing an ERD and mapping the ERD to data structures\n- Identification keys, foreign keys, global and local attributes\nDefinition of consistency conditions\n\n\n- Inherent, external consistency conditions\n- Classes of consistency conditions\nReproduction of transactions\n\nOutlook, trend of DBMS and trends\n\n\n- Distributed database structures\n- Graph databases (NoSQL)\n- Document databases (NoSQL)\n- Typical cloud data structures","summary_plain":"Together with your trainer you will work out the basics, implementations and applications of relational database techniques and DWH structures","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":1000},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1590},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1590},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1590},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1360},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":5520},"US":{"country":"US","currency":"USD","taxrate":null,"price":1730},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1780},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":2390}}},"lastchanged":"2025-10-24T17:11:30+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/21409","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/training-sql03"}}