Posts

Showing posts with the label tutorial

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Tableau 2 Top Books to Read

Image
In this post, I have given two top data visualization in Tableau books. These books helpful for your self-study.   Top Tableau Course Contents Introduction to Tableau  Connecting to data  Visual analytics  How to design dashboard  Mapping  Calculations  How to publish and Manage with Tableau  Security with Tableau ..... Read more . Two Best books on Tableau to Learn and Visualize the Data. #1.  Learning Tableau Learn how to create effective data visualizations with Tableau and unlock a smarter approach to business analytics.  It might just transform your organization About This Book Create stylish visualizations and dashboards that explain complexity with clarity. Learn effective data storytelling to transform how your business uses ideas and makes decisions Explore all the new features in Tableau 10 and start to redefine what business. analytics means to your organization. #2.  How to create Data Visualization in Tableau  Tableau Your Data! is a co

Data mining Real life Examples

Image
Data mining is a process to understand about unused data and to get insights from the data. You need a quick tutorial and examples to perfect with this process. The best example is the Backup data business use case to mine the data for useful information. The backup data is simply wasted unless a restore is required. It should be leveraged for other, more important things. This method is called Data Mining Technique . --- For example, can you tell me how many instances of any single file is being stored across your organization? Probably not.  But if it’s being backed up to a single-instance repository, the repository stores a single copy of that file object, and the index in the repository has the links and metadata about where the file came from and how many redundant copies exist. By simply providing a search function into the repository, you would instantly be able to find out how many duplicate copies exist for every file you are backing up, and where they are coming from. Know

AWS Cloud Computing Tutorial for Beginners

Image
Complete tutorial for beginners on AWS. Also explained AWS security features. 1. What you can do with AWS Store public or private data. Host a static website. These websites use client-side technologies (such as HTML, CSS, and JavaScript) to display content that doesn't change frequently. A static website doesn't require server-side technologies (such as PHP and ASP.NET). Host a dynamic website, or web app. These websites include classic three-tier applications, with web, application, and database tiers. Support students or online training programs. Process business and scientific data. Handle peak loads. 2. AWS (Amazon Web services different features) AWS Management Console A web interface. To get started, see the Getting Started with the AWS Management Console. AWS Command Line Interface (AWS CLI) Commands for a broad set of AWS products.To get started, see AWS Command Line Interface User Guide. Command Line Tools Commands for individual AWS products. For more information

Here's Quick Guide on Hadoop Security

Image
Here is a topic of security and tools in Hadoop. These are security things that everyone needs to take care of while working with the Hadoop cluster. Hadoop Security Security We live in a very insecure world. For instance, your home's front door to all-important virtual keys, your passwords, everything needs to be secured. In Big data systems, where humongous amounts of data are processed, transformed, and stored. So security you need for the data . Imagine if your company spent a couple of million dollars installing a Hadoop cluster to gather and analyze your customers' spending habits for a product category using a Big Data solution. Here lack of data security leads to customer apprehension. Security Concerns Because that solution was not secure, your competitor got access to that data, and your sales dropped 20% for that product category. How did the system allow unauthorized access to data? Wasn't there any authentication mechanism in place? Why were there no alerts? Th

The AI Quick Tutorial Put You on Edge

Image
Artificial intelligence (AI) means different things to different people. Some believe that AI is synonymous with any form of intelligence achieved by nonliving systems; they maintain that it is not important if this intelligent behavior is not arrived at via the same mechanisms on which humans rely. For others, AI systems must be able to mimic human intelligence. How Humans Accomplish Intelligence. No one would argue with the premise that to study AI or to implement AI systems , it is helpful if we first understand how humans accomplish intelligent behavior; that is, we must understand activities that are deemed intelligent in an intellectual, scientific, psychological, and technical sense. For example, if we want to build a robot capable of walking like a human, then we must first understand the process of walking from each of those perspectives; people, however, do not accomplish locomotion by constantly stating and following a prescribed set of formal rules that explain how to t

MongoDB Basics Tutorial top Resources

Mongo DB has rapidly grown to become a popular database for web applications and is a perfect fit for Node.JS applications, letting you write Javascript for the client, backend and database layer. Its schemaless nature is a better match to our constantly evolving data structures in web applications, and the integrated support for location queries is a bonus that’s hard to ignore. Throw in Replica Sets for scaling, and we’re looking at really nice platform to grow your storage needs now and in the future. Now to shamelessly plug my driver. It can be downloaded via npm, or fetched from the github repository. To install via npm, do the following: npm   install   mongodb or go fetch it from github at  https://github.com/mongodb/node-mongodb-native Once this business is taken care of, let’s move through the types available for the driver and then how to connect to your Mongo DB instance before facing the usage of some CRUD operations. Tutorial on MongoDB Mongo DB data type