Anshula's journey

WHY USE SQL (STRUCTURED QUERY LANGUAGE)? While Excel can only handle data containing up to one million row, businesses today generate data in the billions and trillions.To manage such vast amounts of data, databases and indespensable. NOW, HOW TO CREATE TABLES IN SQL? In SQL, we utilize the CREATE command to create tables.. SYNTAX :  CREATE TABLE   "TABLE NAME"( "COLUMN 1"   "data type for column 1" "COLUMN 2"  " data type for column 2" , "COLUMN N"   'data type for column n", [table constraint]); CONSTRAINTS: 1. NOT NULL : Column cannot have null values  2. DEFAULT : Provides a default value. 3. UNIQUE : All values in column are different. 4. CHECK : Makes sure that all values. 5. PRIMARY KEY : It is use to uniquely identify a row in the table. 6.FOREIGN KEY : It is use to ensure referential integreting of data. INSERT COMMAND The INSERT INTO statement is used to add new records into a database table. SYNTAX: --- Sin...

 First, we will know what is macro? So it's a program that automates repetitive tasks by recording and replaying a series of steps.  Benefits of using macro ~Saves time ~ Easy to use How to enable Marcos in excel.. Step 1 : Go to home Step 2 : Customize the ribbon Step 3 : Go to main tabs, Select developer. How to record macro  Step 1 : Go to developer ,then click on record macro Step 2 : Type macro's name then select ok (there should not be spaces ). Recording will start.. Stop the recording when the work is done.. When u click on visual and then go to module you will see the actual code which is running behind macro...  You can edit that code as well.  USE OF RELATIVE REFERENCE - The macro will insert a row relative to the cell selected.  Click the  use relative reference  button on the developer tab to toggle relative reference on and off. For saving workbook containing macros, save it as  EXCEL MACRO ENABLED WORKBOOK.  💻