1. Introduction to business graphic design tool Canva....7
1.1 Logging / Setup Canva Account
1.2 Layouts & Templates
1.3 Get you setup with your Canva & account
1.4 Tour of your dashboard
1.5 Learn about the different types of templates Canva has
1.6 Learn how to use the pre-designed layouts
1.7 Downloading your work
1.8 Working with text; Photo backgrounds & Shapes
1.9 Illustrations, icons and lines; Adding pages to a design
1.10 Image; Text features and Charts
2. Creating business related documents with Canva.....26
2.1 Designing CV
2.2 Business posters
2.3 Business cards
2.4 Calander
2.5 Labels and Presentations
3. Business Database Management with Structured
Query Language (SQL)..........................................35
3.1 Concept of DBMS,
3.2 RDBMS and OORDBMS Tables, relationships between tables and applying constraints
3.3 Create user command
3.4 Alter user command
3.5 Drop user command
3.6 Create table command
3.7 Alter table command
3.8 Drop table command
4. SQL and its applications in business..............81
4.1 Insert, update, delete and select commands
4.2 Select command with where, having, order by and group by clause Design tables for sales order system
5. Data Analytics with Advance Excel-I.......................104
5.1 Creating Business Data Sheets
5.2 Importing data into Excel
5.3 Using formulas – math, stat and finance formulas
5.4 Searching data; Sorting data; Pivot Table
5.5 Use of IF – Els
6. Data Analytics with Advance Excel-II................135
6.1 Use of Hyperlinking of data sheets
6.2 Using VLOOKUP Using Filters
6.3 Working on Text with functions