tcs
SQL “Create an customer Table with following Attributes (Columns )1. Customer SSN ID: A Numeric value for Employee ID (Primary key)2. First Name: A text value for customer name(Maximum 50 characters)3. Last Name: A text value for customer name(Maximum 50 characters)4. Email: A text field to capture the Email of an customer.5. Date Of Birth : A Date value (YYYY-MM-DD)6. Address: A text value to capture street, city details(Maximum 100 characters)7. Contact Number: Numeric value Maximum 10 digits. After Successful Creation of Table insert minimum 10 Demo records” CREATE TABLE customer (customer_ssn_id INT PRIMARY KEY,first_name VARCHAR(50),last_name VARCHAR(50),email VARCHAR(100),date_of_birth DATE,address VARCHAR(100),contact_number BIGINT CHECK (LENGTH(contact_number) = 10)); INSERT INTO customer (customer_ssn_id, first_name, last_name, email, date_of_birth, address, contact_number)VALUES(1001, ‘John’, ‘Doe’, ‘john.doe@example.com’, ‘1990-01-15’, ‘123 Elm St, New York, NY’, 1234567890),(1002, ‘Jane’, ‘Smith’, ‘jane.smith@example.com’, ‘1985-05-23’, ‘456 Oak Ave, Los Angeles, CA’, 2345678901),(1003, ‘Michael’, ‘Brown’, ‘michael.brown@example.com’, ‘1992-08-10’, ‘789 Pine Blvd, Chicago, IL’, 3456789012),(1004, ‘Emily’, ‘Johnson’, ’emily.johnson@example.com’, ‘1995-12-01’, ‘321 Maple Ln, Houston, TX’, 4567890123),(1005, ‘David’, ‘Davis’, ‘david.davis@example.com’, ‘1988-03-18’, ‘654 Cedar Rd, Phoenix, AZ’, 5678901234),(1006, ‘Sarah’, ‘Wilson’, ‘sarah.wilson@example.com’, ‘1993-07-25’, ‘987 Birch St, Philadelphia, PA’, 6789012345),(1007, ‘Chris’, ‘Miller’, ‘chris.miller@example.com’, ‘1991-11-07’, ‘111 Spruce Dr, San Antonio, TX’, 7890123456),(1008, ‘Laura’, ‘Garcia’, ‘laura.garcia@example.com’, ‘1987-09-14’, ‘222 Fir Pl, Dallas, TX’, 8901234567),(1009, ‘James’, ‘Martinez’, ‘james.martinez@example.com’, ‘1994-04-29’, ‘333 Redwood Ct, San Jose, CA’, 9012345678),(1010, ‘Linda’, ‘Rodriguez’, ‘linda.rodriguez@example.com’, ‘1990-02-22’, ‘444 Palm Way, Austin, TX’, 1234567809); ******************************************************************************************* “As a financial data analyst, i want to search Customer personal Data by there customer Id” “After Successful insertion of records financial data analyst, will beable to retrieve customer Details from customer table by there customer id” SELECT * FROM customerWHERE customer_ssn_id = 1001; — Replace 1001 with the desired customer SSN ID ******************************************************************************************** “As a customer, I want to update my personal information( such address or phone number) in the database, so thatbank has up to date details” “After Successful insertion of customer records, customer will be able to update the personal contact details.The query result should contain the following attributes;Customer SSN id | name( first_name+last_name) | Email | Phone | address” UPDATE customerSET address = ‘456 New Address St, Miami, FL’, — New addresscontact_number = 9876543210 — New phone numberWHERE customer_ssn_id = 1001; — Replace 1001 with the desired customer SSN ID SELECT customer_ssn_id, CONCAT(first_name, ‘ ‘, last_name) AS name, email, contact_number AS phone, addressFROM customerWHERE customer_ssn_id = 1001; — Replace 1001 with the desired customer SSN ID ******************************************************************************************* “As a bank employee, i want to able to Capture Customer Transaction Data in the Database”“Create an Customer_transaction Table with following Attributes (Columns )“”Enter the values for input fields (on Screen) : Customer id (Primary key ) , Customer Name, Account Number , IFSC code, Account balance , Adhara card No. , Pan Card No , Contact Number After Successful Creation of Table insert minimum 10 records” CREATE TABLE customer_transaction (customer_id INT PRIMARY KEY,customer_name VARCHAR(100),account_number VARCHAR(20),ifsc_code VARCHAR(11),account_balance DECIMAL(15, 2),aadhar_card_no VARCHAR(12),pan_card_no VARCHAR(10),contact_number BIGINT CHECK (LENGTH(contact_number) = 10)); INSERT INTO customer_transaction (customer_id, customer_name, account_number, ifsc_code, account_balance, aadhar_card_no, pan_card_no, contact_number)VALUES(1, ‘John Doe’, ‘123456789012’, ‘IFSC0001’, 15000.75, ‘123412341234’, ‘ABCDE1234F’, 1234567890),(2, ‘Jane Smith’, ‘234567890123’, ‘IFSC0002’, 20000.50, ‘234523452345’, ‘FGHIJ5678K’, 2345678901),(3, ‘Michael Brown’, ‘345678901234’, ‘IFSC0003’, 35000.00, ‘345634563456’, ‘JKLMN9012L’, 3456789012),(4, ‘Emily Johnson’, ‘456789012345’, ‘IFSC0004’, 45000.25, ‘456745674567’, ‘OPQRS3456M’, 4567890123),(5, ‘David Davis’, ‘567890123456’, ‘IFSC0005’, 100000.00, ‘567856785678’, ‘TUVWX7890N’, 5678901234),(6, ‘Sarah Wilson’, ‘678901234567’, ‘IFSC0006’, 25000.75, ‘678967896789’, ‘ABCDE1234P’, 6789012345),(7, ‘Chris Miller’, ‘789012345678’, ‘IFSC0007’, 30000.00, ‘789078907890’, ‘FGHIJ5678Q’, 7890123456),(8, ‘Laura Garcia’, ‘890123456789’, ‘IFSC0008’, 75000.50, ‘890189018901’, ‘JKLMN9012R’, 8901234567),(9, ‘James Martinez’, ‘901234567890’, ‘IFSC0009’, 90000.25, ‘901290129012’, ‘OPQRS3456S’, 9012345678),(10, ‘Linda Rodriguez’, ‘012345678901’, ‘IFSC0010’, 50000.00, ‘012301230123’, ‘TUVWX7890T’, 1234567809); ******************************************************************************************* As a bank employee, i want to search customer Data(personal data and transactional data by there Employee Id “Bank employee will be able to retrieve customer account details from transactional details and personal details from customer table (Customer id , Customer Name, Account Number , IFSC code, Account balance , Adhara card No. , Pan Card No, Date Of Birth (DD-MM-YYYY) , Email , Address , Contact Number).” SELECT ct.customer_id, ct.customer_name, ct.account_number, ct.ifsc_code, ct.account_balance, ct.aadhar_card_no, ct.pan_card_no, c.date_of_birth, c.email, c.address, c.contact_numberFROM customer_transaction ctINNER JOIN customer c ON ct.customer_id = c.customer_ssn_idWHERE ct.customer_id = 1; — Replace 1 with the desired customer ID **************************************************************************************** As a customer, I want to check updated account balance after transaction process “After Successful transaction process, records in customer transactions table will be updated . And customer will able to check the updated account balance.(Customer id | name( first_name+last_name) | Email | Account Balance)” UPDATE customer_transactionSET account_balance = account_balance + 5000.00 — Adjust this value for deposit/withdrawalWHERE customer_id = 1; — Replace 1 with the desired customer ID SELECT ct.customer_id, CONCAT(c.first_name, ‘ ‘, c.last_name) AS name, c.email, ct.account_balanceFROM customer_transaction ctINNER JOIN customer c ON ct.customer_id = c.customer_ssn_idWHERE ct.customer_id = 1; — Replace 1 with the desired customer ID UI UX BY SUS /* style.css */ body { font-family: Arial, sans-serif; background-color: #f0f2f5; margin: 0; padding: 0; } .container { width: 50%; margin: 50px auto; padding: 20px; background-color: #fff; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); } h2 { text-align: center; color: #333; } label { display: block; margin: 10px 0 5px; color: #555; } input, textarea { width: calc(100% – 22px); padding: 10px; margin-bottom: 10px; border: 1px solid #ccc; border-radius: 4px; } button { width: 100%; padding: 10px; background-color: #28a745; color: #fff; border: none; border-radius: 4px; cursor: pointer; font-size: 16px; } button:hover { background-color: #218838; } .success-message, .error-message { text-align: center; margin-top: 20px; font-weight: bold; } .success-message { color: green; } .error-message { color: red; } ************************************************************** <!DOCTYPE html> <html lang=”en”> <head> <meta charset=”UTF-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1.0″> <link rel=”stylesheet” href=”style.css”>
New Year: The History of Bharat’s Decline
1st January or first day of ‘’new year”, phones start to ring and celebrations begin everywhere. Consuming meat and alcohol are on its peak on this day. Ever wondered why or how this day became the first day of the year? What is the logic or history behind it? This blog will open up your eyes by providing some super important pages of untaught history. Have you ever celebrated April Fool’s Day? If yes, then you’re successfully brainwashed by British education system. The piece of information shared here will remove all your ignorance and even make you feel angry over our insult. The content will also make you feel true sense of pride and fortune for getting birth in this sub-continent named Bharat. History of New Year in Independent Bharat November 1952, Calendar Reform Committee was formed by Nehru government. Senior Indian Astrophysicist Meghnad Saha was made the head of the Calendar Reform Committee. He was asked to review all the calendars and make a report, drawing the conclusions for the most suitable calendar for Independent Bharat. On 18 February 1953, i.e., in only three months the report was given to the government with a conclusion that Vikram Samvat should be compulsorily implemented along with Gregorian calendar. Nehru government discarded the report by the committee as the committee was just part of a political gimmick to make Hindus happy. On March 1957, Nehru officially discarded the report by the committee and made Gregorian calendar as the only calendar to be used in government offices and works. The Gregorian calendar or the calendar we use right now is one of the most un-scientific and illogical calendars. Under which or whose influence Nehru discarded the most scientific calendar, Vikram Samvat and chose an illogical calendar for our nation? We would know this later in the blog but before it we should know about the shocking history of calendars. The historic influence of Vikram Samvat over the Globe Before 1752, Vikram Samvat was followed all over the world directly or indirectly because it is the most scientific calendars till today. According to it, our date changes with the sunrise i.e., nearly 5:30 in the morning. As Vikram Samvat was followed all over the world and Britain’s time is 5 hours 30 minutes before us, so, they used to change their dates with reference to us i.e., at 12 AM. It was according to Bharat’s sunrise time, the world had fixed its date change time. The act of colonization and deeds of Nehru led us to a change our time of date change from sunrise to 12 AM. Britain fixed their date change time with reference to our sunrise and we copied them by changing our dates at 12 AM. That is called true slave mentality. Surya Siddhantam, world’s oldest surviving book on Astronomy, establishes that Earth is spherical & gave the concept of Latitude as लɾरेखा & Longitude as देशाȶर for global positioning. Gregorian calendar’s history of silent theft Romans used Julian calendar or Roman Calendar which was cheap copy of Vikram Samvat and Gregorian calendar was a cheap copy of Julian calendar. Romans used to celebrate new year according to Vikram Samvat i.e., between March and April when nature’s beauty is at its peak, trees bring new leaves on themselves and a joyful season is present. Britishers had shifted their New Year to January 1. So, when they came to Bharat, they made fun of our ancestor’s by calling it Fool’s day. Our New Year is in Chaitra Shukla Paksha pratipada(first day) falls in March and April and therefore they called it April fool. Its pretty unfortunate that we carry that tradition of Britishers till today and we’ve become pseudo-Britishers with no cultural dignity. Its up to your self-esteem and love towards Bharat Mata that you wish to carry this tradition of our genius ancestor’s insult or not. Now, let us know the logic or reason behind the name of months : – January – Named after Roman god Janus. February – Named after the Roman goddess called Februa. March – Named after Roman god of war called Mars. April – Comes from a Roman word for “second” – aprilis – as it was the second month of the Roman year. May – Named after Roman god Mars’s mother named Maia. June – Named after Roman god Jeus’s wife named Juno. July – Julius Caesar was born and died in this month. So, this month was named after him to give respect. August – Named after Augusta Caesar. September – Seventh month October – Eighth month November – Ninth month December – Tenth month Now, one can clearly see that how Roman calendar was copied from Vikram Samvat and Gregorian calendar was copied from Roman calendar. They didn’t even change the name of months as the 12th month has Dec in it which means ten. Now it’s evident that who’s real fool. There is no logic in this calendar as July and August are named after great Roman warriors, so, these months have 31 days in it. Moreover, we can also see how Latin is a copy of Sanskrit language with words like sept, oct, no, dec, maia etc. We should not have used such an un-scientific and illogical calendar when we had Vikram Samvat based on works of a genius Astro-physicist named Aryabhatta. Vikram Samvat was started by Raja Vikramaditya ji but this samvat was only started to make the year count short, otherwise, we do have calendar which starts back right from the origin of first life on this planet. One who follows any Bhartiya samvat can simply look at the sky and tell which day and date it is. These calendars are based on advanced and accurate calculations of different planets and Earth. Instead of choosing this master piece, a calendar was chosen which is absolutely rubbish but we follow it till today. Why Nehru did this to us? The reason lies in Macaulay’s education system. On 2
New Year: The History of Bharat’s Decline Read More »
Is feminism needed today?
Let’s start with a basic question. What is the difference between a man and a woman? The answer depends on the place they are in. Let me explain. Both of them are humans, and somehow or other, they are equally capable. The only difference between a man and a woman is their reproductive organ. Now, what’s the use of reproductive organs? to procreate and bring new life to this planet. It means that the role of gender is very limited. In the case of human relationships, there’s only one that has something to do with gender, and that too for a short period of time. In all other relationships, including friendships, there’s no role for gender to play. In an office, workplace, or educational institution, gender has no role to play. But we see it playing a prominent role in our society. Some men claim that they’re superior and strong. On the other hand, women are fighting for women’s rights. I’m not saying that they’re doing something wrong. My only point is that the human mind understands things through dissection or differentiation. But in reality, the difference doesn’t exist, be it between white and black, men and women, or other so-called different castes, creeds, classes, etc. We’re all humans, and for the ones who have a higher level of understanding, we’re part of creation or life energy. The way to achieve equality is not by creating further differences but by including everyone. We give preference to different castes, genders, etc. and expect inequality to end. This is not how it works. It may be a good temporary solution. But if we want equality in the true sense, then these differences must end. It can only happen when people get the right guidance and education. I have seen students standing outside of schools and referring to girls as “maal,” which translates to “an object.” When these kids grow up with such a mindset, we see domestic violence, rapes, and other crimes against women. Hence, my humble request through this blog is that let’s together fight against the differences, uprooting the orthodox and suppressing societal frameworks, but with a caution that our efforts don’t further divide the society. Moreover, wisdom doesn’t come from knowledge and the accumulation of facts; it has to be gained through experience. We need to develop wisdom in the present and upcoming generations for a permanent solution to these problems. Read the blog below to get insights on it. Link – https://foxfoster.com/saraswati-puja-from-darkness-to-enlightenment-inner-enginnering/ Aditya Roushan Blogger
Is feminism needed today? Read More »
Saraswati Puja – From darkness to enlightenment | Inner Enginnering
Suppose one has financial literacy, digital literacy, or a PhD in some domain. We would call such a person knowledgeable. But if that person starts to think highly of himself because he accumulated something more than someone else, then he is super foolish. In reality, we are all foolish people who know nothing. Just go out in a garden and have a look at the big creatures, trees, leaves, ants, air touching your body, your breath, and so on. What do we know about them apart from their physical nature, which we have known through dissection or some other means? Do we know how life functions? Forget functioning; we don’t know what life is. Today is Saraswati Puja: she’s revered as the goddess of yoga, music, and art. The term “Vidya” comes from the word Veda. Veda is basically a repository of the knowledge gained through spiritual experiences by our sages. In short, Vidya means spirituality. It is a technology that, when used correctly, leads to the experience of Bramha, or “self.” When someone experiences himself or herself, then that person has the experience of the entire universe and beyond it, which are non-physical dimensions, as said in the Vedic and Yogic texts. So, in this full context, I pray that Maa Saraswati, the form of the creator, blossoms within you and encourages you to experience life to its fullest potential. I’m sharing a link for you to begin your spiritual journey or the journey of non-physical or beyond life and death. Inner Engineering Online: https://innerengineering.sadhguru.org/hi/online#online_enroll Note: I, as the writer or Foxfoster, will not be benefited in any way if you enroll in Inner Engineering. It is just the taste of immense joy I have received because of it that led me to share this link. Moreover, there is no personal bias toward the Isha Foundation; it is just because my spiritual journey began here. The initial programmes at Isha cost some money because not everyone is equally dedicated. It takes a lot of energy to initiate someone into a spiritual process. If someone is not serious about it, then because of him/her, the one who’s initiating may get harmed. The advanced programmes at Isha are always free because, until then, your dedication is tested. So, don’t let the initial fee stop you. The returns on physical, emotional, and other spiritual aspects will be immense, and you will thank this blog later. I can assure you of it because of my eight months of experience with inner engineering practices.Happy Saraswati Puja!Namaskaram Aditya Roushan Writer Also Read Important certifications in cybersecurity 2023 Role Of Cybersecurity In Crypto Currency. Best Upcoming Phone In October What Is Ethical Hacking | Ideas, Scope And Limitations Of Ethical Hacking How To Protect Yourself From Becoming Victim Of Cyber Threats How To Spot Fake News On WhatsApp?
Saraswati Puja – From darkness to enlightenment | Inner Enginnering Read More »
How to start a career in cyber security, roadmap and future opportunities
As the world becomes increasingly digitized, the importance of cyber security has grown exponentially. With data breaches and cyber-attacks becoming more common, it’s important for individuals and businesses to understand the basics of cyber security and how to protect themselves. In this article, we will discuss how Indian people can start learning about cyber security in 2023. Understand the basics: Before diving into the more advanced aspects of cyber security, it’s important to understand the basics. This includes understanding common security threats, such as malware, phishing, and social engineering, as well as basic security concepts, such as encryption and authentication. Learn about different security protocols and standards: Cyber security is a field that’s constantly evolving, with new protocols and standards being developed all the time. It’s important to stay up to date on the latest developments in the field, such as the latest encryption algorithms, authentication methods, and security frameworks. Get hands-on experience: The best way to learn about cyber security is to get hands-on experience. This can be done by participating in online security challenges and competitions, or by setting up your own virtual lab to practice different security techniques. Take a course: There are many online and offline courses that are available for people who want to learn about cyber security. These courses can provide a structured learning experience and help you gain a deeper understanding of the field. Join a community: Cyber security is a field where professionals share knowledge and collaborate to make the digital world more secure. Joining a community of like-minded individuals will help you stay up to date on the latest developments and provide you with an opportunity to network with other professionals in the field. Learn about Indian laws and regulations: India has its own set of laws and regulations related to cyber security, and it is important to be familiar with them. Seek certification: While certifications are not mandatory, they can help you demonstrate your knowledge and skills to potential employers. Certifications like Certified Information Systems Security Professional (CISSP), Certified Ethical Hacker (CEH) and many more are widely recognized in the industry. conclusion: Cyber security is a rapidly growing field with a high demand for professionals. By understanding the basics, staying up to date on the latest developments, getting hands-on experience, taking a course, joining a community, learning about Indian laws and regulations and seeking certifications, Indian people can start learning about cyber security in 2023. Remember that it is a long journey but with patience and persistence, you can become a cyber security expert. Also Read Important certifications in cybersecurity 2023 Role Of Cybersecurity In Crypto Currency. Best Upcoming Phone In October What Is Ethical Hacking | Ideas, Scope And Limitations Of Ethical Hacking How To Protect Yourself From Becoming Victim Of Cyber Threats How To Spot Fake News On WhatsApp? Roadmap A roadmap for cybersecurity in 2023 would involve a combination of the following steps: Continual education and training: As the field of cybersecurity is constantly evolving, it’s important to stay current with the latest developments, threats, technologies, and best practices. This can be achieved through ongoing education and training programs, such as attending conferences, workshops, and webinars, reading industry publications, and taking relevant certifications. Implementation of multi-factor authentication: With an increasing number of data breaches and cyber-attacks, it’s crucial to ensure the security of login credentials. Multi-factor authentication, which involves using multiple methods of verifying a user’s identity, such as a password and a fingerprint or a token, can provide an extra layer of security. Emphasis on cloud security: As more and more companies are moving their data and applications to the cloud, it’s essential to ensure the security of cloud-based systems. This includes implementing best practices for securing cloud infrastructure, such as encryption and access controls, and regular monitoring and testing of cloud environments. Adoption of Artificial Intelligence and Machine Learning: With the increasing complexity of cyber threats, AI and ML can help organizations to detect, analyze, and respond to cyber threats more effectively. AI-based threat detection and response systems can help organizations to identify potential threats in real-time and respond to them quickly. Focus on IoT security: As the number of IoT devices continues to grow, it’s important to ensure the security of these devices. This includes implementing security measures such as encryption, secure firmware updates, and regular monitoring and testing of IoT networks. Emphasis on incident response planning: Having a robust incident response plan in place is crucial for organizations to respond quickly and effectively to a cyber-attack. This includes regular testing and updating of incident response plans, as well as training employees on how to respond to a cyber-attack. Compliance with laws and regulations: Cybersecurity laws and regulations are constantly changing, so it’s important for organizations to stay up to date with the latest legal requirements, such as the General Data Protection Regulation (GDPR) and Cyber Security of Critical Infrastructure (CSCI) in India. In summary, this roadmap is designed to help organizations to stay ahead of the curve in the constantly evolving field of cybersecurity. By continually educating and training employees, implementing multi-factor authentication, focusing on cloud security, adopting AI and ML, focusing on IoT security, having a robust incident response plan, and complying with laws and regulations, organizations can better protect themselves against cyber threats in 2023. Future opportunities The field of cybersecurity is rapidly evolving, and there are a number of future opportunities in the field that are worth considering: Artificial intelligence and machine learning: With the increasing complexity of cyber threats, AI and ML can help organizations to detect, analyze, and respond to cyber threats more effectively. Opportunities in this area include the development of AI-based threat detection and response systems, and the use of ML algorithms to identify patterns in large sets of data. Cloud security: As more and more companies are moving their data and applications to the cloud, there is a growing need for experts in cloud security. Opportunities in this area include the development of security
How to start a career in cyber security, roadmap and future opportunities Read More »
Top 12 Flying Schools In India
Flying Schools In India Indira Gandhi Rashtriya Uran Akademi (IGRUA) Madhya Pradesh Flying Club (MPFC) National Flying Training Institute (NFTI) Ahmedabad Aviation & Aeronautics Ltd. (AAA) Bombay Flying Club Rajiv Gandhi Aviation Academy Government Flying Training School OFAA – Orient Flights Aviation Academy Indian Aviation Academy Adventure Flight Education Private Limited, Bangalore Asia Pacific Flight Training Academy Bihar Flying Institute National College of Aviation Indra Gandhi Rastriya Uran Akademi Established in 1985 Indra Gandhi Rastriya Uran Akademi is situated in Raebareli ,U.P Contains 24+ Aircrafts,4 multi engine Admission through IGURA: Entrance test conducted by them in every city of India and the difficulty level is medium to hard . More often Pilots of this Academy are chosen for Public sector airlines -Air India for their aircraft Approved Courses Following Professional Courses, duly approved by Director General of Civil Aviation, Govt. of India are offered to students to avail benefits / subsidy by banks: Ab-initio to Commercial Pilot Licence (CPL) coupled with Instrument and Multi Engine Endorsement alongwith an option for BSc (Aviation) degree. Simulator training as per candidates requirements. Multi Engine endorsement. Instrument Rating . License issue/ renewal tests and License endorsement checks. Ab-initio to Commercial Pilots License (CPL) course for foreign nationals as per Regulatory requirements in their respective countries Specifically designed training courses for Indian Navy and Indian Coast Guard Pilots. CRM Workshop Multi-Crew Co-operation (MCC) Course AELP Training and Testing course Fees Structure The Course Fee for Ab-initio to CPL Course with I/R and multi-engine endorsement is Rs. 45,00,000 and no GST is applicable on the same at present. Additional expenditure for about Rs. 2.00 Lac is payable towards cost of Uniform, Study Material, Navigation Computer, Headphones, Personal Accident Insurance Premium etc. DGCA/ RTR Examination and License fee will be payable by the trainee directly through Debit/Credit Cards or Internet Banking. In addition, for those enrolling in BSc Course, University & Examination fee will be extra as applicable. Separate Hostels for Boys and Girls are provided on twin sharing basis against subsidized charges of Rs. 1500 per month. Eligibility for the course is: Age limit – 17 years old Intermediate (10+2) graduate with English, Physics, and Math 55% aggregate marks in Physics and Math Note: SC/ST/OBC/EWS candidates will be provided with 5% relaxation in total aptitude. INR 42,00,000 -Tuition fee (need to be paid in four-quarterly in 1-year) NR 2,00,000 – Additional fee (Uniform, Headphones, Navigation tools, Study Material, and more) IGRUA is a premier flying training institute in India. They have a good reputation. Air India does conduct campus interviews at IGRUA. More IGRUA students find jobs with the airlines than any other school in India. This might be due to the fact that IGRUA filters the students at the time of selection, has a good ground school, nice fleet and experienced ground and flight instructors. However, at the end of the day, the applicants still need to pass the written exams, psychometric battery tests and interviews conducted by the airlines. So it is inevitable that some will take longer than others to find a job. Is it worthwhile studying at IGRUA? If you are serious about being a commercial Pilot, the best flying academy in India is IGRUA. IGRUA is a government body which offers courses such as ab-initio to Commercial Pilot License (CPL), simulator training as per candidate’s requirements, multi-engine endorsement, instrument rating, CRM workshop, The aircrafts used for training at this institute are TB-20, Zlin, DA-40 and DA-42. Our Late PM, Rajiv Gandhi laid the foundation stone for IGRUA in 1985. Before joining politics Rajiv Gandhi worked as a Pilot with Indian Airlines. Candidates are shortlisted for selection on the basis of a two hour written test followed by a pilot aptitude test. Once a candidate clears these two rounds they are eligible to appear before an interview panel which consists of representatives from NACIL, DGCA, a psychologist and IGRUA examiners. The Advertisement for Ab-initio to CPL course is scheduled for release in National News Papers/ website in April every year. The Ground training is imparted up to ATPL standard and flying training to meet CPL requirements as stipulated by DGCA. The Course Fee & other Charges The Course Fee for Ab-initio to CPL Course with I/R and multi-engine endorsement is Rs. 42,00,000 Additional expenditures for about Rs. 2.00 Lac is payable towards cost of Uniform, Study Material, Navigation Computer, Headphones, Personal Accident Insurance Premium etc. DGCA/ RTR Examination and License fee will be payable by the trainee directly through Debit/Credit Cards or Internet Banking. In addition, for students enrolling in BSc Aviation Course, University & Examination fee will be extra as applicable. Also Read what is ils and how does an ils work? all about flight crew in india. from zero to a commercial pilot in india. how to become a commercial pilot in india? | what is conventional pilot programme? how to apply for a pilot computer number(pcn) at dgca india. Madhya Pradesh Flying Club (MPFC) About Mpfc It was on October 9, 1951, when the club came into existence. The Club has set numerous records among all the Flying Clubs ever since the beginning of its operations in August 1955. For over 24 years, from 1958 to 1982, the club successfully maintained and operated aircraft belonging to the MP State Government. In the face of aggression in 1962, the club trained Indian Air Force Pilots for their initial flying. Once again during the 1971 aggression, the club offered services of its aircraft and maintenance staff to the Indian Air Force. The Club started its satellite base at Bhopal in 1958 to train candidates and also provide services to the MP State Government. National Flying Training Institute (NFTI) It was established in 2007, CAE Gondia, and It is also known as National Flying Training Institute (NFTI) is a joint venture between CAE and the Airport Authority of India (AAI). CAE Gondia’s pilot training programs provide high quality and focused ab initio training to aspiring airline pilots. Our programs combine premier ground
Top 12 Flying Schools In India Read More »
Why Is NASA trying to crash Earth on Mars?
SHIELD is an idea for a Mars landing that would allow low-cost missions to reach the planet’s surface safely by employing a collapsible foundation to absorb impact. California Academy of Sciences, inc. The SHIELD Experimental Landing Vehicle is designed to absorb high-energy shocks, such as those experienced in the vehicle’s crash zone. Mars was visited nine times, each time using cutting-edge parachutes, massive airbags, and jetpacks to safely land on the surface. Engineers are now investigating whether crashing is the quickest way to reach the Martian surface. An experimental lander design known as SHIELD (Simplified High Impact Energy Landing Device) would use an accordion-like, collapsible base that functions like a car’s crumple zone and absorbs the energy of a severe impact, as opposed to slowing a spacecraft’s high-speed descent before touching down. The new design might significantly lower the cost of landing on Mars by streamlining the terrifying entry, descent, and landing procedure. Additionally, it might increase the range of potential landing pages. With the help of a collapsible, shock-absorbing foundation that could safely fall into the Earth, the SHIELD Mars landing concept might enable low-cost missions to travel to the Martian surface. NASA should be credited. JPL-Caltech According to SHIELD’s project manager Lou Giersch of NASA’s Jet Propulsion Laboratory in Southern California, “We think we could go to more hazardous locations, where we wouldn’t want to risk trying to deploy a billion-dollar rover with our existing landing systems.” “Perhaps we could even land many of these to create a network at other hard-to-reach sites.” >> Get Best Information And Knowledge At: https://foxfoster.com/information/ Vehicle Crashes and Mars Landings Work completed for NASA’s Mars Sample Return campaign had a significant influence on much of SHIELD’s design. The Perseverance rover is collecting rock samples in sealed metal tubes as the initial phase in that campaign. In the future, a spacecraft will safely crash land in a barren area while transporting those Martian samples back to Earth in a small capsule. Engineers began to question if the fundamental concept was reversible after researching methods for that procedure, according to Velibor Cormarkovic of the SHIELD team at JPL. “Why can’t you land something heavy on Mars, he asked, “if you want to land something heavy on Earth?” If we can successfully land on Mars, we will know SHIELD is able to function on planets or moons with thicker atmospheres.” On August 12, this SHIELD prototype base was tested in a drop tower at JPL to simulate the impact it would experience landing on Mars. SHIELD is a collapsible Mars lander that would allow a spacecraft to intentionally crash land on the Red Planet, absorbing the impact. NASA, JPL, and Caltech Engineers had to demonstrate that SHIELD can shield delicate electronics during landing in order to determine whether the theory would actually operate in practise. The scientists tested the durability of Perseverance’s sample tubes in a hard Earth landing using a drop tower at JPL that stands over 90 feet (27 metres) tall. It has a massive sling, known as a bow launch mechanism, that can launch an item onto the surface at speeds comparable to those experienced during a landing on Mars. Cormarkovic previously tested vehicles that had crash dummies for the automotive sector. Some of those tests involve crashing the cars into a wall or other deformable obstacle while they are being pulled along on sleds at high speeds. There are several methods for accelerating the sleds, including using a sling similar to the bow launch system. “The SHIELD tests we’ve done are kind of like a vertical version of the sled tests,” Cormarkovic explained. “However, rather of hitting a wall, the abrupt stop is caused by a smash onto the ground.” Fantastic Success On August 12, the crew convened at the drop tower with a full-size prototype of SHIELD’s foldable attenuator, an impact-absorbing inverted pyramid made of metal rings. To simulate the electronics carried by a spacecraft, they hung the attenuator from a grapple and inserted a smartphone, a radio, and an accelerometer. They were perspiring as they saw SHIELD gradually ascend to the tower’s peak. >> Best Tech News: https://foxfostertechnology.com/tech-news/ A bow launch system on this drop tower at JPL can propel test objects 110 mph into the ground, simulating the forces they would encounter during a Mars landing. NASA/JPL-Caltech credit Another SHIELD project participant at JPL, Nathan Barba, commented, “Hearing the countdown gave me goosebumps.” The entire team was eager to find out whether the prototype’s items would withstand the impact. The bow launcher blasted SHIELD into the ground at about 110 mph after only two seconds of waiting (177 kilometres per hour). After being slowed down by atmospheric drag from its initial speed of 14,500 miles per hour (23,335 kilometres per hour) as it enters the Mars atmosphere, that is the speed a Mars lander gets close to the surface. The “landing zone” for prior SHIELD experiments was made of soil, but for this test, the crew simulated a landing on Mars by placing a steel plate on the ground that was 2 inches (5 centimetres) thick. SHIELD was hit with a force of about 1 million newtons, which is equivalent to 112 tonnes smashing against it, according to the onboard accelerometer. SHIELD impacted at a slight angle, then bounced about 3.5 feet (1 metre) into the air before flipping over, according to high-speed camera footage of the test. Since there was no bounce in the earlier testing, the team thinks the steel plate is to blame for the bounce. When the team opened the prototype to retrieve the simulated electronic payload, they discovered that the onboard devices, including the smartphone, had survived. “The only hardware that was damaged were some plastic components that we didn’t mind,” Giersch explained. “This test was a success overall!” The next step will be to design the rest of a lander in 2023 and see how far their concept can go. Thanks For Reading
Why Is NASA trying to crash Earth on Mars? Read More »
What are Uncontrolled Aerodrome? Everything you Need To Know
uncontrolled Aerodrome Definition: It’s a location from that craft flight operations surface while not an impression tower or additional exactly wherever the tower is non-operational. It is generally conjointly known as a non-towered aerodrome or traffic management. In United States quite 19000 non-towered airports vs five hundred airports with management towers Functions: Non-towered airports generally lie beneath controlled airspace. In this case, some or all craft arrival and departure need zero clearances from a RATC [Remote traffic Control], principally these are terminal or center management or perhaps although there’s no tower managing landings and takeoffs. Pilots acquire zero clearances by radio signals given by RATC, by phone, or through an organization dispatcher or native flight service station; in some cases, outward craft (IFR or VFR) (Visual Flight Rules) start up and level out below the ground of controlled airspace, then radio for a clearance before climb any. Most nations already establish low-altitude VFR corridors for non-towered airports in massive urban areas in order that VFR arrivals and departures will avoid controlled airspace traffic. Processes on Uncontrolled Aerodromes and Safety Rules and procedures for the providing of AFIS (Automated fingerprint identification) and for providing info on a restricted scale are set out by “L” licensed person is to supply info to the encircling traffic concerning activities at the airdrome and in its locality. Other aircrafts reports position and planned activities to the station before getting into ATZ or before beginning any operations at communication between the station and therefore the different traffic. thanks to the truth that AFISO cannot, with few exceptions, provide orders, its role is just to tell. therefore, to the safety of air traffic around the airdrome contributes principally serving correct and current info VFR Circuit for Uncontrolled Aerodromes Communications needs Information is often changed with a flight station (FSS), community airdrome station (CARS), universal communications (UNICOM), or vehicle operators by directed transmissions, or with different craft by broadcast transmissions. Transiting craft Overflying Aerodromes Transiting craft shall not operate at a height of 6000 foot higher than associate degree airdrome. Standard Left-Hand Pattern Before arriving at an associate degree uncontrolled aerodrome, arrange your approach to the circuit. If it’s necessary to cross over the airdrome before connecting the circuit, or when departure, it’s suggested that the crossover be created a minimum of five hundred foot higher than the circuit altitude. Must Read: WHAT IS ILS AND HOW DOES AN ILS WORK? ALL ABOUT FLIGHT CREW IN INDIA. FROM ZERO TO A COMMERCIAL PILOT IN INDIA. HOW TO BECOME A COMMERCIAL PILOT IN INDIA? | WHAT IS CONVENTIONAL PILOT PROGRAMME? HOW TO APPLY FOR A PILOT COMPUTER NUMBER(PCN) AT DGCA INDIA. What is AFIS/FSS? The airdrome Flight info Service (AFIS) or the Flight station (FSS) are basically Flight service info provided to the associate degree airdrome. it’s a better level of service than A/G radio; but it remains essentially a supply of knowledge instead of management. In the UK, AFIS do issue obligatory directions to craft and vehicles on the bottom should have to be compelled to carry, up till craft pass a runway holding purpose. In Canada, FSS can settle for flight plans and may relay IFR clearances to craft on the bottom or on the wing. In each environment, it’s forever a pilot’s responsibility to be glad that each action is safe, secure and to announce their position and intentions while operating the airdrome. What are the norms and Protocols? This method is completely different for various estates, provinces and countries. Below things give coverage protocols for many things. General: To maintain a continuous receiver, watch on the “appropriate frequency” ( G/A, or UNICOM ) specific to be used within the airdrome vary Report the pilot-in-command intentions before getting into the maneuvering domain Rules for VFR (Virtual Flights Rules) The following procedures apply once flights are conducted underneath Visual Flight Rules Departure Before moving onto the take-off surface, report the pilot-in-command departure intentions on the acceptable frequency. Before takeoff, ascertain by each radio and by visual observation that there’s no chance of collision with another craft or a vehicle throughout takeoff After takeoff, there should be a report outward from the airdrome traffic circuit, and maintain a continuous receiver watch on the acceptable frequency till afar from the realm Arrival Before getting into the airdrome space (and, wherever circumstances allow, a minimum of 5 minutes before getting into the area), report the aircraft’s position, altitude and calculable time of landing and therefore the pilot-in-command arrival procedure intentions on the acceptable frequency Report once connection the airdrome traffic circuit, giving the aircraft’s position within the circuit Report once on downwind leg, if applicable Report once on final approach Report once afar from the surface on that the craft has landed Best Tech And Mobile Review Website: Foxfostertechnology Thanks For Reading Abhishek verma Blogger And Content Writer
What are Uncontrolled Aerodrome? Everything you Need To Know Read More »
What Is No-Fly Zone(NFZ): Facts concerning No Flying Zone
In this article we’ll look these points: 1)What is flying zone 2)Origin of No-Fly Zone 3) Violation of No-Fly Zone Zelenskyy: We repeat every day: close the sky over Ukraine,Close for all Russian missiles, Russian combat craft, for of those terrorists. Make a humanitarian air zone What is a no-fly zone? A no-fly zone is a district, a part, or a section which is locality established by military powers over that certain craft do not appear to be allowed to fly. During conflicts or wars or the opposite such events like emergencies, no-fly zones are obligatory to forestall enemies from offending the country or any specific place being protected at intervals in the zone. A no-fly zone is simply preventing all kinds of consignment and commercial planes to figure in this area In an area where there is not any flying zone, the military of the country or alliance is going to have power to shoot down all the invaded flights or Drones. A no-fly zone is going to be used to defend sensitive areas like royal residences, the place of emergencies or brought in concisely over sporting events and large gatherings. No-Fly Zones had been implemented quite double in history-: a) In fixed components of state b) at intervals the Gulf 1991 War & c) In Socialist People’s Libyan Arab Jamahiriya in 2011 These were the items where the worldwide organization & U.S. used their Superior aggregation to stymie authorization rulers of less powerful countries. But in Ukraine, the U.S and international organization their cases were fully totally different. Origin of No-Fly Zone In 1991 it had been Saddam Hussein United Nations agency sent chopper gunships equipped with napalm & various Weapons to want revenge from the rebels. quite Lakhs of Kurdish Civilians were dry ally slaughter, and were lost at intervals the barren island with none food and vegetation. George H.W. Bush [U.S. President ] and his allies fell into torturing situation.They want to induce eliminate Husayn kind power In late New Style calendar month,1991 The U.N passed another resolution recriminating Hussein. In 1992, there was another no-fly zone that was obligatory at intervals the thirty third parallel south, to protect the Mohammedan Muslims community. Those infractions were badly punished once saddams violated NFZ. The Iraqi craft were shooted down and destroyed their military assets Violation of No Fly Zone The global organization allies obligatory a “no-fly zone” over Ukrainian skies, with the meaning of countering Russians, easing humanitarian suffering, and protective Ukrainian civilians attempting to escape the fighting. the state has obligatory a no-fly zone perpetually. In the US, recent polling shows this can be a well-liked idea: threequarters of American citizens support a NATO-impose no-fly zone. however a no-fly zone doesn’t equate to a no-combat zone. Quite the alternative. Implementing a no-fly zone needs the utilization of military unit, and in state, that might doubtless mean effort the Russian military and allies. If the U.S. and its global organization allies aren’t attempting to attack Russian assets, Aswell as assets at intervals Russia, their craft patrolling the no-fly zone would be heavily exposed to Russian air and ground attacks. Again, this presents a big and unacceptable risk to yank and allied pilots and runs the danger of large conflict increase. 👉 Everything About Aviation What does the U.S. say concerning No-Fly Zones? This attractiveness the no-fly zone course of action might stem from the so victorious implementation of no-fly zones in several of the military operations in Southern Republic of Iraq (Operation Southern Watch), Northern Republic of Iraq (Operation offer Comfort/Northern Watch), European nation (Operation Deny Flight). What are we able to Observe in recent No Fly zones? First, in every no-fly zone, the U.S. and allied fighters had air superiority or were ready to bring home the bacon air superiority in little time. in contrast to in state, wherever global organization is left with a terrible selection at the commencement. To ascertain an efficient no-fly zone, it should either bring home the bacon air superiority direct by offensive Russian air defenses or place allied craft into a region to enforce a no-fly zone while not air superiority. This would expose global organization craft to deadly Russian fire. The Russians, as an example, have a S-400 mobile weapons system with a variety of four hundred kilometers that might operate in state or at intervals Russian territory to strike NATO and Ukrainian craft. Second, despite dominating the skies over the Republic of Iraq, Libya, and Bosnia, U.S. and allied planes were still laid-off upon and engaged with hostile forces throughout their social control missions. as an example, AN yank and a French fighter was shot down in Deny Flight, and the Republic of Iraq repeatedly laid-off at craft patrolling the no-fly zones through 2003. we should always expect an equivalent to occur over Ukrainian skies, however rather more intensely and likely with a lot of deadlier effects. After all, Russian air-to-surface capabilities and its Air Force so much outdo Iraqi, Libyan, and Serbian capabilities. Third, these previous no-fly zones showcased the issue of operative in an exceedingly dynamic airspace wherever “friendly fire” incidents will occur. this can be notably the case if there’s a malfunction in an exceedingly electrical device or other instrumentality that helps determine friend or foe. Tragically, in 1994, the U.S. Air Force shot down 2 U.S. Army Blackhawks within the northern Iraqi no-fly zone. From AN operational perspective, Russian air ability outpaces Ukraine’s. Would the new intro for craft for a no-fly zone build make it tougher for Ukrainian fighters on the bottom to spot friendly or enemy aircraft? Thanks For Reading Best Mobile Review Site: foxfostert technology
What Is No-Fly Zone(NFZ): Facts concerning No Flying Zone Read More »