Learn SQL - Road Map to become an ETL Tester, Data Warehouse Tester - Part 3
Road Map to become an ETL Tester, Data Warehouse Tester | Learn SQL - Part 3
• Road Map for becoming an ETL Tester -...
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 (St...
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, Dat...
Road Map to become an ETL Tester, Data Warehouse Tester | Software Testing Fundamentals Part 2
• Road Map for becoming an ETL Tester -...
Video 29: Case Sensitive Search in SQL | • Case Sensitive Search in SQL | SQL Se...
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 ...
Video 26: Printing Star Patterns using SQL - Part 26 | * • Printing Star Patterns using SQL - Pa...
Video 25: Fibonacci Series Using SQL - Part 25 | * • Fibonacci Series using SQL - V25 - Wh...
Video 24: Splitting data based on format in SQL | * • Splitting data based on format in SQL...
Video 23: Missing Sequence Number in SQL | Recursive CTE | Generate Sequence Number --* • Missing Sequence Number in SQL | Rec...
Video 22: Comma Separated values to multiple rows | string_split() , Cross apply --* • Comma Separated values to multiple ro...
Video 21: XML Path in SQL - • Comma Separated values in SQL | XML P...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting --* • Sorting in SQL | Order By | Condition...
Video 2 Title: Difference between Primary Key and Unique Key --* • Difference between Primary Key and Un...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of SELECT Statemen...
SQL Step by Step Video 8 Title: UPDATE | DELETE | WHERE | ALTER | DROP in SQL -- * • UPDATE | DELETE | WHERE | ALTER | DRO...
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 (St...
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, Dat...
Road Map to become an ETL Tester, Data Warehouse Tester | Software Testing Fundamentals Part 2
• Road Map for becoming an ETL Tester -...
Смотрите видео Learn SQL - Road Map to become an ETL Tester, Data Warehouse Tester - Part 3 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь SQL With RaviMartha 16 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 65 раз и оно понравилось 1 людям.