Skip to main content

Posts

Showing posts from September, 2021

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

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

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