Data Management Tools

Data Tabulation in Excel

Creating a Table, Adding, Deleting new rows or columns, Moving a Table, Removing duplicate rows from a table. Sorting and filtering a table, auto filter, advanced filter, formatting of table.

series, auto fill series, Cell referencing (Relative, Absolute, Mixed).

Data from other sources: Importing external data from different database files. Creating Custom Views of your Worksheet.

Functions: Functions and its parts, some useful mathematical and statistical Functions in spreadsheet (eg. SUM, COUNT, MAX, MIN, IF, COUNTIF, CEILING, FLOOR, TRUNC, ABS, FACT, INT, LOG, MOD, POWER, ROUND, EXP), logical functions (IF, AND, OR). Date & Time functions (NOW, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND).

Decision Making & Advance Spread-Sheet Tools: Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER), Vlookup, Hlookup. What if analysis (Data tables, Scenario, Goal seek, Sub-total, Pivot Table), Macros, Protection.

Graphical methods: line graph, bar graph, pie chart, histogram, scatter plot.

Descriptive Statistics (mean, median, mode, standard deviation, sample variance, Range).

Introduction: Database Management Systems

Definition, Characteristics of DBMS, Architecture & Security, Types of Data Models, Concepts and constraints of RDBMS, Introduction to Structured Query Language, MySql Installer, Download sample Database, Loading Sample Database.

Data definition and Manipulation

SQL Process, SQL Commands – DDL, DML, DCL, DQL, SQL Constraints, Data Integrity, Data Types, SQL Operators, Expressions, Querying Database, Retrieving result sets, Sub Queries, Syntax for various Clauses of SQL, Functions and Joins.