Marko Jankovic marko-jankovic

Chapter 1: Introduction to PL/pgSQL

What is PL/pgSQL?

PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language used to write functions, triggers, and stored procedures within the PostgreSQL database. It extends SQL by adding control structures such as loops, conditions, and error handling. This allows developers to write more complex database operations and business logic inside the database itself.

Unlike SQL, which is primarily used to query and manipulate data, PL/pgSQL allows for procedural control over how and when those operations occur, making it ideal for tasks such as automation, batch processing, and integrating complex business logic into your database operations.

History and Significance in PostgreSQL

1. 10 Interview Questions Every JavaScript Developer Should Know
2. 21 Essential JavaScript Interview Questions from best mentors all over the world
3. 25 Essential JavaScript Interview Questions from top 3% developers company
4. 5 More JavaScript Interview Exercises
5. 5 Typical JavaScript Interview Exercises
6. Development hiring managers and potential interviewees may find these sample JavaScript proficiency interview Q&As and code snippets useful
[7. JavaScript

This list is provided as a guide for tools engineers of all skill levels looking for jobs in the game industry. It's meant as a guide to topics that should be pursued broadly in order to be well spoken in an interview. I doubt any hiring manager requires deep knowedge across every topic, but an ideal candidate would be somewhat knowledgable (aware of its existence if asked directly) with all topics here.

Each list of bullets increases in difficulty, so later bullets are more applicable to senior (or even director) level candidates.

Good luck.

@gorlak

Math

Junior Web/JS/PHP Developer

Ovo je kompilacija pitanja na koje smo odgovarali na raznim intervjuima za poslove. U pitanju je Junior Dev pozicija, tako da se većina pitanja bavi bazičnim stvarima, ali u okviru intervjua ispitivači vole da ispitaju vaše granice i da zadaju i poneko teže pitanje.

Ukoliko želite da pomognete, javite nam neka od pitanja koja su Vas pogodila na mail, ili na Slacku, ili uradite pull request.

Puna verzija ovog fajla se nalazi na: https://gist.github.com/markomitranic/d9319af84d2c87b81df9

1. HTML Fundamentals

HTML Structure and Semantics

What is HTML?
HTML (Hypertext Markup Language) is the standard language used to create and design documents on the web. It structures content using elements or tags.
What are the building blocks of HTML5?
The building blocks of HTML5 include elements like <header>, <footer>, <section>, <article>, and <nav> which enhance semantic meaning and accessibility.
What is the purpose of the `` element in HTML?

What forces layout / reflow

All of the below properties or methods, when requested/called in JavaScript, will trigger the browser to synchronously calculate the style and layout*. This is also called reflow or layout thrashing, and is common performance bottleneck.

Generally, all APIs that synchronously provide layout metrics will trigger forced reflow / layout. Read on for additional cases and details.

Element APIs

Getting box metrics

elem.offsetLeft, elem.offsetTop, elem.offsetWidth, elem.offsetHeight, elem.offsetParent

Frontend Developer Interview Questions

JavaScript

Types

What are the primitive/native types exist?
Which built-in prototypes exist?
What is the difference between a primitive and complex type?
Which primitives have corresponding objects?

###Time Complexity O(1) is constant time, no matter how much data there is, it will take the same amount of time to find the answer
O(log n) is cutting the search area in half each time
O(n) is looping through each item once
O(n²) is looping through twice
0(nⁿ) is looping through each value and having to do something with each value based on how many values came before it
####TapeEquilibrium rewrite
A is an Array = [3,1,2,4,3]
N is the length of A

	#!/bin/bash

	if [[ "$STASH_USER" == "" \|\| "$STASH_PASS" == "" ]]; then
	echo "FATAL: You need to set STASH_USER and/or STASH_PASS"
	exit 1
	fi

	STASH_HOST=${STASH_HOST:-stash.hq.practicefusion.com}
	STASH_URL=https://${STASH_USER}:${STASH_PASS}@${STASH_HOST}