Tuesday 16 May 2017

15 Highest Paying Programming Languages In 2016

Java
With the motto “Write once, run anywhere,” Java has become a nearly ubiquitous concurrent language that can run on just about any platform imaginable, meaning developers who have mastered the language are always in high demand. Senior level Java developers can often expect salaries as high as $115,000.
Python
A highly versatile and very readable language, Python is used heavily by major players in the tech industry, such as Google and NASA, and senior-level Python developers can easily fetch a $100,000+ salary.
R
Otherwise known as GNU S, the R programming language is specialized for statistical computing and graphics development. Widely used by data miners and statisticians for data analysis, R can fetch some very high salaries exceeding $100,000, because the language is so specialized.
Objective-C
A modernized upgrade to its predecessor C, Objective-C is the main language used by Apple to develop its OS X and iOS platforms. It is used heavily by Apple for their APIs, Cocoa and Cocoa Touch. Because of Apple’s reliance on the language, Objective-C can fetch top-notch developers a salary that is close to six figures.

Swift
A relatively new language on the market as a streamlined companion to Objective-C, Swift has exploded in popularity recently as the main programming language for Cocoa and Cocoa Touch, Apple’s frameworks supporting iOS, OS X, watchOS, and tvOS. Demand and salaries are still on the rise for this young language, and Swift’s affiliation with Apple means a skillset that includes this language could easily earn six figures in the near future.
C#
Developed by Microsoft and part of the foundational family of C programming languages, C# (pronounced “see sharp”) is known for its simplicity and wide general usage. C# developers can easily earn a solid $90,000+ in salary.

JavaScript
As one of the three main technologies for World Wide Web content production, it should be no surprise that JavaScript developers are among the most in-demand on the market. Whether it’s running a website on any browser without the need for plugins, implementing site-specific browsers or developing desktop widgets, there’s always work for a JavaScript developer. A senior JavaScript developer can typically expect a salary of at least $90,000.
Perl
Technically a family of related languages, Perl is generally known best as a popular CGI scripting language and is also used for graphics programming, system administration, and even some financial applications. Salaries vary based on the specific use, but Perl’s versatility means its programmers are always in high demand and can often expect a salary of no less than $80,000.
C++
Another member of the famous C family, C++ is best known for being an efficient and flexible language that is used to develop large systems such as desktop applications and server platforms. A very well-known and reliable language, C++ can often fetch its developers a salary of at least $80,000.
SQL
Short for Structured Query Language, SQL is a special-purpose language whose main function in development is managing the data in databases and data streams. It has grown widely in popularity recently and can demand salaries well into the $80,000 range.
Ruby on Rails
Also known simply as “Rails,” Ruby on Rails has earned a very respectable reputation in recent years for its popular default structures for databases, web services and web pages. A Ruby on Rails job can consistently haul in a healthy salary of $75,000+.
C
Famous for the original “Hello, World!” program, C is one of the bedrock languages of modern computing and remains an incredibly useful language for efficiently mapping machine instructions for applications and operating systems. As it’s one of the most widely-known languages of all time, C developers are always in high demand, with salaries typically ranging anywhere from $60,000-$80,000.
PHP
Most often used specifically for server-side functions like web development, PHP has grown tremendously in popularity in recent years. Its web-facing features make it a highly-demanded skill, and PHP developers can easily claim salaries of over $75,000.
T-SQL
Short for Transact-Structured Query Language, T-SQL is closely related to its predecessor, SQL, serving as the main line of communication with the SQL server for any application’s user interface. T-SQL is a very specific language that requires a certain skillset, so while it may not be in as high demand as some other language, specialists still get compensated well for mastery of the language and can pull in an average salary of over $70,000.
Ruby
Not to be confused with Ruby on Rails, Ruby is a sophisticated, modernized take on classic languages like C and PERL that emphasizes simplicity through natural syntax and easy-to-read code. Its broad appeal means even entry level developers can fetch salaries pushing $60,000, and senior level developers can earn salaries close to six figures.
It’s well documented that there is a shortage of top tech talent in the market, so no matter which of these highly lucrative languages you choose to tackle, you can’t go wrong. Start mastering one of these languages now and rest assured that your skillset will be in high demand.

Thursday 25 June 2015

What are the most important things to learn in web development as of 2015?

If you are web development then you must know following.

Front End Developer
1. HTML5, CSS3, JavaScript, Jquery
2. JS Framework- angular
3. UI library- Semantic UI, Bootstrap, Foundation, Polymer
4. Front End Tools - Gulp, Grunt, Bower
5. CSS preprocessor - LESS, SAAS, Stylus
6. JS preprocessor - CoffeeScript, TypeScript, LiveScript
7. Asynchronous - Ajax

Back End Developer
1. PHP, Python, Ruby
2. Backend Framework -
               PHP - Symfony, Laravel, Nette, Zend, CodeIgniter
               Ruby - Ruby On Rail
               Python - django
               JavaScript - Node.js, Express.js, Total.js, Sails.js, Meteor.js
 3. Database - MySQL, MongoDB, PostgressSQL, MariaDB

Code Quality
1. TypeSystems - FlowTyped, TypeScript
2. Testing - Mocha, qunit
3. Quality - jslint

Summary
This is latest list for development but you can also need to learn ASP.NET, Java, MS SQL Server etc
             

Thursday 28 May 2015

How to insert 1000 rows at a time

How to insert 1000 rows at a time

Create a table, suppose Status in which two columns first Id with Identity and another one is value.

CREATE TABLE Status
(
    ID INT IDENTITY(1,1),
   Value INT
)

Now Insert data into table Status

DECLARE @ID INT
SELECT @ID = 1
WHILE @ID>=1 AND @ID<=1000
BEGIN
  INSERT INTO Status VALUES(1)

END

Results:



Wednesday 27 May 2015

UNION and UNION ALL

UNION and UNION ALL

UNION allows to combine the results of two or more TABLE using SELECT statement into a single result set.

You can use UNION on table that have same structure to get results like they must have the same number of columns and columns must have compatible data types

by default, UNION removes duplicate rows from the result set but if you use ALL (UNION ALL) then all rows are included in the results and duplicates are not removed

When UNION is used, the individual SELECT statement cannot have their own ORDER BY or COMPUTE clause
but There can be only one ORDER BY or COMPUTE clause after the last SELECT statement.

Syntax:
select_statement UNION [ALL] select_statement

CREATE TABLE  FY1
(CustomerNo INT PRIMARY KEY,
 OrderAvg_FY1 INT,
 OrderCount_FY1 INT)

INSERT INTO FY1 VALUES(0155, 300, 7),
(0133, 700, 6),
(0144, 200, 2)

CREATE TABLE  FY2
(CustomerNo INT PRIMARY KEY,
 OrderAvg_FY2 INT,
 OrderCount_FY2 INT)

INSERT INTO FY2 VALUES(0155, 100, 2),
(0130, 500, 4),
(0144, 20, 1),
(0011, 25, 3)


SELECT *FROM FY1
UNION
SELECT *FROM FY2

Results:




















and result set of UNION ALL are:



Tuesday 19 May 2015

What is RDBMS?

Relational DataBase Management System (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd. In RDBMS relationships maintained throughout the data and tables.
                                                                                           
RDBMS is the base for SQL and all latest database system like MS SQL Server, Oracle, MySQL MS Access.  Data in RDBMS is stored in database called tables.


There are the following categories of data integrity exist with each RDBMS:

Entity integrity
It specifies that there should be no duplicate rows in a table.

Domain integrity
It enforces valid entries for a given column by restricting the type, the format, or the range of values.

Referential integrity
It specifies that rows cannot be deleted, which are used by other records.

User-defined integrity
It enforces some specific business rules that are defined by users. These rules are different from entity, domain or referential integrity.



Although DBMS and RDBMS both are used to store information in physical database but there are some remarkable differences between them.

Difference between DBMS and RDBMS

You can also read other differences:

The main differences between DBMS and RDBMS are given below:

1. In DBMS, applications store data as file while in RDBMS applications data store in tables.

2. In DBMS, Data is generally stored in either heirarchical form or navigational form while in RDBMS, the tables have an identier called primary key and the data values are stored in the form of tables.

3. In DBMS, there is no Normalization while in RDBMS Normalization applies on tables

4. DBMS does not apply any security with regards to data Manipulation While in RDBMS defines the integrity constraint for the purpose of ACID(Atomicity, consistency, Isolation and Durability) property.

5. DBMS uses files system to store data, so there will be no relation between the tables while in RDBMS, data values are stored in the form of tables, so a relationship between these data values will be stored in the form of a table as well
6. DBMS has to provide some uniform methods to access the stored information
while RDBMS system supports a tabular structure of the data and a relationship between them to access the stored information
7. DBMS does not support distributed database
while RDBMS supports distributed database

8. DBMS is meant to be for small organization and deal with small data. it supports single user
while RDBMS is deigned to handle large amount of data. it supports multiple uses
9. Examples of DBMS are file systems, xml etc. and RDBMS example are mysql, postgres, sql server, oracle etc.





Saturday 16 May 2015

Top skill to get your dream jobs

Here I am listing Top skill to get your dream jobs. Currently many technology used in market but these technology are latest and mostly related to Business Intelligence.

1. PaaS
2. MapReduce
3. Cassandra
4. Cloudera
5. Hbase 
6. Pig 
7. ABAP 
8. Chef 
9. Flume 
10. Hadoop 

11. Puppet
12. NoSQL
13. Zookeeper

14. SOA
15. Data Architect
16. Solr
17. Data Scientist
18. Big Data
19. OpenStack
20. CMMI
21. R
22. CloudStack
23. OmniGraffle
24. Arista
25. Documentum
26. UML
27. Sqoop
28. JDBC
29. RDBMS