Database Design and Administration
Servoy provides easy to use tools to create tables and columns in your database, but the underlying database design and structure will have a huge impact on your application. This course covers standard database principals that can be applied to all database vendors (MySQL, Postgres, SQL Server, etc). You’ll learn the core purpose of the database, normalization, when to denormalize, picking the right keys, basic SQL syntax, subqueries, joins, indexes, example design principles, transactions, locking, and more!
Overview
Servoy provides easy to use tools to create tables and columns in your database, but the underlying database design and structure will have a huge impact on your application. This course covers standard database principals that can be applied to all database vendors (MySQL, Postgres, SQL Server, etc). You’ll learn the core purpose of the database, normalization, when to denormalize, picking the right keys, basic SQL syntax, subqueries, joins, indexes, example design principles, transactions, locking, and more!