Posts

Quantum Internet Benefits

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

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

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

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

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  

SQL Where Complex Query : #100daysofsql Day 3

Image
 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,

SQL Where Queries : Day 2 #100Days of SQL

Image
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 above 600\ -- where query for SafetyStock level above 600 s

SQL Script : Adventure works database setup and Select query, list of tables #100daysofsql

Image
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 - AI Automation Architecture as a Service's Common Functionalities

Image
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

Satellite systems GEO vs LEO vs MEO

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