Best Database Design Courses

Find the best online Database Design Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Database Design Courses.

Basics of Database Design & Development

Understand basics of database design & development through step by step procedure

Created by Creative Online School - Creative & Engaging Online Courses

"]

Students: 111568, Price: $89.99

Students: 111568, Price:  Paid

Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design. Through this tutorial we will try to teach the basis components of database design and explains how to make a good database design.

Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!

Contents of this course 

  • Introduction and Database Overview 
  • Understanding SQL Types of commands 
  • Tables, Views and Stored Procedures 
  • Database constraints 
  • Database Normalization 
  • ER Diagram 
  • Relational Database Management System 
  • NoSQL 
  • RDBMS vs. NoSQL 

Database Design

Learn relational database Design with practical concepts and examples. This series works with any database system!

Created by Caleb Curry - Educator, YouTube Partner.

"]

Students: 92691, Price: $34.99

Students: 92691, Price:  Paid

Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases:

  • MySQL
  • Oracle
  • Microsoft SQL Server
  • PostgreSQL
  • SQLite
  • MiariaDB
  • and MORE!

We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth.

Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish.

No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy.

After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!

Learn Database Design with MySQL

A Complete Course to Master Database Design using MySQL

Created by Eduonix Learning Solutions - 1+ Million Students Worldwide | 200+ Courses

"]

Students: 76480, Price: $39.99

Students: 76480, Price:  Paid

Database design is one of the most important aspects of Web programming. Successful implementation of any system with Data Storage will always need proper database design. In order to create great database design you will not only have to master the Database technology but will have to master database design process and normalization.

This course will teach you the nuances of proper database design. It will teach you all the hidden tips and tricks and will ensure that you learn all the major concepts of a proper database design. This course will also teach you SQL and you will be a SQL power user by the end of this course.

You will start with basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and database design process. Database design , normalization, structure mapping, keys and junction tables comes next.

The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. So this complete Database course and will surely help you become a Database Design Guru.

Database Design and Management

Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.

Created by Visual Paradigm - Design & Management Tool for Business IT System Development

"]

Students: 74819, Price: Free

Students: 74819, Price:  Free

Database Design and Management is tailor-made for software development teams who need to develop application or software system that require data persistence. There are altogether 14 lectures with more than 2 hours of quality videos. All lectures come with clear voice-over as well as demonstrations to walk you through different tools step by step. We are sure you can master database design and management skills with ease and learn most key features in Visual Paradigm after attending the lectures.

The lectures cover a wide range of contents. Firstly, you will start by an introduction of database design, with description of ERD, entity and column. After gaining a better knowledge about ERD, you can then jump to keys, relationships, database view, triggers and stored procedures. This course also covers database management skills like the generation of database from ERD, database patching and reverse engineering of ERD. Developers may want to study the lecture about ORM for system development with database. Last but not least, the training introduces some best practices in database design and management, as well as the usage of data specification.

Once you have completed this online training, you will know how to design database productively and effectively.

MongooseJS Essentials – Learn MongoDB for Node.js

Learn how to create Mongoose Schemas to build a full CRUD application based on the MongoDB database design.

Created by Patrick Schroeder - Software Developer

"]

Students: 73739, Price: Free

Students: 73739, Price:  Free

In this course we will build a simple application to show how to perform full CRUD (create, read, update, delete) operations within Node.js.

We'll be using the Node module MongooseJS. Mongoose allows us to define our models in the form of a schema, along with a simple to use API that abstracts away a lot of the pain of working directly with the MongoDB driver.

First, we will create a Book schema using MongooseJS. We will use string data types to add a title, author and description. Next, we will build a simple server using Express.js. Then we will build 4 routes to query, update and delete Books from our Schema. We will use Postman to perform actions on these routes and check the results in our browser.

What You Will Learn

  • Build CRUD Applications
  • Create Mongoose Schemas
  • Design Routes using Express.js
  • Create a Server using Express.js
  • Build a RESTful API

SQL for Beginners: Learn SQL using MySQL and Database Design

Understand SQL using the MySQL database. Learn Database Design and Data Analysis with Normalization and Relationships

Created by Tim Buchalka's Learn Programming Academy - Professional Programmers and Teachers - 1.24M students

"]

Students: 65076, Price: $89.99

Students: 65076, Price:  Paid

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don't know where to start?

Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn.

Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases.

Whatever the reason you have arrived here, this course will...

Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities.

Key concepts you will learn and work with in this course.

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design
Data Analysis

The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy.  You will struggle to find another MySQL course that has a section on this.   This section alone, will give you a huge edge over other applicants for jobs.

Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section.

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases.

In addition there are installation videos covering MySQL on Windows, Mac or Linux.

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database.

Why enrolling in this course is the best decision you can make.

Become skilled as a database developer generally needs you to learn SQL, a database, and then database design.  Often this will require multiple courses.  However you learn all those topics, and data analysis in this one course.

Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday.  Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to  teach you how to become proficient with SQL, MySQL and Database design as quickly as possible.

If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you!

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.  

SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course.

Your new job or consulting opportunity awaits!  

Why not get started today?

Click the Signup button to sign up for the course!

Relational Database Design

Learn how to create an effective relational database design to use in your IT career or even a personal project.

Created by Ben Brumm - IT Software Consultant

"]

Students: 40112, Price: $49.99

Students: 40112, Price:  Paid

Learn how to design a proper relational database with this course!

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier.

If you want to improve your software development career, get into database admin or database design, or are just curious on this topic, this course is for you.

You don't need to know SQL or have any programming experience to be able to take this Relational Database Design course.

This course includes:

  • Almost three hours of video lessons
  • Included PDF files of the database diagrams at keys steps will help you learn all about database design.
  • The topics covered include normalisation and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships.

The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram.

I also show you how to download and install the software that is being used for this.

What topics are covered in this database design course?

The topics covered are:

  • We'll walk through a sample database
  • Reason or why the database is needed
  • Some advantages of relational databases
  • Identify entities for the tables and attributes
  • Create tables and columns
  • Reorganise them to make the layout and design more efficient.

If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you.

You'll learn all you need to be able to design an effective database!

SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

Created by Sagar Uppuluri - Software Architect and a passionate trainer

"]

Students: 28323, Price: Free

Students: 28323, Price:  Free

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant. 

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema. 

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features.  Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises

Created by Kirill Eremenko - Data Scientist

"]

Students: 24890, Price: $89.99

Students: 24890, Price:  Paid

Are you interested in a career in Data Science or Data Analytics?

In that case, inevitably you are going to encounter databases in your work.

But how do you interact with databases?

The answer is simple: SQL 

SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request.

In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL. 

And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable.

But there are many SQL courses out there, so the question is:

What makes this course stand out?

The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design.

We will cover off topics such as:

- OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ

- Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step

Why is that important?

Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit.

These skills will allow you to better interact with databases and derive results and extract insights from your data faster.

This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you!

We look forward to seeing you inside,

Kirill & Ilya

The Complete Database Design & Modeling Beginners Tutorial

Learn Database Design the easy way. Go from simple to complex with a real life example: online store's DB using MySQL.

Created by Rares Ilea - Web Applications Developer | IT Consultant

"]

Students: 18374, Price: $94.99

Students: 18374, Price:  Paid

Are you new to Databases and Database Design? Do you feel like you’re left guessing how to properly design the database for your project? ..Or maybe you just want to add this on-demand skill to your CV.

Our Database Design Beginner’s Tutorial is here to help. Here’s how:

  • Learn by Designing a Real Life Database from A to Z. The tutorial covers the design of an online store’s database. By the end of the course you will learn how to apply database design concepts to a real project, not just a mock, nonsense database. You will eliminate guesswork and design a database confidently.

  • Going from simple to complex in simple, incremental steps: you won’t feel overwhelmed by the complexity of database design. Every new concept will develop naturally, making database design feel easy peasy.

  • Several examples for each theoretical definition: Database design theory can be daunting. Following every theoretical aspect with several practical examples makes it easier to understand.

  • Short & Sweet: No rambling. Straight to the point. This is a tutorial that you’ll actually finish. Just the right amount of theory and practical examples that will enable you to take action fast and apply what you’ve learned on your projects!

NEW (2018) Quiz Test! 35 Popular Database Design Interview Questions. 

You will learn the answers to the following topics:

  • What is a database?

  • How do databases work? The power of database indexes.

  • What are some different types of database management systems (DBMS)

  • What is a relational database? What are tables, columns, primary keys, foreign keys, relationships, and much more

  • What is database design and why is database design important?

  • What are the 3 levels of database design? Conceptual, Logical and Physical database design.  

  • Data modeling and database design tools. You will also learn how to setup MySQL Workbench on your computer and how to design a database with its aid.

  • What database normalization is and how to apply the three normal forms (1NF, 2NF, 3NF)

  • What does data redundancy mean?

  • How to design and create database relationships: one-to-one, many-to-one and many-to-many.

  • Complete the design of an online store’s database. Create entities and attributes for:  products, items, customers, categories, brands, reviews, etc.

  • Finally, you'll learn how to use forward engineering (a feature of MySQL Workbench) to create the actual database on MySQL Server.

  • Every technical lecture has attached a screenshot of the resulting database schema

This tutorial is perfect for professionals, entrepreneurs or students who need to integrate databases in their projects and use data more efficiently than using Excel or simply add Database Design to their CV and make a step forward in their career.

Here are some comments from students after taking this course:

“Fantastic fast pace course, well presented and explained backed up with many examples.”  

Danny Schell

“The instructor has in depth knowledge abut databases and database design.I would highly recommend this course for any one trying to learn the fundamentals of database design and table relationships further more learn how to create physical databases ..this course is the basis for a strong understanding of the chapters covered.

I highly recommend it.” 

Zak

“This tutorial fulfill it's promised. It is simple to understand and to the point. I think the author is very experienced and know what he is talking about. No need to ask what else do we, the student need, just make it happen.” 

Alcides Apaza Yanarico

The Complete Database Design and Modeling Beginners Tutorial is a heck of a deal compared to the cost of time spent on searching for this information all over the Internet and putting it together in a well structured way; not to say having a real life example on how to design a database step by step.

Because this tutorial takes you through a series of incremental steps, from simple to complex, with real life examples, Database Design will be easy to understand.

Buy NOW and join our 10812+ students community that are learning Database Design and improving their skills just like you. Learn Database Design easily or get your money back! Our course is backed up with Udemy’s 30-day 100% money-back guarantee, there's no reason to hesitate.

Join NOW and get exclusive deals and special offers, including free courses, available only to our students through student’s announcements. 

Special thanks to artmonkey & makyzz / Freepik for the course image design.


MySQL, SQL and Stored Procedures from Beginner to Advanced

A beginners' guide to MySQL queries, database design, transactions and stored procedures.

Created by John Purcell - Software Development Trainer

"]

Students: 17955, Price: $29.99

Students: 17955, Price:  Paid

This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you.

Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database.

MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.

Master Advanced MySQL Features, Starting from the Ground Up

In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures.

You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool.

By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.

Complete SQL and Databases Bootcamp: Zero to Mastery [2021]

Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises!

Created by Andrei Neagoie - Senior Software Developer / Founder of zerotomastery.io

"]

Students: 17277, Price: $99.99

Students: 17277, Price:  Paid

Just launched with all modern SQL and Databases (PostgreSQL, MySQL, + more) features for 2021! Join a live online community of over 400,000+ students and a course taught by industry experts that have actually worked both in Silicon Valley and Toronto managing databases. This is one of the most in demand tech skills in the world right now with SQL being used for many years to come (it has been around since the 1970s and going stronger than ever)!

Using the latest best practices in SQL, Database Management and Database Design, this course is focused on efficiency. Never spend time on confusing, out of date, incomplete tutorials anymore. Graduates of Andrei’s courses are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, + other top tech companies.

We guarantee you this is the most comprehensive online resource on Databases like PostgreSQL and MySQL. This project and exercise based course will introduce you to all of the modern toolchain of an SQL developer or anyone using a database in the workplace (Product Manager, Business Analyst/Intelligence, Data Analyst, Data Scientists, Machine Learning Engineer, Web Developer, Mobile Developer + any role requiring insights from data). Along the way, we will learn practical and real world skills that will get you hired.

The curriculum is going to be very hands on as we walk you from start to finish of working with databases and SQL, all the way into learning how to scale databases, how to manage them, and even bonus material on working with Big Data, Caching using Redis, and connecting PostgreSQL to a Node.js server. We even talk about pros and cons of choosing an SQL Database vs NoSQL like MongoDB. We will start from the very beginning by teaching you SQL and Database Fundamentals and then going into advanced topics so you can make good decisions and work with any data that your company has no matter how complex!

The topics covered are:

- NoSQL (MongoDB) vs PostgreSQL, MySQL vs NewSQL

- SQL Theory And Concepts

- The Relational Model

- SQL Basics

- SQL Functions

- Data Modification Language / DML

- Data Query Language / DQL

- Subqueries

- Indexes

- SQL Filtering / WHERE Statement

- 3 Valued Logic

- SQL JOINS

- Window Functions

- Date Filtering and Timestamps

- SQL Aggregate Functions

- SQL Operator Precedense

- SQL ORDER BY

- SQL GROUP BY

- SQL Top Down Design

- SQL Bottom Up Design

- SQL Entity Relationship Diagram

- SQL Normalization

- Database Types

- The role of a DBMS

- Multi Table SELECT

- The Software Development Lifecycle / SDLC

- POSTGRES Role Management

- POSTGRES Permission Management

- POSTGRES Backup Strategies

- POSTGRES Transaction Management/ SQL Transactions

- POSTGRES/SQL Data Types

- SQL Views

- Redis Database

- Elasticsearch

- Connecting A Database To A Server/Web App (Node.js)

- Data Engineering (Kafka, Hadoop, etc...)

- Sharding

- Replication

- Backups

- Vertical + Horizontal Scaling

- Distributed vs Centralized Databases

- Big Data + Analytics

- Database Security (SQL Injections, Access Control, etc...)

+ more

With SQL you will be able to work with all databases like: PostgreSQL, MySQL, Oracle SQL, Microsoft SQL Server, IBM DB2, SQLite, MariaDB, Amazon Redshift, Presto, Apache Hive with Hadoop, and many many more because SQL is everywhere!

You see, data is everywhere and it is the most valuable asset in the world. All the top companies need people that can work with data. That is where this course comes in. Unlike most tutorials out there, this course encompasses many fields working with many databases. Whether you want to get into the tech industry, you’re a mobile or web developer, a data scientist, a machine learning engineer, a business analyst, even sales and marketing or you have your own company. Any role that requires you to work with data will need to know this valuable skill that is SQL (how to interact with databases, analyze, and use data).

Here is the thing though. There are many courses on this topic.

Let me tell you 3 reasons why this course is different from any other SQL/PostgreSQL/MySQL/Database tutorial online:

1. In this course you will learn to work with not just 1 but many Databases like MySQL, PostgreSQL, Microsoft Server, Redis, and so much more. No prior programming or technical experience is necessary. We take you from absolute zero, all the way to mastery. We will go above and beyond to not just teach you SQL commands but to teach you advanced techniques, best practices, database design and how to think about performance, security, and scalability.

2. This course is taught by actual professionals who have experience and have worked with databases for some of the largest companies in the world. Mo is a super star when it comes SQL. He has built software for the European Union, launched products for 5 Fortune 500 companies, and has consulted at Google. Andrei has worked on enterprise level apps for large tech firms in Silicon Valley as well as Toronto and has also taught others tech skills that got them into big companies like Google. By having both Andrei and Mo teach, you get to see different perspective and learn from 2 engineers as if you are working at a company together.

3. We are going to have fun here. The course starts off with you getting hired at Keiko Corp to investigate their recent Database breach. Because we believe in learning by doing, you will be doing tons of real life assignments and exercises along the way, and eventually get to the point where you can help Keiko Corp solve their mystery by looking at their databases and analyzing hidden information. Our goals is that everyone has fun and is successful after completing the course :)

This course is not about making you just watch along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial. No! This course will push you and challenge you to go from an absolute beginner in SQL and Databases to someone that is in the top 10% of SQL and Database experts!

Taught By:

Andrei is the instructor of the highest rated Development courses on Udemy as well as one of the fastest growing. His graduates have moved on to work for some of the biggest tech companies around the world like Apple, Google, Tesla, Amazon, JP Morgan, IBM, UNIQLO etc... He has been working as a senior software developer in Silicon Valley and Toronto for many years, and is now taking all that he has learned, to teach programming skills and to help you discover the amazing career opportunities that being a developer allows in life.

Having been a self taught programmer, he understands that there is an overwhelming number of online courses, tutorials and books that are overly verbose and inadequate at teaching proper skills. Most people feel paralyzed and don't know where to start when learning a complex subject matter, or even worse, most people don't have $20,000 to spend on a coding bootcamp. Programming skills should be affordable and open to all. An education material should teach real life skills that are current and they should not waste a student's valuable time. Having learned important lessons from working for Fortune 500 companies, tech startups, to even founding his own business, he is now dedicating 100% of his time to teaching others valuable software development skills in order to take control of their life and work in an exciting industry with infinite possibilities.

Andrei promises you that there are no other courses out there as comprehensive and as well explained. He believes that in order to learn anything of value, you need to start with the foundation and develop the roots of the tree. Only from there will you be able to learn concepts and specific skills(leaves) that connect to the foundation. Learning becomes exponential when structured in this way.

Taking his experience in educational psychology and coding, Andrei's courses will take you on an understanding of complex subjects that you never thought would be possible.

--------

Mo is a Solutions Architect with over 7 years of experience in Software Architecture and Development. Having worked as a consultant for the majority of his career, he has seen it all.

He has worked on global applications for multi-nationals, governments and Fortune 500 companies.

Throughout his career he has seen every type of developer and development practice, and the one thing that he believes more than anything is that software development is a pragmatic team sport. Go fast alone, go far together!

My main goal with instructing is to teach the foundational knowledge to set you up for life-long learning. Software and development practices change often, but when you have the right foundation adapting to the constant change becomes easy!

See you inside the courses!

Database Design Introduction

Prevent typical developer mistakes by learning how to properly create and normalize a relational database

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 10016, Price: $49.99

Students: 10016, Price:  Paid

This course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project.  Information in this course is a must for anyone responsible for building and maintaining a database.

Data Modeling and Relational Database Design using ERwin

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs

Created by Haris Kilikotu - Developer | Architect | Product Manager

"]

Students: 10008, Price: $49.99

Students: 10008, Price:  Paid

The data model is the one place where you can store all the relevant information about a data asset (definitions, structure, relationships, integration points etc) and deliver it in a visual and contextually appropriate format for stakeholders involved in the management and consumption of data.

The course will help you learn how to develop data models and maintain them with the help of popular data modeling tool ERWIN. We will discuss various data modeling techniques with the help of appropriate modeling scenarios and make you ready to take up complex data modeling challenges and become an effective data architect. The tools and techniques demonstrated in this course are equally applicable to OLTP & OLAP databases.

MySQL Database Administration: Beginner SQL Database Design

Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 6911, Price: $109.99

Students: 6911, Price:  Paid

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

If you’re looking to develop practical, real-world analytics and BI skills, and learn how to create and maintain databases, you’ve come to the right place.

This course is unlike anything you’ve seen before, guaranteed. We'll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.

You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you’ll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    For students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Creating, Altering, and Deleting Schemas & Tables

    In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).

  • Inserting, Updating, and Deleting Records

    After we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed.

  • Database Design

    Now that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models.


    ***MID-COURSE PROJECT:
    Normalize this database for your client! 

  • Advanced Concepts
    In this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff! 

  • Server & User Management
    In our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA.

    ***FINAL COURSE PROJECT: Design and build an entire database from scratch! 

IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

______________________________

Enroll today and get LIFETIME access to:

  • 7 hours of high-quality video

  • Downloadable MySQL ebook and cheat sheets

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you!

Happy administering!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Real World MYSQL Database Design & Management Projects 2021

Master SQL by creating complex databases & building reports through real-world projects-MySQL, PHP, HTML, CSS, Bootstrap

Created by TheMachineLearning.Org . - Machine Learning Engineer

"]

Students: 6645, Price: Free

Students: 6645, Price:  Free

  1. Easy to use: As it supports SQL language, users don’t need to be technically expert to access the database. It can be easily accessed by users with basic SQL knowledge and experience on other relational databases.

  2. Cost Free: Another benefit of using this database is that the user doesn’t have to spend money to pay the license fee, as it is free of cost and available on the official website for download.

  3. Customizable Code: As it is available as an open-source tool, software developers have an option to customize the source code as per their own applications and use it. The source code is freely available to web users. The do’s and don’ts of the software are defined in GPL i.e. GNU General Public License.

  4. Secured: It offers one of the most secured databases in the world and hence used by well-established web applications like Facebook, Twitter, Instagram, etc. Its various security features like Firewall, Encryption, and User Authentication are the helping hands in protecting sensitive user information from intruders.

  5. Better Performance: It supports the multi-engine storage feature which facilitates database administrators to configure the database in a way to balance the workload. Hence, it makes the database flawless in terms of performance.

  6. High Availability: It offers 24*7 hours availability and offers solutions like Master/Slave Replication and specialized Cluster Servers.

  7. Scalability: It offers very good scalability to web applications through MySQL Thread Pool provided by MySQL Enterprise Edition. A thread pool provides a model that is used for managing threads (or processes), like the multi-user connections overhead and execution requests, in a hassle freeway.

  8. Platform-Friendly: It is a platform-friendly database supporting a number of platforms like Microsoft Windows, Oracle Solaris, AIX, Symbian, Linux, MAC OS, etc.

  9. Friendly Interface: It has a user-friendly interface with a lot of self-management features and different automated processes like configuration and administration-related tasks, which allows users to do the job effectively from Day 1.

Python Database Design | Build A Database Management System

Level up your Python programming skill by building a complete Python Database Management System with Tkinter in Python

Created by Emenwa Global - Senior Developers

"]

Students: 2373, Price: $89.99

Students: 2373, Price:  Paid

A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.

Database management systems are set up on specific data handling concepts, as the practice of administrating a database evolves. The earliest databases only handled individual single pieces of specially formatted data. Today’s more evolved systems can handle different kinds of less formatted data and tie them together in more elaborate ways.

Over time, the models for database management systems have changed considerably. This is a key part of understanding how various DBMS options work.

The earliest types of database management systems consisted mainly of hierarchy and network models.

  • The hierarchy model is one where each node or component has a child/parent relationship with one other node or component.

  • In the network model, the difference is that a single component can have multiple relationships – think of this as a single node being able to “multicast” connections.

However, over time, these models became overtaken by something called a relational database. In the relational database model, individual components have attributes that are linked to their identities through a database table design. The rows and columns of an individual database table include those identities and attributes in such a way that traditional structured query language or SQL can be used to pull various kinds of information on these relational models.

In this course, we covered the following topics that helped us to build full functioning Database Management System from scratch:

1. How to setup a Database

2. Project Setup

3. Logo and Title

4. Entry boxes for new records

5. Database Display Box

6. Time and Date

7. Adding menu bar

8. Viewing Database Table

9. Add New Record

10. Delete Record

Advanced SQL Database Administration with MySQL Workbench

Master SQL database design & advanced database management systems to build and maintain databases w/ real-world projects

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 1889, Price: $129.99

Students: 1889, Price:  Paid

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you'll take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security.

We'll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we'll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events.

Throughout the course, you'll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    For students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Importing Data to the Database

    We'll quickly review some basic concepts like creating, inserting, and deleting records. Then we'll learn how to tackle large data imports with ease, using the table data import wizard. We'll be using this handy tool throughout the course. You will construct and populate a database from the ground up as the business grows, just like a real DBA as part of the course project.

  • Altering, Updating & Mapping Keys

    We'll briefly review critical concepts like altering tables and updating records, discuss the ins and outs of primary and foreign keys, and from there you'll jump right into your assignments and quizzes for this section.

  • Replication, Backup & Recovery

    Here we'll introduce the critical DBA concepts of replication, backup and recovery. We'll discuss the various benefits of replication, different methods of backing up your databases, and you'll learn how to restore your data should the need arise. This is getting into some pretty serious stuff! 

    ***MID-COURSE PROJECT
    You will need all of the skills you've learned so far to complete this hands on mid-course project. You'll help your CEO by enhancing the data structure to accommodate changing business needs, and insert new data into various places within your database.

  • Trigger Automation
    Here we'll dive into one of the most powerful automation tools you'll use as a DBA...triggers! You'll learn how you can create triggers to look for changes in the database via create, update, and delete statements, and then automatically enact changes on one of more of your tables. Triggers will be your best friend as a DBA, and can be extremely handy for Analysts to understand as well.

  • Creating Views
    Sometimes you don't need to create a table, and a view (aka "a virtual table) is a better option. We'll walk through what views are, how you create them, and some of the major benefits of using views in certain situations.

  • The EER Diagram Editor
    One of the best tools at your disposal for understanding your database and communicating its structure to others in your organization is leveraging EER Diagrams. We'll review some of the basics that we discussed in the Beginner course, and we'll also learn how to use the EER Diagram Editor to reverse engineer your schema, which is an extremely handy tool!

  • Stored Procedures & Scheduled Events
    Next, we'll dive deeper into automation by learning how to create stored procedures and scheduled events. If you liked triggers, you're going to love these! You can use stored procedures to simplify your processes, make your code more modular and easier to understand, and centralize certain parts of complex queries that you can leverage throughout your organization. Scheduled events will allow you to run one-time or recurring processes on your database, which you can schedule on whatever cadence you want. These are really fun! 

  • Automating Data from Website Activity
    Here we'll be talking about the different types of data businesses typically track from their website activity, including traffic source data, on-site behavior, product purchases, and more. We'll discuss the various methods used to capture the various data types, and discuss the DBA's role in partnering with Engineering to make sure this is all working as it should.

  • Database Security
    In the last section before the final project, we'll discuss some of the most common types of database security threats you should be aware of as a DBA, as well as security best practices to mitigate your risk. Again, we'll discuss the DBA's role in the organization, how a DBA will partner with Engineering here, and who typically owns what.

    ***FINAL COURSE PROJECT
    This hands-on project will test all of your DBA skills. You will need to alter tables, import lots of data, design an optimal structure for an entirely new set of tables for a new business initiative, create an EER Diagram describing your new tables, and then you'll actually create them. After that, you'll need to create a stored procedure and a view, which will both used for reporting on the new data the company will be collecting. Finally, you'll need to come up with a comprehensive security plan to make sure your organization is aware of threats and following best practices. I know this sounds like a lot, but at this point you'll be ready for it! 

IMPORTANT NOTE: This course does NOT go deep on data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

______________________________

Enroll today and get LIFETIME access to:

  • 8 hours of high-quality video

  • Downloadable MySQL ebook and cheat sheets

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you're looking for a unique and engaging way to develop advanced MySQL database administration skills, this is the course for you.

Happy administering!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Microsoft ACCESS Beginners Hands-on Training with Exercises

Quick Learn MS ACCESS for beginners from scratch to design and develop real-world Database applications.

Created by Mazhar Hussain - Computer Science Lecturer and Programmer

"]

Students: 1754, Price: Free

Students: 1754, Price:  Free

Microsoft ACCESS is an information management tool, or relational database, that helps you store data that can easily be accessed, managed, modified, updated, controlled, and analyzed.

ACCESS can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.

ACCESS Components: You will be able to learn Microsoft ACCESS Components: Tables, Forms, Queries, and Reports. Each has its own special function to allow the user to manage information in MS ACCESS.

  • A Table allows the user to store a collection of data about a specific topic like Customers or Orders. Relationships can be established among the tables to access and manage the data easily.

  • A Form allows a user to enter/change/update data to tables.

  • A Query allows the user to view, change, manipulate, and analyze data in different ways like combining data from two different tables (Customers and Orders) to create a user’s own custom view (London Orders for April).

  • A Report is an effective way to output your data in a printed format in the way you want it .

This Course is specifically designed for beginners with

  • Hands-on training

  • Real-world applications

  • Exercises

  • Final project

At the end of this Course, you will be able to create a real-world DATABASE Applications in MS ACCESS from scratch.

Oracle PL/SQL Fundamentals & Database Design–3course bundle

The ultimate Oracle/database course bundle with over 20 hours and 100 videos!

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 1476, Price: $109.99

Students: 1476, Price:  Paid

Over 20 hours and 100 videos are included in this bundle.

Save 20% by purchasing 3 Oracle/Database courses. This bundle includes:

  • Oracle PL/SQL Fundamentals vol. I
  • Oracle PL/SQL Fundamentals vol. II
  • Database Design Instruction

In this Oracle 11g PL/SQL vol I & II courses, you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

The Database Design Instruction course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project.  Information in this course is a must for anyone responsible for building and maintaining a database.

JavaFX Database Management System! Database Design In JavaFX

Level up your JavaFX programming skill by building a complete JavaFx Database Management System from scratch in JavaFX

Created by Emenwa Global - Senior Developers

"]

Students: 1138, Price: $89.99

Students: 1138, Price:  Paid

JavaFX is a software platform for creating and delivering desktop applications, as well as rich Internet applications that can run across a wide variety of devices. JavaFX is intended to replace Swing as the standard GUI library for Java SE, but both will be included for the foreseeable future.

In this course, we will concentrate and learn how to build a complete database management system in JavaFX using the full components of JavaFX. Below are the things will accomplish in this course:

1. How to create a simple login page

2. How to open the second login form

3. How to add image to login page

4. How to create SQlite Database in JavaFX Database Management

5. How to create Tables in Database

6. How to create classes for Database

7. How to connect to Database using connection class

8. How to connect to Connection Class from Login Model

9. How to successfully get results from your Database connection

10. How to create a Login page for Students Portal

11. How to open Database Table in Students Portal

12. How to auto-close Login Page

13. How to populate Students Data on the Table

15. How to add New Students Data into your Database

16. How to clear Text Fields in Database

17. Improve your Java programming skills

18. How to export your project and create a standalone application in JavaFX

Database Design for Relational Databases using SQL Server

Learn Database Design Fundamentals and sharpen your SQL in under 5 hours. SQL Database Design explained for Beginners

Created by Daniel Tait - Database Instructor

"]

Students: 481, Price: $19.99

Students: 481, Price:  Paid

Start learning Database Design Today!

A lot of IT professionals have a good working knowledge of SQL yet lack the foundational knowledge of relational database design. Learning database design and the relational model will put you ahead of the game. This course covers all the essential aspects of relational database design with practical demos given in SQL Server. You will learn how to spot un-normalized data structures and how to correct them. You will learn all about the process of data normalization and why it is important. This includes the various normal forms such as Boyce-Codd normal form and fourth normal form. This course also covers tips on how to identify relationships between entities and how to correctly model them in a relational database.

You will be able to understand advanced database design concepts with the aid of intuitive diagrams and practical examples. You will learn how to identify functional dependencies and transitive dependencies in your data. You will learn the different types of keys and when to use them. In addition, you will learn the different types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. More importantly, the end of the course you will know how to enforce these relationships by using integrity constraints.

Note that you will need either a Windows or Linux computer to install SQL Server.

Case Studies in Six-Step Relational Database Design

Illustrating the six-step relational database design process using case studies.

Created by Fidel Captain - Database Developer, Web Developer, Lecturer and Consultant

"]

Students: 210, Price: $19.99

Students: 210, Price:  Paid

A database is the backbone of any application, and therefore it must be sturdy, reliable, and accurate. Having a well-designed database is the key to having your database meet these criteria, and the six-step database design technique ensures that the data model upon which your database is based is sturdy, reliable, and accurate.

Review case studies on designing relational databases in six easy steps

  • Review the Six-Step Relational Database Design technique
  • Learn by example using case studies that go through designing a database in six easy steps
  • Each case study goes through each of the six steps
  • Each case study starts with a problem statement and ends with a Crow's Foot R-M diagram
  • Challenge yourself with case studies increasing in complexity

Case studies demonstrating the Six-Step Relational Database Design technique

After a brief overview of the six-step database design process, three case studies are used to demonstrate how the technique works. Each case study starts with a concise statement of the problem and then goes through each of the six steps that are part of the six-step database design technique, ending with a Crow's Foot relational database model.

Some knowledge of database design terminology and techniques is required, and while this course does delve into the details of the six-step relational database design technique, you will learn, from examples, how this technique can be used to create a sturdy, reliable, and accurate relational database model. The extensive supplemental resources (handouts) that compliment the video tutorials allow you to fully understand how the six-step relational database design technique works.

You will learn what the six steps of Six-Step Relational Database Design are, and how they work to transform a problem statement into a Crow's Foot relational database model using three examples.

Basic Relational Database Design

Build and design efficient databases for your applications

Created by Packt Publishing - Tech Knowledge in Motion

"]

Students: 47, Price: $89.99

Students: 47, Price:  Paid

With growing market demands,  every developer working on various programming languages plans to become  a full-stack developer and database management is key to developing  every web, desktop, or cloud application.

You'll start by preparing your own database tables, then create an  advanced database design to manage your data efficiently, which is  necessary when you are working with a large set of data for any project.  Along the way, you will also experience the power of database models  and relationships to reuse a particular set of data.

By the end of the course, you will be able to build and design efficient  databases. You will also be able to use normalization to restructure  your database and reduce redundancy. 

About the Author

Smail Oubaalla is a talented  software engineer with an interest in building the most effective,  beautiful, and correct software possible. He has helped companies build  excellent programs. He also manages projects and has experience in  designing and managing new products. When not working, he loves hanging  out with friends, hiking, and playing sports (football, basketball,  rugby, and more). He also loves working his way through every recipe he  can find in the family cookbook or elsewhere, and indulging his love for  seeing new places.