Skip to main content

Posts

Showing posts from April, 2017

10 the best SAS new features for dashboard

SAS visual analytics is a completely new architecture from SAS. It has the capability to manage large amounts of data and bring it into memory to analyze it, explore it and publish reports. Although the data amounts are massive — up to 1.1 billion rows of data, the SAS LASR Analytic Server, to use its full name, was designed to be intuitive to users without an advanced degree in computer science.

All about SAS analytics Server - The SAS Analytic Server begins with an eight-blade server with 96 processor cores, 768 gigabytes memory and 4.8 terabytes (TB) of disk storage. The upper end of the reference configurations is 96 blades with 1,152 cores, 9.2 TB memory and 57.6 TB of disk storage, enough disk space to store the entire Library of Congress six times.
Where to Learn SAS Visual Analytics

Also read: Modelling with SAS a detailed video course to get instant benefit 

The real SAS Visual analytics benefits
The speed of in-memory architecture offers tremendous benefit. Organisations can ex…

How to add DATE function awesome way in SQL

The SQL DATE function is so powerful. It is being used innovative way in almost all projects. All projects depends in DATE, and without it there is no way of existing of project. The Quick tour helps you use this function effectively in your project. You can learn Oracle SQL step by step for all Developers.

The below is the list of SQL DATE functions

SYSDATE - It returns current local DATE and Time

CURRENT_DATE - Return local DATE and TIME and adjusted to current session Time Zone.

ROUND (DATE) - Rounds to nearest DAY

TRUNC (DATE) - Truncates Time

MONTHS_BETWEEN(date1,date2) - Returns number of months between date1 and date2'

LAST_DAY(DATE)- Returns last of the month

ADD_MONTHS(date,integer_months) - Adds specified number of months to specified date.

NEXT_DAY(date, day_of_week) - Returns to next day of the week that comes after the specified DATE

Also Read:The Best SQL Book for all Developers.

Views in SQL a sample Query for your project

A view is basically a logical view of one or more base tables. A view can be a read only or updatable. A view generally be created to avoid any unwanted changes into actual base tables. Mainly view is created for security reasons.
A view can be constructed with another view so it is called as nested view.You can create or replace an existing viewA view can be created without having base tables. This is possible with FORCE option. Read only views: The standard syntax for view is as follows:
CREATE OR REPLACE VIEW INVOICE_SUMMARY AS SELECT VENDOR_NAME COUNT(*) AS INVOICE_COUNT, SUM(INVOICE_TOTAL) AS INVOICE_TOTAL_SUM FROM VENDORS JOIN INVOICES ON VENDORS.VENDOR_ID*INVOICES.VENDOR_ID GROUP BY VENDOR_NAME;
How to use FORCE command:
CREATE FORCE VIEW PRODUCTS_LIST AS SELECT PRODUCT_DESCRIPTION, PRODUCT_PRICE FROM PRODUCTS;
Updatable Views: A view can also be updatable if a view follows certain rules. Read more to understand all about what is updatable view.
A view when it is created for update purpose,…

How to learn DevOps best way for novices simplified

The DevOps is basically a Software development system and most popular in Cloud computing. On-device software and storage may not be passe just yet, but it’s getting there, as more and more computing processes are taking place in the cloud. Many companies are also preferring distributed computing, which allows multiple computers to network with one another to solve a task (and, unlike the cloud, gives companies control over the actual hardware involved).

Many of the skills involved with cloud computing and distributed computing are related, so the two are often grouped together:
Skills to learn include SQL for database management, programming languages like Ruby, JavaScript, and Python for building cloud-based applications, and DevOps (a software development system popular in the cloud computing field). Specific in-demand programs include Microsoft Azure and Amazon Web Services.
Also Read: 2017 Fast Growing IT Skills 

For instance, Agile, Scrum, Continuous Integration, Test-Driven Deve…

Aws management console popular features you need

The AWS Management Console is a web application for managing Amazon Web Services. The console provides an intuitive user interface for performing many AWS tasks. These include working with Amazon S3 buckets, launching and connecting to Amazon EC2 instances, setting Amazon CloudWatch alarms, and so on.
Each service has its own console, which you can access from the AWS Management Console. The console also provides information about your account and about billing. The following five service in AWS management console you will get are:
Getting start of Service: The AWS Management Console provides multiple ways for navigating to individual service consoles.
To open a console for a service Do one of the following:  Type the name of the service in the search box. Then choose the service that you want from the list of search results. Version 1.0 1 AWS Management Console Getting Started Guide Adding and Removing Shortcuts Choose one of your recently visited services under the search box.Choose …