SQL

Structured Query Language is a language for querying databases.

sql

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Aggregating and grouping data in SQL with Group by and Partition by

Understand the differences between GROUP BY and PARTITION BY through a simple example.Let’s parepare some sample data for this lesson using these scripts below.

How to Build Advanced SQL

Building more maintainable, readable and optimized data workflows. SQL remains the language for data. Developed back in the 1970s, it’s one of the few technologies that has remained constant.

Creating Maintenance Plans in SQL Server

This article deals with the creation of SQL maintenance plan for small databases, which enable automating some database administration tasks.Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the databases that are hosted therein are kept in shape.

SQL SUBSTRING function and its performance tips

This article mentions the fundamentals of the SQL Substring function and how to improve its performance. SQL Server offers various built-in functions and these functions make complicated calculations easier for us.

Dear businesses, perfect spreadsheets and SQL first

Dear businesses, perfect spreadsheets and SQL first. Baby steps to bring Data Science closer to businesses and set them up for success

Basic SQL: Ranking Best Cities for Avocado Lovers

I’ll be the first to admit, I’m basic. Avocado toast, pumpkin spice latté, Christmas-lights-in-July kind of basic. I have an unhealthy Mason-jars-to-food ratio.

Easy pivot() in BigQuery, finally

Easy pivot() in BigQuery, in one step. Introducing the easiest way to get a pivot done in BigQuery. This has been one of the most recurrent BigQuery open questions.

SQL for Web Developers (Part II)

Before we continue to create our first database, let‘s examine a common and important principle that all web developers should be familiar…CRUD stands for Create, Read, Update, and Delete which are the four basic functions of persistent storage.

Kaggle Titanic Competition in SQL

Exploratory Data Analysis & Feature Engineering. There is nothing more powerful than learning something new or taking a skill to the next level by simply doing.

SQL for Web Developers (Part I)

SQL(Structured Query Language) is a special-purpose language developed to work with relational databases. More specifically it’s used to manage and manipulate data in those databases.

Randomizing Data In SQL

Generate randomized test/train datasets in SQL using NASA JPL dataset. One can easily use the rand() function to generate random floating point values between 0 and 1.

Why Azure SQL is Best For Developers (Part 1)

Azure SQL has a lot of built-in features that make it the best database in the cloud for developers. In this first part of this two-part series, Davide Mauri

Getting Really Good at Rails :joins

If you’re intimidated by :joins then fear not, this article will break down a step-by-step guide for understanding and using them.The main motivation behind joins is to efficiently load data. With joins you can significantly reduce the time it takes to select records that fit the criteria you are looking for.

The simplest way to understand Associations in Rails

As someone who’s new to Rails with no prior experience, I’d like to share with you how I came to understand this tricky concept when…developing Rails applications. I’ll go over some keywords that you might have seen and tried to use and give examples on how to effectively use Rails Associations.

Rakuten frees itself of Hadoop investment in two years

The U.S. arm of the Japanese e-commerce giant has moved away from Hadoop in a bid to cut hardware costs and ease the management of its estate.In 2018 the business started to get serious about giving more users access to this insight – without having Python or Scala coding chops – while also reducing its capital expenditure on hardware, and started looking to the cloud.

Learn SQL: Intro to SQL Server loops

Loops are one of the most basic, still very powerful concepts in programming. The same stands for SQL Server loops.Today, we’ll give a brief info on how they function and introduce more complex concepts in upcoming articles of this series.

Introduction to BigQuery - DZone Big Data

BigQuery is a serverless, highly scalable, cost-effective, enterprise-grade modern data warehouse offering on Google Cloud Platform.

How (not) to kill your SQL Server performance with implicit conversion

How (not) to kill your SQL Server performance with implicit conversion. Learn how to avoid performance killer and help SQL Server choose an optimal execution plan for your queries

Island adventures with T-SQL Window Functions

Island adventures with T-SQL Window Functions. Traditional “Gaps and Islands” problem can be easily solved using T-SQL Window Functions