Tag: SQL

How to Execute SQL Queries in Python and R Tutorial
Post

How to Execute SQL Queries in Python and R Tutorial

Originally posted on datacamp. Learn easy and effective ways to run SQL queries in Python and R for data analysis and database management. What is SQL Structured Query Language (SQL) is the most common language used for running various data analysis tasks. It is also used for maintaining a relational database, for example: adding tables,...

Beyond SQL: 8 new languages for data querying
Post

Beyond SQL: 8 new languages for data querying

Originally posted on infoworld. SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query Language (SQL) were almost synonymous. Anyone who wanted to retrieve information from a database had to learn SQL. Anyone who wanted to...

How to Write SQL in Native Python
Post

How to Write SQL in Native Python

Originally posted on kdnuggets. If the idea of being able to link with SQL databases and define, manipulate, and query using Python sounds appealing, check out the SQLModel library. Do you write a lot of SQL? Do you end up calling a lot of this SQL from within Python? Does the idea of being able...

How to use SQL with Pandas?
Post

How to use SQL with Pandas?

Originally posted on mlwhiz. Pandas is one of the best data manipulation libraries in recent times. It lets you slice and dice, groupby, join and do any arbitrary data transformation. You can take a look at this post, which talks about handling most of the data manipulation cases using a straightforward, simple, and matter of fact...

Why Python is outpacing R and SQL in data science
Post

Why Python is outpacing R and SQL in data science

Data scientists are adopting specialized skillsets and programming languages to differentiate themselves in a growing field, according to Harnham. As the field of data science explodes, data professionals are increasingly using programming language Python to get work done, over other tools such as R and SQL, according to Harnham’s US Data & Analytics Salary Guide 2019, released this week....

Imperative vs declarative
Post

Imperative vs declarative

Imperative – you instruct a machine what to do step by step. Example: assembly language. Declarative – you instruct a machine what you want to get and it supposes to figure it how to do it. Example: SQL. Imperative vs declarative is an example of limitation of categorical thinking. There is a spectrum of values, but we trapped...

Sharing Docker Containers across DevOps Environments
Post

Sharing Docker Containers across DevOps Environments

Docker provides a powerful tool for creating lightweight images and containerized processes, but did you know it can make your development environment part of the DevOps pipeline too? Whether you’re managing tens of thousands of servers in the cloud or are a software engineer looking to incorporate Docker containers into the software development life cycle,...