The purpose of ORDER BY keyword is used to sort the results in descending or ascending order
e.g SELECT * FROM Users
ORDER BY State DESC;
e.g SELECT * FROM Users
ORDER BY State ASC;
or
SELECT * FROM Users
ORDER BY State;
What is difference between select and select distinct
What is the difference between select and select distinct
SELECT DISTINCT statement is used for returning only distinct (different) values from a column.
SELECT statement is used for returning all the values in the table column.
E.g SELECT States FROM Customers;
E.g SELECT DISTINCT States FROM Customers;
Summary of SQL – Please click here
String reverse using java script split method
Assume given string ‘str’ value is “welcome”
function stringRev(str) {
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]
// Use join() method to join the elements of the array into a string as below in comments
var joinArray = arrayReverse .join(“”); // [“e”, “m”, “o”, “c”, “l”, “e”, “w”] to “emoclew”
//Return the reversed string
return joinArray; // “emoclew”
}
stringRev(‘welcome’);
String reverse in java script using decrementing For-loop
Assume given string ‘str’ value is “welcome”
function stringRev(str) {
var stringOne = “”;
for (var i = str.length – 1; i >= 0; i–) {
stringOne = stringOne + str[i];
}
return stringOne; // “emoclew”
}
stringRev(‘welcome’);
var stringOne = “”;
for (var i = str.length – 1; i >= 0; i–) {
stringOne = stringOne + str[i];
}
return stringOne; // “emoclew”
}
stringRev(‘welcome’);
Differences between SQL and PL/SQL
PL/SQL is procedural language where s SQL is data oriented language.
PL/SQL purpose is to create applications but SQL is data manipulator and reviewer
PL/SQL executions works at block of code level while SQL execution is per statement at a time.
PL/SQL servers for building, formatting and display application screens but SQL sources data for that screens.
PL/SQL is procedural based and instructs database on how to do but SQL is declarative level which helps database on what to do.
PL/SQL purpose it to code program blocks, procedures, triggers, functions, and packages but SQL is used to code queries, DCL, DML and DDL statements
SQL can be subset of PL/SQL but PL/SQL can not be subset of SQL
Popular databases or filesystems that uses SQL – Please click here
Defect priority and severity
Severity indicates the seriousness of the defect.
Severity types are Critical, Major, Moderate, Minor, Cosmetic
Priority indicates how quickly the defect needs to be fixed.
Priority types are High, Medium, Low.
Low Severity and Low Priority: A cosmetic error in a page which is not important to users.
High Severity and High Priority: An error in the login feature which does not allow user to login to application or a server error in the web application.
Low Severity and High Priority : The spelling mistakes that happens on the cover page or heading or title of an application.
High Severity and Low Priority: A page access error which page is rarely used by users.
Popular databases or filesystems that uses SQL
1. MySQL
2. Oracle
3. PostgreSQL
4. MS SQL Server
5. SQLite
6. Dbase
7. Hadoop
8. MaxDB
9. MariaDB
10. Openbase
What is Apex?
Apex is a programming language for salesforce (only)
-
- Object Oriented Program, in which the data types have to defined.
- Allows developers for flow execution in force.com platforms.
- Enables developers to add business logic to most system events including button clicks, related record updates and visualforce pages.
Datatypes in Apex
- Primitives
Apex primitives include the following datatypes.
- Integer
- Boolean
- Decimal
- Double
- Date
- Date Time
- Time
- String
- Long
- ID- Any valid salesforce.com Id.
- sObjects
- Any object that can be stored in force.com platform database.
- sObject variable unlike primitive variable refers to row of data in salesforce. That is a complete record as a variable.
What is Salesforce
Salesforce.com is an American cloud computing company.
Salesforce offers Software as a Service (SaaS) platform which helps in Customer Relationship Management.
It has a multi-tenant architecture and subscriptions.
The following are the application clouds in Salesforce CRM.
1. Sales Cloud
2. Service Cloud
3. Marketing Cloud
4. Data cloud
5. App Cloud
6. Analytics Cloud
7. Community Cloud
2. Service Cloud
3. Marketing Cloud
4. Data cloud
5. App Cloud
6. Analytics Cloud
7. Community Cloud
Salesforce also offers Platform as a Service (PaaS) using Force.com sites.
People involved in Salesforce Implementation
1. End User ( Customer)
2. Administrator
3. Developer
4. Consultant
1. End User ( Customer)
2. Administrator
3. Developer
4. Consultant
The following are the list of Salesforce Certifications.
1. Certified Administrator
2. Certified Advanced Administrator
3. Certified Sales Cloud Consultant
4. Certified Service Cloud Consultant
5. Certified Force.com Platform App Builder
6. Certified Force.com Platform Developer I
7. Certified Force.com Platform Developer II
8. Certified Technical Architect
2. Certified Advanced Administrator
3. Certified Sales Cloud Consultant
4. Certified Service Cloud Consultant
5. Certified Force.com Platform App Builder
6. Certified Force.com Platform Developer I
7. Certified Force.com Platform Developer II
8. Certified Technical Architect
How to change numbers to zero
How to change numbers to zero – refer below code:
Dim i
Dim j
Dim output
objStr= “1234567890”
j = 0
For i = 1 to 9
output =output&replace(objStr,i,j)
Next