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

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 17 lectures (3h 16m) | Size: 1.41 GB
SQL is a language to operate databases; it includes database creation, deletion, fetching rows, modifying rows, etc

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.

Requirements
No prior experience is required. We will start from the very basics. Oracle/SQL Developer.

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
SQL developer, IICS developer, Informatica developer