K Z, Author at Adglob Infosystem Pvt Ltd

MS SQL Server – Login Database

Post author:K Z
Post published:September 8, 2021
Post category:MS SQL Server
Post comments:2 Comments

A login database is a simple credential for accessing SQL Server. For example, you provide your username and password when logging on to Windows or even your e-mail account. This…

MS SQL Server Management Studio

Post author:K Z
Post published:September 8, 2021
Post category:MS SQL Server
Post comments:1 Comment

MS SQL Server Management Studio is a workstation component\client tool that will be installed if we select the workstation component in the installation steps. This allows you to connect to…

MS SQL Server – Architecture

Post author:K Z
Post published:September 8, 2021
Post category:MS SQL Server
Post comments:1 Comment

We have classified the architecture of SQL Server into the following parts for easy understanding − General architectureMemory architectureData file architectureLog file architecture General Architecture Client − Where the request was…

MS SQL Server – Installation

Post author:K Z
Post published:September 8, 2021
Post category:MS SQL Server
Post comments:1 Comment

SQL Server supports two types of installation − StandaloneCluster based Checks Check RDP access for the server.Also Check OS bit, IP, domain of server.Check if your account is in admin…

MS SQL Server – Introduction

Post author:K Z
Post published:September 8, 2021
Post category:MS SQL Server
Post comments:2 Comments

This chapter introduces SQL Server, discusses its usage, advantages, versions, and components. What is SQL Server? It is a software, developed by Microsoft, which is implemented from the specification of…

Python Pandas – Missing Data

Post author:K Z
Post published:September 1, 2021
Post category:Pandas Python
Post comments:0 Comments

Missing data is always a problem in real life scenarios. Areas like machine learning and data mining face severe issues in the accuracy of their model predictions because of poor…

Python Pandas – Aggregations

Post author:K Z
Post published:September 1, 2021
Post category:Pandas Python
Post comments:0 Comments

Once the rolling, expanding and ewm objects are created, several methods are available to perform aggregations on data. Applying Aggregations on DataFrame Let us create a DataFrame and apply aggregations on it.…

Python Pandas – Window Functions

Post author:K Z
Post published:August 31, 2021
Post category:Pandas Python
Post comments:0 Comments

For working on numerical data, Pandas provide few variants like rolling, expanding and exponentially moving weights for window statistics. Among these are sum, mean, median, variance, covariance, correlation, etc. We will now…

Python Pandas – Statistical Functions

Post author:K Z
Post published:August 31, 2021
Post category:Pandas Python
Post comments:0 Comments

Statistical methods help in the understanding and analyzing the behavior of data. We will now learn a few statistical functions, which we can apply on Pandas objects. Percent_change Series, DatFrames…

Python Pandas – Options and Customization

Post author:K Z
Post published:August 31, 2021
Post category:Pandas Python
Post comments:0 Comments

Pandas provide API to customize some aspects of its behavior, display is being mostly used. The API is composed of five relevant functions. They are − get_option()set_option()reset_option()describe_option()option_context() Let us now…