Home
Videos uploaded by user “CodeSmith 001”
Informatica : Transformation based Interview questions
 
53:08
Informatica : Transformation based Interview questions
Views: 4361 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: 5206 CodeSmith 001
Concept of Routing Data Using Router (Informatica)
 
09:25
Building the concept of classifying data in groups, based on conditions.
Views: 35 CodeSmith 001
N-th Highest Element Sql (Oracle)  : Generic Solution
 
07:10
Nth Highest Salary Nth Highest Marks Generic Solution
Views: 160 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: 52 CodeSmith 001
ETL: What is an Staging Database
 
04:02
Staging DB, Defined with Example
Views: 3727 CodeSmith 001
Index Creation in Oracle
 
02:32
Index Creation in Oracle
Views: 24 CodeSmith 001
Partitioning In Informatica
 
32:00
Partitioning In Informatica
Views: 2311 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: 277 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: 44 CodeSmith 001
Handling Null values :  NVL And Coalesce
 
07:17
Topic :Handling Null values : NVL And Coalesce 28th 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: 26 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: 21 CodeSmith 001
CHMOD Command in Unix
 
19:35
Permissions in Unix Groups in Unix Read Write Execute
Views: 127 CodeSmith 001
ETL : Informatica Transformations
 
41:01
Informatica Transformations 1. Aggregator 2. Expression 3. Filter
Views: 271 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: 2997 CodeSmith 001
Informatica : Transformations Active/Passive  Classification
 
30:46
Active/Passive Transformations in Informatica, Connected/Unconnected Transformations Basic details
Views: 537 CodeSmith 001
Operators And Expressions (Sql)
 
36:57
Sql: Operators And Expressions
Views: 88 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: 40 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: 11 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: 137 CodeSmith 001
ETL : Lecture 9 : Informatica Architecture
 
26:28
Informatica Architecture , Domain ,Node , Integration services, Repository Metadata
Views: 98 CodeSmith 001
ETL : Sql Basics Lecture:5
 
46:05
Joins Views Transactions Commit,Rollback
Views: 72 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: 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: 38 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: 43 CodeSmith 001
Database Normalization
 
30:57
Topic : Database Normalization 21th 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 https://youtu.be/-t2unhp_T8g
Views: 33 CodeSmith 001
Datatypes : Oracle (Sql)
 
27:02
Oracle Datatypes Difference between Char and Varchar Date Number
Views: 71 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: 44 CodeSmith 001
Synonyms in Oracle
 
03:52
Synonyms in Oracle
Views: 29 CodeSmith 001
Insert Statement In Oracle
 
50:46
Topic : Insert Statement In Oracle 6th 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: 12 CodeSmith 001
Basic Unix Commands
 
25:16
Unix Basics
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: 14 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: 53 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: 11 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: 15 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: 34 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: 10 CodeSmith 001
Views in Oracle
 
08:19
Views : Concept and Usage
Views: 11 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
Set Operations  : Minus, Intersect, Union
 
21:43
Topic : Set Operations : Minus, Intersect, Union 18th 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
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: 3 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: 9 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: 25 CodeSmith 001
Quantitative Aptitude : basic Algebraic formulas proof : L2
 
06:29
Quantitative Aptitude : basic Algebraic formulas proof : L2
Views: 43 CodeSmith 001