Customized Remote Work Solutions From the World’s Largest Fully Remote CompanyCustomized Remote Work SolutionsLearn More

Database

Showing 1-9 of 24 results
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 1

by Mirko Marović

Properly used, an SQL database index can be so effective that it might seem like magic. But the following series of exercises will show that underneath, the logic of most SQL indexes---and wielding them correctly---is quite straightforward.

8 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Turn Chaos Into Profit: Understanding the ETL Process

by Alexandre Wanderer

ETL can consolidate data from various sources into an organized, reliable, and usable database. This allows businesses to employ previously unused or underused data to improve their performance. In this article, Toptal Data Modeling Developer Alexandre Wanderer demonstrates all stages of the ETL process in building a data warehouse.

8 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 3

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? Code migration tools, public synonyms, and change management are important to keep in mind.

14 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 2

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? This round of pitfalls to avoid includes coverage of sequences, identity columns, and filtered indexes.

8 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

When Does it Make Sense to Use Google BigQuery?

by Maksym Goroshkevych

What do you do when you come across a dataset that’s simply too big to allow fast queries? Google BigQuery could be part of the solution, though it’s no silver bullet. In this article, Toptal Java Developer Maksym Goroshkevych explains how BigQuery can drastically improve query performance, and when you should and should not use it.

10 minute readContinue Reading
EngineeringIcon ChevronTechnology

Angular 6 Tutorial: New Features with New Power

by Joaquin Cid

Angular 6 is out! The most outstanding changes are in its CLI and how services get injected. In this tutorial, Toptal Freelance Angular Developer Joaquin Cid goes over the basic steps of initial setup and then creates a small diary app using Material Design for the front end and Firebase for the back end.

16 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Developing a Bioinformatics Database for Disulfide Bonds Research

by Viktor Bojović

The Protein Data Bank (PDB) bioinformatics database is the world's largest repository of experimentally-determined structures of proteins, nucleic acids, and complex assemblies. All data is gathered using experimental methods such as X-ray, spectroscopy, crystallography, NMR, etc. This article explains how to extract, filter, and clean data from the PDB to make it suitable for further analysis.

25 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Database Migrations: Turning Caterpillars into Butterflies

by Ivan Pavlov

For a large codebase, managing database schema can become tedious, especially if you maintain multiple testing environments or customers that update the product at different paces. Sometimes, documenting the latest schema or database changes isn't enough. In this article, Toptal Database Engineer Ivan Pavlov introduces us to concepts that help manage database states.

11 minute readContinue Reading
EngineeringIcon ChevronBack-end

Blockchain, IoT, and the Future of Transportation: Understanding the Motoro Coin

by Michal Mikolajczyk

Open-source, IoT, and Ethereum smart contracts work together with a new utility coin to make transportation more accessible and reduce vehicle waste. In this article, Toptal Freelance Ethereum Developer Michał Mikolajczyk explains the motivations and methodology behind his startup's latest initiative.

16 minute readContinue Reading

Join the Toptal® community.