Learn SQL Database from A to Z

You'll learn database skills that will help you start as a PRO with a highly paid job. BEST DATABASE COURSE IN UDEMY
3.7 (18 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,543 students enrolled
Instructed by Fahmi Eshaq Development / Databases
$50
Take This Course
  • Lectures 146
  • Contents Video: 11.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

This database course teaches you everything you need to know about databases! You'll learn SQL and Database Design.

You'll learn all the necessary skills that prepare you for a high salary database job. In this course, I share my database expertise with you and give you the key to database industry! This course prepares to start your database career like a pro. Whatever you learn in this database course is applicable to Oracle, MySQL, Access, DB2, or the like. I testify this is the most comprehensive database course for beginners in udemy.

Don't miss the course! Start Now!

What are your price models?

The course costs $50 USD.

Please note section 4 is highly dependent on previous sections. Once you get familiar with previous sections, you can watch and practice section 4.

**** You can download the powerpoint slides from lecture #4 ********

Important note: section 1 includes very generic information. Feel free to skip it.

Warning: this database course is quite intensive and you have to watch them in sequence. I broke the course into many short videos to make it easier for you to understand the topics; however, whatever you learn in this course will remain with you for the rest of your life! You'll gain a priceless MUST-HAVE valuable database skills. Spend good time learning this course IN and OUT because this course PAYS OFF really well if you grasp it well.


Don't miss the course! Start Now!

What are the requirements?

  • No experience is required

What am I going to get from this course?

  • Design and develop databases from scratch like PRO
  • Write basic and advanced SQL queries like a WHIZ
  • Work on any database management system such as Oracle, SQL Server, MySQL, etc

What is the target audience?

  • Anyone interested in databases or want a career in database industry such as DBA, Data Analyst, Database Developer, BI/DW, SQL Tester, Data Modeler, etc

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Databases (Very Basic Foundation)
Course Overview
Preview
02:14
What is a Database?
01:36
Where to Store Data?
00:09
02:06

You do not have the right to change the powerpoint content and I hold no responsibility or liability for any changes you make to the powerpoint.

Database Tools
Preview
00:49
Database Skills vs. Database Tools
Preview
01:31
How to Store Data?
00:18
Why do We Use Databases?
00:37
What to Store in a Database? Part 1
01:25
What to Store in a Database? Part 2
01:28
What is Business Requirements?
02:24
What to Store in a Database? Part 3
01:59
Where Can you Create a Database?
01:47
Database Design vs. Database Implementation
Preview
01:34
Entities and Attributes
05:07
Example: Problem Statement
04:58
Demonstrate a Mockup Application
02:13
Why Design Phase? (Anomalies) - Part 1
03:48
Why Design Phase? Part 2
Preview
01:02
Section 2: Design Phase
What is Normalization?
Preview
01:32
Eliminate Multi-Values
10:14
Introduction to Keys
04:01
What is a Superkey?
02:59
05:27

Reminder: first name, last name, and email is not a Candidate Key because we can reduce the key to email

Superkey is every possible key out there the ones that can be reduced
and the ones that cannot be reduced. The keys that can't be reduced get
elected as Candidate keys and then ONLY one of those candidate keys can
be selected as a primary key. For example, "First Name, Last Name, Email" is a superkey but cannot be a Candidate Key. However, Email is a Candidate Key because Email is unique enough to identify a record without the need of first name and last. In short, First Name, Last Name, Email is superkey not a candidate key.

What is a Primary Key (PK)?
05:33
What is an Alternative Key?
03:00
What is a Surrogate Key?
06:17
04:34

Note: In the first five seconds, the voice sounds as if it got cut in half when in fact its not. This problem was caused by audio issues.

Remove a Repeating Group
04:42
Review First Normal Form (1NF)
03:52
1NF Exercise - Part 1
07:35
1NF Exercise - Part 2
05:29
1NF Summary
01:32
What is Second Normal Form (2NF)?
10:10
2NF Exercise
01:44
2NF Summary
00:35
What is Third Normal Form (3NF)?
02:42
3NF Exercise
02:21
3NF Summary
01:03
01:45

Important Note: Fourth Normal Form is listed under lecture 124 by the very end of the Physical Phase; I didn't create appendix section. Why did I move 4NF to lecture 124? 4NF+ is more theortical and may confuse you and distract you if I demonstrated it right after 3NF. Also, 4NF and above are supplementary and not mandatory.

The End of Normalization
11:15
Introduction to Relationships
01:42
What is One-to-Many Relationship?
10:52
What is Many-to-Many Relationship?
13:36
What is One-to-One Relationship?
06:45
What is Self-Reference Relationship?
07:03
What is an Extended One-to-One Relationship? - Part 1
11:04
What is an Extended One-to-One Relationship? - Part 2
10:09
Introduction to Entity Relationship Diagram (ERD)
01:07
How to Draw One-to-Many Relationship in an ERD? - Part 1
05:28
How to Draw One-to-Many Relationship in an ERD? - Part 2
04:11
How to Draw Many-to-Many Relationship in an ERD?
07:01
How to Draw One-to-One Relationship in an ERD?
02:22
How to Draw Self-Referencing Relationship in an ERD?
03:49
How to Draw Extended One-to-One Relationship in an ERD?
04:22
Review ERD
05:32
01:58

You can find lots of free youtube tutorials on how to design ERD on Microsoft Visio. For the time being, don't worry about designing ERD on MS Visio because it's luxury rather necessity. Anyhow, if still interested in MS Visio, here is few resources:

https://www.youtube.com/watch?v=K0mNzXnHkYc

https://www.youtube.com/watch?v=sIX80pvJnMY

https://www.youtube.com/watch?v=znzAYZhEsuU

https://www.youtube.com/watch?v=gW7xpykljeU



The End of Design Phase!
00:46
Section 3: Physical Phase
Introduction to the Implementation (Physical) Phase
Preview
01:10
Install Oracle Database - Part 1
Preview
03:36
Install Oracle Database - Part 2
03:06
Quick Tour on Oracle SQL Developer
02:54
What is SQL?
Preview
02:19
How to Create a Data Table?
15:52
How to Insert Data into a Database?
07:34
What is SELECT Statement?
04:08
What is WHERE Clause?
03:36
Comparison Operators
02:41
What is AND Operator?
07:01
What is OR Operator?
04:23
What is IN Operator?
02:44
Multiple AND Operators
01:59
Mixture of Operators
06:18
What is a Function?
04:00
What is not Equal Operator?
01:23
What is an Alias?
02:23
How to Sort a Table?
03:43
What is BETWEEN Operator?
00:59
What is NOT Operator?
02:20
How to Find NULL Values?
02:25
What is Concatenation? - Part 1
02:06
CHAR vs. VARCHAR
04:41
What is Concatenation? - Part 2
03:08
Learn More about INSERT
03:42
Quick Review on Implementation Phase
01:41
17:15

The HR example is supported and provided by Oracle Corp.

Implement HR Schema - Part 1
12:39
Implement HR Schema - Part 2
03:45
Implement HR Schema - Part 3
05:47
Implement HR Schema - Part 4
02:16
Implement HR Schema - Part 5
05:21
Implement HR Schema - Part 6
05:04
Implement HR Schema - Part 7
03:10
Implement HR Schema - Part 8
01:13
How to Create a New User?
10:15
Run SQL Queries on HR Schema
13:35
How to Format Dates?
05:10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Fahmi Eshaq, Data Analyst

Mr. Eshaq is a proactive and versatile data analyst offering a diverse background in designing relational databases, writing ad-hoc SQL queries, scraping public data, developing software applications, and analyzing business requirements. He brings experience in design and implementation of technological solutions for business process enhancement. Mr. Eshaq areas of expertise are data analysis, systems analysis, and project management.

Ready to start learning?
Take This Course