Online IT / SAP Training & Certification Programs

Knowers Consulting Inc:
Based in Atlanta, Georgia, Knowers is an industrial leader in IT, Business and Organisational training. We provide a wide range of online / distance learning courses in a variety of IT fields including ORACLE, SAP, SQL, Microsoft Office, and more. We are dedicated to manpower development and management for the workplace, government and NGOs around the world.

Online / Distance Learning Information Technology (IT) Training Certification Programs:

Microsoft SQL Server 2008/2012
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to generate databases that can be accessed from workstations, the Internet, or other media such as a personal digital assistant (PDA). Modules include:

- Introduction to Microsoft SQL Server 2012
- Getting Started with SQL Azure  (2012)
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2012 Data Types
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Querying SQL Server Metadata
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
- Improving Query Performance

Oracle Database
Oracle is referred to as Oracle RDBMS or simply as Oracle. It is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation. Oracle is one of many database servers that can be plugged into a client/server system and it works to efficiently manage its resource to provide information among the multiple clients requesting and sending data in the network. Features include:

- Oracle System DBA
- Installing and upgrading the database software and application tools
- Allocating system storage and planning future storage
- Requirements for the database system
- Creating database and its parameters
- Upgrade Oracle database from 10gr2 to 11gR2
- Creating database objects (tables, views, indexes)
- Create users and grant database privileges
- Setup database security and auditing
- Setup database backup (Hot backup and Cold backup)
- Recover database  using RMAN, Import and Export
- Setup database monitoring using Toad, Enterprise manager
- Database optimization and performance tuning
- Perform database maintenance (reorgs, collect stats, Capacity planning)
- Design and Implement database high availability strategy  and provide 24x7 support
- Technical support and work with Oracle support to fix database bugs
- Ensuring compliance with the database license agreement

Oracle 10g Foundations
Students develop the skills to effectively interact with an Oracle 10g Database using Oracle SQL and SQL*Plus. You receive a hands-on introduction to SQL Basics and SQL*Plus including a basic knowledge of relational databases and how to access them through SQL and SQL*Plus. Topics covered in this class are necessary to the development and administration of an Oracle 10g database . Course objectives include:

- Understanding relational database terminology
- Understanding Structured Query Language basics
- Learn how to format reports using SQL*Plus commands
- To extract and organize information from the database
- To insert, update & delete information in database tables
- To create and drop tables, views, synonyms and indexes

Oracle E-Business Suite (Applications DBA)
An Oracle Application database administrator (APPS DBA) is someone who administers and maintains the Oracle database server and combines the roles of a DBA and a System Administrator. Objectives include:

- Develop the basic skills to effectively administer an Oracle application database server
- Understand how to install, maintain and administer Oracle application Technology Stack.
- Gain understanding of the Oracle application architecture and how its components work and interact with one another.

Oracle Financial Courses:
Oracle financial applications are set of enterprise resource planning eBusiness suites Applications that help Organizations to enhance their day to day business processes. Oracle eBusiness Suite Financial Applications allow Organizations to Increase efficiency and reduce back-office costs with standardized processes for shared services, productivity tools, and integrated performance management. Courses include:

- Oracle General Ledger
- Oracle Payables
- Oracle Purchasing
- Oracle Receivables
- Oracle Order Management
- Oracle Assets

Certified Electronic Health Record Specialist (CEHRS/CEHRIS) Certification
10-Week Online Course
These are exciting times in Health Information Technology as the 3 trillion dollar Health sector begins to transform and re-position itself by using Health Informatics tools to improve healthcare quality and efficiencies. Possible applicants include:

- Physicians who want to get into health information technologies and Electronic Medical Record implementation at their practices and hospitals.
- Nurses who want to start a career as a nurse informacist.
- Healthcare workers who want to train as Electronic Medical Record Implementation Specialists.
- Information Technology professionals who want to transition into health information technology positions.

- SAP Training, and Microsoft Office packages are also available. Contact us via our Contact Us page for more information.