Query JSON Data with SQL/JSON Functions & Autonomous Database
In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL...
An Overview of Analytic Functions in PostgreSQL
Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default. They allow you to execute a variety of...
T-SQL Scripts to Monitor your Resource Pool Stats
Imagine you have a business-critical MS SQL Server serving requests for both OLTP and some batch processing tasks, as data gets pulled by...
Import JSON Data with SQL Developer Web into Autonomous Database
Twitter Activity provides loads of information for analysis. You can learn your target audience...
Entity Framework – Just a Few Clicks Away
Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on...
How to Check Status Of SQL Agent Jobs using PowerShell Tool
From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential...
Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW)
When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Creation of Pandas DataFrame in Python with Examples
Python is a general-purpose language that can work with various types of data structures and solve data-related problems with the help of...
LINQ in C#: A tutorial with Query Examples in LINQ to Objects
Less is more – this is definitely true when it comes to object collections and LINQ queries. One...
