Related Technologies & Tools

Core Skills Databases & Data Management
Experience Summary

Hands-on work with relational databases and administration tools, writing queries, inspecting and validating data, and documenting schemas, reporting, and data-handling procedures for technical and business users.

Technology
About
 
MS SQL Server

Microsoft SQL Server is Microsoft's enterprise relational database platform for transactional systems, reporting databases, stored procedures, security, integration, and business application data management.

Additional Resources:

View Details
Oracle

Oracle Database is an enterprise relational database platform used for mission-critical applications, structured data management, SQL workloads, stored procedures, performance tuning, and database administration.

Additional Resources:

View Details
IBM DB2

IBM Db2 is IBM's enterprise relational database family for transactional, analytical, mainframe, distributed, and hybrid data-management workloads. It supports SQL-based application data, administration, optimization, and governance needs.

Additional Resources:

View Details
PostgreSQL

PostgreSQL is an open-source object-relational database system used for SQL-based application data, transactional workloads, extensible data types, indexing, stored logic, and enterprise web or application back ends.

Additional Resources:

View Details
MySQL

MySQL is an open-source relational database management system widely used for web applications, enterprise applications, structured data storage, SQL querying, replication, and operational data management.

Additional Resources:

View Details
MariaDB

MariaDB is an open-source relational database made by the original developers of MySQL. It is commonly used for SQL-based data management, MySQL-compatible web applications, enterprise workloads, replication, and high-availability database environments.

Additional Resources:

View Details
Informix

IBM Informix is an IBM relational and object-relational database platform used for embedded, transactional, time-series, edge, and enterprise data-management workloads where reliability and administration are important.

Additional Resources:

View Details
MS Access

Microsoft Access is Microsoft's desktop relational database and application platform for forms, reports, tables, queries, and small business data-management applications.

Additional Resources:

View Details
Claris FileMaker Pro

Claris FileMaker Pro is a current low-code custom app and database platform from Claris, an Apple company. It combines data tables, layouts, scripts, forms, reporting, and cross-platform deployment for specialized business applications.

Additional Resources:

View Details
MongoDB

MongoDB is a document-oriented NoSQL database that stores flexible JSON-like documents. It is used for modern application data, evolving schemas, distributed data workloads, and developer-centered data models.

Additional Resources:

View Details
SQL

SQL is the standard query language for relational databases, used to define schemas, query data, join tables, aggregate results, update records, and support reporting or application data access.

Additional Resources:

View Details
Transact-SQL

Transact-SQL is Microsoft's extension to SQL for SQL Server and Azure SQL, used for stored procedures, functions, variables, control-of-flow logic, data manipulation, and database programming.

Additional Resources:

View Details
PL/SQL

PL/SQL is Oracle's procedural extension to SQL for database programming, stored procedures, functions, packages, triggers, and data-processing logic inside Oracle Database environments.

Additional Resources:

View Details
erwin / ERD Data Modeling

erwin / ERD Data Modeling represents entity-relationship diagramming, logical and physical data modeling, schema design, database architecture, and data-relationship documentation, including experience with erwin Data Modeler-style tools.

Additional Resources:

View Details
SQL Server Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) is Microsoft's server-based reporting platform for paginated reports, report deployment, subscriptions, data-source connections, and SQL Server-backed enterprise reporting.

Additional Resources:

View Details
Crystal Reports

Crystal Reports is a report-design and business reporting tool used to create database-backed reports, connect to structured data sources, format output, and deliver operational or business intelligence reporting.

Additional Resources:

View Details
Logi Report

Logi Report is an enterprise reporting engine now positioned within insightsoftware's Logi Analytics portfolio. It supports pixel-perfect reporting, embedded reporting, database-backed report generation, and operational reporting workflows.

Additional Resources:

View Details
SQL Server Management Studio

SQL Server Management Studio is Microsoft's integrated environment for managing SQL Server and Azure SQL databases, writing T-SQL, administering objects, configuring security, executing queries, and maintaining database systems.

Additional Resources:

View Details
Toad

Toad database software is a family of database development and administration tools used for SQL editing, schema browsing, query optimization, database automation, and DBA/developer workflows, especially in Oracle and other enterprise database environments.

Additional Resources:

View Details
pgAdmin

pgAdmin is the open-source administration and development platform for PostgreSQL, used for object browsing, query execution, database management, server administration, and PostgreSQL development workflows.

Additional Resources:

View Details
Navicat

Navicat is a cross-platform database development and administration product family used to connect to relational databases, design objects, run SQL, manage data, model schemas, and support DBA/developer workflows.

Additional Resources:

View Details
dbForge Studio

dbForge Studio is Devart's database IDE and administration tool family for SQL development, schema comparison, database design, query work, data management, and vendor-specific database development workflows.

Additional Resources:

View Details
Aqua Data Studio

Aqua Data Studio is a multi-database IDE for query development, database administration, schema exploration, visual analytics, ER modeling, and data-management work across many database platforms.

Additional Resources:

View Details
RazorSQL

RazorSQL is a universal database query, SQL editor, and database administration tool for connecting to multiple database engines, browsing objects, editing data, running scripts, and supporting developer DBA workflows.

Additional Resources:

View Details
SQuirreL SQL

SQuirreL SQL is an open-source Java SQL client for JDBC-compliant databases. It supports database browsing, SQL execution, object inspection, plugins, and cross-platform database development or administration workflows.

Additional Resources:

View Details
IBM Data Studio

IBM Data Studio is IBM's Eclipse-based database development and administration environment for Db2, Informix, and related IBM data platforms. It supports SQL development, database administration, tuning, and data-driven application workflows.

Additional Resources:

View Details
Eclipse Data Tools Platform

Eclipse Data Tools Platform is an Eclipse project that provides frameworks and tools for data-centric development, database connectivity, SQL editing, database browsing, and integration with heterogeneous data sources.

Additional Resources:

View Details
TOra

TOra is an open-source SQL IDE and database administration tool historically focused on Oracle, with support for SQL worksheets, schema browsing, PL/SQL debugging, and database developer/DBA workflows.

Additional Resources:

View Details
SQLTools++

SQLTools++ is a lightweight Oracle-oriented SQL front end used for SQL execution, database browsing, script work, and developer-focused database access in Oracle environments.

Additional Resources:

View Details
SQL Maestro

SQL Maestro is a database administration and development tool family for SQL editing, object management, database design, data manipulation, and vendor-specific database management tasks.

Additional Resources:

View Details
phpMyAdmin

phpMyAdmin is a web-based administration tool for MySQL and MariaDB. It supports database, table, user, permission, import/export, SQL query, and web-hosting-oriented database management workflows.

Additional Resources:

View Details