4.08 (371 reviews)
☑ Can make better database using standard principles
☑ Prepare better database from scratch
☑ Feel comfortable to write database design in resume
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
Mastering Database Design
Introduction and Database Overview
Understanding SQL Types of Commands
Tables, Views and Stored Procedures
Relational Database Management System
RDBMS vs. NoSQL
Learning MySQL Development
Introduction to MySQL
Data types in MySQL Part - 1
Data types in MySQL Part - 2
MySQL Workbench Installation
Creating with PHPMyAdmin
Creating Database & Table through MySQL Workbench
Design and Accounts
Import and Export
Introduction to MySQL Queries and SELECT Clause
Inserts Updates and Deletes
Mastering Table Joining: Part 1
Mastering Table Joining: Part 2
Working with Math and Strings: Part 1
Working with Math and Strings: Part 2
Group By: Part 1
Group By: Part 2
Section 2 was great with explaining and showing how to utilize SQL. Section1 and Section3 was a section where the instructor was inputting commands back to back in each video at a fast pace and then going onto the next subject. Section 2 was great though
For a beginner this is hard to follow. My self is an expert on DB design and I am taking this course to refresh some basic concepts. However, I do believe for a beginner who’s taking this course it would be better to show how to install the DB
The course is very helpful. Even though the Section 1 does not cover any coding, the next sessions have them clearly explained. The Only problem is that the section2 and section3 are incomplete. Waiting for the update.
I have learn that what the database is and how the database works with a structure of server . Also learn the types of commands that we are gonna be used in database systems . Types of tables, views and stored procedures are to be learned.
Dieser Kurs besteht aus drei Teilen aus anderen Kursen. Nicht kohärent aufbereitet, keine Einführung, keine Verabschiedung und der erste Teil des Kurses war generell sinnlos. Der zweite und dritte Teil sind gut aufbereitet und gesprochen. Diese bieten einen guten aber sehr kurzen Einblick in die Materie. Vorallem der dritte Teil referenziert im Letzten Video auf ein nächstes :D Bitte diesen Kurs auch als das anbieten was es ist. Ein kurzer Einblick und mehr nicht. War zum Glück kostenlos. Aber kostenlos muss nicht billig sein.
The first module was instructed in a less sufficient manner, the second module was more comprehensive and understandable.
i learned each and everything in detail with clearcut examples ...finally i am very satisfied with this course..thank you..
The first thing I wanted to note is that the second and third sections of the intro lesson are switched, which was confusing. Also, I worried at first because he jumped into a SQL database already made without context such as "I'm using this database to help you visualize the terms I'm discussing, no need to worry about making this database". Lastly, his misspelling of words is rather frequent and it started to interfere with the lesson flow. However, I'm going to stick with the course and see if the flow and feel of the course improves. The second part of the lesson, learning to create a database, goes much better. I would have liked this course first, or a mention in the first part that creating a database will be covered in the second part.
This course is helpful for those who students want to revise there concepts of database and summarizes bits and bytes of database.