4 hours of instruction
A deeper dive into the many capabilities of a relational database, how to optimize usage and make sure that your are getting the most use out of your database so that you have a strong base for your applications.
OBJECTIVES
- Learn advanced features and capabilities of a relational database
- Understand aspects of optimization within your database to increase speed and scalability
PREREQUISITES
Databases: Relational
SYLLABUS & TOPICS COVERED
- Advanced Relational Database Concepts
- Object relational mapping (ORMs)
- ACID properties in SQL
- Optimizing Databases
- Transactions in SQL
- Indexing
- Normalization
SOFTWARE REQUIREMENTS
Database software/Snowflake, Terminal, Text editor