PHP and MySQL Trainings in Bangalore

Pre-requisites: Basic Knowledge of OS (Win/Linux), Basic HTML. Knowledge of any one Programming Language. (Preference: C/C++/Java/C#)

Course Duration: 30 hrs

Class Overview

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice.

Class Goals

Learn how PHP works.

Learn the basic syntax of PHP.

Learn to create dynamic interactive pages with PHP.

Learn to manipulate files with PHP.

Learn to work with arrays in PHP.

Learn to validate forms with PHP.

Learn to write functions in PHP.

Learn to manipulate and manage database data with PHP.

Learn to authenticate users with PHP.

Learn to manage sessions with PHP.

Learn to work with the MDB2 package.

Learn advanced form validation with regular expressions.

Learn to send email with PHP.

Course Outline

Module 1: Introduction to Web Development

Internet and Web Architecture

( Web server, Web Browser,Request, Response and Web protocols).

Introduction to server side script. (Dynamic websites)

Module 2: Introduction to PHP

History and advantages of PHP

Version differences

Apache server and its features

Installation and configuration

Configuration (php.ini and httpd.conf settings)

Module 3: PHP5 Core Language Basics

PHP script fundamentals (Basic Syntax)

Writing output to Browser (HTML embedding)

Comments

Module 3:  Variables, Data types and Operators

Variables

Super Global Variables

Local & Global Variables

Reference Variables

Basic Data Types

Integers

Floating-Point Numbers

Strings

Booleans

Null

Resources

Arrays

Constants

Operators

Binary Operators

Assignment Operators

Comparison Operators

Logical Operators

Bitwise Operators

Unary Operators

Negation Operators

Increment/Decrement Operators

The Cast Operators

The Silence Operator

The Ternary Operator

Module4: Control structures, Arrays and Functions

Control Structures

Conditional Control Structures

Loop Control Structures

Code Inclusion Control Structures

Functions

User-Defined Functions

Function Scope

Returning Values By Value

Returning Values By Reference

Declaring Function Parameters

Static Variables

Arrays

Type of arrays

Array Functions

Module 5: Object-oriented programming

Class and Objects

Abstraction, Encapsulation, Inheritance and Polymorphism

Access Specifiers

Constructors and Destructors

Static and final modifiers

Module 6: Exception Handling

Configuration directives

Exception handling

Module 7: Built in functions

String functions

Date & Time functions

Mathematical functions

Mail functions

Module 8: File Handling

Opening and closing of files

Create file and manipulation

Read and write information in files

Create remove and rename directories

Parsing directory paths

Module 9: Web Programming with PHP

Cookies and Sessions

What are cookies and sessions?

Handling cookies

Session Handling

Module 10: FORM Handling

Modularize code with include and require

GET, POST request handling ( HTML FORMs)

PHP authentication concepts

File Uploading and Downloading

File handling functions

How to uploading and download files

MY SQL Programming

Module 1: Introduction to MySQL

Module 2: Database Fundamentals

DBMS and RDBMS concepts

Creating Databases, Tables and Users

Retrieving and manipulating data with SQL

MySQL Data types

SQL Command and Queries

How to use Phpmyadmin

Module 3: Database Interaction

Interaction with different databases

Retrieve information from tables

MySQL and MySQLi Functions

Module 4: Conclusion

Security Concepts

PHP Best practices

Pointers/Resources for PHP and MySQL.

Available benefits for successfully trained candidates:-

•   Study material provided
• Interview Guidance for interview
•  Mock Tests conducted
•   Mock Interviews conducted
•  Resume Preparation as per the standards
•  Guidance for Microsoft SharePoint MCTS Certification Exams
•  MNC Reference provided.

Fees Structure:
Rupees: 11,000/-
Duration: 30 hours

Timings: Flexible as per the Candidates

NOTE:-  Regular and weekend batches available.

Venue Address:

#1-24/5,3^rd Floor, S.P Mansion Building

Marathahalli,

Bangalore-37

Land Marks:

1. Besides to Coupon Mall

2. Near to Axis Bank

3. Brand Factory

Regards,

Venkat

www.DatapointInfotech.com

+91-9916229967

SharePoint 2007/SharePoint 2010 trainings

Hi ,

We are at DataPoint Infotech offering wide range of courses for Microsoft SharePoint Server 2010. We know that professionals want to learn from professionals. Our instructors are Real time industry experts working for Good MNC’s. They are certified industry leading instructors with real world experience. DataPoint Infotech guarantees quality instructors for delivering the courses as per the schedules.

SharePoint Application Development Training: Our training course has been designed to give developers everything they need to know to begin using SharePoint to create commercial collaboration and portal projects.

SharePoint Administrators Training:

This course is designed for the IT professional who has been tasked with setting up, managing and maintaining Microsoft's SharePoint Server 2010 platform. During this course you will learn how to install SharePoint Server, create and manage Web applications and site collections as well as understand their place and purpose within the SharePoint platform. You will also learn about the new implementation of service applications and gain an understanding of the document management features provided by this newest edition of SharePoint Server.

SharePoint End Users Training:

Gain the hands-on skills required to use and manage content in a Microsoft SharePoint 2010 environment. Learn about site navigation, document storage and retrieval and how to create and manage sites, lists, and libraries. This course is intended for everyone who works with SharePoint 2010 on a daily basis.

New Batches:

SharePoint Application Development: Every Week we have New Batches

Course content Available Here: http://sharepoint2010training.blogspot.com/2010/08/sharepoint-2010-training-in-bangalore.html

SharePoint Administration/Configuration: Every Week we have New Batches

Course content Available Here: http://sharepoint2010training.blogspot.com/2011/01/sharepoint-server-2010.html

SharePoint End Users Training: Every Week we have New Batches

Course content Available Here:

http://sharepoint2010training.blogspot.com/2011/04/sharepoint-2010-end-user-training-in.html

Training formats: we have both Regular and Weekend Batches

Duration: 50 hours. It is completely hands on training with examples.

Timings: Timings are flexible as per the participants. We have both Regular/Weekend Batches available

Benefits:-

• Study material

• Interview Guidance

• Mock Tests

• Mock Interviews

• Resume Preparation as per the standards

• Guidance for Microsoft SharePoint MCTS Certification Exams

• MNC Referral

Note: We are also providing Guarantee Job Training for freshers with Money Back Offer.

For complete information have a look on below link:

http://sharepoint2010training.blogspot.com/2011/05/guarantee-job-training-for-freshers-on.html

Venue Address:

#1-24/5,3^rd Floor, S.P Mansion Building

Marathahalli,

Bangalore-37

Land Marks:

1. Besides to Coupon Mall

2. Near to Axis Bank

3. Brand Factory

Regards,

Venkat

www.DatapointInfotech.com

+91-9916229967

Deploying Master Page using Feature Receiver in SharePoint 2010

Deploying Master page need to create module which is available as template in Visual studio 2010. I created a Module. A module can be used to deploy files to your SharePoint environment and the scenario I came up with was to use a module to deploy a master page.

• I started out by creating an Empty SharePoint project. This can have any name you like and it can be both a farm and a sandboxed solution

• Next add an new item to the project and choose a module

• You can rename the module if you want to, I will leave the name at Module1

• After the module is created it contains an elements.xml file and a sample.txt file. The sample.txt file can be renamed to sample.master.

Project structure after adding a module and renaming the sample file to sample.master

I’m not a designer, so I wasn’t interested in creating a brilliant new design (good job, because I wouldn’t be able to do that!).

For the purpose of this example I just took the standard SharePoint 2010 master page contents.

• Open up SharePoint Designer and open the site you are working on

• Choose Master Pages on the left side

• Open v4.master

Don’t let SharePoint fool you. There is a default.master, but this is the old SharePoint 2007 master page that is used if you perform a visual upgrade. When creating a site in SharePoint 2010 the master page that will be used by default is v4.master. I know it’s a bit confusing, but if you have been working with SharePoint for a while you won’t be surprised by this.

• Copy the contents of v4.master and past them in your sample.master file in Visual Studio. Make the changes you want to.

• Note how the elements.xml file has changed to reference the sample.master rather than the sample.txt

The contents of the elements.xml file

• Make sure the module is added to a feature in your project that is scoped at the site (= site collection) level

• You could stop here and this solution will deploy your sample.master master page to the master page gallery of your site collection.

This will not apply the master page to the site collection when the feature gets activated though. It will only make it available for selection.

• If you the master page to be applied when the feature gets activated you right click on the Feature1 and you add an event receiver. This will add a feature receiver file to the feature.

• In this file we will add some code that will apply the sample.master master page when the feature gets activated and it will apply the v4.master when the feature gets deactivated.

• Code used in the feature receiver

• Now if you activate the feature the code in the feature receiver will run and will apply sample.master to the site. As you can see we change both the MasterUrl and the CustomMasterUrl. The MasterUrl is used on all pages that are not publishing pages. This means it is used on the pages in the sitepages library and on the pages in the _layouts directory like the settings page for instance. The CustomMasterUrl is only used on pages that are stored in the Pages library. This library is created when the SharePoint Server Publishing Infrastructure features is activated on the site collection and the SharePoint Server Publishing feature is activated on the site.

• You can also use the SharePoint user interface to apply a new master page. The Site Master Page is the equivalent of the CustomMasterUrl and the System Master Page is what the object model calls the MasterUrl.

Changing the master page using the SharePoint user interface

Guarantee job training for freshers on SharePoint Server 2010 @Bangalore

DataPoint Infotech is an IT Consulting, Training and software Development Company headquartered in Bangalore. We are Offering Job Guarantee Training for Fresher’s in Microsoft Technologies ASP.NET,C# and SharePoint Server 2010. The candidates who needs training from real time experts with a job assurance. Our experienced mentor will train you to become a software professional in 3 months.
Training Highlights:

• Training on SharePoint Server 2010 for a period of two months.
• Every 5 days mock tests and interviews conducted during training period.
•  Special attention on each participant.
•  One month real time project Training, which includes all phases [Software development Life cycle i.e. SDLC].
• Assistance to complete MCTS certifications on SharePoint Server 2010.
• We will refer all the trained Candidates to get jobs in MNC’s.
• Only 15 candidates allowed per a batch.
• 24/7 Lab Facility to work on assignments
•  Internet Facility provided.

Prerequisites: This course is designed for individuals with a basic understanding knowledge on Programming Languages.

 Fees: 55,000/- per candidate [Including Taxes].

Conditions:-

• Candidates should need to complete 3 months training.
• After completion of the training, candidates need to available to complete the real time project and to attend interviews from MNC’s.

 Best Regards,
 Venkat Ramavath,
 DataPoint Infotech,
 E-mail: venkat.ramavath@gmail.com
 Mob :+91-9916229967
 #1-24/5, 3rd Floor, S.P Mansion Building, Marathahalli,
 Bangalore , Karnataka, India
 website: http://www.datapointinfotech.com/

SharePoint server Applications Testing Interview Questions

 

Q. What are Various Tools available for SharePoint Testing?

Ans. Some of the Tool available for Testing are:

* SharePoint 2007 Test Data Population Tool (available at CodePlex)

* Sporm ( available at Codeplex)
* Can also Use Typemock Isolator for Testing sharePoint object model.

Q. How will you set up a Platform for Testing SharePoint WebParts?

Ans. We would need to install :

1. WSS 3.0

2. Microsoft Office SharePoint Server 2007 installed.

3. Windows Server 2003 or 2008.

4. Visual Studio 2005 or 2008.

Q. How would you plan Testing WebParts.

Ans. A Tester would need to verify by adding,deleting and moving webparts on a webpart page.Also, a Tester should verify the Web Part properties, Webpart ToolPane and that nothing fails on the Page.

Q. How will you Test the Performance of a SharePoint Website?

Ans. Various Tools are available in the market to do that. Some of them are

* Fiddler – a very handy and light weight tool that can provide quick overview of you web site performance. It can also records scripts that you can use in VSTS.

* neXpert - an add-on to Fiddler which automates the classic performance best practice checks and produces a HTML report on the issues found in a Fiddler capture.

* Visual Round Trip Analyzer - Web page performance visualizer and analyzer tool.

* Also, Can use SharePoint Capacity Planning * Also, Can use SharePoint Capacity Planning Tool from Microsoft.

 

Q. How would you plan Testing WebParts.

Ans. We can Test a SharePoint site for various customizations that will be done by a developers or a designers.

For e.g. some important steps for Testing Custom WebParts are:

* Verify that you can add the Web Part properly to a sharepoint page, and nothing fails.

* Verify that the Web Part handles all of its exceptions.

* Verify that the Web Part works correctly regardless of where the Web Part Page is located.

* Verify that the Web Part can access its resources in different setup configurations.

* Verify that Web Part properties displayed in the tool pane are user-friendly.

* Verify that the Web Part renders appropriately based on user permissions.

* Verify that the Web Part previews properly.

* Verify that adding several instances of the same Web Part to a Web Part Page (or in the same Web Part zone) works correctly.


Q. How would you Test Design and Layout changes in SharePoint?

Ans. Some of the changes that we need to check are :

* See if companies Logo is displayed correctly. Verify that it shows up on each and every page of the Site.

* Verify that every page in SharePoint including list and library pages(AllForms.aspx) uses the same master Page.

* Verify that the application Pages such as "settings.aspx" also inherit the company branding layout( or master Page).

* Verify that any page can be edited sucessufuly, and the user can add/remove webparts from the Page.

* Verify the any New page created, inherits the custom Branding Layout or master Page.

* Verify that the branding( master page or look and feel) or layout does not fail if a user adds a Content editor webpart with custom Css in the webpart.

* Verify design in Various browsers.

 

SharePoint server Applications Testing Interview Questions

 

Q. What are Various Tools available for SharePoint Testing?

Ans. Some of the Tool available for Testing are:

* SharePoint 2007 Test Data Population Tool (available at CodePlex)

* Sporm ( available at Codeplex)

* Can also Use Typemock Isolator for Testing sharePoint object model.


Q. How will you set up a Platform for Testing SharePoint WebParts?

Ans. We would need to install :

1. WSS 3.0

2. Microsoft Office SharePoint Server 2007 installed.

3. Windows Server 2003 or 2008.

4. Visual Studio 2005 or 2008.


Q. How would you plan Testing WebParts.

Ans. A Tester would need to verify by adding,deleting and moving webparts on a webpart page.Also, a Tester should verify the Web Part properties, Webpart ToolPane and that nothing fails on the Page.


Q. How will you Test the Performance of a SharePoint Website?

Ans. Various Tools are available in the market to do that. Some of them are

* Fiddler – a very handy and light weight tool that can provide quick overview of you web site performance. It can also records scripts that you can use in VSTS.

* neXpert - an add-on to Fiddler which automates the classic performance best practice checks and produces a HTML report on the issues found in a Fiddler capture.

* Visual Round Trip Analyzer - Web page performance visualizer and analyzer tool.

* Also, Can use SharePoint Capacity Planning * Also, Can use SharePoint Capacity Planning Tool from Microsoft.

 

Q. How would you plan Testing WebParts.

Ans. We can Test a SharePoint site for various customizations that will be done by a developers or a designers.

For e.g. some important steps for Testing Custom WebParts are:

* Verify that you can add the Web Part properly to a sharepoint page, and nothing fails.

* Verify that the Web Part handles all of its exceptions.

* Verify that the Web Part works correctly regardless of where the Web Part Page is located.

* Verify that the Web Part can access its resources in different setup configurations.

* Verify that Web Part properties displayed in the tool pane are user-friendly.

* Verify that the Web Part renders appropriately based on user permissions.

* Verify that the Web Part previews properly.

* Verify that adding several instances of the same Web Part to a Web Part Page (or in the same Web Part zone) works correctly.


Q. How would you Test Design and Layout changes in SharePoint?

Ans. Some of the changes that we need to check are :

* See if companies Logo is displayed correctly. Verify that it shows up on each and every page of the Site.

* Verify that every page in SharePoint including list and library pages(AllForms.aspx) uses the same master Page.

* Verify that the application Pages such as "settings.aspx" also inherit the company branding layout( or master Page).

* Verify that any page can be edited sucessufuly, and the user can add/remove webparts from the Page.

* Verify the any New page created, inherits the custom Branding Layout or master Page.

* Verify that the branding( master page or look and feel) or layout does not fail if a user adds a Content editor webpart with custom Css in the webpart.

* Verify design in Various browsers.

 

 

Windows Powershell Interview Questions for SharePoint 2010

Q. What is Windows Powershell ?

Ans. Windows PowerShell is a new Windows command-line shell designed especially for system administrators. In the SharePoint administration context, Windows PowerShell is another administration tool that supersedes the existing Stsadm.exe.
Q. How is Windows Powershell different from Stsadm ?

Ans. Unlike stsadm, which accept and return text, Windows PowerShell is built on the Microsoft .NET Framework and accepts and returns .NET Framework objects. In addition to that it also gives you access to the file system on the computer so that you can access registry,digital signature certificate etc..Q. What are cmdlet's?

Ans. Windows PowerShell introduces the concept of a cmdlet which are simple build in commands, written in a .net language like C# or VB.Q. Can you Create PowerShell scripts for deploying components in SharePoint ?

Ans. If you are creating a webpart with VS 2010 then you can deploy it using ctrl + f5. However, to activate the webpart feature you can write a powershell script (.ps1) and execute it after dpeloyment.
Q. Where is Powershell located in SharePoint ?

Ans. On the Start menu, click All Programs -> Click Microsoft SharePoint 2010 Products -> Click SharePoint 2010 Management Shell.
Q. If you need going to install a webpart or any custom solution in SharePoint 2010 using PowerShell What permissions do you need?

Ans. In order to use Windows PowerShell for SharePoint 2010 Products, a user must be a member of the SharePoint_Shell_Access role on the configuration and content database. In addition to this, the user must also be a member of the WSS_ADMIN_WPG local group on the computer where SharePoint 2010 Products is installed.
Q. How to list all the commands in PowerShell ?

Ans.
Get-Command * commands gets you all the Powershell commands. For more commands refer msdn site.