• views: 56
• date: 3 January 2024
• posted by: voska89

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

Homepage

https://www.udemy.com/course/sql-full-course-basic-to-advance/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.