Learn SQL From Scratch No Experience Required

Learn SQL From Scratch No Experience Required, available at $199.99, has an average rating of 4.4, with 146 lectures, based on 34 reviews, and has 1613 subscribers.

You will learn about 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 This course is ideal for individuals who are Newbies or New Graduates or New Career Seekers or System Analysts or Data Analysts or Business Analysts or Database Developers or Software Developers or Web Developers or Report Writers or IT Professionals or Anyone who wants to learn databases It is particularly useful for Newbies or New Graduates or New Career Seekers or System Analysts or Data Analysts or Business Analysts or Database Developers or Software Developers or Web Developers or Report Writers or IT Professionals or Anyone who wants to learn databases.

Enroll now: Learn SQL From Scratch No Experience Required

Summary

Title: Learn SQL From Scratch No Experience Required

Price: $199.99

Average Rating: 4.4

Number of Lectures: 146

Number of Published Lectures: 146

Number of Curriculum Items: 146

Number of Published Curriculum Objects: 146

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

~~~~~~~~~~~

**** WARNING: If you are expecting this course to be part of Udemy’s promotion, you are wrong. This course is NOT part of Udemy’s promotions and it WILL NOT be part of udemy’s promotions. The course’s price is $200 and it will remain $200.

Don’t miss the course! Start Now…

ANOTHER Warning: this database course is not for everyone. The course is quite intensive and you have to watch them in sequence unless YOU ALREADY 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!

Course Curriculum

Chapter 1: Introduction to Databases (Very Basic)

Lecture 1: Course Overview

Lecture 2: What is a Database?

Lecture 3: Where to Store Data?

Lecture 4: Data vs. Information

Lecture 5: Database Tools

Lecture 6: Database Skills vs. Database Tools

Lecture 7: How to Store Data?

Lecture 8: Why do We Use Databases?

Lecture 9: What to Store in a Database? Part 1

Lecture 10: What to Store in a Database? Part 2

Lecture 11: What is Business Requirements?

Lecture 12: What to Store in a Database? Part 3

Lecture 13: Where Can you Create a Database?

Lecture 14: Database Design vs. Database Implementation

Lecture 15: Entities and Attributes

Lecture 16: Example: Problem Statement

Lecture 17: Demonstrate a Mockup Application

Lecture 18: Why Design Phase? (Anomalies) – Part 1

Lecture 19: Why Design Phase? Part 2

Chapter 2: Design Phase

Lecture 1: What is Normalization?

Lecture 2: Eliminate Multi-Values

Lecture 3: Introduction to Keys

Lecture 4: What is a Superkey?

Lecture 5: What is a Candidate Key?

Lecture 6: What is a Primary Key (PK)?

Lecture 7: What is an Alternative Key?

Lecture 8: What is a Surrogate Key?

Lecture 9: What is a Repeating Group?

Lecture 10: Remove a Repeating Group

Lecture 11: Review First Normal Form (1NF)

Lecture 12: 1NF Exercise – Part 1

Lecture 13: 1NF Exercise – Part 2

Lecture 14: 1NF Summary

Lecture 15: What is Second Normal Form (2NF)?

Lecture 16: 2NF Exercise

Lecture 17: 2NF Summary

Lecture 18: What is Third Normal Form (3NF)?

Lecture 19: 3NF Exercise

Lecture 20: 3NF Summary

Lecture 21: What is After Third Normal Form?

Lecture 22: The End of Normalization

Lecture 23: Introduction to Relationships

Lecture 24: What is One-to-Many Relationship?

Lecture 25: What is Many-to-Many Relationship?

Lecture 26: What is One-to-One Relationship?

Lecture 27: What is Self-Reference Relationship?

Lecture 28: What is an Extended One-to-One Relationship? – Part 1

Lecture 29: What is an Extended One-to-One Relationship? – Part 2

Lecture 30: Introduction to Entity Relationship Diagram (ERD)

Lecture 31: How to Draw One-to-Many Relationship in an ERD? – Part 1

Lecture 32: How to Draw One-to-Many Relationship in an ERD? – Part 2

Lecture 33: How to Draw Many-to-Many Relationship in an ERD?

Lecture 34: How to Draw One-to-One Relationship in an ERD?

Lecture 35: How to Draw Self-Referencing Relationship in an ERD?

Lecture 36: How to Draw Extended One-to-One Relationship in an ERD?

Lecture 37: Review ERD

Lecture 38: The End of Entity Relationship Diagram

Lecture 39: The End of Design Phase!

Chapter 3: Physical Phase

Lecture 1: Introduction to the Implementation (Physical) Phase

Lecture 2: Install Oracle Database – Part 1

Lecture 3: Install Oracle Database – Part 2

Lecture 4: Quick Tour on Oracle SQL Developer

Lecture 5: What is SQL?

Lecture 6: How to Create a Data Table?

Lecture 7: How to Insert Data into a Database?

Lecture 8: What is SELECT Statement?

Lecture 9: What is WHERE Clause?

Lecture 10: Comparison Operators

Lecture 11: What is AND Operator?

Lecture 12: What is OR Operator?

Lecture 13: What is IN Operator?

Lecture 14: Multiple AND Operators

Lecture 15: Mixture of Operators

Lecture 16: What is a Function?

Lecture 17: What is not Equal Operator?

Lecture 18: What is an Alias?

Lecture 19: How to Sort a Table?

Lecture 20: What is BETWEEN Operator?

Lecture 21: What is NOT Operator?

Lecture 22: How to Find NULL Values?

Lecture 23: What is Concatenation? – Part 1

Lecture 24: CHAR vs. VARCHAR

Lecture 25: What is Concatenation? – Part 2

Lecture 26: Learn More about INSERT

Lecture 27: Quick Review on Implementation Phase

Lecture 28: ERD of Human Resources System

Lecture 29: Implement HR Schema – Part 1

Lecture 30: Implement HR Schema – Part 2

Lecture 31: Implement HR Schema – Part 3

Lecture 32: Implement HR Schema – Part 4

Lecture 33: Implement HR Schema – Part 5

Lecture 34: Implement HR Schema – Part 6

Lecture 35: Implement HR Schema – Part 7

Lecture 36: Implement HR Schema – Part 8

Lecture 37: How to Create a New User?

Lecture 38: Run SQL Queries on HR Schema

Lecture 39: How to Format Dates?

Instructors

Fahmi Eshaq
SQL Data Analyst

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 2 votes
4 stars: 10 votes
5 stars: 18 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu