Skip to main content

MySQL Notes for Professionals book

MySQL Notes for Professionals book

Chapters Getting started with MySQL Data Types SELECT Backticks NULL Limit and Offset Creating databases Using Variables Comment MySQL INSERT DELETE UPDATE ORDER BY Group By Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause … Joins JOINS: Join 3 table with the same name of id. UNION Arithmetic String operations Date and Time […]

PostgreSQL Notes for Professionals book

PostgreSQL Notes for Professionals book

Chapters Getting started with PostgreSQL Data Types Dates, Timestamps, and Intervals Table Creation SELECT Find String Length / Character Length COALESCE INSERT UPDATE JSON Support Aggregate Functions Common Table Expressions (WITH) Window Functions Recursive queries Programming with PL/pgSQL Inheritance Export PostgreSQL database table header and data to CSV file Triggers and Trigger Functions Event Triggers […]

MongoDB Notes for Professionals

MongoDB Notes for Professionals

Chapters Getting started with MongoDB CRUD Operation Getting database information Querying for Data (Getting Started) Update Operators Upserts and Inserts Collections Aggregation Indexes Bulk Operations 2dsphere Index Pluggable Storage Engines Java Driver Python Driver Mongo as Shards Replication Mongo as a Replica Set MongoDB – Configure a ReplicaSet to support TLS/SSL Authentication Mechanisms in MongoDB […]