insert into plsql_challenge_quizzes ( quiz_type, frequency, start_date ) values ( 'Database design', 'Weekly', date '2013-10-05' ); That's right, the weekly database design quiz starts tomorrow, authored by me!
For more details, keep reading:
Relational databases form the backbone of thousands, if not millions, of applications around the globe. A key part of building these applications is designing and implementing the data structures they use. Proper table design can mean the difference between a scalable, high performing database that is a joy to query and an unscalable mess that makes your brain melt.
Given the importance of databases, understanding good data modelling techniques and physical implementation methods are essential skills for architects, database administrators and developers creating database applications.
Building on the SQL and PL/SQL quizzes already available at the PL/SQL Challenge, the weekly Database Design Quiz kicks off on 5 October to help you build these skills. The quiz will cover many areas of database design, from logical design all the way to physical database design, including topics such as:
- Normalization – ensuring you have high quality data
- Referential integrity – saving you the time and effort of writing your own constraints
- Indexing – enabling you to write fast and efficient queries
Whether you’re an experienced data modeller or completely new to relational databases, the weekly Database Design Quiz offers you the opportunity to both learn new approaches and show off your expertise. It will teach techniques that you can use to improve the quality for your work and impress future employers with your achievements.
Registering is quick, easy and free. If you’re not already a member of the PL/SQL Challenge, then head to www.plsqlchallenge.com and sign up for a free account. Let the Database Design competition commence!