SQL Tutorial or SQL Journey for Intermediate / Level 2

[mitsumi]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 23 lectures (3h 54m) | Size: 1.62 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
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
SQL developer, IICS developer, Informatica developer

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction