The Art Of Database Design
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Art Of Database Design to your Wishlist.

Add to Wishlist

The Art Of Database Design

Improve and extend practical knowledge of database design in Oracle, SQL Server, MySQL and PostgreSQL.
New
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Created by Tihomir Magdic
Last updated 8/2017
English
Current price: $10 Original price: $130 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • get into details and techniques of database designing in Oracle, SQL Server, MySQL and PostgreSQL
  • find more inspiration, ideas and solutions in database design
  • write robust warehouse system with stock calculation
  • design model where are needs of writing data in bits and bitwise operations
  • design and define a new taxonomy in existing design
  • custom design for internationalization and localization
  • test database design/objects in more complete and systematic way
View Curriculum
Requirements
  • You need to have experience in database modeling and in creating database objects in relational databases.
  • You should be very familiar with creating and using the objects such as tables, table constraints, views, triggers, stored procedures, and functions.
  • It is also necessary to know well SQL syntax, especially the select various types of joins, build in functions...
  • It would be preferable to know at least first three forms of normalization, and have some experience in programming.
  • It would be useful to have a basic knowledge in general business areas such as warehousing, sales or supplies.
Description

Upgrade your database design skills with new ideas and solutions.

Starting with the installation of the relational database and its tools, and with an introduction to each subject, this course will take you through database design best practices in various business domains:

  • taxonomy.
  • warehousing.
  • internationalization/localization and,
  • database testing

It shows you the techniques of:

  • a live stock level calculations, 
  • bitwise operations on relations, 
  • localization, 
  • advanced data searching,
  • plural forms, 
  • basic query optimization, 
  • creating automated database tests of various tests types, etc.

It includes the source codes of the complete course for the 4 most popular relational databases:

  • Oracle
  • SQL Server
  • MySQL, and 
  • PostgreSQL.

All the databases (express editions) and tools (freeware or trial) used in the course can be used completely free of charge. You can choose other databases and tools if you think they are more suitable for you. The source code from the scripts will work on some other databases that are more or less compatible with the listed ones.

With a help of naming convention and crow's foot notation you’ll be able to work alongside the author as you work through each chapter.

It is not for beginners!!!

Suitable for advanced or expert database designers/developers, through this course of 43 lectures and 2 hours of content and complete scripts for most popular relational databases, you’ll learn and establish a strong understanding of the practical and flexible solutions in the field of database design.

You need to have experience in creating all the basic objects in any of the relational databases:

  • tables, 
  • views, 
  • indexes, 
  • foreign keys and,
  • other constraints.

It would be preferable to know at least first three forms of normalization, joins, as well as that you have some experience in programming. By creating tables, views, indexes, and stored procedures you’ll understand practical problems and possible solutions in your future database design practice.

Almost every chapter has exercises to encourage you to think of just learned.

Complete with full scripts of creating users, privileges, and database objects for each chapter, you’ll be able to work on your own solution as a branch of selected solution from the course.

Who is the target audience?
  • Experienced database designers, but also software engineers and software architects.
Compare to Other Database Design Courses
Curriculum For This Course
43 Lectures
02:00:13
+
Introduction
4 Lectures 03:49

Who Is Your Instructor
00:40

Source Codes
00:34

+
Getting Started
4 Lectures 05:29

client tools and alternatives

Client Tools Recommendations
00:38

Crow's foot notation (entities, relationships)

ER Diagram Notation
00:38

naming convention rules for tutorial

Naming Convention
03:12
+
Taxonomy
5 Lectures 26:40

introduction and definition

Preview 01:49

wines and servers taxonomies

Examples And Implementation
16:01

extensions for UI, data relation and data integrity

Taxonomy Extensions
05:53

custom sorting

query optimization

Some Improvements And Optimization
02:26

Exercises
00:31
+
Warehousing
10 Lectures 24:43

document reorganization

Preview 00:50

  • stock calculation
  • documents and document types definitions

Basic Stock Calculations
06:13

support for more warehouses

More Warehouses
02:28

incrementing document's number

Primary keys
03:30

copying documents

document sign

correct stock calculation

Document Cancellation
01:48

  • inventory reading
  • inventory note
  • inventory surplus
  • inventory shortage
Inventory
03:30

  • goods in transit
  • new document types

Transfer Goods Between Warehouses
02:14

optimization of stock calculation

Basic Performance Optimizations
00:50

statuses, document merging, document dependency, stock quantity types...

Possible Extensions
02:46

Exercises
00:34
+
The Weekdays
4 Lectures 07:35
  • working days of stores
  • early implementations
Preview 02:44

bitwise operations

Calculations
01:39

weekdays presets

Presets And Checking
02:51

Exercises
00:21
+
Alternate Keys
2 Lectures 03:52

why alternate key

Preview 02:04

searching, changing key values

Benefits
01:48
+
Internationalization
6 Lectures 18:35
  • definition
  • purpose
  • scopes
  • unicode standard
Preview 01:38


  • translating
  • implementation
  • optimization
Design
14:07

initial dictionary filling

Localization
01:03

localization testing (messages)

Testing Analysis
00:32

Exercises
00:41
+
Database Testing
5 Lectures 27:54
  • data as an important corporate asset 
  • assertion
  • recorded tests
Introduction
08:14

  • recorded test results
  • failed tests
Automatization
06:40

test types

Deep Test Analysis
04:18

existence of tables, columns, primary keys, foreign keys, indexes, triggers, sequences

Tests
08:23

Exercises
00:19
+
Conclusion
3 Lectures 01:36
What’s Next
00:36

Final Words
00:18

Stay In Touch
00:42
About the Instructor
Tihomir Magdic
0.0 Average rating
0 Reviews
8 Students
1 Course
More than 20 years of practice in the design of large-scale business applications

Tihomir Magdic is a passionate and creative software engineer, project manager and database consultant. He started programming at Atari and soon went to national programming contests. He graduated in 1999 from the Faculty of Organization and Informatics in Varazdin, Croatia, major in designing information systems, master of computer science.

He has over 20 years of experience in the development of large enterprise systems (design, database development, programming, UX ...). He has interests in various fields of databases, multimedia, algorithms, user interfaces, microcontrollers, but he loves to develop new concepts and to test his own ideas in practice. He likes to learn but also likes to transfer own knowledge and experience to others.

Some of the things he loves to do in his spare time include scuba diving, wind surfing, mountain biking, traveling to new places, watching football, but most passionate in tae-kwon-do training. He enjoys the most spending time with his wonderful wife and their daughter.