Study and implement Built-in function of mySQL using Airline reservation data base : Part 1

Business Scenario

Welcome back,Developers!

In the previous lab, we used Stored Procedures to automate repetitive database operations in the SkyReserve Flight Booking System.

Now, imagine the airline management team wants to generate meaningful insights from the stored data.

For example:

How to display passenger names in uppercase?

What is the length of each passenger's name?

What is the average ticket price?

Which flight has the highest and lowest fare?

Writing complex SQL logic for each of these tasks would be time-consuming. Fortunately, MySQL provides Built-in Functions that perform these operations quickly and efficiently.

Pre-Lab Preparation

Git Pull

git pull origin branchName

Task 1: Use of String Functions

Select the existing database.

1

1

Topic :

1) Basic SQL Queries

2) Understanding of Built-in functions

Display passenger names in uppercase.

2

1

Display length of passenger lower case

3

1

Display length of passenger names.

4

1

Task 2: Use of Numeric Functions

Display ticket prices with rounded values.

1

1

Find maximum and minimum ticket prices.

2

1

Display average ticket price.

3

1

 

Great job!
You have successfully implemented String and Numeric Functions in MySQL to format text and perform calculations on airline reservation data.

Checkpoint

git push origin branchName

Git Pull

Next-Lab Preparation

Topic :

1) Basic SQL Queries

2) Understanding of Built-in Functions