Learn SQL - Road Map to become an ETL Tester, Data Warehouse Tester - Part 3 скачать в хорошем качестве

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