The duration of a CodeRage Conference presentation is generally 45 minutes. Each replay includes video and audio.
Your Search Keywords: BASICS
Seven Deadly Sins of Designing Databases
Jason Tiret – Embarcadero
Relevant to: ERStudio
This session focuses on the seven most common mistakes software developers make while designing databases and how to correct them. Learn the basics of normalization and data modeling, defining consistent data definitions and other best practices for designing quality database applications. The session focuses on beginning to intermediate data modeling techniques and is targeted for software developers who want to enhance their data modeling skills and design better database applications.
Starting with the XML basics, learn about well formed and valid documents, encoding, and recoding and XSD validation. See examples in Delphi for Win32 and Delphi Prism showing you which tool to choose when. Finally, learn where things can go wrong and how to prevent that: improper but well formed XML, copying data between XML documents, convert XML to tables and objects, etc.
Relevant to: Delphi, InterBase SMP, Blackfish SQL
Delphi developers can choose between many databases on the market for their database-applications. Embarcadero offers InterBase and BlackfishSQL - both are great products. Many Delphi developers are facing the fact though, that they have to support one of the “big players” with their application. Oracle is used very often in big environments and then it's good when the developer can say: "Oracle database, no problem." This session opens the door to this database, explain the basics, what is different from smaller databases and how the databases tools from Embarcadero can help you to produce an excellent product in a very efficient way with Delphi for Oracle databases.