Intuitive SQL Databases Case Study (Udemy.com)

Practice SQL for Data Science or Database Administration to Help a Startup CEO Manage His Data

( 3 Reviews )

Created by: EzzEddin Abdullah

Produced in 2018

What you will learn

Create a table
Insert values into it
Use and understand some data types
Use SELECT statements
UPDATE records
Use some aggregate functions like COUNT(), MIN(), SUM()
Use WHERE clause
Remove a character from a string
Cast a string to numeric values
Write subquery
Retrieve the top and bottom candidates
Add a column
Do a for loop
Make a histogram
Use DELETE clause
Use IN operator

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 80 / 100

Course Description

If you look forward to being a data scientist or want to refresh your mind of SQL, or just want to practice SQL databases, then I made this course for you. This is not a theoretical course; this is a very practical course
In this course, you will learn how to create a table, insert values into it, use and understand some data types, use SELECT statements, UPDATE records, use some aggregate functions like COUNT(), MIN(), SUM(), use WHERE clause, remove a character from a string, cast a string to numeric values, write subquery, retrieve the top and bottom candidates, add a column, do a for loop, and make a histogram. Who this course is for:

Aspiring data scientists.
Data scientists who want to refresh their mind of SQL by practice. They will benefit but not much as beginners.
Beginner database administrator.

Time: 31m

Instructor Details

EzzEddin Abdullah

4.0 Rating
3 Reviews

Ezz is a former data scientist intern graduated as Electronics and Communications Engineer. He's been teaching programming since the age of 19 to many teams in his college and Master degree students as well. He recently published a SQL article at KDnuggets called "Intuitive SQL Case Study" which he converted into a course here at Udemy with some additional things and coding assignments.
He has done many projects in digital signal processing, control system engineering, communication engineering, satellite communication, and convex optimization. His graduation project included data analytics and prediction tasks in which he used PCR (Principal Component Regression), a machine learning algorithm.
Languages he uses:
- MATLAB, SQL, Julia, R
- Python (numpy, scipy, pandas, matplotlib, scikit-learn, jupyter notebook)

Reviews

4.0

3 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Noureddin

Great introductory and refresher course. Small and to the point. Thanks!

By Rahul Vijayakumar

I was expecting advance topics

By Deepal D'Silva

It's a nice course for a beginner who wants to understand the basics of SQL and immediately get into its applications. I'd love to see a more advanced course in addition to it as well!