Database Management System : MySQL and Database Modelling
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.54 GB
Genre: eLearning Video | Duration: 49 lectures (2 hour, 19 mins) | Language: English
Learn Database, UML, SQL,MySQL and Modelling for beginners
What you'll learn Homepage: https://www.udemy.com/course/database-management-system-mysql-and-database-modelling/
Introduction to Data and Data Types in SQL perspective
Introduction to information Systems
System Analysis & E-R Modelling and Relationships
Different ways to for Database Modeling
Querying using Structure Query Language
Data Definition language (DDL)
Data Manipulation language (DDL)
Installing MySQL Server and building your own live database
Operators
Aggregation functions
Filtering
Assignments
Requirements
No requirements, Only Your computer
Description
This course is designed to people from all backgrounds (IT and non-IT) who are willing to learn all about Databases and System analysis
After this course you'll be able to :
Analyse a system and Build Entity-Relationship Diagrams, and build the logical model.
Normalise your database tables (until the 3NF).
Implement your ER-Diagram into a physical database using MySQL ( Build your own Database).
You'll be able to read, write and understand SQL queries and Complex SQL queries (Nested SQL queries).
Use most important Pre-built SQL functions.
Use join statements in SQL.
The course is updated regularly, you can always ask questions and give feedback.
Bonus content such as other DBMS will be added regularly.
The course is aimed to be brief, not lengthy. lengthy courses shows lack of engagement. the course is designed in a way that each lecture is short and brief as possible. after each a quiz or notes are shared for interactive learning.
This course have short lectures, but they are large in quantity. they are focused and direct to the point in order to avoid the distraction of the learners.
Who this course is for:
Beginners looking forward to discover the world of database
People with no knowledge to databases world
Students Looking to boost their academic performance
This course is NOT for Database Professionals
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.