KnowledgeWorks IT Consulting Pvt Ltd Jayanagar, Bangalore, Karnataka

To acquaint user with ‘C’ languages by providing detailed knowledge of usability and flexibility of ‘C’ language features. This module begins with an introduction to ‘C’ language where the user will learn to write programs in ‘C’ using its basic features. Building upon the basic concepts, the user is made familiar with pointer and handling memory locations. Subsequently, advanced concepts like appropriate usage of Abstract Data Types like structures, unions and File Handling operations will be taught. Duration: 3 Days Pre-requisites Before proceeding with this Course, you should have a basic understanding of Computer Programming terminologies. A basic understanding of any of the programming languages will help you in understanding the C programming concepts and move fast on the learning track. Target Audience This Course is designed for software programmers with a need to understand the C programming language starting from scratch. This Course will give you enough understanding on C programming language from where you can take yourself to higher level of expertise. Course Content Basic structure of C program Layout of a Executable file. Runtime memory layout of a application Datatypes, Keywords, Operators and control statements Arrays Strings as character array Modular programming Preprocessor Pointers Double dimension array Dynamic memory allocation (malloc(),calloc(),realloc(),free()) Structures and unions File Handling

Basic introduction to the C++ Programming language for C programmers Duration: 5 Days Pre-requisites Thorough, working knowledge of C Target Audience Programmers who have written programs in C Course Content Procedural Programming. Generic Programming. Lab - Using STL Containers, Algorithms. Generic Programming. Object-Based Programming. Lab - Implementing a Class. Object-Oriented Programming. Lab - Implementing a Class Hierarchy. Programming with Templates. Lab - Implementing a Template Container. Exception Handling. Input and Output Streams. Lab - Object. Persistence and I/O

This course introduces the basic Core Java programming language and how to develop Java applications using Eclipse. Students learn the syntax of the Java programming language, object-oriented programming using Java, exception handling, generics, collections, and file input/output (I/O). During the course, students will develop and test Java applications using Eclipse. Duration: 5 Days Target Audience This course is intended for programmers who are interested in adding Java to their skills. Pre-Requisite The students should be familiar with any programming language like C or C++. Course Content Introduction to Java. Objects, Classes and Interfaces Constructors Encapsulation Inheritance Polymorphism The Life Cycle of an Object Writing a finalizes Method Creating and Using Packages Interfaces Modifiers Types of Classes The Collections Framework Handling Errors Using Exceptions Threads of Control Working with Input and Output in Java

Python is a high-level, interpreted, interactive and object-oriented scripting language. Python is designed to be highly readable. Duration: 2 Days Pre-Requisite Knowledge of Programming, preferably in ‘C’ Course Content • Salient features of Python • Simple input/output operations • Continuation • Comments • Multiple statement Group • Basic types & variables • Special variables • Assignment • Memory management • Operators & Expressions • Control Structures • Sequences • Dictionaries • Nested data structures • Functions & procedures • Files • File System • Exception Handling • Modules • Object Oriented Programming

Understanding the role of Java EE technologies in the development of enterprise grade Java applications and learn how Java EE facilitates the integration of Java components with non-Java systems including relational databases. And get the practical experience for developing and deploying web and multi-tiered Java enterprise applications. Duration: 5 Days Pre-Requisite Before attending this course the student should have: A strong working knowledge of C Awareness of Internet, HTML, Scripting etc. Target Audinece Software designers and programmers involved in the design and implementation Java based software systems. Course Content Introduction to Object oriented programming and Java Java basics Overview of java.lang member classes Working with arrays Classes and Objects Constructors Packages Inheritance Interfaces Exception handling Overview of Java IO system Overview of Java Collection frameworks Overview of J2EE Introduction to Webpage development Container component model Container services/responsibilities Servlet architecture Servlet API Session management JSP benifits JSP architecture JSP execution phases JSP elements EJB architecture Container responsibilities Overview of EJB types Members of an EJB Writing and deploying Session beans Settingup database connection pools Working with Entity beans (BMP and CMP) Differences between BMP/CMP Introduction to XML Rules for wellformed and valid XML files Writing DTDs Parsers DOM and SAX API for Java

This course provides in-depth concepts of Spring and Hibernate Framework with simplified examples. Spring framework makes the easy development of JavaEE application. Duration: 6 Days Pre-Requisite Working knowledge of Core Java and Database Programming. Course Content SPRING FRAMEWORK Introduction to Spring Creating your first Spring application Understanding IOC Understanding AOP JDBC Support and DAO Introduction to the Spring MVC framework HIBERNATE Introduction to Hibernate Relationships and Collections Persistence Transaction, Concurrency and Caching Batch Processing The Hibernate Query Language Improving Performance Examples and Lab

Javascript is a lightweight, interpreted programming language. It is designed for creating network-centric applications. It is complimentary to and integrated with java. Javascript is very easy to implement because it is integrated with html. It is open and cross-platform. Duration: 3 days pre-requisite it is assumed that a prior knowledge of html coding. It would help if some prior exposure to object-oriented programming concepts and a general idea on creating online applications. Target audinece this course has been prepared for javascript beginners to help them understand the basic functionality of javascript to build dynamic web pages and web applications. Course content the document object introduction to cross-browser compatibility working with frames working with forms and forms-based data regular expression javascript debugguer javascript object oriented programming

This course teaches experienced JavaScript developers how to create server-side applications with Angular, with an application that queries RESTful web services for data. Duration: 3 Days Pre-Requisite Developers with at least 2 years of hands-on experience in JavaScript Knowledge of basic HTTP, HTML and CSS Objective Use Angular JS for front-end single page web application Course Content Introduction to angularjs Our first angularjs application Single page applications Controllers Models Views Expressions Filters Scopes Angular forms Ajax, data, and angular Directives

Node.js is a platform for easily building fast, scalable network applications. Learn how to use the event-driven, non-blocking I/O model to build data-intensive real-time applications that run across distributed devices. We will explore the design choices that make Node.js unique, how this changes the way applications are built and how systems of applications work most effectively in this model. Learn how to create modular code that’s robust, expressive and clear. Understand when to use callbacks, event emitters and streams. Use streams to easily manipulate data that would be impossible to fit in application memory. Gain confidence in handling errors effectively to ensure runtime reliability. The course has extensive lab exercises to reinforce the concepts and techniques covered. Duration: 3 Days Pre-Requisites Students taking this course should have JavaScript programming experience. Objectives On completion of this course, students will be able to: Clearly understand the platform design choices that led to Node.js choosing an event loop and what this means for applications built on that foundation. Understand the unique trade-offs present in event-driven programming. Create Node.js modules and express code modularity in an application. Understand the core flow control patterns in Node.js and know when it is appropriate to use callbacks, event emitters or streams. Create and manipulate buffers efficiently. Understand how to manage error state and know when a process should exit due to an error. Build RESTful applications with node, express and mongodb Course Content Javascript basics Intro to node.js Installing node.js Modules and npm The callback pattern Events Error handling File system Streams Connecting to databases Http module

ASP.NET is a web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites. It allows you to use a full featured programming language such as C# or VB.NET to build web applications easily. Duration: 3 Days Pre-Requisite Before proceeding with this tutorial, you should have a basic understanding of .NET programming language. As we are going to develop web-based applications using ASP.NET web application framework, it will be good if you have an understanding of other web technologies such as HTML, CSS, AJAX. etc Target Audinece This course has been prepared for the beginners to help them understand basic ASP.NET programming. After completing this course you will find yourself at a moderate level of expertise in ASP.NET programming from where you can take yourself to next levels. Course Content Introduction to the .NET Framework Getting started Data Types and Variables Using the .NET Framework Branching and Flow Control Classes and Objects Properties and Methods Object-Oriented Techniques Working with Arrays Delegates and Events Generics Handling Exceptions Collection Classes Working with .NET Framework LINQ Unit Testing

SQL (Structured Query Language) is used to modify and access data or information from a storage area called database. Duration: 4 Days Course Content Oracle SQL SQL - Quick Recap Advanced Grouping Functions - Only Advanced Set Operators Paired Columns in Sub-Queries Joins Co-related Sub-Queries Pseudo-Columns In-line Views Analytical Functions TCL Privileges, Roles & DCL Data Dictionary Creating Views Indexing Synonyms DB Links Oracle PL/SQL Introduction to PL/SQL - A Quick Recap Cursors Exceptions Stored Procedures Functions Packages Triggers Autonomous Transaction DBMS_JOB Package Dynamic SQL Ref Cursors Records & Object Types Collections Bulk Binding Tracking the Dependencies 10g & 11g Features PL/SQL Unit Testing

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam. Duration: 5 Days Objectives Install Oracle Grid Infrastructure Install and configure Oracle Database 11g Configure Oracle Net services Monitor and administer undo data Manage the database storage structures Create and administer user accounts Perform basic backup and recovery of a database Manage data concurrency Monitor performance Describe Oracle Database Architecture Pre-Requisite Oracle Introduction to SQL course or equivalent experience Taken Oracle PL/SQL course or equivalent experience Course Content Exploring the Oracle Database Architecture Installing your Oracle Software Creating an Oracle Database Managing the Oracle Database Instance Manage the ASM Instance Configuring the Oracle Network Environment Managing Database Storage Structures Storage Structures Administering User Security Managing Data Concurrency Managing Undo Data Implementing Oracle Database Auditing Database Maintenance Monitor (ADDM) Describe and use the advisory framework Performance Management Backup and Recovery Concepts Performing Database Backups Performing Database Recovery Moving Data Working with Support

This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered. Duration: 5 Days Objectives Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager) Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state Use an appropriate and flexible memory configuration for your database Identify burdensome database sessions and poorly performing SQL Configure the Oracle Database for optimal recovery Configure the database instance such that resources are appropriately allocated among sessions and tasks Schedule jobs to run inside or outside of the database Use compression to optimize database storage and duplicate a database Target Audinece Database Administrators Support Engineer Technical Administrator Technical Consultant Pre-Requisite Complete the Course Oracle Database Administration I Course Content Core Concepts and Tools of the Oracle Database Configuring for Recoverability Using the RMAN Recovery Catalog Configuring Backup Settings Creating Backups with RMAN Restore and Recovery Task Using RMAN to Perform Recovery Monitoring and Tuning RMAN Diagnosing the Database Using Flashback Technology I

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Duration: 5 Days Pre-Requisite This course requires that you meet the following prerequisites: Working knowledge of relational databases. Basic knowledge of the Microsoft Windows operating system and its core functionality. Target Audinece This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers. Upon Course Completion After completing this course, students will be able to: Describe the basic architecture and concepts of Microsoft SQL Server. Understand the similarities and differences between Transact-SQL and other computer languages. Write SELECT queries Query multiple tables Sort and filter data Describe the use of data types in SQL Server Modify data using Transact-SQL Use built-in functions Group and aggregate data Use subqueries Use table expressions Use set operators Use window ranking, offset and aggregate functions Implement pivoting and grouping sets Execute stored procedures Program with T-SQL Implement error handling Implement transactions

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. Duration: 5 Days Pre-Requisite This course requires that you meet the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design. Target Audinece The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases. Upon Course Completion After completing this course, students will be able to: Describe core database administration tasks and tools. Install and configure SQL Server 2014. Configure SQL Server databases and storage. Plan and implement a backup strategy. Restore databases from backups. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Perform ongoing database maintenance. Automate SQL Server maintenance with SQL Server Agent Jobs. Configure Database Mail, alerts and notifications.

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. Duration: 5 Days Pre-Requisite This course requires that you meet the following prerequisites: At least 2 years’ experience of working with relational databases, including: Designing a normalized database. Creating tables and relationships. Querying with Transact-SQL. Some exposure to basic programming constructs (such as looping and branching). An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. Target Audinece This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include: Implementing a data warehouse. Developing SSIS packages for data extraction, transformation, and loading. Enforcing data integrity by using Master Data Services. Cleansing data by using Data Quality Services. Upon Course Completion After completing this course, students will be able to: Describe data warehouse concepts and architecture considerations. Select an appropriate hardware platform for a data warehouse. Design and implement a data warehouse. Implement Data Flow in an SSIS Package. Implement Control Flow in an SSIS Package. Debug and Troubleshoot SSIS packages. Implement an ETL solution that supports incremental data extraction. Implement an ETL solution that supports incremental data loading. Implement data cleansing by using Microsoft Data Quality Services.

Our Sybase database training develops and delivers excellent learning solutions to support your personal and organizational learning goals. We developed our courses to provide real solutions for the challenges you face every day, these task-based courses get to the heart of Sybase technology and provide you with the technical know-how that you can apply to achieve effective results, the ability to address specific real-world issues that pertain to your company's unique environment. When it comes to delivering Sybase database administration and technology training, there is no one better equipped than real-world production Sybase DBA's. Our access to production DBA, technical support and database architects ensures that our programs incorporate the most recent tips, tools and best practices to bring you up to speed and help you get the most out of your Sybase training. Duration: 5 Days Pre-Requisite Fundamental understanding of databases and SQL language Basic understanding of network connectivity architecture Knowledge of general Unix commands Target Audinece Database Administrators, Database Designers, End-Users, SQL Developers Course Content Module 1:Introducing Adaptive Server Module 2:Installing Servers Module 3:Establishing Connectivity Module 4:Configuring Server Behavior Module 5:Configuring Memory Module 6:Initializing and Using Devices Module 7: Creating and Using Databases Module 8:Suggested Disk Resource Strategies Module 9: Managing tempdb Module 10: Administering System Roles and Logins Module 11: Managing Database Access and Users Module 12: Implementing Object Permissions, Groups, and Roles Module 13: Using Bulk Copy Utility Module 14: Overview of Automatic Recovery Module 15: Planning for Backups Module 16: Performing a Backup Module 17: Practicing Advanced Backup Techniques Module 18: Monitoring the System

This course is part one of a three-part series that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses collectively cover implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment. While there is some cross-over in skills and tasks across the courses, this course primarily covers the initial implementation and configuration of core services including Active Directory Domain Services (AD DS), networking services, and Microsoft Hyper-V Server 2012 configuration. Duration: 5 Days Pre-Requisite Before attending this course, students must have: A good understanding of networking fundamentals. An understanding of and experience with configuring security and administration tasks in an enterprise environment. Experience supporting or configuring Windows operating system clients. Good hands-on Windows client operating system experience with Windows Vista, Windows 7, or Windows 8. An understanding of basic Active Directory Domain Services (AD DS) concepts, such as the purpose of user accounts and computer accounts. Students would also benefit from having some previous Windows Server operating system experience. Target Audinece This course is intended for Information Technology (IT) Professionals who have good Windows operating system knowledge and experience and want to acquire the skills and knowledge necessary to implement the core infrastructure services in an existing Windows Server 2012 environment. The secondary audience consists of those seeking certification in the 70-410, Installing and Configuring Windows Server 2012 exam. Upon Course Completion After completing this course, students will be able to:

Learn how to administer Windows Server 2012 with this five-day course. This course is part two in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 Infrastructure in an existing enterprise environment. The three courses collectively cover implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment. Although there is some cross-over of skills and tasks across these courses, this course primarily covers the administration tasks necessary to maintain a Windows Server 2012 infrastructure such as Implementing Server Images, User and Group management with Active Directory Domain Services(AD DS) and Group Policy, Remote Access and Network Policies, Data Security, Monitoring and Update Management Duration: 5 Days Pre-Requisite Before attending this course, students must have: Real world hands on experience working with Windows Server 2008, Windows Server 2008 R2 or Windows Server 2012. Good knowledge and understanding of Active Directory and networking infrastructure. Target Audinece This course is intended for Information Technology (IT) Professionals with hands on experience working in a Windows Server 2008 or Windows Server 2012 environment, who wish to acquire the skills and knowledge necessary to be able to manage and maintain the core infrastructure required for a Windows Server 2012 environment. The key focus for students in this course is to broaden the initial deployment of Windows Server 2012 services and infrastructure and provide the skills necessary to manage and maintain a domain based Windows Server 2012 environment, such as user and group management, network access and data security.

This course will provide you with the knowledge and skills to configure and manage a Microsoft® SharePoint Server 2013 environment. This course will teach you how to configure SharePoint Server 2013, as well as provide guidelines, best practices, and considerations that will help you optimize your SharePoint server deployment. This is the first in a sequence of two courses for IT Professionals and will align with the first exam in the SharePoint Server 2013 IT Pro certification. Duration: 5 Days Pre-Requisite An ideal candidate will have at least one year of experience with deploying and administering multiple SharePoint 2010 farms across a large enterprise. Because many customers skipped upgrading from SharePoint 2007, a candidate can also have at least 2 years of experience with SharePoint 2007 and knowledge of the differences between 2007 and 2010, particularly the Service Application model. A candidate can demonstrate the following skills: Software management in a Windows 2008 R2 enterprise server or Windows Server 2012 environment. Deploying and managing applications natively, virtually and in the cloud. Administering Internet Information Services (IIS). Configuring Active Directory for use in authentication, authorization and as a user store. Managing an application remotely using Windows PowerShell 2.0. Connecting applications to Microsoft SQL Server. Implementing Claims-based Security.

This five-day course examines how to plan, configure, and manage a Microsoft SharePoint Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the Search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013. Duration: 5 Days Before attending this course, students must have: Completed Course 20331: Core Solutions of Microsoft SharePoint Server 2013, successful completion of Exam 70-331: Core Solutions of Microsoft SharePoint 2013, or equivalent skills. At least one year’s experience of mapping business requirements to logical and physical technical design. Working knowledge of network design, including network security. Experience managing software in a Windows 2008 R2 enterprise server or Windows Server 2012 environment. Deployed and managed applications natively, virtually, and in the cloud. Administered Internet Information Services (IIS). Configured Active Directory for use in authentication, authorization and as a user store. Managed an application remotely using Windows PowerShell 2.0. Connected applications to Microsoft SQL Server. Implemented Claims-based security.

In this course, students learn core skills that are common to almost all SharePoint development activities. These include working with the server-side and client-side object models, developing and deploying features, solutions, and apps, managing identity and permissions, querying and updating list data, managing taxonomy, using workflow to manage business processes, and customizing the user interface. Duration: 5 Days Pre-Requisite Before attending this course, students must have:: A working knowledge of using Visual Studio 2010 or Visual Studio 2012 to develop solutions. A basic working knowledge of SharePoint solution development, either in SharePoint 2013 or in earlier versions of SharePoint. A working knowledge of Visual C# and the .NET Framework 4.5. A basic understanding of ASP.NET and server-side web development technologies, including request/response and the page lifecycle. A basic understanding of AJAX and asynchronous programming techniques. A basic working knowledge of client-side web technologies including HTML, CSS, and JavaScript. Familiarity with approaches to authentication and authorization, including claims-based authentication. Course Content Module 1: SharePoint as a Developer Platform Module 2: Working with SharePoint Objects Module 3: Working with Lists and Libraries Module 4: Designing and Managing Features and Solutions Module 5: Working with Server-Side Code Module 6: Managing Identity and Permissions Module 7: Managing Custom Components and Site Lifecycles Module 8: Introducing Apps for SharePoint Module 9: Client-Side SharePoint Development Module 10: Developing Remote Hosted SharePoint Apps Module 11: Publishing and Distributing Apps Module 12: Automating Business Processes Module 13: Managing Taxonomy Module 14: Customizing User Interface Elements Module 15: Working with Branding and Navigation

Basics of Functional Test Automation tool Quick Test Professional training is used to gain considerable knowledge on QTP tool. Duration: 3 Days