Posts

Showing posts with the label AWS

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

AWS CLI PySpark a Beginner's Comprehensive Guide

Image
AWS (Amazon Web Services) and PySpark are separate technologies, but they can be used together for certain purposes. Let me provide you with a beginner's guide for both AWS and PySpark separately. AWS (Amazon Web Services): Amazon Web Services (AWS) is a cloud computing platform that offers a wide range of services for computing power, storage, databases, machine learning, analytics, and more. 1. Create an AWS Account: Go to the AWS homepage. Click on "Create an AWS Account" and follow the instructions. 2. Set Up AWS CLI: Install the AWS Command Line Interface (AWS CLI) on your local machine. Configure it with your AWS credentials using AWS configure. 3. Explore AWS Services: AWS provides a variety of services. Familiarize yourself with core services like EC2 (Elastic Compute Cloud), S3 (Simple Storage Service), and IAM (Identity and Access Management). PySpark: PySpark is the Python API for Apache Spark, a fast and general-purpose cluster computing system. It allows you

Load Balancers in AWS: Choosing the Right Option for Your Application

Image
The load balancer's purpose is to balance the incoming traffic. It allocates the incoming traffic to the available healthy servers. Here are the top AWS load balancers. AWS Load balancers These are Application Load Balancer, Gateway Load Balancer, and Network Load Balancer. Application Load Balancers Gateway Load Balancers Network Load Balancers   1. Application Load Balancers (ALB) A Load balancer contains two parts - Listeners and Target groups. The listener then connects to a target group. The listener first checks the availability of connection according to the IP address and Port you did configure. Adopted from Amazon AWS   2. Gateway Load Balancers (GWLB) A Gateway Load Balancer receives traffic from the source and sends the traffic to targets. It sends requests to multiple virtual appliances. It's the prime difference between ALB and GWLB. 3. Network Load Balancers (NLB) A Network Load Balancer functions at the fourth layer of the Open Systems Interconnection (OSI) model

Cloud Computing: Horizontal Vs. Vertical Scaling

Image
The purpose of cloud computing is resource utilization. You can scale up the resources in two ways - vertical and horizontal. Adding resources, you can do either horizontally and vertically . The advantages and drawbacks you can find in simple words. Scaling 1. Horizontal Scaling Advantages You can increase workloads in small steps. The upgrade-cost is far less. Scale the system as much as needed. Drawbacks Dependency on software applications is more for Data distribution and parallel processing. On top of that, fewer software applications exist in the market. You May Also Like:  9 Top Services AWS Provided 2. Vertical Scaling Advantages Since it is a single machine, it is easy to manage. On the fly, you can increase workloads. Drawbacks It is expensive. You need a huge investment. The machine should be powerful to take more workloads - future use. Below is the List of Resources that You can do both Horizontal and Vertical Scaling Platform Scaling Network Scaling Container Scaling Dat

AWS Vs Azure Load Balancers Top Insights

Image
In AWS, you have three types of load-balancers. In the case of Azure, you have only two load balancers. This post tells you the comparison between these two. 1. AWS Load Balancers: Application Load balancer Network Load balancer Classic Load balancers. a. Application Load Balancer Balancing of HTTP and HTTPS traffic and provides advanced request routing targeted at the delivery of modern application architectures, including micro-services and containers.  Operating at the individual request level (Layer 7), Application Load Balancer routes traffic to targets within Amazon Virtual Private Cloud (Amazon VPC) based on the content of the request. b. Network Load Balancer Network Load Balancer is best suited for load balancing of Transmission Control Protocol (TCP), User Datagram Protocol (UDP), and Transport Layer Security (TLS) traffic where extreme performance is required. c. Classic Load Balancer The Classic Load Balancer provides the basic load-balancing across multiple Amazon EC2 inst

9 Top AWS Services a Quick List

Image
In this post, I have explained the top AWS services list . These services are useful to read before your next interview. knowing this list is a must for all cloud-computing engineers. AWS provides various services. This post gives a clear understanding of AWS's top services.  AWS Books AWS in action AWS Cookbook Not only for traditional services, but it also offers services for Mobile IoS and Android Os.  Aws Service catalog  helps organizations to manage their IT services. AWS List of Top AWS Services Quick List These 9 Services of AWS are popular. I have explained each service to understand quickly. EC2 Lambda S3 DynamoDB IAM Amazon Cognito Device Farm Mobile analytics SNS 1. AWS EC2 Instance EC2: Amazon Elastic Compute Cloud (EC2) provides secure, scalable, on-demand hardware virtualization in the cloud. Using Amazon EC2 eliminates the need to invest in server hardware upfront so that users can focus on, develop, and deploy applications faster.  EC2 instances com

AWS Block Vs Object Storage Top Differences

Image
In AWS, Block and Object are two types of storage. I have given differences between these two. Why because storage is a prime concept in the cloud environment. Object Vs Block Storage Why are these names different? Because these two are different storage types - Object and Block. Object Storage Object means it is a single object. You are not dividing here. In the context of AWS, object storage helps your file to store as-is. How big it does not matter. Let your file size is 10MB. Then, it saves as a 10 MB file. What happens when you update a 30MB file. It deletes the old object and creates a brand new one. For small changes, you need to update the whole file. So, it utilizes a lot of resources. Object storage is much better for big files and very few changes. AWS manages object storage. AWS has full control over Object storage. Object Vs Block Block Storage Block storage divides your file into blocks. You have selected a block size of 512 bytes. If you want to upload a 10MB file, it th

AWS to Understand EC2 Security

Image
Amazon Elastic Computing Cloud, you can call it EC2. Here're EC2 top security features and shared frequently asked interview questions on EC2. Based on your requirement, you can increase or decrease computing power. Before you enable the Autoscaling feature, you need to know its impacts since it's the Administrator's responsibility. AWS to Understand EC2 Security AWS EC2 Making your existing hardware to the requirement always is not so easy. So EC2 service in AWS helps you to allocate computing power according to your needs.  AWS EC2 instance acts as your physical server. It has a memory. You can increase the instance size in terms of CPU, Memory, Storage, and GPU.  EC2 auto scaling is a property, where it automatically increase your computing power. Security Features in EC2 Virtual Private Cloud. The responsibility of Virtual Private Cloud is to safeguard each instance separately. That means, you cannot access other instances, which are already created by other organiz

4 Layers of AWS Architecture a Quick Answer

Image
I have collected real interview questions on AWS key architecture components. Those are S3, EC2, SQS, and SimpleDB. AWS is one of the most popular skills in the area of Cloud computing. Many companies are recruiting software developers to work on cloud computing. AWS Key Architecture Components AWS is the top cloud platform. The knowledge of this helpful to learn other cloud platforms. Below are the questions asked in interviews recently. What are the components involved in AWS?   Amazon S3. With this, one can retrieve the key information which is occupied in creating cloud structural design, and the amount of produced information also can be stored in this component that is the consequence of the key specified. Amazon EC2 . Helpful to run a large distributed system on the Hadoop cluster. Automatic parallelization and job scheduling can be achieved by this component. Amazon SQS . This component acts as a mediator between different controllers. Also worn for cushioning requirem

Amazon Web services Daily career tips subscribe today

Image
You will receive daily tips to your email id. They are suitable to all application developers and working professionals in Amazon web services. These are from theory to practical and other relevant tips to find suitable jobs. You can subscribe here. You will receive tips on the following points. Get ready and share it to your friends also. Tips about AWS What the developers will do , if they selected for AWS jobs What type of roles available in AWS Interview tips on AWS Best training on AWS Also Read: Top 8 AWS basic Questions and answers 5 Key modules you need to learn in AWS

8 top AWS tricky interview Questions

Image
In this post, I have explained AWS (Amazon Web Services) tricky interview questions. The EBS, AMI, S3 and Amazon instance included in my questions Q1. Explain Elastic Block Storage? What type of performance can you expect? How do you back it up? How do you improve performance? A1. EBS is a virtualized SAN or storage area network. That means it is RAID storage to start with so it’s redundant and fault-tolerant. If disks die in that RAID you don’t lose data. Great! It is also virtualized, so you can provision and allocate storage, and attach it to your server with various API calls. No calling the storage expert and asking him or her to run specialized commands from the hardware vendor.   Performance on EBS can exhibit variability . That is it can go above the SLA performance level, then drop below it. The SLA provides you with an average disk I/O rate you can expect. This can frustrate some folks especially performance experts who expect reliable and consistent disk through

3 Best Ways to Learn AWS on Weekends

Image
Amazon web services are one of the popular skills. So, many developers started adding this skill to their list. Due to digital transformation, companies started giving more weightage to the developers who have AWS skills. How to Learn AWS I want to share in this post how to learn AWS quickly.  The idea is to use your weekends to learn AWS.  My learning plan to allocate 5 hours a week. You can take out 2 hours  Saturday and 3 hours Sunday time for this learning. 3 Best Ways to Learn AWS on Weekends  As I said in my previous post   basic interview questions on Amazon web services really a quick start. 3 Best Ways to Learn AWS During Weekends. What is next how to start learning and be industry-ready. You need to have a good  laptop to begin your learning. If it is Ubuntu pre-installed one, really this is good for your study and practices... What materials online you need to refer to. This is basically a question for the developer. Just begin with AWS manuals published

7 AWS Interview Questions asked in Infosys, TCS

Image
Here are seven amazing Infosys AWS interview questions for your quick reference. These are also asked in TCS. Infosys and TCS AWS interview questions 1). What is AWS? Amazon Web Services (AWS) provides on-demand computing resources and services in the cloud, with pay-as-you-go pricing. For example, you can run a server on AWS that you can log on to, configure, secure, and run just as you would a server that's sitting in front of you 2). What you can do with AWS? Store public or private data. Host a static website. These websites use client-side technologies (such as HTML, CSS, and JavaScript) to display content that doesn't change frequently. A static website doesn't require server-side technologies (such as PHP and ASP.NET). Host a dynamic website or web app. These websites include classic three-tier applications, with web, application, and database tiers. Support students or online training programs. Process business and scientific data. Handle peak loads. AWS Quest