What you'll 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

Requirements

NO NEED ANY SKILLS BEFORE YOU START THIS YOU CAN WATCH HERE LEARN IT

Description

SQL => DATABASE CONCEPTSDATABASEDBMSDATA MODELSRDBMSSQLWHAT IS DATABASE ?=> THE PLACE WE CAN STORE THE RELATED DATA AND LATER RETRIVE THE DATA IS KNOWN AS DATABASEDBMS => 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 ModelNetwork ModelEntity-Relationship Data ModelRelational Data ModelRDBMS =>DBMS using Relational Data Models are known as RDBMSHere is the list of the top 10 most popular RDBMSs are:SQL =>Programming lanugage for Relational DATABASEStands for Structured Query LanguageSQL(Structured Query Language) is a database computer language designed for managing data in relational database management systems (RDBMS).SQL (SEQUEL), is a standardized computerlanguage that was originally developed by in 1970 for querying, altering and defining relational databases, using declarative statements.1.SQL COMMANDS AND STATEMENTS2.FILTERING AND SORTING3.STRING FUNCTIONS4.NUMBER FUNCTIONSDATE FUNCTIONS6.CTAS7.SET OPEERATORS8.NULLS9.AGGRATE FUNCTIONS10.ANALTICAL FUNCTIONS11.CONSTARINAS12.JOINS13.SUBQURIES14.PIVOT AND UNPIVOT15.INDEXS16.VIEWS17.PERFORMANCE TUNING.STATEMENTS:Types of SQL CommandsData Definition Language (DDL)Data Manipulation Language (DML)Transaction Control Language (TCL)Data Query(Retrieval) Language (DQL)Data Control Language (DCL)DDL - CREATE      ALTER      DROP      TRUNCATEDML - INSERT      UPDATE      DELETE      MERGETCL - COMMIT      ROLLBACKDQL(DRL) - SELECTDCL - GRANT      REVOKEData 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.