SQL Data Analysis:( Oracle, SQL, PL/SQL, TOAD, SQLPlus)

سرفصل های دوره

Mastering SQL Data Analysis: From Oracle Foundations to Advanced PL/SQL Techniques

1. Oracle Database Setup

1. Introduction.html

2. What is Oracle.html

3. Oracle installation requirements

4. Download Oracle

5. Install Oracle

6. Connect to Oracle with SQLPlus

7. Create a new database user

8. Create a table

9. How to stop and start Oracle database server

2. Oracle Configuration with TOAD and SQL Developer

1. What is SQL Developer

2. Download SQL Developer

3. Connect SQL Developer to Oracle

4. Download sample schemas

5. Unlock sample HR Schema account

6. Connect sample schema account to Oracle

7. Unlock sample schema tables

8. What is TNS Names

9. Creating TNSNames

10. Connect to oracle with TNSNames

11. What is TOAD.html

12. Install TOAD

13. Connect TOAD to Oracle

3. Query data with SQL

1. Using FROM clause

2. Using WHERE Clause for filtering data

3. Using ORDER BY Clause

4. Using DISTINCT

5. Using aliases

6. Using Sub-Query

7. Restricting and Sorting Data

8. Using GROUP BY and HAVING Clause

9. Overview of SQL.html

4. Extracting data from multiple tables

1. Introduction to Joins

2. Writing query for a SELF Join

3. Writing query for an OUTER Join

4. Writing query for a CARTESIAN Join

5. Writing query for a NON EQUI Join

6. Writing query for an EQUI Join

7. Overview of Oracle SQL Joins.html

5. Aggregating Data using Aggregate Functions

1. What are aggregate functions

2. Writing query for AVG aggregate

3. Writing query for COUNT aggregate

4. Writing query for MIN aggregate

5. Writing query for MAX aggregate

6. Overview of Aggregate Functions.html

6. Data Analysis using SET Operators

1. What are SET Operators

2. Union SET Operator

3. Minus SET Operator

4. Intersect SET Operator

5. Overview of SET Operators.html

7. Filtering data in SQL

1. Filtering data with OR Operator

2. Filtering data with AND Operator

3. Filtering data with NOT Operator

4. Filtering data with ANY Operator

5. Filtering data with IN Operator

6. Filtering data with ANY Operator

7. Filtering data with LIKE Operator

8. Filtering data with NULL Values

9. Filtering data with ISNULL

10. Overview of Filtering data with SQL.html

8. Data Analysis using Analytic Functions

1. Introduction To Analytic Functions

2. How To Write Analytic Functions

3. Partition By Clause

4. Order By Clause

5. Row number Functions

6. Rank Function

7. Dense Rank Function

8. Lead Function

9. Lag Function

10. First and Last Functions

11. ListAgg Function

12. Overview of Analytic functions.html

9. Analysing data with Single Row Functions

1. single row

2. Character Functions

3. Conversion Functions

4. Date Functions

5. Numeric Functions

6. Overview of single functions.html

10. PLSQL Essentials

1. What is PLSQL

2. PLSQL Block Structure

3. Execute a PLSQL Anonymous Block using SQLPlus

4.1 anonymous-block.zip

4. Execute a PLSQL Anonymous Block using Oracle SQL Developer

5.1 anonymous-block.zip

5. Execute a PLSQL Anonymous Block using TOAD

6. PLSQL Variables

7. PLSQL Variable Declaration

8. PLSQL Variable Assignment

9. PLSQL Variable Anchors

10. Executing PLSQL Variable Assignment using SQLPlus

11. Executing PLSQL Variable Assignment using Oracle SQL Developer

12. Executing PLSQL Variable Assignment using TOAD

13. Initializing Variables in PLSQL using SQLPlus

14. Initializing Variables in PLSQL using SQL Developer

15. Initializing Variables in PLSQL using TOAD

16. PLSQL Literals

17. Variable Scopes in PLSQL using SQLPlus

18. Variable Scopes in PLSQL using SQL Developer

19. Variable Scopes in PLSQL using TOAD

20. Introduction to PLSQL Functions

21. Creating Functions

22. Creating PLSQL Functions using SQLPlus

23. Creating PLSQL Functions using SQL Developer

24. Creating PLSQL Functions using TOAD

25. What are PLSQL Stored Procedures

26. How to create stored procedure using SQLPlus

27. How to create stored procedure using SQL Developer

28. How to create stored procedure using TOAD

29. How to execute or call a stored procedure using SQLPlus

30. How to execute or call a stored procedure using SQL Developer

31. How to execute or call a stored procedure using TOAD

32.1 Overview of PLSQL Data Types.pdf

32. PLSQL Data Types.html

33. PLSQL IF Statements

34. PLSQL IF Statements example using SQLPlus

35. PLSQL IF Statements example using SQL Developer

36. PLSQL IF Statements example using TOAD

37. Overview of PLSQL.html

11. More Data Analysis with Oracle SQL

1. Analyze employee count total

2. Generate hire date report

3. Analyze unique salaries

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy