- Lectures: 55
- Students: 1
- 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
-
Overview
- Working Smart with Microsoft Office & the Internet
- Identify application areas of IT
- Explore various components of a computer
- Explore Windows operating system
- Work effectively on the computer
- Explore the usage of Internet
- Troubleshoot PC and its peripherals
- Classify network architecture and topologies
- Identify resources used to connect a network
- Secure your system and mobile devices
- Use the Microsoft Office Application Suite including Word, Excel, PowerPoint, and Outlook
- Explore the world of data, information, and reporting
- Advance Excel Tools and Techniques for Analyzing Data
- Process data from business transactions
-
Basics
- Summarize data
- Analyze data for decision making
- Exchange data between various sources
- Analyze & present complex data
- Collaborate with other users
- Automate the business operations
- RDBMS Essentials & T-SQL Programming RDBMS
- Create an entity-relationship model
- Map an entity-relationship diagram to tables
- Normalize and denormalize data in tables
- Querying Data Using SQL Server
- Appreciate SQL Server as a database server
- Identify the SQL Server tools
- Retrieve data
- Use functions to customize the result set
- Summarize and group data
- Query data by using joins
- Query data by using subqueries
- Manage result sets
- Manage databases
- Manage tables
- Manipulate data by using DML statements
- Manipulate XML data
- Create and manage indexes
- Create and manage views
- Implement a full-text search
- Implement batches
- Implement stored procedures
- Implement functions
- Implement transactions
- Optimize performance
- Professional Skills-I
- By the end of this course, you will be able to:
-
Advance
- Improve communication skills
- Improve self-presentation skills
- Work effectively in a team environment
- Demonstrate critical thinking
- Understand concepts of health, safety and security
- Understand methods of planning and prioritizing
- Understand the need for values and ethics at the workplace
- Demonstrate capability in basic aptitude tests – verbal, numerical and logic
There is no review for this course
