Snowflake + AI Session-1 | What is Database & Warehouse| @vitechtalks |Tables| Schema | SQL

Hi Welcome to ViTech Talks , Here we are going to talk about What is SQL What is Data Base /Schema /Warehouse How to create tables Load the data into tables Snowflake Training Class-1 ---------------------- demo - https://youtu.be/Lyt6wxkCR1w?si=6SXJQBis1HGRX7uV Snowflake : 1. It is a cloud based data warehouse platform 2. Using it for data storage , data processing and analytical solutions 3. It is built on top of AWS, Azure/GCP 4. It support structured , semistructured and unstructured data 5. It is a saas model (Software as a service) app.snowflake.com SQL / Database / diff SQL commands Database -- It is a collection of data (structured , semistructured and unstructured data ) mysql sybase db2 ms-sql oracle postgrage mangodb snowflake databricks CRUD C - Create (databases/schema/tables..etc) R - Read U - Update D - Delete SQL -- In order to interact/communicate with any database we are going to use sql Structured Query languange It is similar english Data warehouse: Bank --Hdfc --OLTP -- deposit 5000 -- immediate response -- realtime data we are going to store OLAP -- bank stmts - last 5 yrs -- 5-6 mins to retrive your data and generate a bank stmt -- see my company growth last 5 yrs AI -- LLM -- Create a database name as bank -- Create schema name a hdfc , axis , icic --Schema is nothing but logical representation of database --Table consist of rows and columns select * from bank.hdfc.customer ; https://docs.snowflake.com/en/sql-reference/sql/use-database --dELETE , TRUNCATE , DROP DELETE : IF USER WANT TO DELETE SPECIFIC RECORDS OR ENTIRE TABLE RECORDS WHERE CLAUSE IS APPLICABLE TRUNCATE : WE CAN'T DELETE SPECIFIC RECORDS , ENTIRE TABLE DATA IS GOING TO DELETE DROP : iN ORDER TO DELETE TABLE DATA AS WELL AS TABLE STRUCTURE WE ARE USING DROP (PERMANENT DELETE ANY DAATABASE OBJECTS (TABLES , SCHEMA , DATABASE ..ETC) UNDROP : TO RECOVER YOUR DATABASE / TABLES task : cREATE DATBASE NAME AS HR; CREATE ALL 7 TABLES USING LINK https://github.com/VITechTalks/Sql-Practice/blob/main/HR%20Database%20ER%20Diagram.png EMPLOYEE - 40 DEPARTMENTS- 30 REGIONS - 20 Class -Notes: ------------- DROP DATABASE BANK ; -- Create a database name as bank -- Create schema name a hdfc , axis , icic CREATE DATABASE BANK ; CREATE DATABASE BANK_DEV ; CREATE SCHEMA BANK_DEV.HDFC ; CREATE SCHEMA BANK_DEV.AXIS ; CREATE SCHEMA BANK_DEV.MORGAN ; CREATE OR REPLACE TABLE BANK_DEV.HDFC.EMP ( EMPLOYEE_ID INT, FIRST_NAME STRING, LAST_NAME STRING ) ; SELECT * FROM BANK_DEV.HDFC.EMP ; DESC TABLE BANK_DEV.HDFC.EMP ; INSERT INTO BANK_DEV.HDFC.EMP (EMPLOYEE_ID, FIRST_NAME, LAST_NAME) VALUES (1, 'John', 'Smith'), (2, 'Jane', 'Doe'), (3, 'Michael', 'Johnson'), (4, 'Emily', 'Williams'), (5, 'David', 'Brown'); ----I NEED ADD ONE MORE COLUMN TO EMP TABLE AS ADDRESS CREATE OR REPLACE TABLE BANK_DEV.HDFC.EMP ( EMPLOYEE_ID INT, FIRST_NAME STRING, LAST_NAME STRING , ADDRESS STRING ) ; ALTER TABLE BANK_DEV.HDFC.EMP ADD ADDRESS STRING ; ALTER TABLE BANK_DEV.HDFC.EMP ADD PHONE STRING ; ALTER TABLE BANK_DEV.HDFC.EMP DROP COLUMN PHONE; SELECT * FROM BANK_DEV.HDFC.EMP ; UPDATE BANK_DEV.HDFC.EMP SET ADDRESS = 'blr' ; UPDATE BANK_DEV.HDFC.EMP SET ADDRESS = 'HYD' WHERE EMPLOYEE_ID = 1 ; UPDATE BANK_DEV.HDFC.EMP SET ADDRESS = 'chn' WHERE EMPLOYEE_ID IN (4,5) ; ----DROP /DELETE / TRUNCATE --dELETE -- IF USER WANT TO DELETE SPECIFIC RECORDS OR ENTIRE TABLE RECORDS SELECT * FROM BANK_DEV.HDFC.EMP ; DELETE FROM BANK_DEV.HDFC.EMP ; DELETE FROM BANK_DEV.HDFC.EMP WHERE EMPLOYEE_ID IN ( 1,3) ; TRUNCATE TABLE BANK_DEV.HDFC.EMP ; DROP TABLE BANK_DEV.HDFC.EMP ; -- 1M UNDROP TABLE BANK_DEV.HDFC.EMP; #cortexai #ai #SQL #vivisiontechnologies #snowflake #snowflaketraining #sqlzerotohero #database #snowflakeintegration #sqlroadmap #vivisiontech #sqltutorial #sqlforbeginners #snowflakes #SQL #vivisiontechnologies #snowflake #snowflaketraining #sqlzerotohero #database #sqltutorial #snowflakeonlinetraining #ADF #DBT #AZuredatafactory #Snowflake #WhatIsSnowflake #WhatIsSnowflakeDatawareHouse #SnowflakeTutorial #WhatIsSnowflakeDatabase #SnowflakeArchitecture