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 - 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...