5 Tips to Become Expert in SQL

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-dev..

Already a Member? Log In to Your Account
  
This Blog Posts All Posts Directory Listings Articles

5 Tips to Become Expert in SQL

07/27/2014 09:44:36 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: 5 Tips to Become Expert in SQL

Analytics in Different Areas

07/24/2014 23:40:42 PM

Customer Analytics: Understand what your customers really think about you and your products and interact with them more effectively to raise customer satisfaction levels Marketing Analytics: Make your marketing more targeted and effective through cam

Excel Tutorials for Business Analytics

07/23/2014 22:09:10 PM

Microsoft Excel analytics of step-by-step guide [http://www.ictlounge.com/work/practical_workbooks/data_analysis_step_by_step_booklet.pdf] Excel for data analysis [http://www.sagepub.com/bachmanfrccj2e/study/resources/Appendix_f.pdf] Data analysis us

JCL – Mandatory Details in JOB

07/23/2014 03:25:46 AM

//jobname job (acctinfo),programmer-name Because the above are Positional parameters, they must be coded in the sequence. //Stepname Exec PGM=abcd or Proc-name //Stepname DD DSN=ABCD //Stepname DD SYSOUT=* Additional Points:- More than one job can be

DB2 – 5 Frequently Asked Questions

07/21/2014 03:36:02 AM

There are few confusing things in DB2. Almost all people, both experienced and freshers will confuse during interviews. PLAN -  Is an executable DB2 object. A DBRM we can bind directly to a PLAN or a PACKAGE we can bind it to a plan. In the BIND ca

Themis Inc – Advanced DB2 Training

07/19/2014 21:15:40 PM

About Themis Inc Themis Top 25 DB2 Tuning Presentation Across the board, Themis instructors excel at programming, design and systems support. They were early adopters of new releases of software.  ====> DB2 Training Courses

Three Tips for Responding to Failure

07/18/2014 20:56:00 PM

Everyone reacts differently to failure: some immediately accuse others while some take the heat themselves, even if undeserved. Next time you and your team fail, resist the temptation to place blame. Take these three steps instead: Think before you a

2 Best Methods Of Choosing Correct Database – IMSDB

07/18/2014 09:26:00 AM

 We have option to choose two databases. One is DL/I database. The second one is DEDB database. DL/I Database - DL/I is a general access database manager, thus it is suitable for a wide variety of applications. It is also called full function data

IMSDB – Backward and Forward Recovery

07/15/2014 21:58:52 PM

Recovery is the term we use in the sense of IMSDB is restoring a database to its point of integrity. Backward Recovery - IMS will do dynamically backout the data in the following scenarios: Online environment: An application program terminates abnorm

IMSDB – Basic DBRC Components

07/15/2014 07:36:05 AM

DBRC includes the following components, which are introduced in this section: “RECON Data Set” “Database Recovery Control Utility (DSPURX00)” “Skeletal JCL” RECON Data Set DBRC stores recovery- related informatio

Hadoop Forum

07/15/2014 02:12:00 AM

http://sriniforum.bestfreeforum.ca/f5-bigdata-discussion-forumFiled under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Bigdata forum, Hadoop Discussion Forum, Had

Awareness About Heartbleed Bug

07/14/2014 08:40:48 AM

The Heartbleed bug allows anyone on the Internet to read the memory of the systems protected by the vulnerable versions of the OpenSSL software. This compromises the secret keys used to identify the service providers and to encrypt the traffic, the n

Hierarchical Vs. RDBMS

07/13/2014 05:14:22 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: db2, Hierarchical Vs. RDBMS, IMSDB

IMSDB – DL/I, BMP, MPP – Advanced Concepts

07/12/2014 20:38:24 PM

BMP Batch message processing programs (BMPs)Programs that run as batch jobs but access databases that they share with online transactions. In other words, theses share online (message ques) as input, and sends output to database. Transaction-oriented

How SAS Analytics Helps to Address Child Fatalities

07/10/2014 22:02:10 PM

The resulting five-year Child Fatality Trend Analysis is helping investigators better predict the needs of families in crisis. Some of the key findings include: Overall, child deaths within the agency are trending downward. Children who received pr

20 DFSORT Tricks For Interviews

07/10/2014 02:12:08 AM

Filed under: CICS, Easytrive, Mainframe, Quiz, Self-development Tagged: 20 DFSORT Tricks For Interviews

Icebreakers For Meetings And Trainings

07/09/2014 21:12:46 PM

These 40 icebreakers are simple to use and suitable for a wide age range. They are great with a small youth group and can be used in a small space! They require very few props and can easily be used in a home without feeling a hurricane just came 

4 Traits in DB2 Cursor WITH HOLD

07/09/2014 03:46:07 AM

Point 1 - The best example for cursor WITH HOLD is, just imagine, you are processing Master table and Detail table in DB2, you need to retrieve a row from Master table and process the row data, and you need to update it in Detail table. To perform UP

Advanced SQL in DB2 – Part 2

07/08/2014 09:41:05 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Advanced SQL, db2 sql, DB2 Tuning, SQl Tuning

IBM BMC Remedy – a Guide

07/08/2014 02:43:00 AM

The below guide provides a conceptual overview of the applications that make up the BMC Remedy IT Service Management (BMC Remedy ITSM) Suite of applications. ITIL process                         BMC Remedy ITSM application: Change managem

10 Killer Tips For COBOL-DB2 Developers

07/08/2014 00:50:06 AM

The SQLCODE must be checked after every SQL statement Every program must include SQLCA(only once), and DCLGEN for each table Every program must have abend routine. In this routine make sure to use,SQLCODE and SQLSTATE to display Never code SELECT * i

Teradata Utilities Quiz

07/07/2014 00:54:53 AM

Hello, Teradata guys, I have given my quiz here. I will give more in future. Find best links:

Advanced SQL in DB2 – Part 1

07/06/2014 22:09:52 PM

Before going into advanced SOL, I want to give some information on data modelling :

USA-Cross Cultural Sensitivity

07/05/2014 22:03:17 PM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: USA-Cross Cultural Sensitivity

JCL Cataloged and In stream Procedures (proc)

07/05/2014 03:47:38 AM

In JCL there are two different procedures. One is Cataloged and the other one is in-stream. JCL procedures like any other languages are routines, we can reuse any no of times. So that we can avoid errors. The below points we can consider as tough JCL

DB2 V10.5 An Overview

07/03/2014 08:42:01 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: DB2 V10.5 An Overview

DB2 – Pagesets and Zero Page

07/02/2014 04:00:26 AM

What are pagesets: There are two types of pagesets in DB2: Data pageset- which contains the VSAM linear datasets for a tablespace. Index pagesets- which contain the datasets for indexspaces. There are three types of pages in a pageset: header pages,

Oracle to DB2 Migration Compatibility

07/01/2014 19:59:28 PM

DB2 supports NUMBER, VARCHAR2, VARRAY of Oracle. Similarly, several Oracle proprietary SQL statements such as CONNECT BY, ROWNUM, and more are also supported in DB2. Many of Oracle’s conversion and formatting functions, datetime arithmetic functio

© 2006-2014 OnToplist.com, All Rights Reserved