SQL Fundamental in Oracle Database (30 hrs)
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
C-Programming (30 hrs)
- Overview of Computer Software and Programming Languages
- Problem Solving Using Computer
- Introduction to C Programming
- Input and Output
- Control statements
- User-Defined Functions
- Arrays and Strings
Advanced Excel (20 hrs)
- Basic functions used in Excel
- Working with Dates
- Working with Tables
- Working With Charts
- Conditional Formulas and Formatting
- Using Logical Functions
- Working with Lookup Functions
- Documenting and Auditing
- Advanced List Management
- PivotTables and PivotCharts
- Using ‘What-If’ Analysis Tools
- Macros
VBA (20 hrs)
- Recording Macros
- Working with the Visual Basic Editor
- Developing with Procedures
- Managing Program Execution
- Debugging the Code
- Understanding Objects
- Using Intrinsic Functions, Variables and Expressions
- Creating User Defined Functions
- Message Boxes and Input Boxes
- Handling Errors
- Working with Ranges
- Working with Arrays
- Triggers and Events
- Working with Procedures and Parameters
IBM SPSS (20 hrs)
- Overview
- Entering Data in SPSS
- Creating and Modifying Data in SPSS
- Using SPSS Syntax
- Descriptive Statistics
- Graphical Representation
- Custom Table
- Correlation
- Regression
- Chi-Square Test
- One Sample t Test
- Paired Samples t Test
- Independent Samples t Test
- One-Way ANOVA