Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

SQL For Newcomers: The Full Mastery Course

person icon Sameh Sharaf

4.4

SQL For Newcomers: The Full Mastery Course

This course will teach you how to use SQL (Structured Query Language), a language & make a genius in SQL

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Sameh Sharaf

English [CC]

category icon Development ,Database and Design Development,SQL

Lectures -123

Duration -11 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLite 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 on 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 learn 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. 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 is this course 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 in learning SQL and add it to their resume.

Goals

  • Able to select & filter data using SQL, and fetch data for useful reports based on different requirements.
  • Manipulate data by adding new records & modifying or deleting existing ones.
  • Create & modify tables by 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.

Prerequisites

  • Have a PC or laptop to work on. Your old clunky notebook will do.
  • Can work on any operating system (Windows, Linux & MacOS).
SQL For Newcomers: The Full Mastery Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

2 Lectures
  • play icon Introduction 01:15 01:15
  • play icon Tools Used in This Course 01:00 01:00

Setting Up Course Tools

8 Lectures
Tutorialspoint

Browsing & Filtering Data

15 Lectures
Tutorialspoint

Filter Data with AND, OR, NOT Operators

4 Lectures
Tutorialspoint

Math Operations

4 Lectures
Tutorialspoint

String Concatenation

2 Lectures
Tutorialspoint

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

6 Lectures
Tutorialspoint

NULL, DISTINCT & CASE Statements

5 Lectures
Tutorialspoint

Functions in SQL: Multiple-Row Functions

10 Lectures
Tutorialspoint

Functions in SQL: Single-Row Functions

8 Lectures
Tutorialspoint

Nested Queries

1 Lectures
Tutorialspoint

Casting & Data Conversion

6 Lectures
Tutorialspoint

Combination Relationships

5 Lectures
Tutorialspoint

Joins in SQL

8 Lectures
Tutorialspoint

Data Manipulation (DML)

9 Lectures
Tutorialspoint

SQL Data Definition Language (DDL)

23 Lectures
Tutorialspoint

Access Control

6 Lectures
Tutorialspoint

Instructor Details

Sameh Sharaf

Sameh Sharaf

A data engineer, working with data since 2010. Passionate for teaching as for learning.

I'm a certified AWS Solution Architect - Associate and Google Cloud Data Engineer Professional. Experienced with MS Azure and Databricks.

I enjoy building data solutions, aspiring to be a data architect.

If you don't find me online, I can be probably playing badminton, going to short hikes or traveling somewhere around the globe for pleasure or business.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515