Tanishk

Oracle DatabaseBeginner

How to Use Primary Key in Oracle

Create, find, drop, disable and enable primary keys in Oracle, including composite keys, identity columns, the index behind the constraint and the ORA errors you will hit.

MySQLBeginner

How to Use NULL Values in MySQL

How NULL behaves in MySQL comparisons, functions, aggregates, sorting, constraints and indexes, with the queries that silently drop rows and how to fix them.

PostgreSQLBeginner

How to Install PostgreSQL

Install a current PostgreSQL release on Windows, Debian or Ubuntu, RHEL-family Linux or Docker, make the first connection and fix the usual post-install errors.

#installation

MySQLBeginner

What are the New Features of MySQL Enterprise

Learn what MySQL Enterprise has to offer to developers and enterprises to build and manage scalable, reliable, and highly available database.

GeneralBeginner

Overview of Database Management System

See what a DBMS does internally, from query processor to storage engine and transaction log, compare the main types of DBMS, and learn how to choose one.

#db-administration

GeneralBeginner

About Data Science

See where databases and SQL fit in data-science work, from profiling and feature tables to window functions, and avoid the joins and NULLs that skew results.

#data-science

Oracle DatabaseBeginner

Data Types in Oracle

Choose the right Oracle data type for text, numbers, dates, LOBs, JSON, BOOLEAN and VECTOR columns, with size limits and the conversion and NULL behaviour that causes bugs.

Oracle DatabaseBeginner

DUAL Table in Oracle

Learn what Oracle's DUAL table is, when you still need FROM DUAL now that it is optional in 23ai and later, how to generate rows from it, and the mistakes to avoid.

Apache CassandraBeginner

How to Install Cassandra on Windows

Cassandra no longer runs natively on Windows. Run it on a Windows machine with Docker Desktop or WSL2, verify the node with nodetool and cqlsh, and fix common startup errors.

#windows

Microsoft AccessBeginner

How to Create Forms in MS Access

Build Access forms with the Form tool, Form Wizard and Blank Form, switch between Layout and Design view, add controls, restrict data entry and fix #Name? and #Error.

SQL ServerBeginner

How to Restore Database in SQL Server

Restore a SQL Server database with T-SQL or Management Studio: WITH MOVE, NORECOVERY chains, point-in-time recovery, and fixes for errors such as 3154 and 3201.

#restore#sql-server-2014

SQL ServerBeginner

How to Use DATEADD Function

Add or subtract days, months, hours and other units from a date with DATEADD in SQL Server, and handle month-end results, overflow errors and index-friendly filters.

#t-sql