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.
Requirementsmust have knowledge from Level 1. We will continue with different Data types, DDL, DML, DCL, TCL and different types of Single Row Functions.
DescriptionThis 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 forSQL developer, IICS developer, Informatica developer
DOWNLOAD:
- Citación :
https://rapidgator.net/file/045dd1f11f3d42d21dce036e62def60c/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part1.rar.html
https://rapidgator.net/file/4d21768d95d20f82a0b48f40e82608c6/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part2.rar.html
https://uploadgig.com/file/download/1280931a908ee9eD/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part1.rar
https://uploadgig.com/file/download/526431CaEe3998C5/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part2.rar
https://nitroflare.com/view/3EBAF338847634E/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part1.rar
https://nitroflare.com/view/A9E063701F58065/0c8b8.SQL.Tutorial.or.SQL.Journey.for.Intermediate..Level.2.part2.rar