SQL Query Expertise with only 10 clauses
15:11
Пікірлер
@ReikoHuff-e8q
@ReikoHuff-e8q 3 күн бұрын
I am tired and don't want to touch it anymore. I still have 89USD in OKX wallet but I am too lazy to withdraw it. Here is the mnemonic of OKX wallet ({pride}-{pole}-{obtain}-{together}-{second}-{when}-{future}-{mask}-{review}-{nature}-{potato}-{bulb}, for all the friends who are lucky enough to get it.
@raunakgupta1475
@raunakgupta1475 7 күн бұрын
Loved it
@NurtureLearning
@NurtureLearning 7 күн бұрын
thanks for liking and commenting...
@mdkawsarkhan5154
@mdkawsarkhan5154 24 күн бұрын
no
@mdkawsarkhan5154
@mdkawsarkhan5154 24 күн бұрын
303 has been deducted from my account but still not returning
@Pedr0Diniz
@Pedr0Diniz 28 күн бұрын
Great video, thank you for the explanation.
@NurtureLearning
@NurtureLearning 21 күн бұрын
Glad it was helpful!
@MrAlangari97
@MrAlangari97 Ай бұрын
Thank you for sharing this information, But What’s the purpose of clearing and settlement? Why the money is not transferred as soon as the transaction has been authorized? Is there any example for a transaction that has been authorized but cannot be cleared & settled? There is a manual process for some?
@NurtureLearning
@NurtureLearning Ай бұрын
When the card transaction is done, there are frauds which are possible e.g. lost card (e.g. the card was stolen, in this case the liability is with issuing bank mostly). OR the customer goes for returns and chargebacks (which is the responsibility of merchant; the merchant may not charge/settle OR may refund). For these cases, for accounting checks, and for efficient batch processing settlement is done (and this process is followed). For the chargeback cases there may not be any settlement (in some cases where chargeback is after settlement, there is a refund process).
@nareshsharma-wv1xb
@nareshsharma-wv1xb Ай бұрын
Just a question as per your first authorisation diagram. It’s shows once we swipe the card it sends the detail to issuer bank then request goes to master Visa cards. But it should work in this way once a customer swipe its cards at pos the processor send the details to the visa/master network and then request goes to issuer bank.
@magickmagazine7675
@magickmagazine7675 Ай бұрын
thank you most helpful - I forgot how to do this - thank you for the reminder
@NurtureLearning
@NurtureLearning Ай бұрын
Glad it was helpful...
@sebastianzelechowski8557
@sebastianzelechowski8557 Ай бұрын
Super simple and clear info, Thanks a lot!
@NurtureLearning
@NurtureLearning Ай бұрын
thanks for liking and commenting 💐
@najma21
@najma21 2 ай бұрын
Thanks for explaining it so clearly. I just started working on a debit cards project and this video helped me to understand the basic process.
@NurtureLearning
@NurtureLearning Ай бұрын
thanks so much for your generous comments 💐
@RohitSingh-sm4on
@RohitSingh-sm4on 2 ай бұрын
I love your content sir you really make amazing content is there is way i can connect to you sir 🙃
@RohitSingh-sm4on
@RohitSingh-sm4on 2 ай бұрын
@abdulwahab-mf2cm
@abdulwahab-mf2cm 2 ай бұрын
Can you please explain Pre Auth and Auth Host too?
@ayush21Q3
@ayush21Q3 2 ай бұрын
Can you share the slide please. Thanks for the content
@NurtureLearning
@NurtureLearning 18 күн бұрын
Thanks for your comment, unfortunately I don't have the slides now.
@jairjosafath9693
@jairjosafath9693 2 ай бұрын
very well explained sir 💯💯💯💯
@NurtureLearning
@NurtureLearning Ай бұрын
thanks so much for liking and commenting 🙏🏻
@gangasrinivas7974
@gangasrinivas7974 2 ай бұрын
Hi sir, I have around 10 years exp in mainframe. Currently There are openimgs on vision plus. I am planning to join online training sessions, if any. Thanks, Srinivas
@martincundins8756
@martincundins8756 2 ай бұрын
great summary
@NurtureLearning
@NurtureLearning Ай бұрын
thanks so much 💐
@charan6154
@charan6154 2 ай бұрын
hi, the thing I don't get is which code you started/run at 9:57, was it a worker or conductorApplication?
@aravindshiva803
@aravindshiva803 3 ай бұрын
It helped me for my interview. Thanks
@NurtureLearning
@NurtureLearning Ай бұрын
Glad it helped 💐
@ratsword200
@ratsword200 3 ай бұрын
I was looking for how credit card transactions approve so fast. I didn't find the answer but I found a very clear process of how credit cards transactions work
@NL-ty6xs
@NL-ty6xs 3 ай бұрын
Doesnt work for me, what could be going wrong?
@NurtureLearning
@NurtureLearning 3 ай бұрын
Please ensure 1) You are logged in and are in "My available Coupons", basically this link www.bjs.com/myCoupons 2) Go to Developer Tools and select "Console" from the top tabs in "Developer Tools" 3) Copy and paste the script on the console, lastly press enter; Script Title "NEW SCRIPT (USE THIS ONE - Updated on 13th March 2024)", Link: github.com/YesInAJiffy/BJs/blob/main/README.md 4) If the number of coupons are too huge, then refresh the page after 5 seconds and do step 3 again till all coupons are applied. thanks.
@ronshoup6982
@ronshoup6982 2 ай бұрын
I had to type 'enable pasting' first and then run it a few times. only seemed to clip 30 each time.
@sumitkarnik5240
@sumitkarnik5240 3 ай бұрын
Who bears all these fees? is it merchant??
@NurtureLearning
@NurtureLearning 3 ай бұрын
Yes primarily it's the merchant, that's where if you shop and offer to pay to the merchant by cash they give you some additional discounts. There could be some exceptions, for example in BNPL space; but largely its borne by the merchant.
@LexieBryson-h8y
@LexieBryson-h8y 4 ай бұрын
Very helpful again- thank you. I have a question- what about online payments? Is the process the similar?
@NurtureLearning
@NurtureLearning 4 ай бұрын
hi thanks again. No the process is very different. For each and every type of electronic fund transfer the process is different (at high level it may look similar, but if we go one level down we understand the differences). I will try to make videos for ACH and Wire Transfers someday.
@chetandurgavale5623
@chetandurgavale5623 3 күн бұрын
@@NurtureLearning It is very helpful video. Good communication and explained very well. Will be waiting for online transaction flow🙂
@LexieBryson-h8y
@LexieBryson-h8y 4 ай бұрын
Brilliant! Can you please share the link to the next part? (processing fees for acquirer and IPS)
@NurtureLearning
@NurtureLearning 4 ай бұрын
thanks so much. Here it is kzbin.info/www/bejne/sHfTlGeNrratZ7M
@LexieBryson-h8y
@LexieBryson-h8y 4 ай бұрын
@@NurtureLearningthank you!!
@ArrenTadipa
@ArrenTadipa 5 ай бұрын
So therefore BSP must have a big responsibility or obligations from money error to the account holder.mas monitor niyo lahat ng mga miyembro sa labas at pasok ng mga bawat transaction why everytime na magkaroon ng conflict at error system under imbistigation parang malibdiba mas silip dito ni BSP ang pagmumulan hanggang babagsakan at mga system error nito somtimes questionable our reason publicly anouncing to Us.
@NurtureLearning
@NurtureLearning 4 ай бұрын
Thanks so much, sorry but don't understand the question properly.
@siddharthsingh5829
@siddharthsingh5829 5 ай бұрын
Thankyou so much...😊😊😊
@NurtureLearning
@NurtureLearning 4 ай бұрын
Thanks so much for liking and commenting.
@prashanthbakka8651
@prashanthbakka8651 5 ай бұрын
Timeline for the whole process?
@NurtureLearning
@NurtureLearning 4 ай бұрын
hi, depends (because mostly it's batch based), typically done witinin 24 hours but the notice is given to customers as 48-72 hours.
@vishnudeo1981
@vishnudeo1981 5 ай бұрын
Thanks a lot for simple explanation .
@NurtureLearning
@NurtureLearning 5 ай бұрын
thanks for liking and commenting 🙏🏻🙏🏻
@gobieee1
@gobieee1 5 ай бұрын
Thanks for making this video. I've home loan for 30 lakhs. I am parking my surplus fund in the bank account. When I looked at the statement, I see only interest component getting deducted. I dont see any traces of principal component deduction. is this correct? Also, only 2 lakh is pending to close the home loan. is it recommended to keep the account for tax purpose? or can I close it?
@NurtureLearning
@NurtureLearning 5 ай бұрын
Thanks for liking and comment 🙏🏻🙏🏻. Regarding your questions: *Interest Deduction:* 1. The interest is calculated on the daily outstanding balance in the loan account. 2. The interest amount is debited from your SBI Maxgain account at the end of each month. *Principal Deduction:* 1. The EMI (Equated Monthly Installment) that you pay consists of both principal and interest components. 2. When you deposit money into your SBI Maxgain account, this amount is available for withdrawal but also considered as a part of the available balance to offset the outstanding principal. 3. The principal reduction happens gradually with each EMI payment, with a higher portion of the EMI going towards the principal in the later years of the loan tenure. 4. Any surplus amount you deposit in the Maxgain account reduces the daily outstanding balance, thereby reducing the interest portion of your EMI. However, it does not directly reduce the principal until you decide to make an actual principal repayment (for principal repayment you need to go to the bank and ask them for it, it's cumbersome and does not help in any way). Please check with bank once on this and let me know if any corrections. Thanks.
@fadfooood
@fadfooood 5 ай бұрын
Thank you for the video! Well explained 🙏🏻
@NurtureLearning
@NurtureLearning 5 ай бұрын
Glad you liked it, also thanks for leaving your comments 💐💐
@northyland1157
@northyland1157 5 ай бұрын
Type 2 can be managed though diet. Stop all sugars and carbs. you won't get high glucose readings if you never don't eat them in the first place!!! What can you eat? Meat, cheese, salad, avacados, Berries, plane greek yogurt, eggs and omlets..
@abellepenye4153
@abellepenye4153 5 ай бұрын
I say this with the most respect possible. I think there is a slight mistake in the video. Please correct me if I am wrong, I am only here to learn. At 3:20 you can see step 4's description. It says: " Routes data to acquirer" I think that might be wrong because the data is being routed to the issuer. I have learned a lot from this video, so thank you!
@NurtureLearning
@NurtureLearning 5 ай бұрын
Wow thanks, you are absolutely right. The text in the flow needs correction, will correct it 🙏🏻🙏🏻
@abellepenye4153
@abellepenye4153 5 ай бұрын
Super helpful and informative. Thank you!
@NurtureLearning
@NurtureLearning 5 ай бұрын
thanks for commenting, glad you liked it 💐💐
@Adharsh6
@Adharsh6 6 ай бұрын
Super sir what i understood.. If i get 40 laks loan and in od if i deposit 20 laks so i will pay only 20 laks home loan interest Benefit I can with draw od incase of emergency. Some of the bank prepayment is limited. This od will help to reduce the interest. Prepayment should not do. Deposit in od(if you have surplus) Is that my understanding correct?
@NurtureLearning
@NurtureLearning 6 ай бұрын
Yes Adharsh, if you have surplus money put in OD account and then you will save on the interest levied on your home loan.
@roselyneomasheye9959
@roselyneomasheye9959 6 ай бұрын
please make a video on direct card routing
@ShriganeshKolhe
@ShriganeshKolhe 7 ай бұрын
I have the co-oerative bank in India and want to start issuing credit cards. what best companies exist to help out in this case?
@NurtureLearning
@NurtureLearning Ай бұрын
hi, please reach to Rupay or VISA (Rupay preferred for India). The process at high level is a)Onboarding a client (your co-operative bank) b) setting up an account c) allocating cards. It's more complex then what I mentioned, but Rupay or Visa should be able to guide you (if they see the value).
@dhananjaymitkari3893
@dhananjaymitkari3893 7 ай бұрын
Can you send this ppt to me
@NurtureLearning
@NurtureLearning 7 ай бұрын
oh, it's been more than an year, I don't think can find it easily now.
@surajpatel7586
@surajpatel7586 7 ай бұрын
hdfc bank also provide
@NurtureLearning
@NurtureLearning 7 ай бұрын
good to know this 👍🏼👍🏼
@Amandeep-qd9nw
@Amandeep-qd9nw 7 ай бұрын
where is the fees associated with card processing video ?
@NurtureLearning
@NurtureLearning 7 ай бұрын
Just added it in comments.
@rajatshukla2605
@rajatshukla2605 7 ай бұрын
super helpful! many thanks!
@NurtureLearning
@NurtureLearning 7 ай бұрын
thanks so much for liking and commenting 🌻🌻
@lujean5980
@lujean5980 7 ай бұрын
Thank you for such a clear and informative video! I just have one question: in the authorization stage, why is the acquiring bank involved already? Isn't this step about checking whether the consumer can make the purchase? So why doesn't the POS machine send the data to the issuer directly?
@NurtureLearning
@NurtureLearning 7 ай бұрын
Great question, please note that the Merchant has no direct connection with Issuer (the POS can't connect to Issuer directly; imagine if it has to do that then the POS has to have connections with all banks at in place. Instead a router, acquirer here helps). The acquirer bank is the financial institution that has a relationship with the merchant. Acquirer's primary role is to facilitate transactions on behalf of the merchant. When a customer makes a purchase, the merchant forwards the transaction details to the acquirer bank. The acquirer bank then communicates with the payment networks and the issuer to obtain authorization for the transaction, and it ultimately settles the transaction by transferring funds from the cardholder's account to the merchant's account.
@moturuniharika9605
@moturuniharika9605 8 ай бұрын
Thank you for the very clear information
@NurtureLearning
@NurtureLearning 7 ай бұрын
thanks so much for liking and commenting 🌻🌻
@Pheello
@Pheello 8 ай бұрын
Thanks. I’m busy with a startup in the e-commerce space. This video has aided my comprehension in payment space
@NurtureLearning
@NurtureLearning 8 ай бұрын
that's amazing to know, all the very best wishes for your startup 👍🏼👍🏼
@niyaskadangode6197
@niyaskadangode6197 8 ай бұрын
Informative and easy to understand.
@NurtureLearning
@NurtureLearning 8 ай бұрын
Glad you think so and thanks for liking and commenting 👍🏼👍🏼
@zeeshanwallet7724
@zeeshanwallet7724 8 ай бұрын
awesome, informative content. More content needed!! Thanks
@NurtureLearning
@NurtureLearning 8 ай бұрын
thanks so much for commenting and for the wamth in comment 🙂
@ErnieCheruu
@ErnieCheruu 8 ай бұрын
Very Good bro
@NurtureLearning
@NurtureLearning 8 ай бұрын
Glad you liked it and thanks so much for commenting 👍🏼👍🏼.
@amalekyen0012
@amalekyen0012 9 ай бұрын
really helpful, thanks!
@NurtureLearning
@NurtureLearning 9 ай бұрын
Glad it was helpful ✅ !
@rickjamamerican1462
@rickjamamerican1462 9 ай бұрын
Appreciate it. I also had to re-apply the script multiple times as some coupons were not clipped on one attempt. Overall it worked and I appreciate your knowledge sharing
@Earth_18_07
@Earth_18_07 9 ай бұрын
Could you also do interview questions on hibernate?
@rickjamamerican1462
@rickjamamerican1462 9 ай бұрын
Thanks for the tip. it worked!!!!!!!!!!!. My challenge was to copy to the script as I did not see how you clearly open the script and the when I did open it that copy feature in your video was not on my screen. Thanks for sharing.
@NurtureLearning
@NurtureLearning 9 ай бұрын
Glad it worked 👍🏼👍🏼, I shall put some instructions on the description of this video as well.
@rickjamamerican1462
@rickjamamerican1462 6 ай бұрын
nothing is being clipped
@rickjamamerican1462
@rickjamamerican1462 6 ай бұрын
myCoupons:2506 Uncaught TypeError: Cannot read properties of null (reading 'classList') at doSlide (<anonymous>:153:59) at nrWrapper (myCoupons:2504:39)