Code articles

Browse articles by category

Code
SQL Queries: A Guide to Essential Database Management Commands

Basic SQL queries for database management for beginners: types of commands, syntax, usage examples.

Code
Programming in Sociology: Social Research, Truth, Distortions, Tools

Podcast "People and Code", episode #79: Sergey Tikhonov.

Code
C Basics: Learning the Programming Language from Scratch — Lecture 1.1 of the CS50 Course

C Basics – learning the programming language from scratch: the key requirements for creating good code, using an IDE, compiling programs, functions, arguments, and more.

Code
Top 8 Scientific Papers That Changed the World

We recalled the most fundamental scientific works that changed the world and helped humanity step into the digital age.

Code
Pandas DataFrame in Python: The Ultimate Guide for Beginners

Pandas DataFrames in Python – what these structures are and how to work with them: how to create them, get labels, access them, insert and delete data, perform arithmetic operations, and more. A compr...

Code
What is AGI and what is artificial general intelligence capable of?

Let's explore AGI (artificial general intelligence): what kind of AI it is, how it differs from conventional artificial intelligence, and whether it can solve any problem or compete with geniuses.

Code
Webpack Basics: A Comprehensive Guide for Beginners

Learn more about Webpack—what it is, what it's for, and how to use it: how to install and configure it, what commands to use, plugins, and more.

Code
Programmers' Hobbies: How Famous IT Professionals Relax

Hobbies of famous programmers: from washing dishes to bowhunting wild boars.

Code
Testing: Tools, Tester Qualities, Types of Testing, and Careers

Podcast "People and Code", episode #80: Sergey Shaikin.

Code
Java Developer: Who They Are, What They Do, and How to Become a Java Developer

Learn more about the Java developer profession: who they are, what they do, how much they earn, and what you need to know and be able to do to become a sought-after Java developer.

Code
A Cable on the Ocean Floor: 5 Facts About the Internet Between Continents

95% of global internet traffic travels through cables located on the ocean floor. We explain how intercontinental communication lines developed and the dangers they face in the water.

Code
Electronic Music Creation: Trends, Creativity, Commerce, Inside Story, and Software

Podcast "People and Code", episode #81: Andrey Tukaev.