The Art Of Database Design (Udemy.com)

Improve and extend practical knowledge of database design in Oracle, SQL Server, MySQL and PostgreSQL.

( 1 Reviews )

Created by: Tihomir Magdic

Produced in 2017

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 60 / 100

Course 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 this course is for:

Experienced database designers, but also software engineers and software architects.

Time: 2h

Instructor Details

Tihomir Magdic

3.0 Rating
1 Reviews

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.