Sql Full Course Basic To Advance

DATABASE BASICS AND SQL STATEMENTS 1

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.

Overview

Section 1: Introduction

Lecture 1 INTRODUCTION TO DATABASES AND SQL STATEMENTS 1

Lecture 2 INTRODUCTION TO DATABASES AND SQL STATEMENTS 2

Lecture 3 FILTERING AND SORTING 1

Lecture 4 FILTERING AND SORTING 2

Lecture 5 STRING FUNCTIONS 1

Lecture 6 STRING FUNCTIONS 2

Lecture 7 NUMBER AND DATE FUNCTIONS 1

Lecture 8 NUMBER AND DATE FUNCTIONS 2

Lecture 9 CTAS & SET OPERATORS

Lecture 10 NULL HANDLING & CASE AND DECODE 1

Lecture 11 NULL HANDLING & CASE AND DECODE 2

Lecture 12 Aggregate functions & ANALYTICAL FUNCTIONS 1

Lecture 13 Aggregate functions & ANALYTICAL FUNCTIONS 2

Lecture 14 Aggregate functions & ANALYTICAL FUNCTIONS 3

Lecture 15 CONSTRAINTS & JOINS 1

Lecture 16 CONSTRAINTS & JOINS 2

Lecture 17 PIVOT AND UNPIVOT & SUBQUERIES 1

Lecture 18 PIVOT AND UNPIVOT & SUBQUERIES 2

Lecture 19 PIVOT AND UNPIVOT & SUBQUERIES 3

Lecture 20 INDEXES

Lecture 21 VIEWS

Lecture 22 PERFORMANCE TUNING

THIS COURSE USE FOR SNOWFLAKE DEVELOPERS AND PYTHON DEVELOPER AND DATASCIENCE AND DATA ANALYTICS