SQL for Newcomers – A Crash Course

SQL for Newcomers – A Crash Course, available at Free, has an average rating of 4.8, with 31 lectures, 1 quizzes, based on 578 reviews, and has 17721 subscribers.

You will learn about Prepare your machine to run SQL Able to select & filter data Sort and group data preparing for reports Learn about functions in SQL This course is ideal for individuals who are Students aspiring to become data analysts, scientists or engineers or Junior developers who need to work on relational databases. or Junior data analysts and scientists. or Undergraduate students who study relational databases in their curriculum. or Anyone who's interested to learn SQL and add it to their resume. It is particularly useful for Students aspiring to become data analysts, scientists or engineers or Junior developers who need to work on relational databases. or Junior data analysts and scientists. or Undergraduate students who study relational databases in their curriculum. or Anyone who's interested to learn SQL and add it to their resume.

Enroll now: SQL for Newcomers – A Crash Course

Summary

Title: SQL for Newcomers – A Crash Course

Price: Free

Average Rating: 4.8

Number of Lectures: 31

Number of Quizzes: 1

Number of Published Lectures: 31

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 31

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Prepare your machine to run SQL
Able to select & filter data
Sort and group data preparing for reports
Learn about functions in SQL

Who Should Attend

Students aspiring to become data analysts, scientists or engineers
Junior developers who need to work on relational databases.
Junior data analysts and scientists.
Undergraduate students who study relational databases in their curriculum.
Anyone who's interested to learn SQL and add it to their resume.

Target Audiences

Students aspiring to become data analysts, scientists or engineers
Junior developers who need to work on relational databases.
Junior data analysts and scientists.
Undergraduate students who study relational databases in their curriculum.
Anyone who's interested to learn SQL and add it to their resume.

“Wow! I really regret learning SQL”

– No one ever

Hi!

I’m Sameh Sharaf. I am a data engineer. I work 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, 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?

Of course! This course was done for beginners. Even students with some experience in SQL may find it useful as well, 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.

This course was great, but I want to learn more. What should I do?

Fret not! I have the full SQL course ready for you. It has over 11 HOURS of goodies. Look for: “SQL for newcomers: The Mastery Course”

Psst.. Can I get a discount for your awesome Mastery course??

Send me a message and I will give you a $9.99 coupon! How cool is that!

Enjoy the course and happy learning!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Tools Used in this Course

Chapter 2: Setting Up Course Tools

Lecture 1: Download PostgreSQL

Lecture 2: Install PostgreSQL

Lecture 3: Download SQLectron

Lecture 4: Install SQLectron

Lecture 5: Connect to PostgreSQL – Credentials

Lecture 6: Connect to PostgreSQL Using SQLectron

Lecture 7: Import Course Data Using SQLectron

Lecture 8: FOR WINDOWS 32-BIT USERS: SQL Alternative – DBeaver

Lecture 9: FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

Chapter 3: Browsing & Filtering Data

Lecture 1: Check Imported Data

Lecture 2: So.. What is a Database?

Lecture 3: SQL Data Types

Lecture 4: Finally Some Fun! Extracting Data Based on Requirements

Lecture 5: Filtering Data Using WHERE Keyword

Lecture 6: Filter Data by Range Using BETWEEN

Lecture 7: Filter Data by Set of Values Using IN

Lecture 8: Filter Data by Strings (Names, addresses, …)

Chapter 4: Tidy Up Your Results: Sorting, Alias Names, Limit Records

Lecture 1: Give Your Report Fields A Cool Name

Lecture 2: Order Records by Column

Lecture 3: Order Records by Multiple Columns

Lecture 4: LIMIT Record Count Fetched by Your Query

Chapter 5: NULL & DISTINCT

Lecture 1: What Is A NULL Value Anyway?

Lecture 2: Let Me Introduce You to Functions

Lecture 3: SUM Function

Lecture 4: AVG (Average) Function

Lecture 5: COUNT Function

Lecture 6: GROUP BY Clause: Use Functions with Dimensions

Lecture 7: GROUP BY More Than One Dimension

Chapter 6: Epilogue

Lecture 1: Thank you, next step to proceed learning!

Instructors

Sameh Sharaf
Data Engineer

Rating Distribution

1 stars: 5 votes
2 stars: 6 votes
3 stars: 66 votes
4 stars: 242 votes
5 stars: 259 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