Home
Videos uploaded by user “CodeSmith 001”
Informatica : Transformation based Interview questions
 
53:08
Informatica : Transformation based Interview questions
Views: 5909 CodeSmith 001
Hierarchical Queries (Oracle)
 
03:33
Hierarchical Queries in Oracle, Using CONNECT BY PRIOR and START WITH clause. Visual Example using a practical scenario.
Views: 6656 CodeSmith 001
Partitioning In Informatica
 
32:00
Partitioning In Informatica
Views: 2813 CodeSmith 001
N-th Highest Element Sql (Oracle)  : Generic Solution
 
07:10
Nth Highest Salary Nth Highest Marks Generic Solution
Views: 180 CodeSmith 001
ETL: What is an Staging Database
 
04:02
Staging DB, Defined with Example
Views: 4552 CodeSmith 001
Informatica : Transformations Active/Passive  Classification
 
30:46
Active/Passive Transformations in Informatica, Connected/Unconnected Transformations Basic details
Views: 683 CodeSmith 001
Case Statement in Oracle
 
13:05
Topic: Case Statement in Oracle 27th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. https://www.facebook.com/binary01010101/ This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 16 CodeSmith 001
CHMOD Command in Unix
 
19:35
Permissions in Unix Groups in Unix Read Write Execute
Views: 163 CodeSmith 001
Concept of Routing Data Using Router (Informatica)
 
09:25
Building the concept of classifying data in groups, based on conditions.
Views: 41 CodeSmith 001
Date Time Handiling Using To_Date and To_Char (Oracle)
 
17:48
Date Time Handling Using To_Date and To_Char (Oracle) Discussion on an Interview question Useful Links: http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions183.htm https://www.techonthenet.com/oracle/functions/to_date.php
Views: 3312 CodeSmith 001
Oracle Sql : Exists Clause
 
21:26
Topic : Exists Clause 19th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 76 CodeSmith 001
Types of SQL Statements
 
05:02
Types of SQL Statements Data Definition Language (DDL) Data Manipulation Language (DML) Data Query Language (DQL) Transaction Control Language (TCL) Data Control Language (DCL)
Views: 23 CodeSmith 001
Ways to delete duplicate records: Oracle
 
26:26
Topic : Ways to delete duplicate records: Oracle 20th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon. Other Videos of same series : https://www.youtube.com/watch?v=b19w2vs8IE0 https://youtu.be/b19w2vs8IE0 https://youtu.be/Mtp81d-YBpI More Theory: https://www.wikihow.com/Delete-Duplicate-Records-in-Oracle
Views: 38 CodeSmith 001
Dr. Edger F Codd Rules : RDBMS Fundamental concepts
 
49:41
Topic : Dr. Edger F Codd Rules : RDBMS Fundamental concepts 1st Video of this Series Please mail [email protected] ,Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on SQL (DBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 372 CodeSmith 001
Operators And Expressions (Sql)
 
36:57
Sql: Operators And Expressions
Views: 101 CodeSmith 001
Similarities and Differences between Char and Varchar
 
25:37
Topic : Datatype :Similarities and Differences between Char and Varchar 2nd Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified everytime i post something ; Please subscribe to this channel and press the bell icon. I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 66 CodeSmith 001
ETL : Sql Basics Lecture:5
 
46:05
Joins Views Transactions Commit,Rollback
Views: 77 CodeSmith 001
Joins : Arithematic Explaination using set theory and Basic Syntax
 
01:11:33
Topic : Joins : Arithmetic Explanation using set theory and Basic Syntax 10th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected], Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 56 CodeSmith 001
String Operations in ORACLE : Substr and Instr
 
44:32
Topic : String Operations in ORACLE : Substr and Instr 22th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon. Other Videos of same series : https://youtu.be/oxmOJW1S09Y https://youtu.be/lHKr9HNwCBA https://www.youtube.com/watch?v=b19w2vs8IE0 https://youtu.be/b19w2vs8IE0 https://youtu.be/Mtp81d-YBpI https://youtu.be/-t2unhp_T8g
Views: 37 CodeSmith 001
Oracle Basic Query Syntax
 
07:21
Topic : Oracle Basic Query Syntax : Select Statement 4th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 16 CodeSmith 001
ETL : Informatica Transformations
 
41:01
Informatica Transformations 1. Aggregator 2. Expression 3. Filter
Views: 348 CodeSmith 001
ETL : Sql Basics Lecture:4
 
01:13:30
Topics Discussed: Basic Syntax in SQL (Oracle) Basics of boolean Operations Aggregation Group by clause Aggregation/ Group by operations Referential integrity Links: https://www.tutorialspoint.com/sql/ https://oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions https://www.hackerrank.com/domains/sql/aggregation/page:1 https://docs.oracle.com/cd/B19306_01/server.102/b14220/data_int.htm
Views: 61 CodeSmith 001
Components of a Datawarehouse : Concept and applications
 
01:37:13
Topic : Components of a Data-warehouse : Concept and applications 16th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 239 CodeSmith 001
Joins Exercise Solutions
 
01:20:40
Topic : Joins : Examples 11th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on SQL (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 55 CodeSmith 001
Analytical Queries : Row Number, Rank and Dense_Rank
 
10:08
Topic : Analytical Queries : Row Number, Rank and Dense_Rank : Their Syntax and Usage 15th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 60 CodeSmith 001
Datatypes : Oracle (Sql)
 
27:02
Oracle Datatypes Difference between Char and Varchar Date Number
Views: 86 CodeSmith 001
DWH :  dimensional data modelling
 
40:42
Topic : Components of a Data-warehouse : DWH : dimensional data modelling 17th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon. Other Videos of same series : https://www.youtube.com/watch?v=b19w2vs8IE0 https://youtu.be/b19w2vs8IE0
Views: 44 CodeSmith 001
Synonyms in Oracle
 
03:52
Synonyms in Oracle
Views: 39 CodeSmith 001
Quantitative Aptitude : basic Algebraic formulas proof : L2
 
06:29
Quantitative Aptitude : basic Algebraic formulas proof : L2
Views: 47 CodeSmith 001
Sql Interview Question Series : Part 1
 
12:18
Understanding Application of Cartesian product, Discussion Creating Unique groups of 2 in a Team. Question 2 As assignment, to be discussed in next video in this series.
Views: 45 CodeSmith 001
ER Data Modelling : Church Management
 
21:04
Topic : ER Data Modelling 14th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 16 CodeSmith 001
Illustration: Slowely Changing Dimentions
 
09:25
Topic : Illustration: Slowly Changing Dimensions 12th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] for Upcoming trainings. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 15 CodeSmith 001
Index Creation in Oracle
 
02:32
Index Creation in Oracle
Views: 26 CodeSmith 001
Sql Interview Question Series : Part 2
 
16:47
Solving The Scenario based problem using analytical Queries and Joins. Solution to the Question asked in PART 1.
Views: 26 CodeSmith 001
Alter Table Statement
 
59:02
Topic : Alter Table Statement In Oracle: RDBMS Fundamental concepts 7th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 3 CodeSmith 001
Keys In Sql
 
16:25
Keys In SQL : Natural Key ,Candidate Key and Surrogate Key
Views: 48 CodeSmith 001
Quantitative Aptitude: Arithmetic Progressions
 
05:37
Quantitative Aptitude: Arithmetic Progressions Please Like and Share !!!
Views: 9 CodeSmith 001
Views in Oracle
 
08:19
Views : Concept and Usage
Views: 14 CodeSmith 001
Create table statement , drop truncate & delete
 
25:14
Topic : Create table statement, similarity and differences between drop truncate and delete 5th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 17 CodeSmith 001
Alter Table Statement (Sql)
 
16:44
Alter Table Statement Explained with examples
Views: 11 CodeSmith 001
Refrential Integrity : Primary Key Foreign Key Relationship
 
19:23
Topic : Refrential Integrity : Primary Key Foreign Key Relationship 3rd Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 5 CodeSmith 001
Creating ER Diagram Part 2
 
13:19
Topic : Creating ER Diagram Part 2: Entity Relationship Diagram: RDBMS Fundamental concepts 9th Video of this Series Comments/Suggestions are welcome get in touch with us, by mailing [email protected] , Or comment down here if you have any questions. This is an Unedited Video from the Live sessions on Sql (RDBMS) I will be posting a complete series of these tutorials on this channel, If you would like to be notified every time i post something ; Please subscribe to this channel and press the bell icon.
Views: 7 CodeSmith 001
Quantitative Aptitude: Geometric Progressions
 
05:57
Quantitative Aptitude: Geometric Progressions Please Like and Share !!!
Views: 10 CodeSmith 001
Vlookup :  Lookup values in Spreadsheets
 
05:49
Vlookup : Vertical Lookup function to get values from Another range(s),Tables(s) Using Key(s) from Current Range/Table.
Views: 13 CodeSmith 001
Logical Operators In Sql
 
01:05:13
Logical Operators In Sql : live session (Unedited)
Views: 29 CodeSmith 001
Sequence Generator Transformation - Theory
 
16:56
Sequence Generator Transformation in Informatica: Sequence generator transformation is a passive and connected transformation. The sequence generator transformation is used for • Generating unique primary key values. • Replace missing primary keys • Generate surrogate keys for dimension tables in SCDs. • Cycle through a sequential range of numbers.
Views: 45 CodeSmith 001