SQL_Projects

In this repository, I have attached different files like excel file for dataset, sql file for applying queries and pwerpoint file for presenattion of my work. In Diabetes Prediction Analysis, => Used Rank function for assigning rank to each record as per their order => Creating views => Retrieving Columns using select statement => Applying conditions using where clause => Using aggregate function for calculating values for a column => Use logical operators while applying conditions => Use Group by clause for grouping elements in a column => Use subqueries for using output of inner query as a result for outer query => Use Date and Time functions => Use update, insert and delete statement for updating, inserting and deleting records in a table => Apply Except operator for the exception => Use Alter statement for adding, modifying columns