SQL for absolute beginner || Part 1

#dataanalytics #datascience #sql

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
02:22 1). How to Create a database?
05:44 2). How to see all the databases created?
07:17 3). How to drop/delete a database?
09:42 4). How to use a created database or see which database is being used?
11:15 5). Create a table named STUDENT which has the following attributes:
ID, FIRST NAME, LAST NAME, CITY(CHAR), AGE, Date of joining, RESULT which can be
Pass, fail, or awaited(default).
See if the table is created and also check the description of the table.
18:58 6). Create a table named DEGREE which has the following attributes:
Degree ID, Course name, Length of the course ( Check if it's GREATER THAN OR EQUAL TO
3) and Fees.
See if the table is created and also check the description of the table.
22:11 7). Rename the attribute Date of joining IN Student table to Admission date.
26:57 8). Change the datatype of CITY in the STUDENT table from CHAR TO VARCHAR.
28:05 9). In the DEGREE table change the name of the Course name to the Degree name.
29:09 10). Change the name of the Degree table to Degree_Details and the Student table to Student_Data.
30:41 11). Add a column named Max_Marks to Degree_Details.
31:55 12). Delete the column named Max_Marks from Degree_Details and add a column named
Min_Marks.
34:04 13). Create a table named Enrollment which has the following attributes:
Student ID, Marks, and Degree ID.
See if the table is created and also check the description of the table.
35:51 14). Delete the column named DID from the Enrollment table AND create a new column named
Deg_ID that references Degree_details(Degree_ID).
37:11 15). Create a table named Parents which has the following attributes:
Father Name, Mother name
37:22 16). Delete the table named Parents.