Posts

Featured Post

Python: Built-in Functions vs. For & If Loops – 5 Programs Explained

Image
Python’s built-in functions make coding fast and efficient. But understanding how they work under the hood is crucial to mastering Python. This post shows five Python tasks, each implemented in two ways: Using built-in functions Using for loops and if statements ✅ 1. Sum of a List ✅ Using Built-in Function: numbers = [ 10 , 20 , 30 , 40 ] total = sum (numbers) print ( "Sum:" , total) 🔁 Using For Loop: numbers = [ 10 , 20 , 30 , 40 ] total = 0 for num in numbers: total += num print ( "Sum:" , total) ✅ 2. Find Maximum Value ✅ Using Built-in Function: values = [ 3 , 18 , 7 , 24 , 11 ] maximum = max (values) print ( "Max:" , maximum) 🔁 Using For and If: values = [ 3 , 18 , 7 , 24 , 11 ] maximum = values[ 0 ] for val in values: if val > maximum: maximum = val print ( "Max:" , maximum) ✅ 3. Count Vowels in a String ✅ Using Built-ins: text = "hello world" vowel_count = sum ( 1 for ch in text if ch i...

3 SQL Query Examples to Create Views Quickly

Image
There are three kinds of Views in SQL. The three views are Read-only, Force, and Updatable. Views real usage is to hide data. And you need to ensure base tables are present before you create a View. You can call views as logical tables. The advantage of Views is you can show only some of the fields of base tables. What is a View in SQL A view can be constructed with another view so it is called a nested view. You can create or replace an existing view A view can be created without having base tables. This is possible with the FORCE option. #1: Read-Only Views The standard syntax for the 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 vendor JOIN invoices ON vendors.vendor_id*invoices.vendor_id GROUP BY vendor_name; Notes: You cannot update Read-only Views #2: Force Views CREATE FORCE VIEW products_list AS SELECT product_description, product_price FROM products;...

How Does DevOps Speeds up Delivery

Image
The DevOps is basically a Software development system and most popular in Cloud computing. On-device software and storage may not be pass just yet, but it’s getting there, as more and more computing processes are taking place in the cloud. How Does DevOps Speeds up Delivery 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, C...

Aws management console popular features you need

Image
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. Stocksnap.io 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 o...

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

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...

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