110
Last updated 10/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 382.08 MB | Duration: 2h 45m
Understand basics of database design & development through step by step procedure
What you'll learn
Can make better database using standard principles
Prepare better database from scratch
Feel comfortable to write database design in resume
Requirements
No prior knowledge on Database required.
Description
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
Overview
Section 1: Basics of Database Design
Lecture 1 Introduction and Database Overview
Lecture 2 Understanding SQL Types of Commands
Lecture 3 Tables, Views and Stored Procedures
Lecture 4 Database Constraints
Lecture 5 Database Normalization
Lecture 6 ER Diagram
Lecture 7 Relational Database Management System
Lecture 8 NoSQL
Lecture 9 RDBMS vs. NoSQL
Section 2: Bonus Section: Learning MySQL Development
Lecture 10 Introduction to MySQL
Lecture 11 Data types in MySQL Part - 1
Lecture 12 Data types in MySQL Part - 2
Lecture 13 XAMPP Installation
Lecture 14 MySQL Workbench Installation
Lecture 15 Creating with PHPMyAdmin
Lecture 16 Creating Database & Table through MySQL Workbench
Lecture 17 Design and Accounts
Lecture 18 Import and Export
Lecture 19 Introduction to MySQL Queries and SELECT Clause
Lecture 20 Inserts Updates and Deletes
Lecture 21 Storage Engines
Lecture 22 Mastering Table Joining: Part 1
Lecture 23 Mastering Table Joining: Part 2
Lecture 24 Working with Math and Strings: Part 1
Lecture 25 Working with Math and Strings: Part 2
Lecture 26 Group By: Part 1
Lecture 27 Group By: Part 2
Section 3: Bonus Section: Working with MongoDB (NoSQL Database)
Lecture 28 MongoDB Installation
Lecture 29 Basic Queries: Part 1
Lecture 30 Basic Queries: Part 2
Lecture 31 Advanced Queries: Part 1
Lecture 32 Advanced Queries: Part 2
Who wanna learn basic concepts of Database Design,Who wanna learn advanced concepts of Database Design
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
