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

Focused View

Digital Learning Academy

8:18:40

581 View

1. Oracle Database Setup

1. Introduction.html

2. What is Oracle.html

3. Oracle installation requirements.mp4

01:27

4. Download Oracle.mp4

03:59

5. Install Oracle.mp4

01:58

6. Connect to Oracle with SQLPlus.mp4

03:13

7. Create a new database user.mp4

01:56

8. Create a table.mp4

02:23

9. How to stop and start Oracle database server.mp4

01:26

2. Oracle Configuration with TOAD and SQL Developer

1. What is SQL Developer.mp4

02:41

2. Download SQL Developer.mp4

03:41

3. Connect SQL Developer to Oracle.mp4

02:29

4. Download sample schemas.mp4

02:12

5. Unlock sample HR Schema account.mp4

05:18

6. Connect sample schema account to Oracle.mp4

01:49

7. Unlock sample schema tables.mp4

04:39

8. What is TNS Names.mp4

04:09

9. Creating TNSNames.mp4

06:43

10. Connect to oracle with TNSNames.mp4

03:20

11. What is TOAD.html

12. Install TOAD.mp4

03:21

13. Connect TOAD to Oracle.mp4

02:42

3. Query data with SQL

1. Using FROM clause.mp4

02:52

2. Using WHERE Clause for filtering data.mp4

05:22

3. Using ORDER BY Clause.mp4

05:48

4. Using DISTINCT.mp4

05:52

5. Using aliases.mp4

06:34

6. Using Sub-Query.mp4

08:38

7. Restricting and Sorting Data.mp4

07:18

8. Using GROUP BY and HAVING Clause.mp4

07:36

9. Overview of SQL.html

4. Extracting data from multiple tables

1. Introduction to Joins.mp4

04:11

2. Writing query for a SELF Join.mp4

09:53

3. Writing query for an OUTER Join.mp4

08:14

4. Writing query for a CARTESIAN Join.mp4

06:19

5. Writing query for a NON EQUI Join.mp4

07:26

6. Writing query for an EQUI Join.mp4

07:46

7. Overview of Oracle SQL Joins.html

5. Aggregating Data using Aggregate Functions

1. What are aggregate functions.mp4

01:38

2. Writing query for AVG aggregate.mp4

03:20

3. Writing query for COUNT aggregate.mp4

04:40

4. Writing query for MIN aggregate.mp4

02:48

5. Writing query for MAX aggregate.mp4

03:13

6. Overview of Aggregate Functions.html

6. Data Analysis using SET Operators

1. What are SET Operators.mp4

04:36

2. Union SET Operator.mp4

05:23

3. Minus SET Operator.mp4

01:48

4. Intersect SET Operator.mp4

02:50

5. Overview of SET Operators.html

7. Filtering data in SQL

1. Filtering data with OR Operator.mp4

04:12

2. Filtering data with AND Operator.mp4

04:46

3. Filtering data with NOT Operator.mp4

02:49

4. Filtering data with ANY Operator.mp4

04:01

5. Filtering data with IN Operator.mp4

04:48

6. Filtering data with ANY Operator.mp4

04:01

7. Filtering data with LIKE Operator.mp4

09:18

8. Filtering data with NULL Values.mp4

07:51

9. Filtering data with ISNULL.mp4

02:43

10. Overview of Filtering data with SQL.html

8. Data Analysis using Analytic Functions

1. Introduction To Analytic Functions.mp4

06:43

2. How To Write Analytic Functions.mp4

04:07

3. Partition By Clause.mp4

08:04

4. Order By Clause.mp4

05:48

5. Row number Functions.mp4

09:26

6. Rank Function.mp4

06:04

7. Dense Rank Function.mp4

05:57

8. Lead Function.mp4

06:44

9. Lag Function.mp4

03:37

10. First and Last Functions.mp4

08:56

11. ListAgg Function.mp4

06:14

12. Overview of Analytic functions.html

9. Analysing data with Single Row Functions

1. single row.mp4

00:59

2. Character Functions.mp4

07:50

3. Conversion Functions.mp4

06:48

4. Date Functions.mp4

05:02

5. Numeric Functions.mp4

05:25

6. Overview of single functions.html

10. PLSQL Essentials

1. What is PLSQL.mp4

01:02

2. PLSQL Block Structure.mp4

03:13

3. Execute a PLSQL Anonymous Block using SQLPlus.mp4

02:39

4.1 anonymous-block.zip

4. Execute a PLSQL Anonymous Block using Oracle SQL Developer.mp4

02:58

5.1 anonymous-block.zip

5. Execute a PLSQL Anonymous Block using TOAD.mp4

03:41

6. PLSQL Variables.mp4

01:55

7. PLSQL Variable Declaration.mp4

02:15

8. PLSQL Variable Assignment.mp4

05:31

9. PLSQL Variable Anchors.mp4

04:07

10. Executing PLSQL Variable Assignment using SQLPlus.mp4

06:46

11. Executing PLSQL Variable Assignment using Oracle SQL Developer.mp4

06:42

12. Executing PLSQL Variable Assignment using TOAD.mp4

05:35

13. Initializing Variables in PLSQL using SQLPlus.mp4

02:08

14. Initializing Variables in PLSQL using SQL Developer.mp4

02:19

15. Initializing Variables in PLSQL using TOAD.mp4

02:30

16. PLSQL Literals.mp4

00:31

17. Variable Scopes in PLSQL using SQLPlus.mp4

03:22

18. Variable Scopes in PLSQL using SQL Developer.mp4

03:33

19. Variable Scopes in PLSQL using TOAD.mp4

03:41

20. Introduction to PLSQL Functions.mp4

03:20

21. Creating Functions.mp4

06:21

22. Creating PLSQL Functions using SQLPlus.mp4

04:05

23. Creating PLSQL Functions using SQL Developer.mp4

05:16

24. Creating PLSQL Functions using TOAD.mp4

07:51

25. What are PLSQL Stored Procedures.mp4

02:23

26. How to create stored procedure using SQLPlus.mp4

03:18

27. How to create stored procedure using SQL Developer.mp4

03:31

28. How to create stored procedure using TOAD.mp4

03:24

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

04:01

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

03:44

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

04:03

32.1 Overview of PLSQL Data Types.pdf

32. PLSQL Data Types.html

33. PLSQL IF Statements.mp4

02:59

34. PLSQL IF Statements example using SQLPlus.mp4

10:30

35. PLSQL IF Statements example using SQL Developer.mp4

10:21

36. PLSQL IF Statements example using TOAD.mp4

10:46

37. Overview of PLSQL.html

11. More Data Analysis with Oracle SQL

1. Analyze employee count total.mp4

03:27

2. Generate hire date report.mp4

12:44

3. Analyze unique salaries.mp4

06:24

Description

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

What You'll Learn?

Install Oracle Database and configure the environment for optimal use.
Execute basic to advanced SQL queries to retrieve data from the Oracle Database.
Use the SELECT, FROM, WHERE, ORDER BY, and DISTINCT clauses effectively in queries.
Understand and apply various SQL functions, including aggregate functions for data analysis.
Employ JOIN operations to extract and combine data from multiple tables.
Utilize Oracle’s SET operators for advanced data comparison and analysis.
Filter and sort data effectively using a variety of SQL clauses and operators.
Learn to write and execute PL/SQL blocks for procedural data manipulation.
Develop PL/SQL stored procedures and functions for reusable code and efficient database operations.

Who is this for?

Students and Recent Graduates

IT Professionals

Career Changers

Database Enthusiasts and Hobbyists

Beginners to Oracle SQL

What You Need to Know?

Basic Computer Literacy: Familiarity with operating a computer, managing files and folders, and a general understanding of operating systems (Windows, Linux, or macOS).

Fundamental Understanding of Databases: A basic grasp of what databases are and how they are used. Knowledge of what tables, rows, and columns represent in a database context.

Introductory SQL Knowledge: While not mandatory, having an introductory level of SQL knowledge, such as understanding what a SELECT statement does, can be beneficial.

Oracle Database Software: Access to Oracle Database software for practice. This could be through Oracle's free editions or through a provided environment if part of an institutional learning package.

Software Installation: Ability to install software on your computer, as the course will require installing Oracle Database, SQL Developer, TOAD, and potentially other tools.

Eagerness to Learn: A strong willingness to learn and experiment with SQL and PL/SQL coding, database management, and data analysis techniques.

Analytical Thinking Skills: Ability to think logically and analytically, as solving database problems and writing queries require a structured approach.

More details

Description

Dive into the world of Oracle SQL and PL/SQL with our comprehensive course, designed to take you from beginner to expert. This course is meticulously structured over eleven sections, starting with the essentials of Oracle Database setup, configuration with TOAD and SQL Developer, and advancing through to complex data analysis using PL/SQL. Whether youâ€™re looking to enhance your data management skills, leverage analytical functions for in-depth insights, or understand the intricacies of SQL data manipulation, this course offers a deep dive into the powerful capabilities of Oracle databases.
From installing Oracle and creating your first database user to mastering advanced analytic functions and PL/SQL programming, you'll gain hands-on experience with real-world applications. Learn to navigate Oracle's rich set of features, including querying data with SQL, extracting data from multiple tables, aggregating data using aggregate functions, and performing sophisticated data analysis with set operators. Our course also covers essential topics like filtering data with SQL, analyzing data with single row functions, and leveraging the full power of PL/SQL for database management and automation.
Each section is packed with detailed lectures, from understanding the basics of what Oracle is to advanced PL/SQL stored procedures creation and execution. Youâ€™ll unlock sample HR schemas, connect to Oracle with TNSNames, and explore a variety of SQL clauses and functions to filter, sort, and analyze data. With practical examples and clear explanations, you'll learn how to write queries for joins, understand aggregate functions, and utilize analytic and single row functions to draw insights from data.
Our course is enriched with practical examples using the Oracle HR Schema, providing a hands-on approach to learning. By the end of this journey, you will have acquired the skills to effectively analyze data, manage databases, and develop robust SQL queries and PL/SQL programs for real-world applications.
Who this course is for:
Students and Recent Graduates
IT Professionals
Career Changers
Database Enthusiasts and Hobbyists
Beginners to Oracle SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Digital Learning Academy

Instructor's Courses

Digital learning academy produces bespoke elearning which helps you to effectively gain useful and marketable skills and knowledge . We work closely with you to map out exactly what you want to bring about and discover what you want to learn and achieve. We can help you learn something completely new? Working together, we can help you acquire some useful digital skills online. Our instructors are industry experts and have years of experience to deliver the training and skills you need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.