Posts

Showing posts from March, 2017

Featured Post

Step-by-Step Guide to Creating an AWS RDS Database Instance

-
Image
 Amazon Relational Database Service (AWS RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Instead of managing servers, patching OS, and handling backups manually, AWS RDS takes care of the heavy lifting so you can focus on building applications and data pipelines. In this blog, we’ll walk through how to create an AWS RDS instance , key configuration choices, and best practices you should follow in real-world projects. What is AWS RDS? AWS RDS is a managed database service that supports popular relational engines such as: Amazon Aurora (MySQL / PostgreSQL compatible) MySQL PostgreSQL MariaDB Oracle SQL Server With RDS, AWS manages: Database provisioning Automated backups Software patching High availability (Multi-AZ) Monitoring and scaling Prerequisites Before creating an RDS instance, make sure you have: An active AWS account Proper IAM permissions (RDS, EC2, VPC) A basic understanding of: ...
Post a Comment
Read more

Ideas to Choose Networking Career

-
Image
Below are key tips and advice from experts to opt in Networking as a career. Networking is basically admin kind of job. Surely, certification and best training help you progress in Networking career. Skills You Need for Networking Career Degree in Engineering CISCO certifications Practical Experience In addition to the above, one needs knowledge of protocols and specifications to survive in this career. References Certification and Career Options in Networking
Post a Comment
Read more

Spark SQL Query how to write it in Ten steps

-
Image
Spark SQL example The post tells how to write SQL query in Spark and explained in ten steps.This example demonstrates how to use sqlContext.sql to create and load two tables and select rows from the tables into two DataFrames. The next steps use the DataFrame API to filter the rows for salaries greater than 150,000 from one of the tables and shows the resulting DataFrame. Then the two DataFrames are joined to create a third DataFrame. Finally the new DataFrame is saved to a Hive table. 1. At the command line, copy the Hue sample_07 and sample_08 CSV files to HDFS: $ hdfs dfs -put HUE_HOME/apps/beeswax/data/sample_07.csv /user/hdfs $ hdfs dfs -put HUE_HOME/apps/beeswax/data/sample_08.csv /user/hdfs where HUE_HOME defaultsto /opt/cloudera/parcels/CDH/lib/hue (parcel installation) or /usr/lib/hue (package installation). 2. Start spark-shell: $ spark-shell 3. Create Hive tables sample_07 and sample_08: scala> sqlContext.sql("CREATE TABLE sample_07 (code string...
Post a Comment
Read more

Hyperion: How to Learn as Alternative for Mainframe

-
Image
Oracle Hyperion is a reporting tool. Its applications are Capital management, Asset planning, Workforce planning and more. Photo Credit: Srini Books to Read on Hyperion The Oracle Hyperion Financial Reporting 11 covers all basics to learn financial reporting using Hyperion tool. The popular contents are Explore Grids and the Point of View Create Functions and Formulas Master Conditional Formatting and Conditional Suppression Create Dynamic Books and Batches Import Reporting Content into MS Office with Oracle Smart View
Post a Comment
Read more

12 Top Tableau Small Projects for Practice

-
Image
Tableau is one of the best visualization tools. With Tableau Desktop you can connect to multiple data sources. Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag & drop to analyze data. Best 12 Tableau Exercises: Small Projects for Practice. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more. We’ve done years of research to build a system that supports people’s natural ability to think visually.  Shift fluidly between views, following your natural train of thought. You’re not stuck in wizards or bogged down writing scripts.  You just create beautiful, rich data visualizations. It's so easy to use that any Excel user can learn it. Get more results for less effort. And it’s 10 –100x faster than existing solutions Keep Reading The 12 Exercises from Tableau Tableau Tutorial
Post a Comment
Read more