|
|
001 Scnr_1_Converting_Column_to_Rows.mp4
|
MP4
|
129.5 MB
|
|
|
001 Scnr_1_Converting_Column_to_Rows_en.srt
|
SRT
|
21.7 KB
|
|
|
002 Scnr_2_Split_NonKey_Columns.mp4
|
MP4
|
44.4 MB
|
|
|
002 Scnr_2_Split_NonKey_Columns_en.srt
|
SRT
|
6.8 KB
|
|
|
003 Scnr_3_Generating_SeqNo_Using_Exp_Trnfn.mp4
|
MP4
|
59.3 MB
|
|
|
003 Scnr_3_Generating_SeqNo_Using_Exp_Trnfn_en.srt
|
SRT
|
6.5 KB
|
|
|
004 Scnr_4_Separating_Dup_NonDup_Records.mp4
|
MP4
|
79.1 MB
|
|
|
004 Scnr_4_Separating_Dup_NonDup_Records_en.srt
|
SRT
|
9.3 KB
|
|
|
005 Scnr_5_SplittingRecords_Cyclic_Orderof_10.mp4
|
MP4
|
109.3 MB
|
|
|
005 Scnr_5_SplittingRecords_Cyclic_Orderof_10_en.srt
|
SRT
|
12.2 KB
|
|
|
006 Scnr_6_Concatenating_Values.mp4
|
MP4
|
36.1 MB
|
|
|
006 Scnr_6_Concatenating_Values_en.srt
|
SRT
|
11 KB
|
|
|
007 Scnr_7_Cumulative_Sum_Salary.mp4
|
MP4
|
38.9 MB
|
|
|
007 Scnr_7_Cumulative_Sum_Salary_en.srt
|
SRT
|
7.8 KB
|
|
|
008 Scnr_8_Adding_Previous_Row_Salary_Only.mp4
|
MP4
|
54.1 MB
|
|
|
008 Scnr_8_Adding_Previous_Row_Salary_Only_en.srt
|
SRT
|
9.4 KB
|
|
|
009 Scnr_9_Generating_Filename_Dynamically.mp4
|
MP4
|
60.6 MB
|
|
|
009 Scnr_9_Generating_Filename_Dynamically_en.srt
|
SRT
|
8.8 KB
|
|
|
010 Scnr_10_Removing_Dollar_Sign.mp4
|
MP4
|
53.7 MB
|
|
|
010 Scnr_10_Removing_Dollar_Sign_en.srt
|
SRT
|
6.6 KB
|
|
|
011 Scnr_11_Unique_City_Distance.mp4
|
MP4
|
40.5 MB
|
|
|
011 Scnr_11_Unique_City_Distance_en.srt
|
SRT
|
5.1 KB
|
|
|
012 Scnr_12_Using_Mapping_Parameter_in_ParamFile.mp4
|
MP4
|
64 MB
|
|
|
012 Scnr_12_Using_Mapping_Parameter_in_ParamFile_en.srt
|
SRT
|
8.5 KB
|
|
|
013 Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls.mp4
|
MP4
|
62 MB
|
|
|
013 Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls_en.srt
|
SRT
|
8.4 KB
|
|
|
014 Scnr_14_Count_No_of_Vowels_Consonants.mp4
|
MP4
|
84.6 MB
|
|
|
014 Scnr_14_Count_No_of_Vowels_Consonants_en.srt
|
SRT
|
9.3 KB
|
|
|
015 Scnr_15_Removing_Special_Char.mp4
|
MP4
|
22.1 MB
|
|
|
015 Scnr_15_Removing_Special_Char_en.srt
|
SRT
|
5.5 KB
|
|
|
016 Scnr_16_Days_Difference_2_Days.mp4
|
MP4
|
44.4 MB
|
|
|
016 Scnr_16_Days_Difference_2_Days_en.srt
|
SRT
|
6.3 KB
|
|
|
017 Scnr_17_Date_Difference_in_Hrs.mp4
|
MP4
|
20.3 MB
|
|
|
017 Scnr_17_Date_Difference_in_Hrs_en.srt
|
SRT
|
4.8 KB
|
|
|
018 Scnr_18_Adding_Days_to_Date.mp4
|
MP4
|
41.2 MB
|
|
|
018 Scnr_18_Adding_Days_to_Date_en.srt
|
SRT
|
5.7 KB
|
|
|
019 Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year.mp4
|
MP4
|
31.8 MB
|
|
|
019 Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year_en.srt
|
SRT
|
8.9 KB
|
|
|
020 Scnr_20_Extracting_FNAME_MNAME_LNAME.mp4
|
MP4
|
63.7 MB
|
|
|
020 Scnr_20_Extracting_FNAME_MNAME_LNAME_en.srt
|
SRT
|
11.4 KB
|
|
|
021 Scnr_21_Convert_Number_Value_to_Date.mp4
|
MP4
|
45.9 MB
|
|
|
021 Scnr_21_Convert_Number_Value_to_Date_en.srt
|
SRT
|
7.4 KB
|
|
|
022 Scnr_22_Checking_Hiredate_Column.mp4
|
MP4
|
24 MB
|
|
|
022 Scnr_22_Checking_Hiredate_Column_en.srt
|
SRT
|
6.9 KB
|
|
|
023 Scnr_23_Separating_H_D_F.mp4
|
MP4
|
187.6 MB
|
|
|
023 Scnr_23_Separating_H_D_F_en.srt
|
SRT
|
26.2 KB
|
|
|
024 Scnr_24_Dup_NonDup_in_2_Method.mp4
|
MP4
|
152 MB
|
|
|
024 Scnr_24_Dup_NonDup_in_2_Method_en.srt
|
SRT
|
19.5 KB
|
|
|
025 Scnr_25_Previous_Row_Salary_Current_Row.mp4
|
MP4
|
47.1 MB
|
|
|
025 Scnr_25_Previous_Row_Salary_Current_Row_en.srt
|
SRT
|
6.3 KB
|
|
|
026 Scnr_26_Next_Row_Sal_Curr_Row.mp4
|
MP4
|
49.3 MB
|
|
|
026 Scnr_26_Next_Row_Sal_Curr_Row_en.srt
|
SRT
|
9.4 KB
|
|
|
027 Scnr_27_Sum_of_Sal_Repeat_On_All_Rows.mp4
|
MP4
|
42.9 MB
|
|
|
027 Scnr_27_Sum_of_Sal_Repeat_On_All_Rows_en.srt
|
SRT
|
8.1 KB
|
|
|
028 Scnr_28_Concatenate_Values_Per_ID_Column.mp4
|
MP4
|
26.5 MB
|
|
|
028 Scnr_28_Concatenate_Values_Per_ID_Column_en.srt
|
SRT
|
6.4 KB
|
|
|
029 Scnr_29_Concatenate_All_Values.mp4
|
MP4
|
45.3 MB
|
|
|
029 Scnr_29_Concatenate_All_Values_en.srt
|
SRT
|
7 KB
|
|
|
030 Scnr_30_Concatenate_Values_ID_Column_Only.mp4
|
MP4
|
48 MB
|
|
|
030 Scnr_30_Concatenate_Values_ID_Column_Only_en.srt
|
SRT
|
6.8 KB
|
|
|
031 Scnr_31_Slit_Half_Records_Into_Separate_Table.mp4
|
MP4
|
81.6 MB
|
|
|
031 Scnr_31_Slit_Half_Records_Into_Separate_Table_en.srt
|
SRT
|
10.9 KB
|
|
|
032 Scnr_32_Except_Last_5_Records.mp4
|
MP4
|
83.2 MB
|
|
|
032 Scnr_32_Except_Last_5_Records_en.srt
|
SRT
|
12.2 KB
|
|
|
033 Scnr_33_Split_Odd_Even_Records.mp4
|
MP4
|
63.7 MB
|
|
|
033 Scnr_33_Split_Odd_Even_Records_en.srt
|
SRT
|
8.7 KB
|
|
|
034 Scnr_34_Use_Mapping_Parameter_In_Paramfile.mp4
|
MP4
|
54.9 MB
|
|
|
034 Scnr_34_Use_Mapping_Parameter_In_Paramfile_en.srt
|
SRT
|
6.9 KB
|
|
|
035 Scnr_35_Generate_Seq_via_SQL_Transf.mp4
|
MP4
|
69.5 MB
|
|
|
035 Scnr_35_Generate_Seq_via_SQL_Transf_en.srt
|
SRT
|
9.7 KB
|
|
|
036 Scnr_36_Generate_FF_Dynamically_Deptno.mp4
|
MP4
|
108.5 MB
|
|
|
036 Scnr_36_Generate_FF_Dynamically_Deptno_en.srt
|
SRT
|
13 KB
|
|
|
037 Scnr_37_Load_Mutliple_Files_In_Single_File.mp4
|
MP4
|
116.6 MB
|
|
|
037 Scnr_37_Load_Mutliple_Files_In_Single_File_en.srt
|
SRT
|
16 KB
|
|
|
038 Scnr_38_First_Last_Record_Same_Table.mp4
|
MP4
|
49.4 MB
|
|
|
038 Scnr_38_First_Last_Record_Same_Table_en.srt
|
SRT
|
6.6 KB
|
|
|
039 Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf.mp4
|
MP4
|
74.7 MB
|
|
|
039 Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf_en.srt
|
SRT
|
8.7 KB
|
|
|
040 Scnr_40_Replace_Dollar_With_Rupee_Sign.mp4
|
MP4
|
31.4 MB
|
|
|
040 Scnr_40_Replace_Dollar_With_Rupee_Sign_en.srt
|
SRT
|
6.1 KB
|
|
|
041 Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf.mp4
|
MP4
|
51.9 MB
|
|
|
041 Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf_en.srt
|
SRT
|
7 KB
|
|
|
042 Scnr_42_Extracting_Every_5th_Row.mp4
|
MP4
|
41.9 MB
|
|
|
042 Scnr_42_Extracting_Every_5th_Row_en.srt
|
SRT
|
5.2 KB
|
|
|
043 Scnr_43_First_3_Records.mp4
|
MP4
|
65.6 MB
|
|
|
043 Scnr_43_First_3_Records_en.srt
|
SRT
|
8.3 KB
|
|
|
044 Scnr_44_Last_3_Records.mp4
|
MP4
|
41.3 MB
|
|
|
044 Scnr_44_Last_3_Records_en.srt
|
SRT
|
6.3 KB
|
|
|
045 Scnr_45_Run_3rd_Session_After_3_Runs_Only.mp4
|
MP4
|
124.8 MB
|
|
|
045 Scnr_45_Run_3rd_Session_After_3_Runs_Only_en.srt
|
SRT
|
16 KB
|
|
|
046 Scnr_46_Divide_Records_In_2_Half_Using_MV_WV.mp4
|
MP4
|
148.4 MB
|
|
|
046 Scnr_46_Divide_Records_In_2_Half_Using_MV_WV_en.srt
|
SRT
|
19.5 KB
|
|
|
047 Scnr_47_Load_Data_Based_On_Runs.mp4
|
MP4
|
104.1 MB
|
|
|
047 Scnr_47_Load_Data_Based_On_Runs_en.srt
|
SRT
|
11.4 KB
|
|
|
048 Scnr_48_Creating_Email_Id_From_Diff_Columns.mp4
|
MP4
|
40.3 MB
|
|
|
048 Scnr_48_Creating_Email_Id_From_Diff_Columns_en.srt
|
SRT
|
5.3 KB
|
|
|
049 Scnr_49_Breaking_Emailid_In_Diff_Columns.mp4
|
MP4
|
55.6 MB
|
|
|
049 Scnr_49_Breaking_Emailid_In_Diff_Columns_en.srt
|
SRT
|
10.7 KB
|
|
|
050 Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp.mp4
|
MP4
|
68 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
