SQL for absolute beginner || Part 2

#dataanalytics #datascience #sql

What You'll Learn in this video
-- Concat = Concatination
-- order by = it orders the condition into asc or desc
-- char_len = it returns the character length
-- distinct = unique values from the table
-- lower() = return the lower case
-- upper() = it returns the upper case
-- instr() = it finds the index of the character
-- replace = it replaces the desired values
-- substring = it gives the desired answer from 1 rd position name- rahul - rah;

Watch the power Bi dashboard creation here
https://youtu.be/IUofSk2_RNA

my LinkedIn account
https://www.linkedin.com/in/rahulinchal/

my GitHub link
https://github.com/rahulinchal

0:00 Introduction
01:30 Revision
02:30 17). Populate the Student_data table. Display the number of students.
15:35 18). Display the number of degrees/courses in the degree_details table.
17:17 19). Display the number of students who have enrolled in a course/degree.
18:17 20). Display all the data in the Student_Data table.
18:42 21). Display all the data in the Degree_Details table in descending order of Min_Marks.
21:07 22). Display the Student ID, First 3 characters of FIRST NAME.
25:22 23). Display the details of the student whose ID is 15. In the result replace 'v' with 'V'in First name.
30:42 24). Display the First name as FN in upper case, of students whose last name is 'Sharma'. Also, display the position of the letter 'a' in the first name.
35:04 25). Display the last name of students in lowercase whose first name is 'Aishwarya'. Also, display the length of the last name.
36:55 26). Display the details of the students who are from 'Ahmedabad city in ascending order of first name and descending order of id. Display the Last name in reverse.
38:54 27). Write a query to display the first names of students in Upper case.
39:35 28). Write a query to display the full names of students as COMPLETE NAME in Lower case.
41:03 29). Write a query to display the unique cities to which the students belong in ascending order of the city.
43:15 30). Write a query to display the degrees offered. Order them in descending order of Min_Marks.
46:06 31). Write a query to display the details of students who are more than 23 years of age and whose first name has exactly 5 characters.
49:13 32). Write a query to display the FIRST names of students who are 22 years old or younger.
49:57 33). Write a query to display the First names of students who are not from Chennai.
51:12 34). Write a query to display the details of students who are 22 years old or from Mumbai.
52:39 35). Write a query to display the name and age of students who are from Bangalore and of age 27.