In this module, we shall look at risk management in the contract of Salam. We have studied Salam already and we defined it as a contract, as a sale contract in which the delivery of the commodity which is sold is actually on a future date. The price is paid upfront and the delivery of the commodity takes place on a future date maybe 30 days, 60 days, 90 days or more or less. In case of Salam, risk of inability to deliver the commodity on the future contracted date is a possibility. And because of that, there is a risk attached with the contract of the Salam. If the commodity is not available, the risk of loss of revenue income for seller is inevitable. How? If the commodity is not available and the seller has to deliver the commodity to the buyer, then he or she will have to find the commodity from somewhere and there is a possibility that the seller will have to buy the commodity for a higher price. If that does not happen, then the whole transaction would have to be cancelled and the seller who was looking for some kind of benefits from this transaction, those benefits would not accrue. In case there is a possibility of ending up with a loss. The solution to this in Islamic banking and finance is offered by a Salam parallel Salam structure. In this case, there is one Salam arrangement and in parallel to this one, there is another Salam transaction and both these Salam transactions together, they minimize the risk of doing business by the help of Salam. Let us look at the basic structure of a Salam transaction. We have already looked into it, but it is always a good idea to relook at the things because it helps us in learning and understanding the concept more effectively. So we have a Salam seller and we have a Salam buyer. Someone would like to buy a commodity for a variety of reasons. The buyers in this case, they are looking for a commodity in future, however, by way of Salam, they want to make sure that the commodity in future is available to them. So this Salam buyer pays the price of the commodity now at T1 and the Salam seller is actually required to deliver the commodity on a future date. In this case, we are saying T90, T90 means after roughly three months or 90 days. So this is a basic Salam structure. Now at T90, the commodity may not be readily available in the market and that is the basis of risk we have talked about. So what could be done? In that case, this party which was Salam seller, now we call it Salam seller 1. So this transaction between Salam buyer and Salam seller would be called Salam 1. So this Salam seller 1 would enter into another Salam transaction with a third party in such a way that in this second Salam, Salam seller 1 is actually Salam buyer 2 and the third party is Salam seller 2. In the first transaction, there was this price P1, which was the Salam price 1 in the second Salam between the Salam buyer 2 and Salam seller 2, the price is P2. In this way, the Salam seller 1 would be able to procure or would be able to at least ensure that the commodity is available at T90 for him to deliver it on to buyer 1. Now the difference between the two prices P1 and P2 would be actually the profit of this party. In this case, this Salam seller 1 or Salam buyer 1 or whatever we want to call it, we just call it party A just to explain the things and we call this party B and we call this party C. In this case, in this example, party A is actually a financial intermediary. It is earning a profit equal to P1 minus P2 just by way of entering into a Salam sale 1 and a Salam sale 2 and this is a risk management tool as well. The second leg, the second Salam is basically a risk management tool. Now in a Salam parallel Salam structure, the Salam seller 1 who happens to be Salam buyer 2 as well does not enjoy any liquidity benefits. If you remember, we said that the Salam seller enjoys liquidity benefits when it receives the price from the Salam buyer. In this case, what is happening? The Salam seller 1 or Salam buyer 2, we called it party A is receiving the price from the party B and then it is using part of this money to pay to the third party party C as price for Salam 2. So this party actually party A does not enjoy a lot of liquidity benefits. In order to enjoy risk management benefits, liquidity benefits and profit, this Salam seller i.e. party A may enter into a WAD based arrangement with a third party. So instead of using a parallel Salam, this party can enter into a WAD based arrangement so that it continues to benefit from liquidity. Of course, it has risk management benefit and it earns some profit as well. Just to clarify the point, I would like to reshare this structure once again which we studied in the context of Sukuk Salam. Remember we said that central bank of Bahrain on a regular basis issues Sukuk Salam. So this party issues Sukuk to the banks, receives money from them. This transaction is on a Salam basis, so gets the money from them and enters into a Salam sale. So this is basically this dollar comes from the Sukuk sale of Sukuk and then CBB enters into a Salam based arrangement whereby it buys certain commodities on a Salam basis from lead arranger and this lead arranger has to deliver the commodity to the central bank of Bahrain on a future date. In order to ensure that it actually delivers the commodity on a future date, this lead arranger enters into a WAD based arrangement with commodity broker. And of course, for this structure to work and we explained it previously, the issuer central bank of Bahrain will have to enter into a WAD based arrangement as well. If that is the case, then lead arranger would be able to benefit from risk management, would be able to benefit from liquidity and would earn some profit as well. Just to give you the comparison between Salam parallel Salam structure and Salam with WAD structure, we say that in case of Salam parallel Salam structure, liquidity benefits are minimized. They may be almost zero. However, this structure allows the central party, this party A in our example, it allows it to earn some profits. Of course, it has risk management benefits as well. Salam with WAD could be a preferred choice because it gives liquidity benefits. It offers an opportunity to earn profit and of course, it is a very good risk management tool.


Hi everyone happy Thursday my Friday your Thursday my Friday and That is Jaspie 16 box baseball mixer pick your team mixture number five half a case of tier one Half a case of clearly authentic both 2022 edition pretty nice stuff all card ship a lot of great stuff and if you buy it bought at least two teams one Entry four teams two entries It's at or it's at or take all those entries randomize them top two two hundred fifty dollars or break credit each Big thanks to this group for making it happen appreciate it second half in the store right now Check it out. Good luck everyone All right, so let's do the clearly out. Here's the tier one. Let me do the clearly first. Oh Yeah, that car that was parked in front of our driveway here at work Well, we we looked at the tape I Was watching the security cameras Late into the evening and the gentlemen Came back at around 1 30 in the morning Looked at my looked at my note that I put on his car and then soon afterwards drove off So that that's that I think this I think the gentleman was It's kind of a younger dude, but look younger looking dude. I thought But uh seemed to be living out of his car seem to be an unhoused gentleman a homeless guy, so I Yeah, I would have felt bad if It worked itself out next time. I don't know if we'll be so so so nice the warning has been given though. All right Five ten fifteen twenty so ten boxes on the left side ten boxes on the right side on the left side right side One two three for the left side four five six for the right side Four one two three four five six and this We'll save for break six. Oh, and we might as well pop open the tier one as well Yeah, he did have expired plates, too. Well, yeah, I don't know. I don't know if the police would be rushing to the the gates of jasps for For a car with expired plates, maybe a traffic cop Would have loved that right right up a little ticket. I don't know if a regular cop would be like On our way one two three for the left side four five six for the right side One two three four five six We'll do the right side and these will this left side will save for break six. All right So ten clearly boxes six tier one boxes Make 16 Like I said second half in the store All right, and we're gonna lead off with Alejo Lopez That's for the red legs. That's gonna be for Barry while Gilo just would just have a car just towed immediately Well, yeah, if someone was parked in your spot at your old apartment. Yeah, absolutely There's Connor Wong for the Red Sox Terry There you go Terry Now if we had a good thankfully that person's lucky we didn't have a car parked in our lot We we had all parked along the street But if there was a car in here, yeah, then we would have had it towed right away That's it's the only reason why it wasn't my real little little more friendly Little more forgiving, but there were no cars in the lot. So that person got lucky Real luck use your lucky day guy. There's Wade Boggs 80 out of 99 That goes to Terry and the Red Sox One of my favorite. It's always sunny in Philadelphia episodes The Wade Boggs episode There's big Mack mark McGuire 11 out of 25 Blue border right here A's edition going to Barry. He might be watching the stream Might have somehow had access to our Wi-Fi Park near the shop watching the stream There's Casey my is 68 out of 75 Generation now autograph for Detroit Patrick for the Tigers tiger uppercut Byron Buxton 28 out of 50 And high tech design. I don't know if they'll ever bring tech back Hi tech Byron Buxton going to Barry and the twins. I wouldn't mind that I feel like if they you know if they kind of condensed the This is because I think it got a little Overinflated I think if they kind of trimmed that set down a little bit I feel like that could that could make be a nice little comeback Maybe a bunch of too many fillers right lesson learn Buy your spot straight up 54 out of 75 gym Abbott Halo's that's going to go to mark the There should be a good gym Abbott documentary or something. I don't know if there is one And there's the hawk Andre Dawson 89 out of 99. What year is it? Remember when Kerry would pulled him out of a Let's carry wood right mark prior Kerry would I think it was Kerry would in the state farm commercial where he pulled Andre Dawson out of the ivy One of my favorite commercials that goes to Patrick and the cubbies Then Andre Dawson says what year is it? And then we've got Dan Zabee Swanson 67 out of 99 braves I don't feel Patrick and the Braves free agent at the end of the season I guess whoever loses out on the Trey Turner Carlos Correa sweeps takes might Might settle for Damian Swanson, which it's not not really that bad. It's all right pretty solid all right next is Connor seabold 8 out of 50 seabold be bold That's for Terry and the bow socks all right now Six boxes of tier one baseball All right, we got Mike piazza Padres edition 006 out of 3 99 My Dodgers will be in sandy. I think they must be in San Diego already They probably take a bus There's Marcus Simeon 272 out of 299 Toronto Blue Jays that's going to be It's going to be for Patrick and the bluebirds And we have O'Neill Cruz Rookie Otto for the buckos 234 out of 299 Patrick and the pirates Yeah, I need I need to finish that too the the Jeter series the captain Which I heard was actually I saw the first couple episodes I think it actually turned out to be pretty good from what uh from the critical response You maybe not as like sort of not as iconic as last dance, but still pretty solid as Jose Otube to 127 out of 3 99 piece of his jersey going to Patrick and the Astros We're taking commanding to nothing lead In a best of five series going into seattle There's more Astros for Patrick 161 out of 299 Jake Myers Jake the snake Myers And we got Hall of Famer Barry Larkin gold ink autograph 4 out of 25 I think he does what is he what is Barry Larkin doing right now is he Maybe does color commentary for the red tv broadcast? I think so Barry Roberts Barry with Barry There you go, Barry. I'm curious to see how many Dodger fans will be in San Diego tomorrow, um I don't know what the secondary market what that's done, but I know that uh the Padres organization restricted, uh Restricted ellie county zip codes from buying tickets outright 44 out of 349 Josh Donaldson twins That's going to be for Barry and twins We got Ian Anderson 51 out of 199 for the Braves Patrick and the bravos And Maglio Ordonez 195 out of 199 For the white socks that's going to be for rex and the white socks tier one talent three boxes to go second half in the store We can run this back tonight. It's a pretty quick break Pretty fun break credit being given away here as well big hit potential especially in this tier one bat knobs bat barrels one-of-one cut autos All sorts of things in this tier one We got Josh Gibson 35 out of 99 Legends relic That's pretty cool Um, that'll be randomized to one person in this break Josh Gibson What Negro Leagues teams did he play for the Memphis Red Sox homestead graze? Pittsburgh Crawfords The dragon is to see you that through heel Homestead graze azulis de veracruz homestead graze Pretty cool stuff Bit of history there Hans Kraus 13 out of 25 for the fighting fills It's gonna be for David in the Phillies And Tim Reigns 107 out of 2 99 white sock for Rex and the white socks I think Tim Reigns There's an I don't know if this is like a Apocryphal story No, this is actually in his Wikipedia Tim Reigns struggled. Oh, I guess with like a lot of players in the 70s 80s struggled with a cocaine use um His performance dipped in 82 You know he's And at the end of the season he ended he ended up entering treatment for uh Ended up with a treatment for for substance abuse having spent an estimated 40 000 dollars that year on cocaine To avoid leaving the drug in his locker he carried it in his hip pocket and slid head first um when running the bases so he wouldn't break the uh the uh The vials I think that the cocaine wasn't All right, there's Todd Helton double o two out of 2 99 a little bit of the Rockies pinstripe there goes to David in the Rockies. Wow Terry's looked it up and said that Josh Gibson card books for about 500 bucks Pretty nice. Yeah, I can't imagine. Yeah, exactly like Shula's Joe ripper Yeah, not can't can't imagine. There's too many of those game used Relics out there for guys like him a dollars Garcia 189 out of 199 Rangers It's gonna be for Barry and a redemption or at least in becket $500 breakout Autograph bronze ink parallel Boston No Brandon Brandon Marsh Angels edition of Brandon Marsh He wasn't doing crack Jilo Just that just that columbian marching powder Look at that thicker card in the bottom 20 out of 25 Joe Morgan Barry and the reds Logan Gilbert double o three out of 2 99. I think he's making the The start in seattle I'm not mistaken for game three and back here is Ronald Acuna jr Four out of five. Wow. I pulled the one-on-one of this Maybe last week And now here's the four out of five This one is going to go to Patrick Cox and the Braves Out of fives and under get the train with so you got a you got his autograph right on a slice of his bat Game used that That's awesome Patrick All aboard the big hit express All right now Let's uh flip over to the list here Everyone gets a shot at that josh Gibson Oh, no river saying i've got the brazen the next break. It's science that it shows up now. Well at this rate Uh ed I may pull you the out of 10 of that card One I pulled the one of one I pulled the out of five So I I'll have to pull the next the next set out of 10 maybe All right, let's gather all these names dice list Let's roll it. Let's randomize it Four or two six times name on top after six gets the josh Gibson bat relic Good luck one two three four five And sixth and final time after six A lot of sad faces here Saddest of all will be in spot two David very very close unless your name's on top but very close appreciate you trying it's gonna be Happy times after six for patrick There you go patrick All right, we'll also use the same dice roll for the break credit giveaway It's sort this by your first name So barry if you buy an even number of teams basically half of that number becomes entries. So barry bought four teams. That's two entries David bought six teams. That's three entries mark bought four teams two entries patrick bought 12 teams That's six entries Rex bought two teams That's an entry All right. Good luck. Same dice roll four or two six times Top two names after six two hundred and fifty dollars a break credit each One good luck two three four five and Sixth and final time After six no doubt about it patrick with the top two spot. Oh david again Sorry, man. Just on the outside looking in but I appreciate you getting in Thanks for watching. Congrats patrick. I'll send you that break credit As soon as I press this stop recording button We'll see you next time for the next one jazby's casewrakes.com


Since mobile Ymax 2.0 is based on IEEE 802.16E and then M for the physical and the data link layer. So, similar to LTEA that was based on certain really advanced features, here also there are certain interesting wireless or the radio advanced features which are the highlights of Ymax. So, let's look at these one by one. Similar to LTEA carrier aggregation is the most important feature of mobile Ymax that helps the users achieve very high data rates adaptively. Since we've already covered it, so we would not like to discuss it any further. The other highlight is the femtocells which are similar to home in ODEA, the self-organizing networks we've already covered it in the context of LTEA and then relays. So, you see more or less all these features are quite similar to the ones provided by LTEA and that is why when we were discussing their comparison we said in NGN vision there is a possibility that these technologies can be interoperable hence integrable into a unified architecture. Let's get back to our advanced features. So, after carrier aggregation we have femtocells. Femtocells are basically base stations with very high transmit power over shorter distance. That is, these femtocells are wireless networks based on small scale home in ODEA like devices which are installed in the customer premises. Similar to home in ODEA, the primary purpose is to provide connectivity and high data rates. Since similar to home in ODEA, the distance is only restricted to few meters that is up to tens of meters, very high data rates can be achieved. The femtocells are also responsible to implement the quality of service features and the radio resource control on the user equipment, which is a mobile phone, a tablet or anything else. Essentially, the quality of service guidelines, how exactly it would be implemented, the class of quality of service, the breakdown of quality of service into network resource parameters such as bandwidth, latency, etc. are translated into femtocell based parameters which are actually determined by the core network. So, the core network servers are going to determine what quality of service is to be provisioned. Since this quality of service is to be enabled or provisioned in the wireless side, so there is a strong connection requirement that has to be established between the core network and the access side network that is our base station in femtocell. This connectivity is usually provided through well-known broadband technologies in the fixed domain as well as in the wireless domain like DSL, passive optical network, the cable broadband, etc. Then we have the self-organizing networks, not needing much introduction. We've discussed it in detail. The SON is implemented in mobile YMAX 2.0 for similar requirements as it was for LTEA like for neighbor discovery in case handoff is required between the base stations in mobile YMAX 2.0 environment to mitigate interference, provide load balancing if a certain base station is overloaded then its neighbor can be discovered and part of the load can be shed off there. Then certain frequencies need to be reallocated or reappropriated from one base station to the other and transmit power has to be automatically adjusted to handle the radio conditions like signal to noise ratio, S-I-S-I-N-R-C-I-N-R, etc. So SON essentially is implemented in more or less same manner as it has been proposed for LTEA. Then we have relay nodes or the repeater nodes. Relay nodes actually provide coverage by extending or increasing the transmit power in areas which are known as the blind areas whenever high noise is experienced there.  The design of relay is quite similar to that of base station because it has to be a wireless, all wireless device but it has limited capabilities. In addition to relaying from the base station towards the user equipment, a relay can forward the traffic or repeat the traffic to another relay and to another relay and to another relay. So this is actually known as the multi hop relaying. Multi hop relaying is a very advanced feature that allows the coverage in certain inaccessible areas which have very large distance between the user equipment and the base station. Thank you.


Hello everybody, in this video I want to talk with you about special and pro tip about what to do in case that you can't send offer to your watchers. In the last, in the latest ebay update ebay released a new feature where you can send an offer to your watchers in for your ebay listings for your ebay products. This is something which is really amazing when we saw amazing results from our users who really went to their ebay account and send these offers one by one. But the thing is that sometimes we don't have this option even if you have the watchers for our products. Why? I don't know why but this is how ebay works and sometimes you just can't send this offer for some of the watchers. Now in this video I want to show you a special tip which actually one of our professional sellers whose name is Oren Stathia showed me and this is a trick how you can actually send this offer even for items where you don't have this option. Now this method doesn't work for all of the products but in some of the cases you will see that it really helps and that you really can send this offer to products that ebay didn't give you the option to send it. So let's see how it looks like. So if we go to our article about how to send about this new feature in the auto dss blog so if you scroll down you will have here this product. Now here we'll see this link or what you need to do you need to take this link go to ebay take any product which you want for example this one let's say that it's your product and then you need to find the product id of your product. Now when you found the product id this is the product id or what you need to do you need to take this link put it here replace the item id with the new with the item id of your product and click enter that's all you will go to the page where you can send the offer for this product and you will see if you can send the offer for this product or you can't so even if you don't have this eligible for offers option for this product I recommend you to try and still use this link to send this offer this is something which can increase your sense and can give you the option to sell this product even if the buyer didn't bought from you in the didn't buy from you at the same moment when they added you to the watch list. I hope that you like this video how did you like this tip this is a really pro tip something which most of the ebay sellers don't do and don't know how to do this nobody knows about this tip so I really hope that you will take an advantage from using this tip see you in the next videos don't forget to subscribe to our youtube channel and leave a comment if you already knew this tip if it helps you and if you got a new sales after using this tip see you in the next videos don't forget to subscribe to our youtube channel and leave a comment don't forget also to like this video so this video will help to more people and it will help to other ebay sellers see you in the next videos bye bye


This study found that vaginally assisted natural orifice-transluminal endoscopic surgery, VNOTS, hysterectomy resulted in shorter surgical duration, shorter hospital stay, and lower pain scores compared to laparoscopic hysterectomy, LH, for women with undescended enlarged uterine. This article was authored by Chiang Kaya, Sucru YLDZ, Ismael Allari and others.


So the talk is Python load balancer 0 to 1 million requests per second. It's by Abhishek. Abhishek is an undergrad in triple IT. He's working in Robustist R&D team, where he has built a custom load balancer for Robust. Thank you. Can you guys see me at the back? Yeah. So this is my talk. It's a Python load balancer which I custom built this summer in a company called Robustist.  This is my first talk and my first conference, and I'm really glad to share this moment with you all. Before we get into anything, a little bit about myself. I'm a fourth year student at Triple IT Hyderabad. I'm doing a dual degree course, so I'll be passing out in 2017 with an MS degree. My areas of research interests lie in NLP basically, but I've done some other projects also. I'm part of the Language Technology Research Center in Triple IT, and my other interests include well football, and I'm a center forward for my team in Triple IT, and I'm also part of the organizing committee of an Adventure Club of Triple IT Hyderabad. Well, the world technical expertise I have is, I've done a few open source contributions. I have done a few internships for various companies, and I've done a few personal projects for myself, and well, this came about last summer when I was working with a company called Robustest, and that's where we built the load balancer. Before the summer, I actually had little or no idea to what a load balancer is. I did not know how the term itself was alien to me. Only when I started building it, did I realize it's vast and very necessary applications. Now, I must warn you that this is not a technical talk. I will not be getting into technical details of it because it's still under development, but I will surely make sure that I convey as much information as possible.  Anybody? Have you guys used a load balancer at all, or sharing server loads? Yeah. Anybody else?  Have you heard the concept? Well, as he said, it's when you hear load balancer with something, well, it balances load. That's all it does. A load balancer balances load. A load balancer balances load in such a way that it is distributed among all the different computing resources. Here, he said that it balances load among servers. The computing resources need not necessarily always be servers because many computing components can be there as servers or other computers, computer clusters, network links, disk drives, anything. The computing resources could be anything and the load balancer would share resources among all these. I mean, would distribute workload among all these. It aims to optimize resource use, maximize throughput and minimize response time and avoid overuse of a single resource. The load balancer is intelligent in some sense. It aims to distribute the workload in such a way that it optimizes the entire system. It makes sure that no single resource gets overused and it minimizes the entire response time of the application. Using multiple components increases reliability and availability. Well, this is true because, well, your burden on one single component reduces because you have multiple components taking care of your entire application. So the burden on one single component reduces. Therefore, the entire application becomes more available, more responsive and more reliable to you. Well, load balancers have multiple different applications and this is the basic architecture of how a load balancer normally looks like. But they come up with different applications, different techniques and I would go on to show you what load balancers are there and what different applications they give you. So here is a typical architecture of load balancer.  Now, when I began this project in the summer, the way we all start coding is we have our local host, we have our load balancer running on local host, we have our servers running on local host and we have different ports assigned to them. So that's basically how I want to explain to you guys also because I want to give you a small glimpse of the experience of how my summer was spent. So here you see that the load balancer was on port 8080 and there are multiple servers. So one to server four running on ports 8081, 8082, 8083 and 8084. So now for a client to communicate with any of these servers, he has to go through the load balancer. What we do is the address of these servers are not made public. The only thing that is made public is the address of the load balancer and the port number of the load balancer. So if a client wishes to communicate with a server, he has to go through the load balancer. So here the client will say that, okay, hey, pass me through to S1 or he wants to connect to S1. So then the load balancer what he does is, well, he's intelligent. So he knows, the load balancer knows where the S1 is and what address is located at. So it manages to create a session between the client and the server S1. As I told you, there are many different applications for load balancer. Here are some of the load balancers which are there currently in the market right now and they all perform exceedingly well in their task. But well, what else do they offer? Because the thing is, when you're always creating, when you're creating an application, you need to make sure that it caters to your needs. Here, right now, for example, here HAProxy, BalanceNG, F5, all these load balancers perform exceedingly well in the task of load balancing, but what else do they give? So HAProxy, for example, it can give you a HTTP or TCP proxy for web-based applications. So that's what offers.  And 8n, for example, it offers URL manipulations and Nginx gives you the ability to configure weights for each server. So, as I said, there are multiple applications for your load balancer and you can tweak it to fit your needs. So when we go on to the uses of the load balancer, we see that there are multiple uses for such an entity because even before the summer, actually I had no idea to what to expect or to what to build or how to do this, how to go about this. But when I started using it, I realized how important it is in any growing industry, in any application. So here, we see that it increases security. How does it increase security? You could see that the client could not directly connect to any of the backend servers because the address is not made public. To connect to any one server, he has to go through the load balancer. Therefore, in some sense, you're prohibiting direct connections to the servers. So for any client to connect to a server, he has to go through the load balancer. That way, you're increasing security of the entire application. It improves performance of the entire system by distributing traffic. The performance of the entire system is, well, it's increased because you're reducing the burden on the servers which are managing and maintaining the application level traffic. By reducing the burden on those servers, you make sure that your entire system is more responsive, more available. So that's how it improves the performance of the system. Now, it makes the entire system more fault tolerant. This is an important key concept, actually, which you want because the load balancer ensures that there is no one single point of failure. If you have a server which is unresponsive or which has broken down for some reason, and now the entire system is a collapse, but with a load balancer, all it has to do is it has to distribute the traffic among various other servers in the pool. Therefore, thereby, the entire system becomes more fault tolerant. Here are some of the examples of existing load balancers and the statistics they give. The entire traffic which is coming into the application is depicted by the green line and the server one and server two are depicted by the blue line and the red line respectively. As you can see, the sum total at any point, let's say five AM, six AM, is equal to the total traffic coming in. So the load balancer is distributing its load to server one and server two. Now, you may be wondering why server one gets way more than server two. It's probably because server one is bigger, or maybe because, like I told you, like I told in engine X, you give more weight to server one. So it's preferred more than server two, probably because server one has a lesser response time than server two. So you prefer server one more than server two. And one more key concept to grasp is that it is not necessary that the load balancer, all it has to do is to balance load. Because here you have this hourly mail statistics which a load balancer gives is, it's blocked some mail because it says it's spam, blocked some mail because it says it's virus, allows some other mail. So it also allows a moderation of the entire traffic as such. So whatever data is being put through the load balancer, it can also moderate it.  And this is exactly what we did at Robustest because we had very specific needs, we had very specific goal and we had to, that's why we had to build the load balancer from scratch to fit in our environment. Well here are, well the benefits of using load balancer, scalability. That is the most important, the most foremost thing for any growing application. As your application demand increases, you want to be able to satisfy all your customers. How do you do that? You can just add new servers to your server pool. So when you, all you have to do for your scalability of the application is that you have to add servers to your server pool and just update your load balancer. Now it's going to start sending traffic to the new server in the server pool. It improves server utilization and maximizes availability. Well this is because, well no server is a small server. That's what the load balancer says. It's because no matter how small or how large your server is, your load balancer is going to make sure that all the traffic is being distributed among these multiple servers depending proportionate to their sizes. So if it improves the entire server utilization and maximizes the availability of the system. Load balancer can do other things than redirecting traffic. This I've already mentioned because I've told you about BalanceNG and F5 and all those load balancers. Apart from that, I do not know if you guys have heard but you might have seen this project called Mantrid probably on GitHub. Nobody? Oh well, there's another load balancer project called Mantrid upon GitHub. Well what it offers is it offers you a place, it offers you a scenario where you can hold the client when the backend servers restart. You can see how this is useful. And also right now I'm always talking about well servers but in truth the load balancer can communicate with any computing resource as such. So two years ago when I had another internship with another company, we had to do a disaster recovery or a risk management kind of application. So what we had to do was we had to mimic every IO operation on one device on one disk to another disk. So here also a load balancer would come into play because whatever IO operations you're performing on one disk, all you have to do is you have to mimic it to the other disk. If you're performing anything through the load balancer, the load balancer will be capable of copying it and putting it through to the other disk thereby creating a backup disk. So in case of a disaster, if you lose one disk you always have a backup disk. And also you guys might have heard that, well a couple of years ago when Michael Jackson died, Google redirected all queries regarding his death to a error page saying that well your request looks like a DDOS attack. It was because, well there were so many people pouring in for this information. So many people asking why, what was the cause of, what was the reason for Michael Jackson's death and so on. So you can see that even a load balancer has been capable of doing such tasks, like you can figure out if there are more, there's more requests coming in and so they could also figure out that your system could probably be under attack. So that way also increase security in that sense. So to get into my project, well the thing is we had to build the load balancer from scratch because it had to fit into our needs. So I'll be explaining the entire project as a whole and I'll be talking about how we needed the load balancer and then I'll get into the challenges we faced by building one. In the beginning when we started the project we did not actually even know that we needed the load balancer because initially we just thought that we didn't need load balancer, we just wanted to do some direct connections. But when we started building only we realized that the load balancer was very essential, it was a very necessary part of the entire application. So to understand this, let me go through the application as such. So this is Robustest, this is the application which was developed in Robustest, the company itself. So this basically it offers you a web interface, an interface where you can test your mobile applications on the real Android devices. So these devices which you see here, they are real devices which are connected to the server back there. So what you do is when you're, how to test your application is you upload an application or you choose from a list of applications that are given already and then you choose the mobile device which is present here. So once you're done with that you get into another page where you're given a small screen which shows emulation of the phone and which is a real device which is connected to mind you. So it's a real device what you're going to be testing on. So, and you can control these with your mouse and with your keyboard and you have statistics based on like memory usage, CPU usage and network and et cetera. So what we have here is you may have all developed Android applications or may not have Android applications, but you know that when you develop an application you develop it for your phone, you develop it for, you know it works on your friend's phone, it works on your phone, but not necessarily that it works on all the phones that are present there.  So, well you may have figured out like where the load balancer comes into play in this scenario because it's going to be the one which is going to be communicating with all the mobile devices in the back end. So, when I was not part of the front end team, I was only part of the back end team.  So, what I needed basically was I had multiple mobile devices in the back end and they were all running a Droid VNC server or VMLite server which is basically, Droid VNC server is open source if you guys want to look at it, please go ahead and look at it. So, the Droid VNC server or VMLite server which is running on the mobile devices and you had a VNC viewer running on your computer. Now, if you wanted to emulate the phone on your screen, you just had to give it the address of the phone, basically the address in the port number of the phone. Well, in my project though, we had multiple back end mobile devices connected to the load balancer. Now, the load balancer had an internal database telling the phone type and the various addresses of each mobile device. For each client to connect to one mobile device, he had to give in the phone option and the cookie. I'll tell you the reason for a cookie in a while. So, basically he had to give in the phone option and then what the load balancer would do is would look through the internal database and then it would patch it through to the mobile device. Initially, when I did the load balancer project, I was confused because all I really thought was that the load balancer, the initial and the only contribution to it on the whole system was that it was hiding the information of the back end servers. So, initially, you guys must have also figured out that probably it's going to be acting as a server and a client. It's gonna have a server support and a client support so that it's going to act like a server to the client and then act like a client to the server and then pass the information back. But this is not true because that means you're actively involving your load balancer in the communication channel. When you're doing that, when another client comes in and asks for a request, the load balancer is busy with the initial client already. So, that's why what we decided to do was we established a session between the client and the server. So now the load balancer is out of the communication channel and he's able to take requests from other clients. So here what we did was we had requests coming in and so depending on what type the client chooses for, the load balancer makes the case session between the client and the mobile device. And so you can emulate the mobile device on your computer screen and you can do whatever you want or whatever you want is fine. So, but the reason for the cookie was we had to create a sticky session implementation. That was also, that's what we wanted now load balancer because the entire application was built on a per device R billing. So when you're connected to the device and when you close your browser and you come back to it, you're essentially going to be connected back to the same device because well, there was a per device R building as I said. So, and also the fact that when you are connected with one device, the other clients cannot connect to that device because it's in use with one client already. So, when that was happening, the internal database had to be updated saying that, well, this device is being used. So, well, I can't connect to it right now and so on. So, this is how we, well, basically built it and this is the basic, just to the project and well, if you guys have any questions or queries, please feel free to ask me. I'll answer to it best of my requests. I mean, so my knowledge, sorry. And an ideal device. Sorry, I didn't get it, mobile device. So, well, you have a Droid VNC server. It's a, you have something called a Droid VNC server or VM Lite server which is running on the mobile devices and what you have is essentially, you'll be parsing your argument basing on, well, which phone type you want to connect to and you have all standard libraries, socket, OSRE, that's all I used for the project. It was all those only, HTTP request and make the session between the client and the device. That's all. How do you, I mean, if there are five instance of a device and you want to connect to, I mean, two of them are ideal and three of them are busy. How do you route between? Sorry? How do you route between them? I didn't get you. If two of them are ideal and... And three of them are busy and a new request comes in? Yeah, the database is always updated, right? So, suppose two are busy right now. So, the database is, as soon as your mobile phone is in use, the database updated. So, now when the new request comes in, it says that the mobile device is active so it can't participate in your calls. So, it's an actual database itself. Yeah, it's an actual database. Hello? So, you mentioned that you give the IP address of the load balancer rather than the servers for the clients. So, let's suppose a client is sending a request to my blog and there are 10 servers in the back end hosting my blog and load balancer is balancing the request. So, a client sends a request to my blog and the load balancer forwards the request back to one of the servers. How does the load balancer knows that it has to again send the request back to the client? Yeah, exactly. That's what happens is that when the client, when the load balancer gets a request from the client and now the load balancer figures out that which server it has to, till there it's done. So, after that's done, it establishes a session between the client and the server. Now, when you establish a session, again the address and everything of the server or anything is not given out. So, security is still maintained. It's just established session, it's also there. And the client and the back end server, yeah. Okay, so I had a question regarding if a load balancer goes down, how does? Yeah, make sure that load balancer is always active. So, we have to- That is basically this stuff, yeah. One more question, it might be an off topic, but I wanted to know how do you implement, I mean, if I have a use case where a client needs to always present in one particular server. But I can't get it. I mean, there is a use case where a client has to be connected to a particular server. Yeah. Okay, but there are many requests coming up and you want to do a round robin. But along with that, you need to have an IP hash. So, IP hash, IP hash along with round robin. So, how does that happen? I mean, is it- I've not explored such options, but I do know that there are multiple algorithms which the load balancers follow like round robin technique or lease connections time, lease response time, but I've not explored such options. Okay. Hey, can you able to hear me? Sorry? Yeah, I can hear you. So, have you faced this? No, no, no. We didn't do any of those because we didn't have to maintain. We just had like, you know, it connected to each server and each mobile device and back. We didn't, there was no reason for us to care for DDoS or anything of this. The thing is, it won't be there in our case because when one mobile device is connected, another mobile device, another server, another client cannot even request for that mobile device because it's already- Yeah, yeah. Yeah, yeah. But my load balancer does not work there. My load balancer is behind that. Yeah, not in the application service, yeah. So, why did you need to develop your own load balancer? What didn't work with the user commands? Yeah, because we also tried. Actually, we actually started with Mantret. We thought we'll put Mantret in or we'll, because that was open source and we thought we'll use Mantret as our base. But the thing was we had to handle data of the mobile phone and what was, that data had to be handled. That data was not handled. So, we had to develop our own and we also had to implement sticky session and so we did that. So, sticky sessions are handled by many of the load balancers. Many of the load balancers. The standard load balancers. But we had to handle the data or the data of the phone, what phone gives and what the VNC viewer gives back to the others. Okay. Yeah. So, to manage the response time of the load balancer, do you use any type of caching to store like static content or something like that? No, we don't. Response time, well, it depends on the server response time. If the server is more responsive, that means your load balancer is going to choose.  That means that it would choose a server which has lesser response time from the others. We did not do anything particular to this because all our phones are on this. And any particular algorithm you follow to distribute the load among the servers? No, we're not exactly. This is not exactly a load balancer. We're not exactly distributing a load in this. No, we're sending requests based on which phone type they want to access. Okay. So there is no balance of load as such, but then we have to, we need the load balancer nevertheless for distributing. Okay. Thank you. I wanted to understand what design things that you used in this one. Like for example, for reusing connections or taking the connection footprint to be very low. Sorry? So you are your service or whatever this proxy thing is, is facing the clients, right? Yeah. And you, so it's kind of a single point and where every connection would converge. All the questions come through there, yeah, yeah, yeah. So did you, any design thing that you used? We had different threads running for different connections and so on. I can't get into the technical details because it's under development right now and it's a company product. Yeah, so it's okay. What I asked about like design techniques, like for example, did you use socket to use? Yeah, OS socket, actually it's very basic socket programming. Do you do something for reducing the footprint taking or taken, so you have to respond back very fast. Yeah, yeah. That's the main goal. Yeah, yeah. Did you do anything? We just, we just implement session between those two and it was pretty responsive, it was pretty fast anyway. So we didn't mind after that. Sorry? Yeah, yeah, file this up for the roadbansers. No, probably we're going to explore. It's still in a development phase as I told you. So this is so much as I, as we have done, I've told you. This I did probably in two, three weeks we've finished this, we finished how much we could and then yeah, that's all there is. Engine X, no, no, no. This is all custom built. Yeah. Any more questions? Thank you guys.


In this module, we'll talk about the basics of bringing your e-commerce small business on the net. And that basic starts with getting a domain name. That is the step number one. And in the step number one, the keyword over here is play to win, okay? Now playing over here is putting your business on the web and bringing it in the game and playing to win means that you have a strategic approach of having your online presence on the web. Now that involves number of steps also, which I'll go into detail. Those steps are getting a domain name. A domain name tells very, very briefly who you are and what you do. And then of course, you need to have very valuable content, useful content. And of course, then you have to tell your story and your content in your way. You need to have your web presence, your web presence hosting. And of course, you have to bring in the visitors to your website. Okay. So that and of course, you have to bring in the search engine to your website also and generate leads using your email address. And of course, then you have to measure what is happening on your website and tweak. Okay. So we start ahead. So what you see on the screen is an analogy. This analogy over here shows a house. Okay. This house over here, this house is on a plot. Okay. This is a house. This house and this has an address also. Now the plot, the equivalence of plot is your host is the company which is hosting your website or your web application. That is the plot. And then on that plot or the web hosting service provider is your website or your web application. Okay. So that is the host. That is your website. This is your account. And then of course, like every house and any house, there is an address associated with your website. Okay. And that is the address. This is your address. This is your domain name. Now let's go into more details. What is your domain name? Our domain name is your identity on the Internet. Okay. Now that domain name is your identification on the Internet. On the Internet, there is something called as the IP or the Internet protocol. Now that address uniquely identifies the items or the entities which are available or connected to the Internet. And it is hard to remember for humans because it's in American nature. So therefore it is made textual for easy to remember. Now this domain name tells what you do. This domain name tells who you are and that domain name briefly describes what about you, what you're doing and everything about it. Now there are certain things which you need to consider when you are working with your domain name. Keep it short because when it is short, it is easy to remember. It is easy to type also and it is simple. Make it easy to type. Keep it short also. And this domain name should consist of the keywords which tell the visitors what you are doing. It tells you, you know what you're doing but it should be conveying to the users also. And it should include the keywords about you. Target your area. Target your area means that if it is about a certain domain, certain area, say it's about education, the education, something about education should be in the domain name. If it's in the food business, something about the food business should be in the domain name. And in the domain name, don't use special characters. Don't use lot of hyphens or all those things or underscores. Make it simple and pick the right extension. You can have a .com extension. You can have .org extension or any other extension depending upon the nature of your business or your service or your product, what you're doing to keep this all of these things in your mind. Now, I will show you a number of questions which you need to consider while considering your domain name. What are those questions? I'll go briefly go through them. For example, finance, insurance, e-commerce, if you're dealing with it, why? Because the services which you are offering is business intelligence. Why business intelligence? Because in 2016, it was 17 billion market. In 2025, it is $147 billion market, huge market. You need to capitalize on this market. What you are producing, you are producing analytical models and predictive models and it is global. And of course, your services are dashboards, customer segmentation, sentiment analysis, cash flow analysis and forecasting, all of those things. And then based upon this, you create a domain name. So if you see over here on the screen, so we see that you are dealing with data. So the word data is in the domain name. You are dealing with business analytics, therefore, BI is in the domain name. And of course, you are dealing with analytics, so it is there. Now you need to check whether their domain name is available or not because a domain name has to be unique and no two domain names can be same. So now I will take you to a screen and we'll see if this domain name is available or not. Okay, now we have the domain name checker. So let's see if this domain name is available or not. So you can see over here that we have that screen which is showing the domain name and to search for the domain name, I type the domain name. It was data to bi.com. Let's see if this domain name is available or not. So this domain.com I use because this company has been around for about 20 years. And what you see it is the loading. And let's see what we get the result. Okay. And you see that it is unavailable to no problem. Let's try the other option also, which was with the same and other extension, which was biz. Let's see if this domain name is available and unfortunately their domain name is also not available. So that is not a problem. If you are interested in getting their domain name, which is important for your business, let's see who has their domain name. Now I pick that domain name and go to the who is server, which will tell us who is the owner of their domain. So I do check over here whether who is the owner of their domain name. And let's see it searches. And we see that there is certain owner of this domain name, but the information is not available all of it due to privacy reasons. But if you can copy paste the link about the owner of this domain name, you will I'm sure get the information. And once you have that information, you can contact the domain name owner or you can check with a domain broker. So finally, we not only go for a domain name, but we go for multiple domain names because you need to save and secure your business.  Which identify a industry or a market.


And after learning so much more throughout the last month and a half now I understand why the mom makes videos the way she does and you're gonna see some of her videos today You're gonna be like, oh, it's not great But then when you find out why it just kind of makes sense and now I feel kind of bad after watching the family of Jake Paul From Shane Dawson today. We really got to sit back and ask ourselves is Shane Dawson being manipulated by the Paul family What is up everybody? This is Chris from the Rewired Soul where we talk about the problem But focus on the solution and if you're new to my channel, my channel is all about mental health Most of it is about helping you improve your mental health And what I like to do is pull things from the YouTube community or pop culture to try to teach you how to improve your mental health So if you're into that make sure you subscribe ring that notification bell because I make a ton of videos And I've been reviewing pretty much every episode of the Shane Dawson Jake Paul series. All right So before I get started before I get started. I got a little rant against Felix PewDiePie PewDiePie, I forgot his last name, but I got a little rant I didn't want to make a whole separate video for this, but I watched Felix's video about Shane Dawson, you know, and he was just bringing up all the stuff people have already brought up I'm surprised how late Felix was in this But anyways regardless of that like like Felix touched on a bunch of the same points that everybody touched on and everything and you know Felix is this loud voice. I'm like man. I I love Felix. I love PewDiePie I think he's a really good dude But like when it comes to mental health and addiction topics like I don't know his his He's very ignorant. Um and like some of this, you know happened when the whole Demi Lovato thing happened And yeah, like it was just I made a video about this. I made a video. I'll link it up in the info card, but Here's my gripe with PewDiePie today. He okay, you know what?  I did I think a year ago and they asked me to talk about them I'm like, okay fine, but I would never want to take money from it I would never want to take money for a mental health app It just doesn't feel right and I'm probably the most morally skewed person ever So for me to come up with that conclusion and not Shane, it's kind of weird like what like I don't I don't get it Like this is crazy to me. This is absolutely nuts to me So I saw a comment earlier on my channel and it said something to the effect of like I don't think it's right to have a mental health channel and Promote, you know your patreon or merch or I'm like wait what what like I don't know what world people live in I might make a separate video about PewDiePie like trying to discredit better help which is ridiculous Like they basically are the middle person for people and therapists like that's all they are There might be bad therapists on there, but there might be good therapists like what but like to say It's immoral to get sponsored by a mental health place like okay first off first off It's called Shane immoral for that like PewDiePie Has like the largest audience and have any of you guys seen the the clothing line that he started with his wife Like it's like like a little squiggle line and they sell it for like $25 like what what and they're saying It's a moral for Shane to be sponsored by a mental health place like I don't get that like should mental health be free should physical, you know should you know Physical health be free like going to the doctor like someone say yes, and maybe I don't know Maybe that's what PewDiePie is talking about because PewDiePie is from places where they have universal health care and that stuff is free So maybe that's where he's coming from but to call it immoral is really really ridiculous Like I don't get that at all like doctors who peddle medications just so they can get a kickback on it Even though the medication might be addictive and kill people that is immoral but saying like someone's getting sponsored to promote a mental health website that or app that helps people and Like no, I guess you could say this is biased because I'm supported by better help But like no like I don't back anything that I don't believe in like I've had I've had people come to me and ask me to Talk about their product and things like that and I'm like absolutely not a lot of them have been like Supplements and things for addiction. I'm like absolutely not. But anyways, that's my gripe with Felix Sorry, I had to get that rant out of the way Let's get into the topic of the Shane Dawson like this is something that I've been worried about since the start of the series If any of you watched my last video I touched on it, but now I'm going to expand deeper into it So my fear is that Shane is going to get manipulated and it's interesting too. I'll talk about this first I had a comment so I did like a whole live stream of reaction and somebody said like, oh man, that's messed up He said Shane needs better friends Sorry, like sorry about that And I think that that comment might have thought like maybe thought I was referencing like people like Andrew or Garrett or you know Even Rylan or Morgan. No, no, no, those people are great But like I think the person that comes to mind is like Tana mojo, right? Like like what like Shane needs to stop surrounding himself by people who are constantly getting into stuff So something that we were talking about in the live stream and I and by the way my videos are for you Okay, like so the definition of insanity is doing the same thing expecting different results, right? Shane keeps hanging out with the same type of person Shane keeps reaching out to the same kind of people Shane is doing this over and over but he's expecting a different result. That's insane So like one thing that I really hope at the end of this series is that we're able to like have some kind of recap video Maybe he like sits back and reflects on this stuff because there was a lot of stuff in the ending of this Part three that made me think that maybe Shane like going back and editing this stuff is like, oh my god Like was I getting manipulated? But yeah, like I kind of was taken aback like some people are upset that I'm like giving Shane like some real talk Not like he'll ever see this video But the thing is like I always say this the best friends in your life are gonna tell you what you need to hear And not what you want to hear. All right, like yeah, it sucks But like I have to keep people around I have to keep people around like my girlfriend my best friend other people all of you I need to keep people around who put me in check who say Chris you are messing up All right, so like no like I love Shane Shane is an amazing human being But because I care about him, it's like yo, dude, you need to quit hanging out with certain people You need to quit trying to find the best in every single person So as we go on and we keep watching this video, you just see Shane just feeling bad for everybody Just for for Jake and then for Logan and then for the mom I think the only person you didn't feel bad for was like the dad at some point and like that's good Another comment said that Shane is an empath and absolutely absolutely and this is great Like I made a video about why depression is awesome and people who have experienced depression. They're more likely to be empathetic It's an amazing quality. The problem is is that for those of you out there who are empath It goes way too far. All right, and then what happens is we start to get taken advantage of so so much of our Mental health is about balance like yeah, we need to feel bad for people But we also need to set up boundaries like that's the give and take of this thing Like I need to feel bad for you, but I also need to say yo you need to get your stuff together You know what I mean? So one of the things is about being an empath and what you know When I'm worried about Shane getting manipulated like let's talk about the audience Okay, so my fear is that Shane is going to have the pendulum Just keep shifting over and over now He did make a tweet about this But so in the beginning in the beginning a bunch of people were worried that Shane was gonna try to you know Sympathize with Jake Paul. So the pendulum swing this way, right? And he's like, okay.  So then in this video He does this huge disclaimer and bam It's going this way again and he's starting to realize that and man if this is you it will drive you nuts Like I used to be the biggest people pleaser on earth I was always trying to please everybody and it was screwing up my mental health So when I talk about these things about Shane like it's because I care about him And I want to make sure that these things don't happen, but I don't know Shane I'm not friends with Shane, but you you're watching my video So if you're a people pleaser, you need to start to get that thing in check People pleasing is a very good thing because it means that you want to help it means that you want to be kind It means that you want to be accountable It means so many things and I need to make a video about that But you need to take this people pleasing and find the balance in it So basically at the end of this video at the end of it He starts showing clips of him and Katie more and talking again and yes. Yes. Yes. Yes Like they start talking about this Every conversation feeling like it was worse for them and you feel bad for them I kind of feel a little bad for them too You know or you'll view them in a positive light You're like man that must have been so hard for them. They're such a nice person And that's that's absolutely correct and like although these people may not be sociopaths and things like that Like Shane needs to be careful because like Katie was saying they will they will screw you over And try to make you feel bad about it like what what you need to sit back So when I'm talking about Shane needs better friends Like I think his friends are great But I think you know some of the people in his inner circle They need to call him out on it like I think Shane's friends are better than people like Jake Paul and Logan Paul like the friend circles They have but one of my concerns when watching this video is like whenever you heard Andrew talking Andrew is very agreeable like anything that Shane said Uh, Andrew kind of parroted it and like that that's just like okay Andrew like you know give him some maybe real talk have your own opinion on these things and stuff because One of the issues with uh, you know the pole brothers or people like tana or these other youtubers who are screwing up Like uh, foosytube was they keep all these people around them who just tell them. Yes. Yes. Yes. Yes. Yes.   Oh, you know what I mean?  So i'm just gonna forget everything else I'm not telling you to hold grudges But you need to take all of the person into account when you're deciding how you want to pursue This relationship, whether it's a friendship or an intimate relationship and things like that And I think that's one of the issues that shane has is that he hyper focuses on what's happening in that moment And forgetting all of the other things that are happening like I mentioned in my last video Like when he was feeling bad for for jake because his mom was filming him But jake literally terrorizes everybody in the team 10 house like shane forgot about that in that moment So anyways, I've talked too long. I would love to know your thoughts Like do you think the paul family is going to manipulate shane? Whether it's jake paul or logan paul or greg paul like do you think that's going to happen and also um, the mom Pam i'm not sure like she's the one who's been reaching out with shane to shane So I don't know leave your comments down below All right, but that's all I got for you this video If you like this video, please give it a thumbs up and again if you are new Make sure you subscribe and ring that notification bell and a huge thank you to everybody supporting the channel over on patreon I'm sorry, but not sorry. I need support. I need to get new equipment and things like that I'm kidding, but if you want to support the channel on patreon, you can do a four buck Pick a tap right there. All right. Thanks so much for watching. I'll see you next time


Hey guys, welcome to SSU Tech. So, we'll decide and this is continuation of SQL Server interview questions and answers. So, today we are going to see about one more SQL query related interview question. So, let's move to next slide to understand about that question. So, basically here in a library, if any person will take the book from the library, it will take the charges like if anyone take the book for between 1 to 30 days, it will be going to charge $0.5. If it will be more than that between 30 first to 60 days, then it will be $0.75 for each day. If the day that will be more than or equals to 61, then it will be going to charge $1.5 on each day. So, here basically you need to write a SQL store procedure that will take three parameters. First will be the from date, second will be the to date and third will be the book price. If your charges will be more than the book price, then it will show only book price and output will have only two columns. First will be the total days and second will be the charges. So, let's assume here we are having an example like if your from date is 2020-01-01 and to date that will be 2020-0-15 and your book price is $15. So, here output should be 15 because charges will be 26.25. How we can calculate that? So, here as you can see inside the note like the total days that is 45 days. So, the charges will be going to applicable up to 30 days that will be $0.5 and between 30 first to 60 days that will be $0.75. So, here in the 45 days first 30 days it will be going to charge on the $0.5 and next 15 days will be going to charge on the $0.75. So, it will be going to calculate like this. So, go to other SQL Server and let's try to write the store procedure and where we can achieve this output. So, here I am using SQL 2017. You may have another version of SQL Server but this query will help you on the all the versions of SQL Server. So, here first of all for creating any store procedure you have to write the create statement. So, the create then proc after that you need to specify your procedure name. So, that will be part 64 of this video series. So, I am going to call this as part 64. Then as your question is saying like we should have three parameters. So, first will be the from date. So, this is the from date and data type of this will be the date. Then we will have next one that is the true date and data type that is date. Then last will be the book price. So, we can call this as book price and this should be integer. And here we can see as then we could have begin and at the last it will be end. So, now the first thing that we need to take care we need to calculate the difference between the true date and from it. So, how we can calculate that? So, first of all let me declare a variable. So, declare at the rate total days and it should be integer. So, here we need to use the date difference and start the bracket. Here we need to get the difference on days. So, we can call this as dd then put comma. Here we need to specify from date. So, this is your from date then put comma last that will be true date. Now, we can close the bracket. So, here we have calculated the total days. Now, the logic will come on the next. So, here first of all let me declare one more variable and that will be the total charges. So, how we can calculate the total charges. So, this is very important and you need to understand. So, first of all we need to use the case statement. So, case when? Now, we are going to check this total date difference. If it is more than or equals to 61 then we need to have the calculation that will be the first one. Let me check the value of this total days. If that value is greater or equals to 61 then the first 30 days will be going to calculate on the point five dollars plus next 30 days will be going to calculate on the point seven five dollars then plus here we need to get how many days are remaining. So, how we can calculate that. So, for that we need to get the total days minus 60 because here we have this 60 for the first 30 days then next 30 days. So, we need to subtract the 60. So, it will get the how many days are remaining then multiply this with the 1.5. So, we have done if your total days is more than or equals to 60. So, not 60 it should be 61. Now, go to the next condition and in the next condition we need to check when the total day greater or equals to 61 then here is will be going to lie between 31 to 60. So, for that first will be same like the first calculation of 30 days will be multiplying with the point five plus here we need to get how many days are remaining. So, for that we can copy this start the bracket subtract with the 30. So, now we will get the how many days are remaining we can multiply with 0.75. Now, the last either you can check with the when condition or you could use the else condition and in the else condition it should be going to lie less than 30 days. So, we can multiply with the 0.5 directly and we could say like and. So, this is the calculation. So, by using this calculation we can directly achieve the output of the total charges. Now, it looks good. Now, here we need to select total days call this as total days.com. Now, here again we need to check the charges value if this charges value is more than the book price then we need to display the book price. So, here we need to use again case when your book price value is less or equals to add the total charges then we need to display the book price. So, here it is the book price else we can display the total charges and we can end with this case statement and let me call this column as charges. So, this is the charges. Now, we can execute this. So, the store procedure is created successfully. Now, let me copy this and try to execute this store procedure and check the output. So, for that we can write the execute then we have three parameters the last one will have the 15 in the from date we need to specify 2020 0 1 0 1 in the second parameter 2020 0 to 15 and in the last parameter that is 15. Now, we need to execute this store procedure. So, in the output you could see we are seeing like the total days that is 45 and the charges that is 15. Now, let me change this with the 50 of this book price. Now, let me try to execute. So, this time we should be able to see this calculated value that will be 26.25. So, let me try to execute and here you could see 26.25. So, it is working fine as per our expectation. So, guys, I hope you have understand how you can achieve this output by writing the store procedure with the three parameters and if you need this script it will be available on the comment box of this video. So, you can go and check the comment. Thank you so much for watching this video. If you like this video, please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.


In the first video what we are going to do is tackle the first problem which is identifying what is a good trade. So the markets have just opened it's July 24th and what we are seeing here you'll see two columns here. One is for day trades and one is for swing trades. The day trades column obviously it looks at very very short time frame so you can see that we have a one day one minute chart. Let's just analyze this day trades column and then we look at the swing trades column. So once the market's open the day trades column becomes very active and you can see that stocks are changing states that's because in the day trading algorithm the changes happen very quickly. So let's first take a look at Apple here we see that Apple is bullish and of course the gray area is the pre-market and sure enough as soon as the market's open you can see that Apple has gone up significantly just about in the last 10 minutes or so. You can see that if you wanted to take a trade you could take a trade once you saw right from the pre-market that Apple was going to be bullish and of course the S&P is also up today so that that works for all stocks all stocks are correlated to the S&P 500 index in some sort in some manner or the other. So Apple is a good example of a good day trade let's look at Starbucks that's another one here Starbucks not so much regardless it is still bullish and so the signal has come up. Now let's look at Goldman Sachs now this is also much better this is like Apple so you can see in the pre-market there was not a whole lot of action in Goldman Sachs but once the markets have opened Goldman Sachs is moving up about two or three dollars here so that is how you would look at the day trade column in general I would not advise you to take a trade right at the market open because that's always going to be a little volatile however once the markets settle in and you get a certain idea of how the markets are going then you want to get into these kind of trades now if you're day trading you probably won't be in the trade for more than maybe 15 minutes 20 minutes half an hour maybe even one hour if the trend continues you can stay in the trade and you'll see that this custom RSI helps you stay in the trade and we'll get to that in a separate video but in this video this day trades column you can see will identify what are the good stocks to day trade for today in the following videos we'll cover the swing trading column as well and then we'll go into the detail into all of these indicators the multi-time frame trend indicator the custom RSI as well as there is something called the SPX ticks which measures the breadth of the market and so we'll get into all of those in individual videos this video was just to cover how you can identify what are the good trades and if it's a bearish day then you would want to look for the very bearish candidates but today given that the SMP is up about you know 10 or 12 points already at the open you're going to you're going to want to look for bullish trades and that's exactly what this column does thanks


Welcome back to Kavuto Coast to Coast. I'm Charles Payne in for Neal Kavuta, and we've got another very busy hour coming up We just had an amazing jobs report and missed the estimates But the details are phenomenal including revisions to May and June that more than made up for the headline Edward Lawrence is at the Labor Department with more Oh Charles the White House is actually saying that they're happy with this report They're highlighting the positives that are in this report like manufacturing jobs increasing in fact manufacturing created 37,000 jobs in July that number on pace with what the June number was so for the past two months Manufacturing in that sector has created 73,000 jobs now add in another 19,000 jobs from construction And that could indicate that there's investment from companies going forward No economic advisor Larry Kudlow says that he's happy with the job numbers and the forecast from the Atlanta Federal Reserve That the third quarter growth will be five percent I actually thought it was a pretty strong report Because the headline number was a little below estimate, but look the back revisions were gigantic 59,000 so really you got to add that in that gives you really two 15 for the month of July And Kudlow ended up saying that you need to look at the trend over the last three months In fact, this economy over the past three months has created 224,000 jobs per month there now economists say that this report could also be good for the Federal Reserve to keep to their path of Forecasting two more rate hikes this year my sources in the Fed say they're really looking at the average hourly wages And that number was 2.7 percent again this month for the 12 months preceding this now if that number stays around the 2.7 percent level inside the Fed they believe that inflation pressures will be lower So the bottom line this jobs report good for the White House good for the Federal Reserve Charles Thank you very much Edward now the steady jobs gain lower and unemployment One of the questions is why why don't we see wages picking up and it could that actually happen real soon? Want to go to real clear editor John Tammany the pain capital management president Ryan pain and stocks who's founder Melissa Armo? Let me start with you John It's it was it was a great report in my mind when I started looking at some of the details particularly of some of some sectors For instance the u6 number going to seven and a half from seven point eight That to me reflects a wider breadth of people who were out of this job market who was struggling and doing much better But are you concerned about any element particularly wages? No, no for one you never look a scans at three point nine percent But for two it's at some point We've got to just throw out the ridiculous models happened upon by economists and just use common sense Think about it The u.s. Has the most valuable companies in the world by far at the high level the mid level the low level Can you name any company in history that got that way without adding the best talent possible and paying that talent? Well, is it really consistent with the market valuations placed on u.s. Companies that somehow those businesses could routinely build workers at all levels it defies basic common sense Americans are paid very well. Who cares that economic statistics don't reveal what's obvious Melissa, what are your thoughts the jobs report? We're up almost a hundred points on a Dow S&P is up for the fifth week in a row will finish higher And and you know NASDAQ 100 just a couple days ago We were talking about a breaking under the 50-day moving average now it could be back to a double top real soon Well, you know what people live and die by these numbers, which I think is ridiculous. This was a good number It wasn't as expected. It's not the end of the world and you know how I can figure that out the market had no negative reaction today We gapped up and opened up today. We had a huge rally yesterday. Apple came out their earnings were spectacular made all the brand new All-time highs there's no reason to you know have a pity party because we didn't hit these exact numbers these estimates sometimes They I think they over shoot what these estimates are want to be but this is a still a good solid solid number And you were talking about early this morning and you were saying, you know what if this was too big then the Fed might say oh And then raise rates another extra time. So I mean, I think it's good Goldilocks Goldilocks. No, I think we have to remember is I mean it yeah Goldilocks action way it is because we have modest inflation And you know, we're seeing the economy grow. We're seeing you know unemployment go up It's moderate and that's all the things you want to see to keep this economy cooking because yeah This is one of the slowest economic recoveries. We've ever had it all time. We're not going to go to zero to 60 overnight So say that again. I said this is one of the slowest economic recoveries We've ever had well, you mean over the ten year that we've had expansion in the economy, right? But more recently it has picked up a tremendous amount of steam. Yeah, GDP was great for last quarter But I mean you can't expect wages to just go skyrocketing overnight. I think that's going to take a while What about the overall economy though? Can we can we expect it's 3% reasonable? I think it's very realistic I mean you have capital expenditures coming back in corporations You have you know people are spending money again the government spending money this this economy is heating up This incorporations aren't going to pay more unless they're forced to I mean if you if you want a company You run a company, you know, you want you're trying to save I mean that's the biggest expense that companies have is payroll They're not going to pay more unless they absolutely have to right of course That's one of the things that was big on Janet Yellen's dashboard the quits part of the of the jolts report And that's starting to edge up and not a lot now John I know you're not a big fan of tariffs, but the battle is joined if you will China announcing 60 billion and retaliatory tariffs But I thought the more important news this morning was China taking measures to sort of slow the decline in their currency Which many people were saying what that was going to be there they're ace in a hole What do you make of it all? Well, I think we overrate this idea that you can devalue your way to prosperity if that were true Then Zimbabwe would be the richest country on earth in Argentina would be number two When you devalue your currency you weaken your workers and you repel the very investment that drives corporate and job creation Look at Japan Japan had some of its best years of economic growth when the yen was soaring against the dollar And so what's crucial is that the Chinese maintain that peg to the dollar? Let's never forget the only reason we're working is because we want to get things more than the Chinese get up and go to work every day We Americans get a raise furthermore China represents an increasingly large market for US companies Apple's the most valuable company in the world. Where does it get one quarter of its revenues from sales in China? Let's not mess up what's great for both countries, of course Melissa I think that's one of the issues we're trying to resolve even greater access and into China And the ability to do business there without giving up too much or giving up intellectual property or straight secrets Right and that's what Trump is coming out doing all this and again It just goes about a hundred percent conviction look at the market today We came out with this all this tower of stuff came out this morning before we opened and we didn't have any negative reaction I was surprised the market is holding tough. It's hanging tough. It's trying to hang in there The market really likes Trump a lot. It's trying to struggle off this tariff is whenever it comes out I think you got it. You got to give it a shot. You got to give him time It could be a couple of months till all this gets straightened out, but China's fighting back They're fighting back hard. Well, you know my thing Ryan is and I talked about it last time on my show I think this ultimately is the combination of art of the deal and art of war All right, if you read art of the deal, you know why President Trump is fighting this fight in the first place If you read the art the art of war right and there's some key components in there Like when you're victorious you don't crush the opponent you leave them at exit in other words We I think we're gonna find a place where we're gonna have to President Trump We'll have to find a place to declare victory because there will be an inflection point there could be yeah, absolutely I mean, let's face it at the end of the day. We import so much more from China than they import from us So I mean we definitely have the upper hand here plus China's economy is slowing our economy is really strong here So this is just a negotiating ploy and we'll probably win that battle or you know that you whatever you want to call it John what's what's worrying you the most of all the things in this economy including debt Which you know what we're sort of remiss because we don't talk about it a lot and we used to Well debt rises when an economy is growing and we know that for obvious reasons No one's going to lend to a person or a business or even a country if they feel that that debt's not going to be paid back So that's something I've been making with some of my relatives, but go ahead To some degree that takes care of itself what worries me is the trade stuff. Let's be clear I I don't buy into this notion that we have we have a strong hand versus China again Apple gets a quarter of its revenues from sales in China GM sold more cars in China in the first quarter than it sold in North America Nike's number two market is China Boeing sells one quarter of its planes in China They're double the number of Starbucks and Shanghai and they're in New York City Why on earth would we get in a war with a country that is still very poor? Imagine what a huge market they'll be for our world-leading companies once China actually gets rich Let's not mess with what's good, right? But we do want access at that market because we've already got the access do we Look at look at the numbers. Why would that? Why does Apple get a quarter of its revenues from sales in China number five? Smartphone maker in China and part because of some some things I mean anyone who does real business in China will tell you there are a lot of obstacles against American companies and American products So that number could be even better if they would level the playing field to the same degree that we level it for their companies Yeah, I know No, go ahead. No, I agree with that I mean, I think that that's the point here is we definitely have room to negotiate and I think you're gonna see that I think we're actually gonna win this conflict. I mean, it could be a win-win listen That's the whole thing China obviously says that they would like to do more rely less on exports and more on the domestic economy You know, they have a huge amount of middle-class that's grown over the years and and they're not gonna always have this Manufacturing, you know advantage not they certainly won't have it against the neighboring country Nike does more Manufacturing of their sneakers in Vietnam now that they do and in China So they want that they want domestic prices to be low I would think but it's just about freer or fairer sort of markets Right that and also the intellectual property thing is a bugaboo and so that is a problem for Trump as well You know when when you look at them a whole let's just say this all works out to America's advantage Trump keeps saying America first Let's just say it all works out You know what the other countries of the world are gonna look at Trump differently because they've had issue with him doing this To them as well and China's been the biggest one that's been trying to stand up to Trump with the with the tariffs If other countries are gonna respect us more if this works out with China Well, we're close to something with you we may get something over the weekend on that and we'll all see hey Thank you all very much for the smart passionate commentary. Have a great weekend in the meantime Sticking with Apple they continue to climb now more than a trillion dollar market cap So what does Tim Cook need to do to really keep up the pace because when you're winter people expect even more from you And of course be sure to tune into my show tonight making money at 6 p.m We're gonna talk about a whole lot of things not just Apple last night. I told you about smuckers It's up eight bucks today. There's a lot of ways to make money in this market. We'll go over it tonight 6 p.m