Kumaran1987

 Hi, In this blog post video, will gonna see about sql query related performance details using SQL server, In that sql server have one option "display detailed execution plan" which will show the detailed query performance information, For more details, check the below video  

Hi, In this blog post we are gonna see about how to connect Google analytics with Tableau software Check this below video for more details,

 In this post, we gonna cover in Google analytics how to create custom reports from dimension and metrics? In this below video, I have explained about Customer who visited my website pages from which city there are visiting and which Internet service provider they used to get the details.

Let's say you have website, you wanna get the details about your customers / your visitors,  who had visited your webpage from google.  Do you wanna know about your website visitors who hit the Google website using some random keywords then this below video will give some ideas. insights about it.

 Hi In this blog spot will cover about user / customer viewed details on your webpages in Google analytics - I had temporary setup Google analytics for my blog, so whoever visited my web page ! I can able do the user explorer and understand about each user viewing behavior based google analytics dimensions and metrics related information - In this below video randomly queries that insights data and checking that who are all users has seen my web pages and other relevant details 

In this blog post,  will see about Exploring this blog's near Decade experience with Google Analytics and Google Data studio platforms   - Google Analytics - Insights intelligence tool to query and visualize   - Google Analytics - User Explorer  - Google Analytics Dashboard providing default data studio visual insights - Google Data studio - Behaviors and overviews  - From Google Data studio Export csv data and import data in SQL server databases  The above mentioned exploring the views, insights between Google Analytics, Google Data studio and Sql Server to ingest data viz'ed datas !! will be available in this below video with details

 Hi , In this blog post will check the join queries SQL Join function below diagram shows difference possibilities   Below queries has been executed on the video podcast -- will see about join query from the db table schema diagram -- will check about product and transaction history table on join  query select * from Production.Product  -- 504 records select * from Production.TransactionHistory  -- 113443 records -- inner join select * from Production.Product p inner join Production.TransactionHistory t on p.ProductID = t.ProductID  -- full join or full outer join select * from Production.Product p full outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- right join or right outer join select * from Production.Product p right outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- left join or left outer join select * from Production.Product p left outer join Production.TransactionHistory t on p.ProductID = t.Product...

 Sql Query with Where clause select ProductSubcategoryID, size, StandardCost, ListPrice, class, style from  Production.Product where ProductSubcategoryID is not null and  size is not null and StandardCost <> 0.00 and  ListPrice <> 0.00 and  class is not null and  style is not null     -- Complex SQL query with where, group by, having clauses and top, rank, dense_rank, row functions select Top 20 ProductSubcategoryID,  Max(StandardCost) as MaximumStdCost,  Max(ListPrice) as MaxListPrice, Max(ListPrice) - Max(StandardCost) as MaxDifferenceStandardFin, Max(ListPrice) / Max(StandardCost) as CostPriceRatio, Rank() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankMaximumCostPriceRatio, Row_Number() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as RankMaximumCostPriceRatio, DENSE_RANK() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankwithNextSequence from  Production.Pro...

Hi In this blog post I am sharing about to installing MySQL server in linux ubuntu 21 using shell scripting   In that shell scripting include that install package related dependencies for MySQL server that will address compatabilty with linux related packages like debians.   After that run the shell script command using exexcutable file like chmod +x filename.sh and then execute the shell script file which has the sudo commands in it.   Once completed executing the command, MySQL server will be installed in your linux ubunutu 21 OS.  Check the MySQL version using "mysql -v"   Run the SQL commands using mysql in that linux terminal I have used the below SQL commands   > Use [databasename]  > show [table_name]  > show columns from [table_name]   Watch this below video for more details

Hi all, In this video  - Setting new password for Super User , Root level privileges between Sudo -i vs Su Root options  - After that will installing the Python new package 3.10.0  

 SELECT --43659, 43662   SalesOrderId,   SalesOrderNumber,   SubTotal,   OrderDate,   (     SELECT SUM(OrderQty)     FROM Sales.SalesOrderDetail     WHERE SalesOrderID not in (43659, 43661, 43662, 43668)   ) AS TotalSales FROM   Sales.SalesOrderHeader WHERE   SalesOrderID not in (43659, 43661, 43662, 43668); The above query explained in this below video,

Today, I am going to share about Where clause usages in SQL Query using Microsoft SQL server and AdventureWorks Database. We Will gonna use "Production.Product" Table in this examples, In this blogpost will see about where clause with other operators such as and, or, like, not null, null  Initially we will explore about Simple SQL where clause queries here, Later I will update more complex SQL where clause queries in future days. At First we will see the normal Query with resultsets select * from Production.Product  -- returned 504 rows of data In this below Query we will see about Safety Stock level value below 1000 -- where query for SafetyStock level below 1000 select Production.Product.ProductID,         Production.Product.Name,    Production.Product.SafetyStockLevel from   Production.Product where  Production.Product.SafetyStockLevel < 1000    In this below query will explore safety stock level values are ...

Hi all,   Welcome to 100 days of SQL script code   In this blog post, will start with AdventureWorks sample database in Microsoft SQL server   Install MS SQL server and SSMS latest version  Download bak file from https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms Follow the restore steps in the same above link after restoring below adventure work database below  Run the below query in SQL server -- showing list of tables select * from INFORMATION_SCHEMA.TABLES   output  customer and product table select query -- customer and product table  select * from SalesLT.Customer select * from SalesLT.Product Outputs are

3AaaS Common functionalities Simple Functionalities are 1. Adding or Saving 2. Removing or Deleting  3. Updating  4. Viewing individual and group of datas  5. Sort Functionalities 6. Searching Functionalities  Intermediate Functionalities are 1. Mapping 2. Merging 3. Advanced searching  Complex Functionalities are,  1. Tree structure view of all simple and Intermediate Functionalities. 2. Graph structure view of all simple and Intermediate Functionalities. Previous linkedin posts and snapshots

GEO - Geostationary/ Geosynchronous  orbit - Satellites round trip 1 time per day !! MEO - Mid Earth Orbit - Satellites round trip 2 time per day !! LEO - Low Earth Orbit - Satellites round trip 18 times per day !!  Morr information will soon updated year like distance measurements!!