What You Will Learn!
- SQL required to work on any On-premise or Cloud Database like Snowflake, Oracle, Teradata, My SQL
- SQL required to work on Visualization or Reporting tools like Power BI, Tableau
- SQL required to work on ETL or Integration tools like Informatica, Talend, Azure Data Factory
- SQL required to work as a Data Analyst
- CLEARING SQL DEVLOPER INTERVIEWS
Description
SQL => DATABASE CONCEPTS
DATABASE
DBMS
DATA MODELS
RDBMS
SQL
WHAT IS DATABASE ?
=> THE PLACE WE CAN STORE THE RELATED DATA AND LATER RETRIVE THE DATA IS KNOWN AS DATABASE
DBMS => DATABASE MANAGEMENT SYSTEMS
=> SOFTWATE THAT STORES DATA IN DATABASES IN AN ORGANIZED WAY TO MAKE IT EASIER TO CREATE, RETRIVE, UPDATE ETC.
DATA MODELS =>
Hierachical Model
Network Model
Entity-Relationship Data Model
Relational Data Model
RDBMS =>
DBMS using Relational Data Models are known as RDBMS
Here is the list of the top 10 most popular RDBMSs are:
SQL =>
Programming lanugage for Relational DATABASE
Stands for Structured Query Language
SQL(Structured Query Language) is a database computer language designed for managing
data in relational database management systems (RDBMS).
SQL (SEQUEL), is a standardized computer
language that was originally developed by in 1970 for querying,
altering and defining relational databases, using declarative statements.
1.SQL COMMANDS AND STATEMENTS
2.FILTERING AND SORTING
3.STRING FUNCTIONS
4.NUMBER FUNCTIONS
DATE FUNCTIONS
6.CTAS
7.SET OPEERATORS
8.NULLS
9.AGGRATE FUNCTIONS
10.ANALTICAL FUNCTIONS
11.CONSTARINAS
12.JOINS
13.SUBQURIES
14.PIVOT AND UNPIVOT
15.INDEXS
16.VIEWS
17.PERFORMANCE TUNING.
STATEMENTS:
Types of SQL Commands
Data Definition Language (DDL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Data Query(Retrieval) Language (DQL)
Data Control Language (DCL)
DDL - CREATE
ALTER
DROP
TRUNCATE
DML - INSERT
UPDATE
DELETE
MERGE
TCL - COMMIT
ROLLBACK
DQL(DRL) - SELECT
DCL - GRANT
REVOKE
Data Definition Language (DDL)
=> DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.
=> All the command of DDL are auto-committed that means it permanently save all the changes in the database.
Who Should Attend!
- THIS COURSE USE FOR SNOWFLAKE DEVELOPERS AND PYTHON DEVELOPER AND DATASCIENCE AND DATA ANALYTICS