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 or SQL Journey for Intermediate / Level 2
Rating: 4.3 out of 5(8 ratings)
29 students

SQL Tutorial or SQL Journey for Intermediate / Level 2

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

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

Explore related topics

Course content

1 section • 23 lectures • 3h 54m total length

  • Data Type Introduction7:50
  • Data Type Character Introduction12:39
  • Data Type Number Introduction7:15
  • Data Type Date Introduction3:19
  • Data Type Lobs and XML Introduction4:38
  • DDL Introduction23:42
  • DDL Create5:16
  • DDL Alter13:06

    Explore ddl alter operations in sql, including adding, modifying, renaming, and dropping columns and tables, with practical examples of alter table statements.

  • DDL Drop and Truncate5:33
  • Single Row Functions - SUBSTR16:09
  • Single Row Functions - INSTR20:01
  • Single Row Functions - LENGTH5:37
  • Single Row Functions - REPLACE10:26
  • Single Row Functions - TRANSLATE8:33

    Learn how the translate function replaces characters in a string with designated replacements in a single expression. See examples of symbol replacement, case sensitivity, and sequential mappings.

  • Single Row Functions - CONCAT6:08
  • Single Row Functions - ABS5:05
  • Single Row Functions - ROUND13:51

    Learn how the round function in SQL rounds numbers to a chosen number of decimal places, including handling dollars and cents and applying rounding for negative values.

  • Single Row Functions - TRUNC5:10
  • Single Row Functions - MOD4:56

    Master the SQL MOD function by computing remainders, using examples like 10 mod 3 to illustrate a remainder of 1, and 18 mod 4 to practice applying the syntax.

  • Single Row Functions - CEIL3:05
  • Single Row Functions - FLOOR3:43
  • Join Introduction33:21
  • Join Syntax14:48

Requirements

  • Must have knowledge from Level 1.
  • We will continue with different Data types, DDL, DML, DCL, TCL and different types of Single Row Functions.

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 59 different journey's of Basic SQL where you learn about following topics.

17. Data Type Introduction

18. Data Type Character

19. Data Type Number

20. Data Type Date

21. Data Type Lobs and XML

22. DDL Introduction

23. DDL Create

24. DDL Alter

25. DDL Drop and Truncate

26. Single Row Functions - Substr

27. Single Row Functions - Instr

28. Single Row Functions - Length

29. Single Row Functions - Replace

30. Single Row Functions - Translate

31. Single Row Functions - Concat

32. Single Row Functions - ABS

33. Single Row Functions - Round

34. Single Row Functions - Trunc

35. Single Row Functions - Mod50

36. Single Row Functions - Ceil

37. Single Row Functions - Floor

38. Join - Introduction

39. Join - Syntax

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