A Good Time To Be a DBA

[seedinfotech-blog]

Why one should learn Java Programming?

Many graduate often ask me, which is the best programming language, which language should we learn, shall I learn Java etc. Well, it depends upon definition of your best programming language, if it’s popularity then obviously Java outscore everyone. There is a long list of programming languages that continue to exist with their strengths and flaws, making our lives easier. However, I strongly don’t believe in any type of competition between different programming languages. Java is one of the best programming language created ever, and I am not saying this because I am a passionate about Java, but Java has proved it in last 20 years. During its journey, this free and open source programming language has achieved numerous milestones and proved its worth. The recent indexes of programming languages popularity have once again reinforced that Java is one of the most popular languages around.

In this blog, I will share my list of reason, and why you should learn Java programming and make a career out of it.

Java is Object Oriented Programming language. Java is a general-purpose programming language that can run on virtually any type of computer and is independent of both device and platform. It promised “Write Once, Run Anywhere” (WORA), providing no-cost run-times on popular platforms. Fairly secure and featuring configurable security, it allowed network- and file-access restrictions.  J2EE included technologies and APIs for enterprise applications typically run in server environments, while J2ME featured APIs optimized for mobile applications.

Java’s latest major release is the platform standard edition 8. Its features include improve developer productivity and app performance through reduce boiler plate code, improve collection and Annotations. There are few below facts of Java

Nearly 9 of every 10 computers in the US runs Java.

3 Billion Devices run Java

There are 9 million java developers worldwide.

1 Billion Java Downloads per Year

Java is everywhere on all platforms and devices and in all countries around the world. It enables developers to make programs work just about anywhere. And it inspired the evolution of an incredible technology community. The brilliance of Java is the platform independency. Java allows you to build applications, develop Android apps, deploy applications, integrate robust libraries, and create sophisticated GUIs. Back-end web developers, especially in industries where you need high performance and security—like finance, healthcare, and even the gaming industry.

Java developers design, develop, code and test computer software based on Java technology. Apart fromJava programming, Java developers may also be required to debug and maintain existing code, perform software builds and releases and create automated test scripts. For a Java developer, having strong understanding on Object Oriented Programming is a must. Without having a strong foundation on OOPS, one can’t realize the beauty of an Object Oriented Programming language like Java.

Integrated Development Environment (IDE) such as Eclipse and Net beans made Java development much easier, faster and fluent. It’s easy to search, refactor and read code using IDEs. Apart from IDE, Java platform also has several other tools e.g. Maven and ANT for building Java applications. Apache, Google, and other organization has contributed lot of great libraries, which makes Java development easy, faster and cost effective.Community is the biggest strength of Java programming language and platform. Java has been very lucky, it has lots of active forums, Stack overflow, open source organizations and several Java user group to help everything.

Java is free from start, i.e. you don’t need to pay anything to create Java application. This FREE thing also helped Java to become popular among individual programmers, and among large organizations. Availability of Java programmers is another big think, which makes organization to choose Java for their strategic development .

What is the future of Java and Java Jobs? Basically, Java is not just a Programming language but it is a programming atmosphere to develop and deploy enterprise applications. It is important for information technology industry to develop and create multiple web-based or server based applications to enhance the industrial competency. There is huge scope for this programming language.If one talks about job opportunities in field of Java, knowledge of it is required with many new technologies and roles such as ‘Java-UI Developers’, ’Android Developers’ and many others. Hence, there are numerous jobs opportunities available in Java, J2EE combining with other new technologies. These are among the higher paid jobs in IT industry, as it comes under software development. One should have the proficient skills to get an employment with IT organizations as many organizations are looking for the professionals, who can manage multiple projects in J2EE and augments the industrial efficiency.The best part about Java is, its eco-system is self-sustaining, from mobility (Android) to middleware (Hadoop), it impacts everything and will continue to make a big impact in future too. Java remaining a developer favorite good reason its secure robust and relativity simple.

Java’s popularity with developers is due to the fact that the language is grounded in readability and simplicity. Java has staying power since it has long-term compatibility, which makes sure older applications continue to work now into the future. It’s not going anywhere anytime soon and is used to power company websites like LinkedIn.com, Netflix.com and Amazon.com.

So, are you interested in designing your career successfully Java Programming Language? At SEED Infotech, we offer courses that enable you to have a sound career in professional courses.

[seedinfotech-blog]

Big Data – Hadoop is buzzword today

Almost every business organization from all sectors and technical professional from all type of industry is becoming interested for knowing Big Data. Hence many technical professionals are trying to get answer of some key questions what exactly is Big Data? Why is it required? Which are Big Data technologies? How is this field different from our traditional data technologies field?

Today market is widely open for Big Data and employers are looking for professionals who have assimilated Big Data related skills.  Many students and professional aspirants of Big Data skills have questions like what are job opportunities in Big Data. What is market trend for Big Data? Which are pre-requisite for learning Big Data technologies?  Which key skills are required? What is future of Big Data technologies?

Let’s understand answers of these all these questions.

Big Data means collection of large data sets in terms of Terabytes, PB, ZB, etc. According to information published, Facebook stores, accesses, and analyzes more than 30 Petabytes of user generated data. Wal-Mart handles more than 1 million customer transactions every hour. In 2008, Google was processing 20,000 terabytes of data (20 petabytes) a day. More than 5 billion people are calling, texting, tweeting and browsing on mobile phones worldwide. YouTube users upload 48 hours of new video every minute of the day. According to Twitter’s own research in early 2012, it sees roughly 175 million tweets every day, and has more than 465 million accounts. 100 terabytes of data uploaded daily to Facebook.

If you look at above statistics, the amount of data generated is huge (volume) at very high rate (velocity) and the kind of data being generated is in the form of structured data (relational data), semi-structured (xml) and most of data generated is real-time and unstructured like documents, text, pdf, media logs, web logs.  Hence one can easily understand that our traditional data management systems RDBMS totally fail to store manage, process such different variety of data at high speed.

Hence ultimately questions raises which are technologies available today in the market to manage such large data sets? The key answer is big data technology – Hadoop.

Hadoop is open source big data project of Apache Software Foundation. It is used to store and process big data in a distributed environment across clusters of computers using simple programming model called MapReduce. It can scale up from single servers to thousands of machines, each offering local computation and storage. Hadoop runs applications using the MapReduce algorithm, where the data is processed in parallel on different CPU nodes.

Hadoop framework is written in java language. Hadoop gives solution not only to process data but also to capture, transfer, store and distribute the data over the thousands of machines of commodity servers as a part of Hadoop clusters.

HDFS (Hadoop Distributed File System) core part of Hadoop stores large data sets of any size (PB, ZB) in terms of data blocks over the clusters. It is rather a data service, thereby makes data always available. Though any machine as a part of cluster is failed, you can dynamically remove the machine from cluster and add new machine to cluster. Replication mechanism is the key of HDFS.

MapReduce Framework another core part of Apache Hadoop is used to process the data locally on each machine over the cluster. MapReduce has two tasks, first is Map tasks and Reduce task. Map tasks run parallel on all the machine where data is stored and reduce tasks is used for aggregating the data from all map tasks. Hence reduce tasks always run after the map tasks.

The top five industries which are looking for Big Data-related skills are Professional, Scientific and Technical Services, IT, Manufacturing, Finance, Insurance and Retail. Many major IT giant like Google, Apple, Facebook, Amazon, Oracle, IBM, Adobe, Cisco, and Accenture are using Hadoop and looking for Big Data – Hadoop professionals.

Different job titles available today are

Hadoop Developer

Data Scientist

Big Data Engineer

Data Visualization Developer

Business Intelligence (BI) Engineer

BI Solutions Architect

Analytics Manager

According to marketresearch by IDC, the big data market is expected to grow from $3.2 billion in 2010 to $16.9 billion in 2015. According to the IDC forecast, the Big Data market is predicted to be worth $46.34 billion by 2018 and is expected to have a sturdy growth across Big Data related infrastructure, software and services over the next five years.According to IDG Enterprise Big Data Research, in the next 1 to 1.5 years, organizations plan to invest in skill sets necessary for Big Data deployments, including Data Scientists, Data Architects, Data Analysts, Data Visualizers, Research Analysts, and Business Analysts.

So you may have questions which are pre-requisite to learn Big Data – Hadoop. Let me help you out. One should have knowledge of Java, SQL and Linux Programming. Additionally if you have good analytical skills, statistical knowledge, awareness of business processes, then it can be value added advantages.

So now Big Data is an important career option which can change your career life. Big Data job opportunities are open for all right from fresher to experienced one who possess necessary skills. Hence at any point if you want any help in choosing big data as your career option, kindly drop me the mail at ‘[email protected]’.

[seedinfotech-blog]

Collection Framework in C#.Net

Many a times closely related objects can be handled effectively by creating their group. This is achieved in C# by using collections. There are two ways which we can use for grouping the objects together.

1.         By creating array of objects

2.         By creating collection of objects.

Arrays are most useful for creating and working with a fixed number of elements of the same data type

Collections provide a more flexible way to work with groups of objects. Unlike arrays, the group of objects you work with can grow and shrink dynamically as the needs of the application change. For some collections such HashTable  or Dictionary, you can assign a key to any object that you add to the collection so that you can retrieve the object by using the key. Read More...

[seedinfotech-blog]

India churns out tens of thousands of graduates each year, but nearly half of them are “unemployable” or do not possess the basic skills necessary for any industry role. Amongst those who get the jobs, close to 40 percent are involved in clerical jobs which do not exactly do justice to their educational qualification. The grim situation gets grimmer for IT Engineers. Reliable reports suggest that almost 83 percent of them fail to meet the ‘criteria of employability’

Current State Of Graduate Employment:

India churns out tens of thousands of graduates each year, but nearly half of them are “unemployable” or do not possess the basic skills necessary for any industry role. Amongst those who get the jobs, close to 40 percent are involved in clerical jobs which do not exactly do justice to their educational qualification. The grim situation gets grimmer for IT Engineers. Reliable reports suggest that almost 83 percent of them fail to meet the ‘criteria of employability’.

SEED Employability Matrix: SEED Infotech, through our extensive research and experience over a span of 2 decades have created a SEED Employability Matrix which identifies the skills & abilities any job aspirant must possess to get employment ready.

Robust Educational Qualification

Right attitude.

Strong Interest & Aptitude in their chosen area of specialization.

Effective communication skills.

Strong Technical Foundation and Technology Specialization in one stream.

Global technology principal certification.

Knowledge of relevant industry practices.

Demonstrable industrial work/project experience.

Interview Preparedness.

SEED Infotech does provide end-to-end solutions & support to students in gaining all the skills & abilities covered in the SEED Employability Matrix. Here are a few case studies illustrating our beyond the obvious approach towards Employability Enhancement.

[seedinfotech-blog]

India churns out tens of thousands of graduates each year, but nearly half of them are “unemployable” or do not possess the basic skills necessary for any industry role. Amongst those who get the jobs, close to 40 percent are involved in clerical jobs which do not exactly do justice to their educational qualification. The grim situation gets grimmer for IT Engineers. Reliable reports suggest that almost 83 percent of them fail to meet the ‘criteria of employability’

Current State Of Graduate Employment:

India churns out tens of thousands of graduates each year, but nearly half of them are “unemployable” or do not possess the basic skills necessary for any industry role. Amongst those who get the jobs, close to 40 percent are involved in clerical jobs which do not exactly do justice to their educational qualification. The grim situation gets grimmer for IT Engineers. Reliable reports suggest that almost 83 percent of them fail to meet the ‘criteria of employability’.

SEED Employability Matrix: SEED Infotech, through our extensive research and experience over a span of 2 decades have created a SEED Employability Matrix which identifies the skills & abilities any job aspirant must possess to get employment ready.

Robust Educational Qualification

Right attitude.

Strong Interest & Aptitude in their chosen area of specialization.

Effective communication skills.

Strong Technical Foundation and Technology Specialization in one stream.

Global technology principal certification.

Knowledge of relevant industry practices.

Demonstrable industrial work/project experience.

Interview Preparedness.

SEED Infotech does provide end-to-end solutions & support to students in gaining all the skills & abilities covered in the SEED Employability Matrix. Here are a few case studies illustrating our beyond the obvious approach towards Employability Enhancement.

[seedinfotech-blog]

How SEED Infotech Enhances Employability!

Current State Of Graduate Employment:

India churns out tens of thousands of graduates each year, but nearly half of them are “unemployable” or do not possess the basic skills necessary for any industry role. Amongst those who get the jobs, close to 40 percent are involved in clerical jobs which do not exactly do justice to their educational qualification. The grim situation gets grimmer for IT Engineers. Reliable reports suggest that almost 83 percent of them fail to meet the ‘criteria of employability’.

SEED Employability Matrix:

SEED Infotech, through our extensive research and experience over a span of 2 decades have created a SEED Employability Matrix which identifies the skills & abilities any job aspirant must possess to get employment ready.

i. Robust Educational Qualification

ii. Right attitude.

iii. Strong Interest & Aptitude in their chosen area of specialization.

iv. Effective communication skills.

v. Strong Technical Foundation and Technology Specialization in one stream.

vi. Global technology principal certification.

vii. Knowledge of relevant industry practices.

viii. Demonstrable industrial work/project experience.

ix. Interview Preparedness.

SEED Infotech does provide end-to-end solutions & support to students in gaining all the skills & abilities covered in the SEED Employability Matrix. Incorporated in 1994, SEED Infotech is India’s one of the leading solution providers in Information Technology Training, Staffing and Products & Tools Consulting services to both Retail ( i.e. students, professionals and individuals) and Corporate customers.

With our headquarters in Pune, one of the IT hubs of India, our activities are spread over many locations in the state of Maharashtra and other IT Metros in India like Bangalore, New Delhi, Chennai etc.

We are an ISO 9001:2008 certified organization that operates through well-defined systems and procedures.

A formidable team of over 600 qualified professionals, 48+ training locations in India, and strong associations with Global Technology Leaders such as Microsoft, Oracle, RedHat, Salesforce, SAP, HP, Hortonworks, Peoplecert and EC-Council and testing & assessment services through Prometric, Pearson-Vue, Kryterion, etc. are undoubtedly our core strengths.

As a R.E.P., SEED Infotech has been approved by Project Management Institute (PMI) to issue Professional Development Units (PDUs) for its training courses.

Excellent Placement Record

SEED Infotech has an enviable placement record since its inception. Every year we create around 50,000 new job opportunities through various Mega Job Fests and Pool Campuses across the country.

[seedinfotech-blog]

NoSQL : Database of Future

Most of you are already familiar with SQL database, and have a good knowledge on MySQL, Oracle, or other SQL databases. But now a days, the approach of developers towards the NoSQL oriented database is increasing in industry.

Relational and NoSQL data models are very different. The relational model takes data and separates it into many interrelated tables that contain rows and columns. Tables reference each other through foreign keys that are stored in columns as well.  When looking up data, the desired information needs to be collected from many tables (often hundreds in today’s enterprise applications) and combined before it can be provided to the application. Similarly, when writing data, the write needs to be coordinated and performed on many tables.

A Scenario : Social Gaming

Social games are data-intensive applications that can explode from zero to millions of players literally overnight. That kind of rapid growth, both in terms of data volume and number of users, necessitates the right class of database to store all that information and scale to a growing user base.

To store this data rapidly, in traditional SQL database, a developer really need to invest lot of coding standards and it will becomes very difficult to manage such scenario using SQL as it requires a constant and rapid updates in data. It is often observed that in such cases the performance will be key issue. NoSQL provides scalability, consistently high performance, always-on 24×365 operations and a flexible data model to resolve this. Some of the most popular social and mobile games come from the likes of Zynga, Electronic Arts, Tencent and Shuffle Master, which are all powered by NoSQL.

To go through the concept of NoSQL, one really has to know JSON.

JSON is short for JavaScript Object Notation, and is a way to store information in an organized, easy-to-access manner. In a nutshell, it gives us a human-readable collection of data that we can access in a really logical manner.

The following example stores information of “book” in JSON format :

{

“book”: [

{

"id":"01",

"language": "Java",

"edition": "third",

"author": "Herbert Schildt"

},

{

"id":"07",

"language": "C++",

"edition": "second"

"author": "E.Balagurusamy"

}]

}

Traditionally this language in-dependant, light-weight data can be stored in XML format, but JSON has some advantages over XML

1)JSON requires less tags than XML – XML items must be wrapped in open and close tags whereas JSON you just name the tag once 2)Because JSON is transportation-independent, you can just bypass the XMLHttpRequest object for getting your data. 3)JavaScript is not just data – you can also put methods and all sorts of goodies in JSON format. 4)JSON is better at helping procedural decisions in your JavaScript based on objects and their values (or methods). 5)You can get JSON data from anywhere, not just your own domain. 6)JSON is easier to read than XML – Obviously a personal preference

NoSQL databases have a very different model. For example, a document-oriented NoSQL database takes the data you want to store and aggregates it into documents using the JSON format. Each JSON document can be thought of as an object to be used by your application. A JSON document might, for example, take all the data stored in a row that spans 20 tables of a relational database and aggregate it into a single document/object. Aggregating this information may lead to duplication of  information, but since storage is no longer cost prohibitive, the resulting data model flexibility, ease of efficiently distributing the resulting documents and read and write performance improvements make it an easy trade-off for web-based applications.

NoSQL is a whole new way of thinking about a database. NoSQL is not a relational database. The reality is that a relational database model may not be the best solution for all situations. The easiest way to think of NoSQL, is that of a database which does not adhering to the traditional relational database management system (RDMS) structure. Sometimes you will also see it revered to as ‘not only SQL’.

It is not built on tables and does not employ SQL to manipulate data. It also may not provide full ACID (atomicity, consistency, isolation, durability) guarantees, but still has a distributed and fault tolerant architecture.

Over the years, the implementation of NoSQL in increasing through different databases and currently around 150 databases are available in industry which are following the NoSQL concept.

Following are some of commonly used databases :

a.Hadoop b.Hypertable c.MongoDB d.CouchDB

[seedinfotech-blog]

Oracle Development Training helps Avadhut to get job at Fujistu

SEED Infotech is an Oracle Workforce Development Program Partner. As a Oracle WDP training partner, we conduct training and certification programs for students & professionals on Oracle Technologies. Learn Oracle 11g Developer from experts: • Build robust and scalable Oracle 11g database applications • Establish a data model and a storage framework • Develop powerful and efficient SQL statements • Write reusable structured PL/SQL code with cursors, procedures and triggers • Improve application performance by utilizing indexes and optimizing PL/SQL

[seedinfotech-blog]

This course provide coverage of Hardware & Networking Courses

This course provides coverage of basic electronics, computer hardware, Windows administration with virtualization, Cisco Networking on LAN and WAN and basic understanding of LINUX Servers , it also  provides students with a solid Foundation in the Information Technology-IMS field in order to pursue more advanced computer related courses.

 Hardware & Networking Courses:-

 PC Hardware Maintenance Professional

PC Networking Professional

[seedinfotech-blog]

NoSQL : Database of Future

Most of you are already familiar with SQL database, and have a good knowledge on MySQL, Oracle, or other SQL databases. But now a days, the approach of developers towards the NoSQL oriented database is increasing in industry.

Relational and NoSQL data models are very different. The relational model takes data and separates it into many interrelated tables that contain rows and columns. Tables reference each other through foreign keys that are stored in columns as well.  When looking up data, the desired information needs to be collected from many tables (often hundreds in today’s enterprise applications) and combined before it can be provided to the application. Similarly, when writing data, the write needs to be coordinated and performed on many tables.

A Scenario : Social Gaming

Social games are data-intensive applications that can explode from zero to millions of players literally overnight. That kind of rapid growth, both in terms of data volume and number of users, necessitates the right class of database to store all that information and scale to a growing user base.

To store this data rapidly, in traditional SQL database, a developer really need to invest lot of coding standards and it will becomes very difficult to manage such scenario using SQL as it requires a constant and rapid updates in data. It is often observed that in such cases the performance will be key issue. NoSQL provides scalability, consistently high performance, always-on 24×365 operations and a flexible data model to resolve this. Some of the most popular social and mobile games come from the likes of Zynga, Electronic Arts, Tencent and Shuffle Master, which are all powered by NoSQL.

To go through the concept of NoSQL, one really has to know JSON.

JSON is short for JavaScript Object Notation, and is a way to store information in an organized, easy-to-access manner. In a nutshell, it gives us a human-readable collection of data that we can access in a really logical manner.

The following example stores information of “book” in JSON format :

{

“book”: [

{

"id":"01",

"language": "Java",

"edition": "third",

"author": "Herbert Schildt"

},

{

"id":"07",

"language": "C++",

"edition": "second"

"author": "E.Balagurusamy"

}]

}

Traditionally this language in-dependant, light-weight data can be stored in XML format, but JSON has some advantages over XML

JSON requires less tags than XML – XML items must be wrapped in open and close tags whereas JSON you just name the tag once

Because JSON is transportation-independent, you can just bypass the XMLHttpRequest object for getting your data.

JavaScript is not just data – you can also put methods and all sorts of goodies in JSON format.

JSON is better at helping procedural decisions in your JavaScript based on objects and their values (or methods).

You can get JSON data from anywhere, not just your own domain.

JSON is easier to read than XML – Obviously a personal preference

NoSQL databases have a very different model. For example, a document-oriented NoSQL database takes the data you want to store and aggregates it into documents using the JSON format. Each JSON document can be thought of as an object to be used by your application. A JSON document might, for example, take all the data stored in a row that spans 20 tables of a relational database and aggregate it into a single document/object. Aggregating this information may lead to duplication of  information, but since storage is no longer cost prohibitive, the resulting data model flexibility, ease of efficiently distributing the resulting documents and read and write performance improvements make it an easy trade-off for web-based applications.

NoSQL is a whole new way of thinking about a database. NoSQL is not a relational database. The reality is that a relational database model may not be the best solution for all situations. The easiest way to think of NoSQL, is that of a database which does not adhering to the traditional relational database management system (RDMS) structure. Sometimes you will also see it revered to as ‘not only SQL’.

It is not built on tables and does not employ SQL to manipulate data. It also may not provide full ACID (atomicity, consistency, isolation, durability) guarantees, but still has a distributed and fault tolerant architecture.

Over the years, the implementation of NoSQL in increasing through different databases and currently around 150 databases are available in industry which are following the NoSQL concept.

Following are some of commonly used databases :

Hadoop

Hypertable

MongoDB

CouchDB

[seedinfotech-blog]

Roles and Responsibilities of a DBA

Diving out from the previous article where in we had learnt that now really it is the right time to become a DBA. Had a thought on finding out the insights related to what a DBA must be actually doing .  DBA’s jobs seems to go into a category where others don’t want to do the tasks or doesn’t have the ability to do. DBA’s get the enviable task of figuring out all of the things no one else can figure out. The DBA needs to have an understanding of networking, programming, scripting, data modelling, Operating System knowledge, Java, Storage, security and anything else that would touch a database. It can be referred to it as the centre of attention. This opens up many fields for an individual whilst going on in the path to become a DBA. Historically and futuristically the DBA had and has total responsibility for the database and had the following job duties:

Install, patch and maintain all Database software

Tune all database instance components including SQL and PL/SQL

Approve all production schema changes

Approve changes to database design

Control all migrations of database schema objects

Design and implement a backup & recovery system

Implement database failover technology

In the late 20th century  DBA’s were still overlooked because DBAs said “It’s not my job,” or “I don’t have time.” Changing technology mandated that the 21st century DBA would have more overall responsibility for the whole operation of their database. Here is a list of typical DBA responsibilities:

Installation, configuration and upgrading of Oracle server software and related products.

Evaluate features and related products.

Establish and maintain sound backup and recovery policies and procedures .

Take care of the Database design and implementation.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Perform database tuning and performance monitoring.

Perform application tuning and performance monitoring.

Setup and maintain documentation and standards.

Plan growth and changes (capacity planning).

Work as part of a team and provide 7×24 support when required .

Perform general technical trouble shooting and give consultation to development teams.

Interface with technical support.

And most of all…..Maintain 100% uptime!

With the advent of new technologies and the growth and importance of data ,the DBA job role became far more demanding, and many companies started to view the DBA as a technical management position, encompassing far more responsibility than the traditional DBA. DBAs were faced with a new requirement to have degrees in both computer science and business administration. The business administration allowed them to understand the working of internal systems and helped them to design the corporate database. Summarizing as stated, becoming a DBA requires a lifetime commitment.  Large corporations will not entrust their life-or-death data to just anyone, and most insist on hiring DBA’s who have demonstrated a commitment to the profession, constantly acquiring new certifications, degrees and knowledge.

[seedinfotech-blog]

Database Testing for beginners

Data of any application is always critical from a business perspective. If basic database operations such as  insert, update delete are performed without testing database for consistency then there is a risk of entire system crash. Database testing is nothing but finding errors in the databases to eliminate them.

What to Test?

Data Validity testing – When data is entered via front end ,check if the data is correctly updated in the backend  database. Check how special characters are handled in the database .Check that right columns in the right tables are being updated. Such checking usually involves use of SQL queries to validate the data.

Data integrity testing – It involves testing of appropriate changes to the related entities and constraints  such as primary key/foreign key ,when data is modified ( insert, update, delete)

Data format testing – This involves checking the size and type of fields that store data in the database with those that accept data in the application. for example application may accept email id  from front end but store without  ” @ ” in the database.

Database code testing – It involves testing the code in the database which implements business logic. This includes testing of stored procedures.

Non-functional database testing – To ensure database scalability ,recoverability with no/minimal loss of data it is important to do database performance testing, database security testing, database recovery testing etc.

How to Test?

Firstly tester needs to understand entire application completely  and which database is being used with the application. need to have understanding of database structure and data mapping ,understand validations and constraints ,creating queries etc.

Figure out all the tables which exists for application and try to execute all the queries for the tables as there are many complexities present. Check each and every table carefully using the appropriate data. Check all the functionalities present in the application.

If the complexity is more than tester can get the queries from developer to check the required functionality.

The world is generating variety of data with a huge volume at a very rapid speed . database is getting more complex due to the business logic which is an important aspect of the application. Database testing is really a complex task and it should be always performed if tester is much experienced in this field. it requires tester to expertise  in sql and stored procedures.

[seedinfotech-blog]

A Good Time To Be a DBA

I’ve seen a few articles lately that reminds us, that – in spite of the current economic, political, social changes happening at macro to micro level – it is a good time to be a Database Administrator, both now and in the future.

Though database administrator skills missed to be the top 10 skills in 2013, it seems to marching ahead in 2014 due to the growing interest in big data (huge collection). Most of the organization are now diving deep to extract information from social media, websites so as to understand the customers inclination, which can be helpful in strategic planning and decision making in the  business.

Every day the growth trend observed related to data is in at around 3 quintillion bytes per day. On top of social media and unstructured data, we have created systems that generate huge amount of logging and audit process information. This no longer limits to the boundaries of IT industries. Because of  IT automization taking place in the small-scale industry to a large-scale industry, the demand to handle the data is increasing.

Data!

The growing amount of data is just a consequence of the complex data systems which needs management as well as database administration skills coming up with new technologies and software options than rather increasing the complexity of IT systems. We cannot capture it all.

For example, there is no computer/storage in the world that can record the processes that take place in the human body within 1 second. Estimates of the human brain’s memory capacity till 1,000 terabytes.

Recently Forbes published the Top Jobs for 2014. Database Administrators are among the Top 10 with:

Total employment in 2013: 119,676 jobs

Jobs added between 2010 and 2013: 11,241 (up 10%)

Median hourly earnings: $37.39

Not to mention that the rise of big data and the collection of massive amounts of data greatly increases the demand for database administrators.

To be continued…with understanding the roles and responsibilities of DBA.