Udemy

The Ultimate Guide to learn SQL from scratch

Enroll Now
  • 3,311 Students
  • Updated 9/2024
4.4
(104 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 12 Minute(s)
Language
English
Taught by
Dr. Satyajit Pattnaik
Rating
4.4
(104 Ratings)

Course Overview

The Ultimate Guide to learn SQL from scratch

Master SQL within few hours!!

Do you know that SQL is one of the top asked skills for any Data Analyst roles?

Do you know that database skills are most essential for developers to be skilled in and understand?

Do you want to understand SQL and databases in general, but don't know where to start?

If you have any such questions in your mind, why don't you checkout below to get more details about the course, and learn who the trainer is.


This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. After completing the course, I promise you, you'll never be afraid to look at a large SQL query again.

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, window functions, transposing & ranking data and using conditional expressions in very interesting ways.


Key concepts you will learn and work with in this course:

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design, Database Architecture!!

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries (DQL)
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases

Windows Functions

Stored Procedures


and at the end, I will also explain you how to interact with MySQL database from Python :)


What's more?

You also get unlocked to a beautiful SQL interview Q&A sheet which has more than 100+ mostly asked interview questions.


The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.

SQL and MySQL skills are in high demand, and you will be able to understand everything by the time you finish up this course.

Your new job or consulting opportunity awaits!


Why not get started today?

Course Content

  • 10 section(s)
  • 21 lecture(s)
  • Section 1 Introduction
  • Section 2 Installation
  • Section 3 Basics of Data Architecture
  • Section 4 Introduction to SQL
  • Section 5 Table Basics
  • Section 6 Joins in SQL
  • Section 7 Data Import & Export
  • Section 8 Functions in SQL
  • Section 9 Nested Queries
  • Section 10 Views

What You’ll Learn

  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL on their resume
  • Learn to perform GROUP BY statements


Reviews

  • A
    Abhaya Moharana
    5.0

    this sql course is very intresting and here all topics are covered in very easy with gave some Basic to advanced levels example with explanation so I am very grateful and to improve my sql skill thank you.

  • P
    Pranay Manusmare
    4.0

    yes the course explain all the concepts in beginner friendly and well manner

  • L
    Laxmi Chourasiya
    5.0

    teaching way in details

  • S
    Somenath Paul
    5.0

    great content

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed