Tag SQL query fundamentals
For primary key and Unique key in a table, index is created automatically. Using indexes appropriately can significantly improve query efficiency for large tables and sorting/grouping operations. Create indexes to increase the performance of query. Like tableau’s context filter that… Continue Reading →
Creating triggers: Before insert trigger: To Create before insert trigger to make sure any new value of Working hours, if it is negative, then it should be inserted as positive. — Create the table create table emp_bit(name varchar(55),occupation varchar (100),working_date… Continue Reading →
Step-1: In this stored procedure, we declare a cursor variable cur that retrieves the names and marks columns from the marks table. Step-2: We also declare variables input_name, input_marks, to store the values fetched from the cursor Step-3: Inside the… Continue Reading →
Check the table in cmd: If-elseif-else: Loops: Simple_loop static: Simple loop dynamic: Stored procedure without parameter: Stored procedure with parameter: Local and Session variables: Local parameter: Simple procedure practice:
Exception handling: Exception handlers: Continue handler: Exit handler: Single error handler: Multiple errors multiple handlers SQL exception: Control flow Explanation of the code Shipped Status Cancelled Status On Hold Status Application to identify the fraud: Create procedure for payments table:… Continue Reading →
Altering and Managing Views: View for frequently selecting columns: With check option to view only virtual table: View not updatable: Real-world Examples of Views in MySQL Creating Simple Views Create a view called emp_sal on the myemp table by selecting… Continue Reading →
Truncate vs delete: 2 types of Insert into students table: Create a students table with following fields and constraints. 4 types of constraints while creating table: Update multiple records: Update exercise: Mode of working Update cmd: Querying schema: Inner Join:… Continue Reading →
A Step-by-Step Guide to Learning Structured Query Language Setting Up Your MySQL Environment Day:1 – create a database called ‘assignments’ Create the tables and Enter the records Understanding Database Concepts: Date: Executing SQL Statements: Step:1 Create a table called countries… Continue Reading →