Students will learn how to start working with MS Excel right from basics to Tables, and advanced in data manipulation with database management system.
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 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).
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.
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.