- Lectures: 55
- Students: 4
- Duration: 144 hours
WHAT YOU WILL LEARN
Working Smart with MS Office with Internet
Advance Excel Tools and Techniques for Analyzing Data
Introduction & Querying Data using SQL Server 2012
Professional Skills
INTERNATIONAL CERTIFICATION MAPPING
MS Office 70-461
SQL Server 2012
ENTRY PROFILE
FORM 4, O / A Levels
Undergraduates , Graduates
Working Professionals
Anyone who wishes to learn basic IT & MS Office Packages
EXIT PROFILE & JOB OPPORTUNITIES
Microsoft Office Specialist
IT Support Technician
MIS Executive
Curriculum
- 3 Sections
- 55 Lessons
- 144 Hours
Expand all sectionsCollapse all sections
- Overview14
- 2.1Working Smart with Microsoft Office & the Internet
- 2.2Identify application areas of IT
- 2.3Explore various components of a computer
- 2.4Explore Windows operating system
- 2.5Work effectively on the computer
- 2.6Explore the usage of Internet
- 2.7Troubleshoot PC and its peripherals
- 2.8Classify network architecture and topologies
- 2.9Identify resources used to connect a network
- 2.10Secure your system and mobile devices
- 2.11Use the Microsoft Office Application Suite including Word, Excel, PowerPoint, and Outlook
- 2.12Explore the world of data, information, and reporting
- 2.13Advance Excel Tools and Techniques for Analyzing Data
- 2.14Process data from business transactions
- Basics33
- 3.1Summarize data
- 3.2Analyze data for decision making
- 3.3Exchange data between various sources
- 3.4Analyze & present complex data
- 3.5Collaborate with other users
- 3.6Automate the business operations
- 3.7RDBMS Essentials & T-SQL Programming RDBMS
- 3.8Create an entity-relationship model
- 3.9Map an entity-relationship diagram to tables
- 3.10Normalize and denormalize data in tables
- 3.11Querying Data Using SQL Server
- 3.12Appreciate SQL Server as a database server
- 3.13Identify the SQL Server tools
- 3.14Retrieve data
- 3.15Use functions to customize the result set
- 3.16Summarize and group data
- 3.17Query data by using joins
- 3.18Query data by using subqueries
- 3.19Manage result sets
- 3.20Manage databases
- 3.21Manage tables
- 3.22Manipulate data by using DML statements
- 3.23Manipulate XML data
- 3.24Create and manage indexes
- 3.25Create and manage views
- 3.26Implement a full-text search
- 3.27Implement batches
- 3.28Implement stored procedures
- 3.29Implement functions
- 3.30Implement transactions
- 3.31Optimize performance
- 3.32Professional Skills-I
- 3.33By the end of this course, you will be able to:
- Advance8
- 4.11Improve communication skills
- 4.12Improve self-presentation skills
- 4.13Work effectively in a team environment
- 4.14Demonstrate critical thinking
- 4.15Understand concepts of health, safety and security
- 4.16Understand methods of planning and prioritizing
- 4.17Understand the need for values and ethics at the workplace
- 4.18Demonstrate capability in basic aptitude tests – verbal, numerical and logic