SQL Tutorial Journey for Beginner's / Step by Step Level 1
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.
- No prior experience is required. We will start from the very basics. Oracle/SQL Developer.
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
I have 14+ years of experience in IT of all phases of SDLC combined with excellent experience as an ETL Architect and Lead.
12+ years of Data Warehousing design and development experience using ETL tools like Informatica PowerCenter, SSIS in Securities, HealthCare, Insurance, Bank and Finance and Manufacturing domains.
About 5+ Years of experience in Data Modelling and Data Analysis, expertise in change data capture and developed real-time data warehouse system using CDC tool Informatica PowerExchange.
4+ years Informatica Data Quality.
14+ years of experience and strong knowledge of Database like Oracle, Teradata, DB2, SQL server, and Hive.
7+ years of experience of leading team of average ten members of onsite-offshore.
2+ years of project management experience & single point of contact (SPOC) of project.
2+ years of experience of data modeling using Erwin.
1+ years of Data Architect experience.
Strong knowledge of Data warehousing and Database concepts.
Involve in requirement gathering, data modeling, design, development, testing, migration and production support.
Hands on experience of OBIEE, Actuate 10, BO 7/BO XI R2, Teradata 13/12 and SSIS 2008.
Strong in shell scripting and Perl scripting.
Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.
Equally successful in both team and self-directed settings and proficient in a range of computer systems, languages, tools and testing methodologies.
Worked on multiple projects simultaneously as an Technical lead.