Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Tutorial Journey for Beginner's / Step by Step Level 1
Rating: 4.9 out of 5(5 ratings)
53 students

SQL Tutorial Journey for Beginner's / Step by Step Level 1

SQL is a language to operate databases; it includes database creation, deletion, fetching rows, modifying rows, etc.
Created byRajnees Kumar
Last updated 3/2021
English
English

What you'll learn

  • SQL Database, Understand Complex SQL Concepts in very easy way with examples.
  • At the end of this course anyone will be able to use SQL in any database management system, become expert in SQL.
  • Build and manage real-world data solutions using hands-on projects and scenarios
  • Gain practical experience in data analysis and reporting using SQL

Course content

1 section • 17 lectures • 3h 16m total length

  • SQL Journey Overview13:55

    Begin a four-level sql journey from level one basics to level four complex sql, mastering select queries, ddl/dml/dcl, joins, analytic and conversion functions, constraints, partitioning, and database architecture, with tests.

  • Journey 1 (Database Introduction)20:56

    Explore the level one database introduction in the SQL journey, examining data as an asset and how databases organize, store, and retrieve information from pre-computer era to computer era.

  • Journey 2 Basic Clause (SQL Clause: SELECT and FROM)15:31

    Master the basic sql clauses by using select and from to retrieve data from the employees table, and learn how to query databases with sql developer.

  • Journey 3 Simple Filter (SQL Operators: Where, Equality and inEquality)16:46

    Learn to filter SQL data using the where clause, equality and inequality operators, and sort results with order by in ascending or descending order.

  • Journey 5 Advance Filter part-2 (SQL Operators: ANY, ALL, IN)12:05

    Master SQL any, all, and in operators through practical examples on salaries and department ids, learning how to filter rows based on any one, all, or exact matches.

  • Journey 4 Advance Filter part-1(OR, AND, BETWEEN)15:18

    Master the journey four advance filter part one concepts in SQL—or, and, between—with practical salary and department examples.

  • Journey 6 Advance Filter part-3 (SQL Operators: Like)21:17

    Learn advanced filtering with the SQL like operator, using % and _ wildcards and escape characters to match starts with, ends with, or contains patterns.

  • Journey 7 (Single Row Function Introduction)7:18

    Learn the fundamentals of SQL functions, focusing on single row functions, their types across character, number, date, null, and conversion data, with distinctions from aggregate functions.

  • Journey 8 Single Row Function (SQL: CHAR Introduction)6:09

    Journey 8 introduces single-row char functions, including case conversion (upper, lower, initcap) and case manipulation (trim, ltrim, rtrim, lpad, rpad), with a preview of substring and replace.

  • Journey 9: Single Row Function (SQL: NUMBER Introduction)10:24

    Discover single row number functions in SQL, including mod, round, trunc, ceil, floor, absolute, power, and square root, with practical examples. Preview their syntax and usage across basic scenarios.

  • SQL Journey 10: Single Row Function (SQL: DATE Introduction)5:28

    this lecture introduces sql date functions, focusing on add_months, month_between, and last_day, with practical examples using sysdate and date arithmetic to prepare for future syntax.

  • Journey 11: Single Row Function (SQL: NULL Introduction)13:48

    Explore what null means as an unknown value in SQL, and learn introductory single-row functions—NVL, COALESCE, NULLIF, and NVL2—to substitute or manage nulls in queries.

  • Journey 12: Single Row Function (SQL: CONTROL Introduction)7:14

    Explore the foundations of SQL control functions, learn how if-else statements and case and decode control statements guide decision logic, and preview their use in future journeys.

  • Journey 13: Single Row Function (SQL: Conversion Introduction)5:17

    Explore the single row conversion functions in SQL, including to_char, to_date, and to_number, with practical examples transforming dates and numbers into and from character types and formatted dates.

  • Journey 14: Single Row Function || Char Part-1 (SQL: UPPER, LOWER, INITCAP)9:12

    Explore the single row character functions in SQL, focusing on upper, lower, and initcap, with syntax and practical examples to normalize case in names and IDs.

  • Journey 15: Single Row Function || Char Part-2 (SQL: TRIM, LRIM, RTRIM)7:42

    Explore single row character functions by trimming spaces with trim and ltrim. See how rtrim handles the right side while trim cleans both sides and ltrim the left.

  • Journey 16: Single Row Function || Char Part-3 (SQL: PAD, LPAD, RPAD)8:31

    Journey 16 of the SQL level one teaches padding with pad, lpad, and rpad to produce fixed-width, left or right padded values for reports and data exports.

Requirements

  • No prior experience is required. We will start from the very basics. Oracle/SQL Developer.
  • This course is beginner-friendly.
  • Basic understanding of computers and internet usage.
  • A laptop or desktop with internet access.
  • Willingness to learn and practice hands-on exercises

Description

This course provides a comprehensive introduction to the language of relational databases: Structured Query Language (SQL).

Our Course Specialties

1. We divide each course In 4 Levels (Basic, Intermediate, Advanced, Complex).

2. At each level, we have several modules.

3. At each module,

       I. we have a separate video, where we briefly covered about that module.

       II. Lesson: Where you can read about that module.

       III. Assignments: In each module, we have 5/10/15 questions where you can do the practice.

       IV. Exams: In each module, we have 5/10/15 questions where you can check your skills, how much you learn it yourself from vaanii portal.

Except these things we also provide live online class where you can interact with us and we will help you throughout the course.

In this we provide 16 different journey's of Basic SQL where you learn about following topics.

0 SQL journey overview

1 Database Introduction

2 Basic Clause

3 Simple Filter and Sort

4 Advance Filter - 1(AND,OR, BETWEEN)

5 Advance Filter - 2(ANY,ALL,IN)

6 Advance Filter - 3(LIKE)

7 Single Row Function Introduction

8 Single Row Function Introduction (CHAR)

9 Single Row Function Introduction (NUMBER)

10 Single Row Function Introduction (DATE)

11 Single Row Function Introduction (NULL)

12 Single Row Function Introduction (CONTROL)

13 Single Row Function Introduction (CONVERSION)

14 Single Row functions -1 (UPPER,LOWER,INITCAP)

15 Single Row functions -2 (TRIM,LTRIM,RTRIM)

16 Single Row functions -3 (PAD,LPAD,RPAD)

Who this course is for:

  • Beginners who want to start their journey in SQL and Data Engineering
  • Students and freshers looking to build a strong foundation in databases
  • Working professionals who want to upskill or switch to data-related roles
  • Developers, testers, or analysts who want to work with data more effectively
  • Anyone preparing for SQL interviews or data-focused job roles

Report abuse