SQL for Newcomers - The Full Mastery Course (Udemy.com)

A course to make you an SQL genius!

Created by: Sameh Sharaf

Produced in 2021

icon
What you will learn

  • Able to select & filter data using SQL, fetch data for useful reports based on different requirements.
  • Manipulate data by adding new records & modifying or deleting existing ones.
  • Create & modify tables with setting constraints to columns.
  • Learn some of the most useful built-in functions in SQL, as well as data type conversion.
  • Join tables using different join types SQL provides.
  • Brag about how cool they are knowing how to use SQL with their friends.

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

Hi!
I'm Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I'm experienced enough.
This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.
SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.
I'm a beginner, is this course for me?
Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.
Is there any prerequisites to attend this course?
The only thing you need is a PC or laptop with average performance and any operating system installed on. We'll be using Windows 10 for this course but the OS does not matter since the tech we'll be using is cross-platform and can work on Linux and Mac.Who this course is for:
  • Junior data analysts and scientists.
  • Junior developers who need to work on relational databases.
  • Undergraduate students who study relational databases in their curriculum.
  • Anyone who's interested to learn SQL and add it to their resume.

icon
Instructor Details

placeholder

A data engineer, working with data for 8 years and counting. Passionate for teaching as for learning.
I'm a certified AWS Solution Architect - Associate and Google Cloud Data Engineer Professional.

icon
More postgresql courses

Rock the JVM! Akka Persistence with Scala

$11.99

SQL and PostgreSQL: The Complete Developer's Guide

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

$11.99

Python 3 Complete Masterclass - Make Your Job Tasks Easier!

$11.99

REST APIs with Flask and Python

$11.99

Python Django Dev To Deployment

$11.99

icon
Reviews

4.6

99 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Prateek Singh Kushwah

nice..............

By Henry

Good revision and nice catch up

By Preeti Motagii

very informative for beginner .

By Christian Onyango

very informative, and learning alot, love it

By Md Aamir Reza

I found it very helpful and so far i have completed four sections.

By Muhammad

It’s easy to understand and very easy to learn for anyone

By Michael Jr Obilikwu

Perfect speed, great tone of voice, and easy to understand methods.

By Sudha

Sesssion was very good and informative

By Amita Chandekar

Good presentation. Rate of speech is bit high. unable to grasp few sentences. Overall good teaching.

By Sarvesh Pandey

The lecture is excellent but basic things like create table, insert

/delete/remove/drop data is not their.

It must their in this video lecture.

By Taimoor Khattak

Good class but in whole course i didn't learn how to save query except for saving it on desktop.

Also creating a data set was not define plus no explanation on IDE use or different tabs.

By Bennett Johnson

Pretty good course, you can go from knowing absolutely nothing about SQL to understanding the select statement pretty well and being able to query whatever data you want.

It was a bit slow paced for my liking but that's alright since it allows beginners to work with the videos easier.

Currently only has videos on the select statement but I'm sure Sameh will add more information in the future