Posts

Showing posts from November 7, 2021

Quantum Internet Benefits

By
Image
  The quantum internet is a network of quantum computers that are connected together using quantum communication. It has the potential to revolutionize many industries, including: Secure communications: The quantum internet would be inherently secure, as it would be impossible to eavesdrop on quantum communications without being detected. This could be used for applications such as secure financial transactions, government communications, and military applications. Quantum computing: The quantum internet would allow quantum computers to be connected together, which would allow them to solve problems that are currently impossible for classical computers. This could be used for applications such as drug discovery, financial modeling, artificial intelligence, and materials science. Quantum sensors: The quantum internet could be used to connect quantum sensors together, which would allow them to create a global network of sensors that could be used to monitor the environment, detect earthq
Post a Comment
Read more

Connecting SQL Server with Power BI Data Viz !!

By
Image
Post a Comment
Read more

Building Complex Sql queries using group by, having, Rank and top functions

By
Image
 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.Product where ProductSubcategoryID is not null and Standa
Post a Comment
Read more

Building Complex ER mapping - Database Diagrams in SQL Server

By
Image
Post a Comment
Read more

Installing Nodejs using shell scripting in Linux Ubuntu 21

By
Image
Post a Comment
Read more

Installing MySQL server in Linux Ubuntu 21 using shell scripting and running basic SQL commands

By
Image
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
Post a Comment
Read more

Linux Ubuntu 21 : Setting Super User password and installing python new package 3.10.0

By
Image
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  
Post a Comment
Read more