Blog
January 1, 2019
•
6 min read
T-SQL - Introduction (Part 1)
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …
January 1, 2019
•
5 min read
T-SQL - Introduction (Part 2)
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …
January 1, 2019
•
1 min read
T-SQL - Querying multiple tables using Set Operators
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …
January 1, 2019
•
3 min read
T-SQL - Querying multiple tables with Joins
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …
January 1, 2019
•
6 min read
T-SQL - Using Functions and aggregating data
``Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - `` [Querying Data with Transact-SQL](https://www.edx.org/course/querying-data-with-transact-sql-0) `` These queries works on AdventureWorks …
January 1, 2019
•
2 min read
T-SQL - Working with subqueries and APPLY
Note : The following scripts are the part of the course on edx titled as: Querying Data with Transact-SQL - Querying Data with Transact-SQL
These queries works on AdventureWorks database and information regarding the same
can be accessed by visiting …
December 23, 2018
•
1 min read
Read data into pandas
Provide column names while reading a dataset in pandas # Import the required modules import pandas as pd Reading the dataset using read.csv() function with mentioning column names in names parameters.
#Fetching data from url as csv by mentioning …
December 22, 2018
•
1 min read
Connect to azure storage (blob) using python
The following code snippets are on creating a connection to Azure Blob Storage using Python with account access key.
For more details on Azure Blob Storage and generating the access key, visit : …
December 20, 2018
•
2 min read
Connect to azure datalake store using python
The following code snippets are on creating a connection to Azure Data Lake Storage Gen1 using Python with Service-to-Service authentication with client secret and client id.
Follow the link, for more details on different ways to connect to Azure …