Database Design & Implementation Master Class 2024

Focused View

Emar Morrison

3:01:01

12 View

1. Introduction

1. Introduction.mp4

01:33

2. Course Objectives.html

2. Getting Started

1. Overview.mp4

00:12

2. File System.mp4

06:22

3. What is a database.mp4

02:20

4. Types of Databases.mp4

07:00

5. Emerging Technologies.mp4

01:52

6. Summary.mp4

00:19

3. Entity Relationship Diagrams (ERD)

1. Overview.mp4

00:20

2. What is an ERD Diagram.mp4

02:13

3. Conceptual Modelling.mp4

01:26

4. Entities.mp4

05:24

5. Attributes.mp4

04:48

6. Relationships.mp4

10:13

4. Relation Modelling

1. Overview.mp4

00:39

2. What is the Relational Model.mp4

01:46

3. ERD to Relational Notation.mp4

05:09

4.1 relational notation lecture.zip

4. ERD to Relational Notation Part 2.mp4

01:38

5. Relational Keys.mp4

06:35

6. Type of Integrity Rules.mp4

03:00

5. Relation Model Normalization

1. Overview.mp4

01:46

2. What is normalization.mp4

04:55

3. Normalization First Normal Form 1NF.mp4

03:48

4. Normalization Second Normal Form 2NF.mp4

06:06

5. Normalization Third Normal Form 3NF.mp4

03:03

6. Boyce-Codd Normal Form.html

7. Section Summary.html

6. Physical database design

1. Overview.mp4

00:19

2. Introduction to SQL.mp4

01:48

3. SQL Statements.mp4

01:04

4.1 Data Types.html

4. Data Types.mp4

00:53

7. Database Implementation Environment Setup

1. Overview.mp4

00:59

2. Introduction to SQL Server, PostgreSQL, Oracle and MySQL.html

3. Installing SQL Server Management Studio and Azure Data Studio.mp4

01:25

4. Installing PG Admin for PostgreSQL.mp4

01:28

5. Installing SQL Developer for Oracle.mp4

01:09

6. Installing MySQL Workbench for MySQL.mp4

01:39

7. Setting up Cloud Database Instance in AWS.mp4

04:59

8. Setting up a Local Environment with SQL Server 2022.mp4

04:59

9. Exploring Azure Data Studio.mp4

03:56

8. The Data Definition Language

1. Create a Database.mp4

04:07

2.1 lecture 40 - create statement.zip

2. Creating Tables.mp4

12:17

3. Creating Tables.html

4.1 lecture 41 - drop statement.zip

4. Drop Statement.mp4

02:46

5. Dropping Objects.html

6.1 lecture - 44 alter statements.zip

6. Alter Statement.mp4

08:43

7. Altering Objects.html

9. Data Manipulation Language

1.1 lecture 45 - insert statement.zip

1. Insert Statement.mp4

09:10

2. Inserting Data.html

3.1 lecture 46 - selecting data.zip

3. Select Statement.mp4

11:55

4. Selecting Data.html

5. Select Statement Pattern Matching.mp4

02:53

6.1 lecture - 48 generated columns.zip

6. Select Statement Generated Columns.mp4

06:06

7.1 lecture 50 - aggregations.zip

7. Select Statement Aggregations.mp4

06:34

8. Aggregation.html

9.1 lecture 51 - join statement.zip

9. Join Statements.mp4

05:35

10. Join Statements.html

11.1 update statements.zip

11. Updating Data.mp4

02:57

12. Update Statement.html

13.1 delete statements.zip

13. Deleting Data.mp4

00:53

14. Delete Statement.html

10. Assignments

1. Creating Tables.html

2. Dropping Objects.html

3. Altering Tables.html

4. Querying Data.html

Description

Relational Database Design and Implementation with SQL Server

What You'll Learn?

Understand the fundamental concepts of databases, data models, and their importance.
Design and create relational databases using Entity-Relationship Diagrams (ERD).
Normalize and optimize database structures to ensure data integrity and performance.
Write SQL queries to retrieve, update, and manipulate data in a database.
Apply database design principles to real-world scenarios and projects.

Who is this for?

People considering a career change into a field that requires database knowledge and skills

Undergraduate or graduate students majoring in computer science, software engineering, or related fields.

IT professionals looking to expand their knowledge and skills in database design

Individuals working with data analysis or data science who need to understand how databases are structured

Individuals who have a general interest in data management and want to understand how databases work

Business analysts who want to understand how data is stored and retrieved for reporting and decision-making purposes.

What You Need to Know?

No experience required

A Laptop/desktop with at-least 8GBs of RAM and 10GB free hard disks space

More details

Description
In today's data-driven world, effective database design is a critical skill for professionals across a range of disciplines, including software development, data analysis, business intelligence, and more. The "Database Design and Management" course is designed to provide students with a comprehensive understanding of the principles, methodologies, and best practices of creating and managing databases.

Course Objectives:
By the end of this course, students will:
Understand Database Fundamentals: Gain a solid grasp of what databases are, why they are essential, and the various types of databases in use today.
Master Data Modeling: Learn how to design databases using Entity-Relationship Diagrams (ERDs) and translate real-world scenarios into structured data models.
Normalization and Optimization: Explore the art of normalizing data to minimize redundancy and optimize database performance.
SQL Proficiency: Acquire proficiency in Structured Query Language (SQL) to interact with and manipulate data in relational databases.
Real-World Application: Apply database design principles to practical, real-world scenarios and projects, gaining hands-on experience.

This course is ideal for:
Computer science students seeking a strong foundation in database design.
IT professionals, including database administrators and developers, looking to enhance their skills.
Data analysts and scientists who require a deeper understanding of database systems.
Business professionals interested in using data for decision-making.
Anyone looking to leverage the power of databases in their careers or projects.
Prerequisites:
Basic computer literacy and familiarity with data concepts are recommended but not required. No prior database design experience is necessary.
Who this course is for:
People considering a career change into a field that requires database knowledge and skills
Undergraduate or graduate students majoring in computer science, software engineering, or related fields.
IT professionals looking to expand their knowledge and skills in database design
Individuals working with data analysis or data science who need to understand how databases are structured
Individuals who have a general interest in data management and want to understand how databases work
Business analysts who want to understand how data is stored and retrieved for reporting and decision-making purposes.

User Reviews

Rating

average 0

Total votes0

Focused display

Database Design

Emar Morrison

Instructor's Courses

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.