Simply download and install your package. With that you have instant answers to all your SQL questions -- data models and code included. Getting started couldn't be easier.
Here's the table of contents for the full package.
With Dofactory .NET you get 15 information-packed chapters, each one covering an in-depth topic together with comprehensive software solutions that make the topic come to life.
It has never been easier to learn rapid SQL development with design patterns, architecture, low query, and more. Get ready for a whole new data developer experience.
Dofactory SQL comes with 2 comprehensive applications which allow you
to experience the data patterns first hand in a real-world application environment.
Below are a few screenshots of the Training App which is a sample .NET application designed for software training companies.
This may seem strange, but numerous SQL patterns have a visual manifestation in the UI.
Those that do are marked with a icon in the application.
Hovering over these icons will display a tooltip that shows which pattern(s) are at work. As you can see below,
many patterns (7 on this page alone) do have an impact on the user experience.
|1. Intro to SQL Patterns|
|2. Clean Data Models|
|3. Ultra-Clean™ Data Models|
|4. Normalization Patterns|
|5. SQL & Data Access Patterns|
|6. Data Persistence Patterns|
|7. Object-Relational Patterns|
|8. Data Experience Patterns|
|9. Auditing & Archiving Patterns|
|10. Supertype-Subtype Patterns|
|11. Tree & Hierarchy Patterns|
|12. Meta Model Patterns|
|13. Seed Data Models|
|14. Bonus: Pattern Cheat Sheet|
|15. Bonus: Database Coding and Naming Conventions|