SQL and Database Design Step by Step (SQL Boot Camp)
4.4 (24 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,566 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL and Database Design Step by Step (SQL Boot Camp) to your Wishlist.

Add to Wishlist

SQL and Database Design Step by Step (SQL Boot Camp)

Become SQL Expert! No Experience Required
4.4 (24 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,566 students enrolled
Created by Fahmi Eshaq
Last updated 5/2017
English
Price: $200
30-Day Money-Back Guarantee
Includes:
  • 11.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Basic SQL
  • Advanced SQL
  • Write Ad-Hoc SQL Queries Reports
  • Relational Data Modeling
  • Entity Relationship Modeling
  • Entity Relationship Diagram (ERD)
  • Design Databases from Scratch (RDBMS)
  • Develop Databases from Scratch
  • Oracle SQL Developer Tool (IDE)
  • Practice Real-World Hands-On Projects
  • Develop Databases for Custom Web Applications
  • 50 Downloadable Resources
View Curriculum
Requirements
  • No experience required
  • Know how to use PC
Description

This Oracle database course teaches you everything you need to know about databases!

  • 2-in-1 you get two VERY important subjects in ONE COURSE: database design (theory) and Oracle SQL (hands-on).
  • Learn necessary skills for getting a highly paid database job. 
  • Whatever you learn in this database course is applicable to Oracle, MySQL, Access, DB2, and the like. 
  • This course is the most comprehensive database course for beginners you could ever find in Udemy.

This course is divided into 4 sections - watch them in sequence:

Section 1. Introduction to Databases (Very Basic)

Section 2. Design Phase (Practical Theory)

Section 3. Physical Phase (SQL) with lots of exercises - You will practice on Oracle platform

Section 4. Five Real-world Hands-on Projects (Fast paced. You have to watch section #2 and section #3 first)

Through out the course, you'll receive 50 downloadable resources such as exercises and projects to help you follow along with me.

With no experience required, this database course will take you from a
complete beginner to a confident and competent database developer who is
able to productively contribute to projects and achieve the results you
want.

Feel free to ask me questions! I'll be happy to help you out.


~~~~~~~~~~~

Database classes are expensive. You pay for Hotel + Food + Travel + Tuition fees! A combined Relational Database Developer (RDBMS) Class + SQL Query Writing Course + Advanced SQL Writing Class quickly adds up to more than $5000. You are getting this course for LESS than a fraction of that cost!

Important Notice: this course is NOT part of udemy promotions program and not subject to any udemy discounts.

~~~~~~~~~~~

Don't miss the course! Start Now...


Warning: this database course is quite intensive and you have to watch them in sequence unless YOU HAVE DATABASE EXPERIENCE. I broke the course into many short videos to help beginners understand the course.

Join Now!

P.S. You can download PowerPoint slides in video #4


Don't miss out...Start Now!

Who is the target audience?
  • Newbies
  • New Graduates
  • New Career Seekers
  • System Analysts
  • Data Analysts
  • Business Analysts
  • Database Developers
  • Software Developers
  • Web Developers
  • Report Writers
  • IT Professionals
  • Anyone who wants to learn databases
Students Who Viewed This Course Also Viewed
Curriculum For This Course
146 Lectures
11:35:20
+
Introduction to Databases (Very Basic)
19 Lectures 37:05

What is a Database?
01:36

Where to Store Data?
00:09

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.

Data vs. Information
02:06



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


Entities and Attributes
05:07

Example: Problem Statement
04:58

Demonstrate a Mockup Application
02:13

Why Design Phase? (Anomalies) - Part 1
03:48

+
Design Phase
39 Lectures 03:16:09

Eliminate Multi-Values
10:14

Introduction to Keys
04:01

What is a Superkey?
02:59

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 Candidate Key?
05:27

What is a Primary Key (PK)?
05:33

What is an Alternative Key?
03:00

What is a Surrogate Key?
06:17

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.

What is a Repeating Group?
04:34

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

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.

What is After Third Normal Form?
01:45

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

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 Entity Relationship Diagram
01:58

The End of Design Phase!
00:46
+
Physical Phase
67 Lectures 05:13:17


Install Oracle Database - Part 2
03:06

Quick Tour on Oracle SQL Developer
02:54


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

The HR example is supported and provided by Oracle Corp.

ERD of Human Resources System
17:15

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

How to Format a Number into Currency?
01:46

Aggregate Functions
03:21

What is ROUND and TRUNC?
02:24

Aggregate Functions vs. Scalar Functions
04:13

From 1:40 to 1:50 there was a video editing issue that may cause confusion:  

total salary sum of department 90 is 88,000 NOT 58,000

What is GROUP BY?
06:19

What is COALESCE and NVL?
02:58

Conditional Statements
04:19

What is INNER JOIN?
07:56

What is OUTER JOIN?
04:18

Set Operators - UNION and UNION ALL
06:09

Set Operators - MINUS and INTERSECT
03:45

What is an Inline View?
02:37

How to Create a VIEW?
05:48

What is a Subquery?
05:25

What is DISTINCT?
00:42

Correlated Subquery - What is EXISTS?
06:14

What is a Scalar Subquery?
03:18

What is a Sequence?
02:51

What is ALTER TABLE?
06:31

What is INDEXES?
03:47

What is a Data Dictionary?
03:32

PL/SQL - How to Create Custom Functions?
13:23

PL/SQL - What is a Procedure?
05:35

PL/SQL - What is a Trigger?
02:45

What are the Types of SQL Queries?
01:58

The End of Physical Phase
01:22

What is After Third Normal Form? (Appendix)
09:14

SQL Hands-on Exercises
03:25
+
Real-world Hands-on Projects
21 Lectures 02:28:49



Project 1: Anonymous Blog Summary
05:12

Project 1: Anonymous Blog - ERD
10:05

In this lecture, I added the keyword "CONSTRAINT" when assigning primary key and foreign key. Note that the "CONSTRAINT" keyword is optional. The fact is whenever you create a constraint such as primary key or foreign key, the Oracle system automatically gives each constraint a unique name implicitly; so, rather than letting Oracle assigning the constraint name automatically, you can use the keyword "CONSTRAINT" as shown in this lesson. How can assigning CONSTRAINT name help you? It helps you when you decide to drop the primary key or foreign key from a table! How would you identify the PK and FK to be dropped? You identify them through the CONSTRAINT name.

Project 1: Anonymous Blog - DDL
08:57

Comments regarding this video tutorial:

You do not necessarily have to enclose an alias with double quotation. The only time you are obliged to wrap double quotation on an alias is when the alias has spaces, such as First Name; you will have to write as "First Name". Also, the keyword AS is optional. You don't have to use it to name an alias.

Project 1: Anonymous Blog - DML
24:27


Project 2: ShinyTalk - ERD
04:08

Project 2: ShinyTalk - DDL
03:06

Project 2: ShinyTalk - DML
11:24


Project 3: Classified Ads - ERD
03:36

Project 3: Classified Ads - DDL
01:50

Project 3: Classified Ads - DML
08:12


Project 4: Consultation Services - ERD
03:21

Project 4: Consultation Services - DDL
01:38

Project 4: Consultation Services - DML
14:35

Project 5: Realestate Website (Exercise)
07:40

Congratulations for the excellent effort you put in!

First of all, thank you for joining this training program. Secondly, I prefer all questions to be posted in udemy discussion platform, so your fellow students can learn too. There is no such thing called stupid question. All questions matter to me; ask and never feel shy! I'll be happy to help you out.

Reach me at my personal email fjamcom@gmail.com

http://www.FahmiEshaq.com



Congrats! The End :)
00:50
About the Instructor
Fahmi Eshaq
4.4 Average rating
24 Reviews
1,566 Students
1 Course
SQL Data Analyst

Fahmi Eshaq is a proactive and versatile SQL data analyst offering a diverse background in designing relational databases, writing ad-hoc SQL queries, scraping data, and writing SQL reports.

His experience as a SQL data analyst lies at the core of a set of technical skills and interdisciplinary knowledge that has served him well in a diverse and fast-moving career. Rarely do enterprises get the opportunity to benefit from such a focused and comprehensive variety of achievements and experiences. Mr. Eshaq's experience in both data integration and management serving both private and public constituencies is a valuable skill that should not be too quickly overlooked. Having a steady and learned hand capable of building databases in a regulatory framework can be a tremendous asset to any company tasked with government relations.

As a technology consultant and system developer, Mr. Eshaq's adherence to technical specifications and wide-ranging compliance measures made him a valued member of a high-energy development team tasked with a focused and determined goal of exceeding I.T. expectations at every level of the company.