admin

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…

Chapters Getting started with PHP Variables Variable Scope Superglobal Variables PHP Outputting the Value of a Variable Constants Magic Constants Comments Types Operators References Arrays Array iteration Executing Upon an Array Manipulating an Array Processing Multiple Arrays Together Datetime Class…

Chapters Getting started with Perl Language Comments Variables Interpolation in Perl True and false Dates and Time Control Statements Subroutines Debug Output Lists Sorting File I/O (reading and writing files) Reading a file’s content into a variable Strings and quoting…

Chapters Getting started with Oracle Database Getting started with PL/SQL Anonymous PL/SQL Block PL/SQL procedure Data Dictionary Dates Working with Dates DUAL table JOINS Handling NULL values String Manipulation IF-THEN-ELSE Statement Limiting the rows returned by a query (Pagination) Recursive…

Chapters Getting started with Objective-C Language Basic Data Types Enums Structs Classes and Objects Inheritance Methods Properties Random Integer BOOL / bool / Boolean / NSCFBoolean Continue and Break! Key Value Coding / Key Value Observing NSString NSArray NSMutableArray NSDictionary…

Chapters Getting started with Node.js npm Web Apps With Express Filesystem I/O Exporting and Consuming Modules Exporting and Importing Module in node.js How modules are loaded Cluster Module Readline package.json Event Emitters Autoreload on changes Environment Callback to Promise Executing…

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…

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…

Chapters Getting started with Microsoft SQL Server Data Types Converting data types User Defined Table Types SELECT statement Alias Names in SQL Server NULLs Variables Dates Generating a range of dates Database Snapshots COALESCE IF…ELSE CASE Statement INSERT INTO MERGE…

Chapters Getting started with MATLAB Language Initializing Matrices or arrays Conditions Functions Set operations Documenting functions Using functions with logical output For loops Object-Oriented Programming Vectorization Matrix decompositions Graphics: 2D Line Plots Graphics: 2D and 3D Transformations Controlling Subplot coloring…

Chapters Getting started with GNU/Linux Detecting Linux distribution name and version Getting information on a running Linux kernel Shell Check Disk Space Getting System Information ls command File Compression with ‘tar’ command Services Managing Services Modifying Users LAMP Stack tee…

Chapters Getting started with Kotlin Basics of Kotlin Strings Arrays Collections Enum Functions Vararg Parameters in Functions Conditional Statements Loops in Kotlin Ranges Regex Basic Lambdas Null Safety Class Delegation Class Inheritance Visibility Modifiers Generics Interfaces Singleton objects coroutines Annotations…

Chapters Getting started with jQuery Selectors Each function Attributes document-ready event Events DOM Manipulation DOM Traversing CSS Manipulation Element Visibility Append Prepend Getting and setting width and height of an element jQuery .animate() Method jQuery Deferred objects and Promises Ajax…

Chapters Getting started with JavaScript JavaScript Variables Built-in Constants Comments Console Datatypes in JavaScript Strings Date Date Comparison Comparison Operations Conditions Arrays Objects Arithmetic (Math) Bitwise operators Constructor functions Declarations and Assignments Loops Functions Functional JavaScript Prototypes, objects Classes Namespacing…