The amazing Salesforce platform allows us to create public website even with developer edition of the platform. The website address will be either SubDomainPrefix.force.com or www.YourCustomDomain.com. This is my public website created using Developer Edition. The major limitation I found for a force.com public website is the 500MB of daily bandwidth and ability of creating only one website.
Reference: An Intro to force.com + steps for creating your own website in a few minutes, Force.com sites overview – contains more details about possible custom domain options, Force.com Public Website implementation guide
APEX test classes are marked with @isTest annotation and it has an added benefit – the class will not be counted against 3MB organization code size limit.
Here is 3 very simple yet very effective questions which can be asked from Client while understanding Business Requirements for building IT solutions:
What is your Vision & Goal?
What are your pain points?
Who all are the key players/ stakeholders?
A nice article answering your Questions here.
Salesforce dataloader is an easy to use graphical tool which installs on your local computer, connects to your Salesforce Instance and can populate your data (CSV, Excel, MS-Access) in Salesforce Instance and can also export your Salesforce data in these formats.
An easy-to-use wizard interface
An alternate command line interface
A batch mode interface with database connectivity
Support for large files with up to millions of rows
Drag-and-drop field mapping
Support for all objects, including custom objects
Detailed success and error log files in CSV format
A built-in CSV file viewer
Supported on Windows 7 and Windows XP, though an unofficial OS X version is also available
Reference: Dataloader Technical Library
Database development traditionally hasn’t used source control at all, as a result there has been challenges in maintaining Change Control Versions. But now it is possible and very convenient as well. Read on this article and Download the free Ebook.
I have been looking for a way to synchronize Salesforce data to SQL Server and I find Informatica to be the thing I have been looking for. It installs on your Salesforce instance (native Salesforce App) and an connect to SQL Server to import/export data. It requires Secure Agent to be installed on your computer (available for Windows and Linux). The Secure Agent is easy to install. It allows you to integrate on premise applications, cloud applications and local files.
I am not sure as of now, if SQL Server have any feature which could directly connect to Salesforce and could synchronize Salesforce data in SQL Server database. It would be a must ask question for me in coming SQL Server Event in Gurgaon.
There are many ways to write and execute SOQL (Salesforce Object Query Language) in Salesforce such as Workbench. Just login using your Salesforce Credentials (you have access to Workbench) and start writing and executing SOQL queries. You may either use the query wizard or can directly write query in SOQL query box and execute the same. Some of the sample SOQL queries are below.
A simple SELECT statement:
SELECT AccountNumber, AccountSource FROM Account
This query is valid in most of the database query languages such as SQL but it is invalid for SOQL:
SELECT * FROM Account (This is a invalid query in SOQL)
WHERE clause with numeric check:
SELECT ActualCost,AmountAllOpportunities,AmountWonOpportunities,BudgetedCost FROM Campaign where Actualcost=11400
WHERE clause with string check:
SELECT ActualCost, AmountAllOpportunities, AmountWonOpportunities, BudgetedCost, Description, Name FROM Campaign where Name = 'GC Product Webinar - Jan 7, 2002'
SELECT ActualCost, AmountAllOpportunities, AmountWonOpportunities, BudgetedCost, Description, Name FROM Campaign where Name like '%GC Product%'
Using built-in functions:
SELECT Min(BudgetedCost), Max(BudgetedCost) FROM Campaign