Advance Data Management

SQL Fundamental in Oracle Database (30 hrs)

  1. Retrieving Data Using the SQL SELECT Statement
  2. Restricting and Sorting Data
  3. Using Single-Row Functions to Customize Output
  4. Using Conversion Functions and Conditional Expressions
  5. Reporting Aggregated Data Using the Group Functions
  6. Displaying Data from Multiple Tables
  7. Using Subqueries to Solve Queries
  8. Using the Set Operators
  9. Manipulating Data
  10. Using DDL Statements to Create and Manage Tables
  11. Creating Other Schema Objects

C-Programming (30 hrs)

  1. Overview of Computer Software and Programming Languages
  2. Problem Solving Using Computer
  3. Introduction to C Programming
  4. Input and Output
  5. Control statements
  6. User-Defined Functions
  7. Arrays and Strings

Advanced Excel (20 hrs)

  1. Basic functions used in Excel
  2. Working with Dates
  3. Working with Tables
  4. Working With Charts
  5. Conditional Formulas and Formatting
  6. Using Logical Functions
  7. Working with Lookup Functions
  8. Documenting and Auditing
  9. Advanced List Management
  10. PivotTables and PivotCharts
  11. Using ‘What-If’ Analysis Tools
  12. Macros

VBA (20 hrs)

  1. Recording Macros
  2. Working with the Visual Basic Editor
  3. Developing with Procedures
  4. Managing Program Execution
  5.  Debugging the Code
  6. Understanding Objects
  7. Using Intrinsic Functions, Variables and Expressions
  8. Creating User Defined Functions
  9. Message Boxes and Input Boxes
  10. Handling Errors
  11. Working with Ranges
  12. Working with Arrays
  13. Triggers and Events
  14. Working with Procedures and Parameters

IBM SPSS (20 hrs)

  1. Overview
  2. Entering Data in SPSS
  3. Creating and Modifying Data in SPSS
  4. Using SPSS Syntax
  5. Descriptive Statistics
  6. Graphical Representation
  7. Custom Table
  8. Correlation
  9. Regression
  10. Chi-Square Test
  11. One Sample t Test
  12. Paired Samples t Test
  13. Independent Samples t Test
  14. One-Way ANOVA