Structured Data Handling Using SQL For Accountants.

ORACLE, SQL, PL/SQL, SQL Developer and Database Modelling.

As a part of experiments in academic research titled ” Enhanced Methods to Develop Productive Programmers “.

What you’ll learn

  • Data Analysis Cycle..
  • Working Structured Data within any Database system..
  • Database Modelling ..
  • Handling Data Using Structured Query Language..
  • Creating Business Logic..
  • Filtering and Restricting Data..
  • Transforming and Grouping Data..
  • Create Digital Database..
  • Oracle PL/SQL..
  • Setting Connection to Database Server..
  • Create Complex Data mining Queries..

Course Content

  • Discovering Database. –> 7 lectures • 30min.
  • Restricting Data Sets –> 1 lecture • 32min.
  • Transforming and Grouping Data. –> 3 lectures • 47min.
  • INNER JOIN (Matched Data Handling) –> 7 lectures • 45min.
  • OUTER JOIN (Unmatched Data Handling) –> 3 lectures • 30min.
  • Answering Business Questions (Sub-Queries) –> 4 lectures • 32min.
  • Automate Business Logic (PL/SQL) –> 8 lectures • 1hr 1min.
  • Extended Lab Section –> 5 lectures • 36min.

Structured Data Handling Using SQL For Accountants.

Requirements

  • English B1.

As a part of experiments in academic research titled ” Enhanced Methods to Develop Productive Programmers “.

this course was created in order to take a place within the educational process of creating technology experts from any field specially finance and statistics.

the course consist of the sections below:

Structured Data Handling Using SQL:

– Discovering data entities.

Different database management systems exist in most companies and banks, the cycle of working with data, connect to Oracle servers , discover data entities and retrieve data using SELECT statement.

– Filtering datasets.

In this Section students will  learn how to filter data and restrict results  according specific conditions using where clause and logical operators.

– Transforming data on needs.

Data mining or working to discover and create data pattern require detailed knowledge of numeric and character functions that can be used in SQL, in this section all functions help to transform original data will be explained and run against database server for practice.

– Change data in where it lives.

– Summarize multiple data records.

– Joining datasets.

– Further joins of datasets.

– Apply business logic on data.

– Creating new data view and entity.

 

Workshop is proper for people willing to work in the field of data analysis and programming ,however no prior data analysis skills or programming knowledge is required for subscription as the training is supposed to achieve that and create specialized accountants  in handling database systems using the structured query language.