Monday , 1 June 2020
Stackode

Recent Posts

Perl Notes for Professionals book

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 methods Split a string on unquoted separators Object-oriented Perl Exception handling Regular Expressions XML Parsing Unicode Perl one-liners Randomness Special ...

Read More »

Oracle Database Notes for Professionals book

cover - OracleDatabaseGrow.png

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 Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions) Different ways to update records Update with Joins Functions Statistical ...

Read More »

Objective-C Notes for Professionals book

Chapters Getting started with Objective-C Language Protocols Blocks Categories Key Value Coding / Key Value Observing Logging NSArray Classes and Objects NSString NSDictionary NSDictionary Low-level Runtime Environment NSArray NSURL Methods Error Handling Enums NSData Random Integer Properties NSDate NSPredicate NSMutableArray NSRegularExpression NSJSONSerialization Memory Management Singletons NSCalendar NSMutableDictionary Multi-Threading NSAttributedString NSTimer Structs Subscripting Basic Data Types Unit testing using Xcode Fast ...

Read More »

Node.js Notes for Professionals book

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 files or commands with Child Processes Exception handling Keep a node application constantly running Uninstalling Node.js nvm – Node Version ...

Read More »

MySQL Notes for Professionals book

cover - MySQLGrow.png

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 Operations Handling Time Zones Regular ...

Read More »

MongoDB Notes for Professionals book

cover - MongoDBGrow.png

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 MongoDB Authorization Model Configuration Backing ...

Read More »

Microsoft SQL ServerĀ® Notes for Professionals book

cover - MicrosoftSQLServerGrow.png

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 CREATE VIEW Views UNION TRY/CATCH WHILE loop OVER Clause GROUP BY ORDER BY The STUFF Function JSON in SQL Server ...

Read More »

MATLAB Notes for Professionals book

cover - MATLABGrow.png

Chapters Getting started with MATLAB Language Functions Documenting functions Using functions with logical output Conditions Set operations For loops Initializing Matrices or arrays Matrix decompositions Object-Oriented Programming Vectorization Graphics: 2D Line Plots Graphics: 2D and 3D Transformations Controlling Subplot coloring in Matlab Image processing Drawing Debugging Financial Applications Fourier Transforms and Inverse Fourier Transforms Ordinary Differential Equations (ODE) Solvers Interpolation ...

Read More »

Linux Notes for Professionals book

cover - LinuxGrow.png

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 command Secure Shell (SSH) SCP GnuPG (GPG) Network Configuration Midnight Commander Change root (chroot) Package Managers Compiling the Linux kernel

Read More »

LaTeX Notes for Professionals book

cover - LaTeXGrow.png

Chapters Getting started with LaTeX Title Pages Header and Footer Text Formatting Tables Typesetting mathematics Creating a Bibliography Add Citation Counters, if statements and loops with LaTeX Document classes Drawing graphs Presentation with beamer package Defining macros Build Tools Accessing documentation of LaTeX packages Creating posters using beamer Engraving Sheet Music

Read More »

jQuery Notes for Professionals book

Chapters Getting started with jQuery Ajax Selectors document-ready event DOM Manipulation DOM Traversing Element Visibility Events Plugins Prepend Append Getting and setting width and height of an element CSS Manipulation Attributes jQuery .animate() Method jQuery Deferred objects and Promises Checkbox Select all with automatic check/uncheck on other checkbox change Each function

Read More »

JavaScript Notes for Professionals book

cover - JavaScriptGrow.png

Chapters Getting started with JavaScript JavaScript Variables Built-in Constants Datatypes in Javascript Bitwise operators Arithmetic (Math) Strings Date Date Comparison Comparison Operations Constructor functions Conditions Comments Arrays Objects Declarations and Assignments Loops Functions Functional JavaScript Prototypes, objects Classes Namespacing Callbacks Context (this) Setters and Getters Events Inheritance Method Chaining Intervals and Timeouts Console Regular expressions Cookies Data attributes JSON AJAX ...

Read More »

Java Notes for Professionals book

cover - JavaGrow.png

Chapters Getting started with Java Language Type Conversion Getters and Setters Reference Data Types Java Compiler – ‘javac’ Documenting Java Code Command line Argument Processing The Java Command – ‘java’ and ‘javaw’ Date Class Dates and Time (java.time.*) LocalTime Literals Operators Primitive Data Types Constructors Object Class Methods and Constructor Annotations Immutable Class Immutable Objects Visibility (controlling access to members ...

Read More »

iOS Developer Notes for Professionals book

Chapters Getting started with iOS UILabel UILabel text underlining attributedText in UILabel UIButton UIDatePicker UILocalNotification UIImage Convert NSAttributedString to UIImage UIImagePickerController UIImageView Resizing UIImage Cut a UIImage into a circle UITableView UITableViewController UIRefreshControl TableView UITableViewCell Custom methods of selection of UITableViewCells Custom methods of selection of UITableViewCells UIView Snapshot of UIView UIAlertController UIColor UITextView UITextField Delegate UINavigationController UIGestureRecognizer UIBarButtonItem UIScrollView ...

Read More »

HTML5 Canvas Notes for Professionals book

cover - HTML5CanvasGrow.png

Chapters Getting started with HTML5 Canvas Text Polygons Images Path (Syntax only) Paths Navigating along a Path Dragging Path Shapes & Images on Canvas Media types and the canvas Animation Collisions and Intersections Clearing the screen Responsive Design Shadows Charts & Diagrams Transformations Compositing Pixel Manipulation with “getImageData” and “putImageData”

Read More »