Library
150 results
Microsoft AccessBeginnerProtect an Access database with password encryption, a split design, Windows folder permissions, ACCDE files and trusted locations, and know where Access security stops.
How MongoDB stores data as documents, how to query, update, aggregate and index them in mongosh, and where it fits compared with a relational database.
SQLiteBeginnerWhat SQLite is, how to start using it, how its flexible typing, foreign key and locking defaults differ from server databases, and when it is the right choice.
MongoDBBeginnerInstall MongoDB Community Edition on Windows with the MSI installer, add mongosh, verify the service, enable access control and fix common setup errors.
#installation#windows#windows-10
GeneralBeginnerDecide between a relational and a NoSQL database by comparing schema enforcement, query flexibility, transactions, consistency and scaling, with a practical checklist.
#nosql#scalability
GeneralBeginnerLearn what the Paradox desktop database was, what its .db, .px and .mb files contain, and how to export legacy Paradox tables to CSV or SQL today.
SQL ServerBeginnerInstall a current SQL Server instance on Windows step by step, choose the right free edition, verify it, fix common setup errors, or run it in Docker.
#installation#sql-server-2014
Oracle DatabaseBeginnerUnderstand what Oracle OLAP cubes are, why the option is deprecated, how to check whether your database uses it, and how to build the same model with analytic views.
Oracle DatabaseBeginnerWrite your first PL/SQL blocks, procedures and functions in Oracle, handle exceptions and query results correctly, and avoid the mistakes that make PL/SQL slow or unsafe.
#pl/sql
Oracle DatabaseBeginnerLearn how Oracle Database is put together: instances, memory, files, tablespaces, schemas and pluggable databases, plus editions and a quick way to start a practice database.
GeneralBeginnerIn this article you will learn about the basics of SisoDB. SisoDb is a schema-less document-oriented provider for SQL Server.
#sisodb
