Excel- Slice & Dice Data
Filters
Learn how to use filters to display only the records that meet criteria that you specify and hides rows that you do not want displayed.
Slicers
Slicers contain a set of buttons which help you quickly filter the data in a spreadsheet, without the need to open drop-down lists to find the items that you want to filter.
Data Validation
Data validation can be used to define restrictions on what data can or should be entered in a cell.
SQL- Introduction to Oracle
Example of SQL Application using Oracle DBMS
The following video will walk you through how SQL queries are written in Oracle. This will give you a feel for how SQL is used with an Oracle database which is one of the most popular DBMS's used in organizations. Don't worry about installing any software now. For the time being we will provide you online tools to practice queries. Once you get comfortable with writing queries, we will walk you through installation.