Learn SQL - Road Map to become an ETL Tester, Data Warehouse Tester - Part 3
Автор: SQL With RaviMartha
Загружено: 2021-07-16
Просмотров: 736
Описание:
Road Map to become an ETL Tester, Data Warehouse Tester | Learn SQL - Part 3
• Road Map for becoming an ETL Tester - Soft...
https://sqlwithravimartha.blogspot.com
00:00 Introduction
01:20 Quick Overview
03:11 SQL Videos in my Channel
04:45 SQL Topics Discussion
14:00 Conclusion & Thanks note
SQL Presentation:
What is SQL?
What is front end? What is backend? How to Store data?
Uses of SQL, Install one of the databases to practise (Microsoft SQL Server, Oracle etc..)
What is a Database, Table, View, Stored Procedure, Function? (Objects)
How to create and alter the above objects
CREATE
ALTER
INSERT
SELECT
UPDATE
DELETE
TRUNCATE
DROP
Subsets of SQL
DDL - CREATE, ALTER, DROP, TRUNCATE
DML - SELECT, INSERT, UPDATE, DELETE, MERGE
DCL - GRANT, REVOKE, DENY, EXECUTE AS, Statement, REVERT
TCL - BEGIN TRANSACTION, COMMIT TRANSACTION, ROLLBACK TRANSACTION
Data Types in SQL
INT, BIGINT, Char, Varchar, Nvarchar, Date, Datetime etc
Constraints in SQL
Primary Key
Unique Key
NOT NULL
Default
Check
Foreign Key
Database Properties (ACID Properties)
Atomic
Consistent
Isolation
Durability
Operators in SQL
Arithmetic Operator -- +, - ,*, %, /
Comparision Operators -- =
Logical Operators -- ALL,AND, OR,ANY, BETWEEN, EXISTS, IN, LIKE, NOT, SOME
SET Operators -- EXCEPT (MINUS), INTERSECT, UNION ***
Imporatant Clauses
GROUP BY
HAVING
ORDER BY -- ASC, DESC
DISTINCT
TOP
JOINS in SQL ***
INNER JOIN
LEFT OUTER JOIN (LEFT JOIN)
RIGHT OUTER JOIN (RIGHT JOIN)
FULL OUTER JOIN (FULL JOIN)
Wild Cards
SELECT * FROM Employee WHERE name LIKE 'Raj%'
Other Concepts
Sub Query
Co-related Subquery
Temporary tables
Local Temp Table
Global Temp Tables
Table Variables
CTE (Common Table Expression)
System Version Tables
------------------------------
Playlists:
SQL Interview Questions:
• SQL Interview Questions
SQL Tutorial Series for Beginners:
• SQL Tutorial Series for Beginners (Step By...
SQL Tips and Tricks:
• SQL Server Tips & Tricks & Short Cuts
ETL Testing:
• ETL Testing
Road Map to become an ETL Tester, Data Warehouse Tester | Key Skills needed to become an ETL Tester
• Road Map to become an ETL Tester, Data War...
Road Map to become an ETL Tester, Data Warehouse Tester | Software Testing Fundamentals Part 2
• Road Map for becoming an ETL Tester - Soft...
Video 29: Case Sensitive Search in SQL | • Case Sensitive Search in SQL | SQL Server ...
Video 28: Finding Missing Sequence Dates - Part 28 | Recursive CTE | DATEADD | Skipped Dates Using SQL
Video 27: Finding Tables with Identity columns - Part 27 | * • Finding Tables with Identity columns - Par...
Video 26: Printing Star Patterns using SQL - Part 26 | * • Printing Star Patterns using SQL - Part 26
Video 25: Fibonacci Series Using SQL - Part 25 | * • Fibonacci Series using SQL - V25 - While L...
Video 24: Splitting data based on format in SQL | * • Splitting data based on format in SQL| LEA...
Video 23: Missing Sequence Number in SQL | Recursive CTE | Generate Sequence Number --* • Missing Sequence Number in SQL | Recursiv...
Video 22: Comma Separated values to multiple rows | string_split() , Cross apply --* • Comma Separated values to multiple rows | ...
Video 21: XML Path in SQL - • Comma Separated values in SQL | XML PATH |...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting --* • Sorting in SQL | Order By | Conditional So...
Video 2 Title: Difference between Primary Key and Unique Key --* • Difference between Primary Key and Unique ...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of SELECT Statement | L...
SQL Step by Step Video 8 Title: UPDATE | DELETE | WHERE | ALTER | DROP in SQL -- * • UPDATE | DELETE | WHERE | ALTER | DROP in ...
Blog: https://sqlwithravimartha.blogspot.com/
Facebook Page:
/ sql-with-ravimartha-109497027391239
/ etl-dwh-testing-100494175057349
Playlists:
SQL Interview Questions:
• SQL Interview Questions
SQL Tutorial Series for Beginners:
• SQL Tutorial Series for Beginners (Step By...
SQL Tips and Tricks:
• SQL Server Tips & Tricks & Short Cuts
ETL Testing:
• ETL Testing
Road Map to become an ETL Tester, Data Warehouse Tester | Key Skills needed to become an ETL Tester
• Road Map to become an ETL Tester, Data War...
Road Map to become an ETL Tester, Data Warehouse Tester | Software Testing Fundamentals Part 2
• Road Map for becoming an ETL Tester - Soft...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: