Library
150 results
GeneralBeginnerSee 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
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 DatabaseBeginnerChoose 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 DatabaseBeginnerLearn 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 CassandraBeginnerCassandra 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 AccessBeginnerBuild 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 ServerBeginnerRestore 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 ServerBeginnerAdd 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
SQL ServerBeginnerGet row counts for every user and system table in a SQL Server database instantly from catalog metadata, and know when you need an exact COUNT instead.
#t-sql
Oracle DatabaseBeginnerCreate an Oracle database the current way: build a container database with DBCA, add pluggable databases with CREATE PLUGGABLE DATABASE, then verify, connect and drop them.
#windows-10
SQL ServerBeginnerFind out how much disk space a SQL Server database, table or index uses with sp_spaceused and sys.dm_db_partition_stats, and read the numbers correctly.
#t-sql
