Snowflake Training Session-1| Batch-10 | What is Database & Warehouse | Snowflake |Tables| Schema

Hi Welcome to ViTech Talks , Here we are going to talk about
https://github.com/vitechtalks
What is Database
What is SQL
What is Data warehouse
Diff databases (RDBMS)
Schema /Table
Create Table /Load data into tables


What is Database : Data base is a collection of data (Strcuterd/semi/unstructured)
We can store data
Realtime data
BANK : if u want check /deposit an amount its a very quick
limited records and realtime data
Mysql/oracle (6-1 yr)

What is SQL: Structured Query language in order to communicate with any database we are going to use SQL
It is similar to english language

What is Data warehouse : Here we are going to store historical data and using for data analyticla solutions

Bank: 5 yrs of bank statement 5 mins
Large amount of data
Snowflake /redshift


Diff databases (RDBMS)
Mysql
oracle
MS sql
postgrage
Db2
sybase ...etc


app.snowflake.com

--------
Create database bank ;

--hdfc employees
create table employee (eid int , ename string) ;

insert into employee(eid,ename) values (1,'arun');
insert into employee(eid,ename) values (2,'Harish');
insert into employee(eid,ename) values (3,'Shilpa');

select * from employee;
--sbi employees
create table employee (eid int , ename string) ;
--Schema -- Logical representation of the database

create table bank.hdfc.employee (eid int , ename string) ;
create schema sbi;

create schema hdfc ;

#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

Видео Snowflake Training Session-1| Batch-10 | What is Database & Warehouse | Snowflake |Tables| Schema канала ViTechTalks