Elliott Farmer Portfolio

My name is Elliott Farmer

Everything Web Design

Web Developer | coder | Webmaster | SEO

SQL | OO PHP | HTML5 | CSS3 | JavaScript

MySQL & PostgreSQL databases

Laravel | Vuejs

8 years experience.

Transmission and data network engineer for ISPs.

16 years experience.

English (native) Spanish (advanced).

Solutions orientated Problem solving mentality.

Learning

My studies & courses

Click on any course to read more

Dani Crossing – HTML5 & CSS3

43 lessons • 20h 10m

Study Duration • 4 Weeks

Dani Crossing – Basic Javascript

36 lessons • 9h 9m

Study Duration • 1 Week

Reece Kenney – Build an Online CV

52 lessons • 3h 56m

Study Duration • 1 Week

Jonas Schmedtmann – HTML5 & CSS3

151 lessons • 37h 30m

Study Duration • 8 Weeks

Jonas Schmedtmann – Advanced JavaScript

320 lessons • 69h 0m

Study Duration • 17 Weeks

Dani Crossing – Basic PHP

65 lessons • 15h 57m

Study Duration • 3 Weeks

Dani Crossing Object Orientated PHP course

Dani Crossing – Basic OO PHP

19 lessons • 4h 59m

Study Duration • 1 Week

Reece Kenney – Build Search Engine Clone

63 lessons • 5h 55m

Study Duration • 1 Week

Reece Kenney – Build Facebook Clone

182 lessons • 16h 51m

Study Duration • 2 Weeks

Reece Kenney – Build Youtube Clone

196 lessons • 18h 43m

Study Duration • 2 Weeks

Brad Travesy - PHP Front to Back

22 lessons • 5h 20m

Study Duration • 1 Week

Brad Travesy OOP PHP and MVC Framework course

Brad Travesy - OOP PHP & MVC

44 lessons • 6h 39m

Study Duration • 3 Weeks

D.Hollingworth – APIs in PHP basic to Advanced

89 lessons • 5h 10m

Study Duration • 3 Weeks

D.Hollingworth – PHP i18n Internationalisation

59 lessons • 3h

Study Duration • 1 Week

Colt Steele – MySQL Beginner to Expert

651 lessons • 37h 33m

Study Duration • 8 Weeks

AmigosCode – PostgreSQL Course for Beginners

61 lessons • 4h 19m

Study Duration • 2 Weeks

Adnan Waheed – PostgreSQL Bootcamp

629 lessons • 67h 30m

Study Duration • 17 Weeks

Brad Traversy – Laravel From Scratch

132 lessons • 13h 30m

Study Duration • 2 Weeks

Brad Traversy – VueJs Crash Course

55 lessons • 2h 57m

Study Duration • 1 Week

Morshedul Arefin – Laravel Travel Agency Website

127 lessons • 26h

Study Duration • 4 Weeks

Bogdan Stashchuk – advanced GIT

320 lessons • 69h 0m

Study Duration • 8 Weeks

nil.pro.np – xampp Windows localhost domain

3 lessons • 0h 41m

Study Duration • 1 Week

netNinja – Docker Crash Course

13 lessons • 2h 07m

Study Duration • 1 Week

Alvin the PM – Jira Complete Course

20 lessons • 1h 33m

Study Duration • 1 Weeks

Cisco CCNA R&S

Cisco Learning Acadamy

Study Duration • 12 Weeks

Foundational C# Certification

Microsoft | FreeCodeCamp

Study Duration • 1 Week

My Website Project

Barcelona Travel Hacks

Javascript Upgrade Plan

Knowledge gained from the Complete JavaScript Course 2022: From Zero to Expert was used to redesign the front-end. I sat deown and designed the CSS, HTML and JS functionality before spending 1 month writing all the code to Make it work. Many many lines of code. For more Information about the project plan and implementation see the Javascript plan pdf.

BTH HTML & CSS Plan for Rel Ver 5.0.0

Knowledge gained from the Build Responsive Real-World Websites with HTML and CSS course was used to redesign the look, feel and code of BTH. The PDF is my notes on everything wrong with BTH and some design concepts for the new look.

barcelona Travel Hacks html & css plan — BTH HTML & CSS Plan for Rel Ver 5.0.0 PDF

barcelona Travel Hacks OOP PHP — BTH OOP PHP for Rel Ver 6.0.0 PDF

BTH HTML & OOP PHP MVC Rel Ver 6.0.0

Knowledge gained from the Object Oriented PHP & MVC course was used to restructure/refactor the back-end PHP code to align the folders and files structuring to conform to the PHP MV model, remove duplicate code and implement a standard php file naming convention. Code cleanup along DRY principles.

BTH PostgreSQL Database implementation

I maintain a MariaDB version, and in parallel, a postgreSQL version of my website database. Future versions will use big data tooling and analytics in the PostgreSQL database while the maraDb version will be the 'light' web server content database. Read about How overcome technical issues when migrating from one database structure to another.

Barcelona Travel Hacks

Website Automation

Barcelona Travel Hacks IndexNow API Design

Barcelona Travel Hacks has about 300 pages of content, over 150 PDF documents and 11,000 images, so managing the updated URLs with Bing Webmaster Tools manually would be a full time job. To automate this task I am leveraging the IndexNow API for Bing webmaster tools as well as the udated_at field of tables in the SQL database. Read more in the Index now API documentation that includes Postman API testing, PHP API handler and a simple Cron scheduler.

Exif tool and Cwebp Documentation — My Notes & implementation for Image Batch Editor PDF

Programatic Image Manipulation

Barcelona Travel Hacks is an image intensive website (11,000 unique images) which leverages three programs for batch and single image metadata manupulation across jpg and WebP formats.

The Exiftool/Gimp/Cwebp batch image manipulation custom App ingests a master JPG image from the SQL database and writes metadata then creates screen full, screen thumb, mobile full and mobile thumb jpg files with metadata EXIF, XMP & IPTC metadata included adding a path to each in the database. Next it converts and file size shrinks to WebP for efficient SEO optimised images. This Image editor APP is a huge time saving tool that automates a boring website admin task. It can bach process a folder of 100 images in about 5 minutes, a task that when performanually, would take about a week.

Gimp Image editor — GIMP – Used to edit raw image files and correct colour, shadow, brightness, aspect ratio, obfuscation for GDPR compliance, etc.

Exiftool Image editor — EXIFTOOL – Corrects metadata for fullsize & thumbnail images and is triggered by custom php code, pulling image metadata from a large SQL table.

Google cwebp Image coder — Google CWEBP Encoder – Converts jpg to webp images preserving image metadata, transparency etc. Trigtered from custom PHP code, updating the SQL with webp filepaths.

Barcelona Travel Hacks Sitemap XML automation

Barcelona Travel Hacks has about 350 pages of content, over 150 PDF documents and 11,000 images, so managing the updated URLs within the XML sitemap would be a labourious and boring task. I have automated this task with a daily cron scheduled script that overwrites the sitmap with a fresh copy leveraging the updated_at field in the SQL database. Read more about the implementation here.

Like what you see?

I would love to hear from you!

GET IN TOUCH!

Resources

Course Keywords:

Resources

Course Keywords:

Inline vs External | JS releases | dynamic typing | let, const & var | Arithmetic operators | comparison operators | assignment operators | Operator precedence | Strings & Template Literals | If Else statements | Type Conversion & Coercion | Truthy & Falsy Values | Equality Operators == or === | Boolean Logic | Logical Operators And Or Not | Switch Statement | Statements & Expressions | Conditional Ternary Operator | JavaScript Releases: ES5, ES6+ and ESNext | activating Strict Mode | JavaScript Functions | function Declarations vs Expressions | Arrow Function | Functions calling other functions | Arrays littoral syntax, Inbuilt function | multi-dimensional array | populate array with function values | Array methods | Introduction to objects | dot or bracket object notation | Object methods | this object | Iteration - for loop | Looping arrays - breaking and Continuing | Looping backwards | loops within loops | while loops | config of vs code - prettier, live server | debugging in console | debugging with breakpoints | HTML & CSS basics | DOM theory | DOM manipulation | DOM events | JavaScript Engine | call stack & Heap | Just-in-Time Optimisation | hoisting | DMZ | scope | Primitive types | Reference types | this keyword | self keyword | object.assign | de-structuring and array | de-structuring and object | spread operator | Rest Pattern and Parameters | Short Circuiting (&& and ||) | Nullish coalescing Operator (??) | Logical Assignment Operators | The for of loop | ES6 Enhanced object literals | Optional Chaining (?) | Object keys, Values & Entries | sets | Maps | What data structure to use? Array, Object, Set, Map | Working with strings | Es6 function default parameters | passing arguments: Value vs Reference | First class & High-Order functions | Functions Accepting Callback Functions | Functions Returning other Functions | The call and Apply Methods | The bind Method | Immediately Invoked Function Expressions (IIFE) | The closure | arr.splice | arr.splice | arr.join | arr.reverse | arr.at | forEach loop | innerHTML | insertAdjacentHTML | Data Transformations: Map, Filter, Reduce | Chaining Methods | Find Method | Some and Every methods | flat, map and flatMap methods | array.fill and Array.from | Number.parseInt | Number.parseFloat | Number.isNaN | Number.isFinite | Number.isInteger | Math.sqrt | Math.max | Math.min | Math.PI | Math.trunc | Math.random | Math.round | Math.ceil | Math.floor | Math.ToFixed | Remainder Operator | Numeric Separators | bigInt | new Date | DateObjects | toISOString | unix datetime | timestamp | Intl.DateTimeFormat | Intl.NumberFormat | Timers: set timeout and Set Interval | countdownTimer | DOM API | DOM node, EventTarget, window, Element node, Text node, Comment node & document node | DOM Inheritance | DOM node methods & properties | selecting elements: documentquerySelector/all(), getElementsById(), getElementsByClassname(), getElementsByTagName() | Inserting elements - insertAdjacentHTML(), createELement() | classList.add(), prepend/append(), cloneNode(), before/after() | Deleting Elements - remove(), parentElement.removeChild() | styles: inline style, getComputedStyle | setProperty() | getAttribute() | setAttribute() | dataset | classList.add, remove, toggle & contains | smooth scrolling: getBoundingClientRect(), clientHeight/Width, scrollTo(), scrollIntoView() | addEventListener(), removeEventListener(), eventTimeout | Event Propagation: Capture target & bubbling phases | e.stopPropagation() | listening in capturing phase | Event Delegation: Implementing Page Navigation | DOM Traversing: childNodes, children, firstElementChild/last, parentNode, parentElement, closest(), previousElementSibling/next | Building a Tabbed Component | Guard clause | sticky Navigation: The scroll Event vs Intersection Observer API | Revealing Elements on scroll: Intersection Observer API | Lazy Loading Images: Intersection Observer API | Building a dynamic slider component | Lifecycle DOM events: DOM content loaded, load event, before unload event | Script loading: head, end of body, Async & Defer | Object Orientated Javascript: Object & prototype | Constructor Functions | New Operator | Prototypal Inheritance | Prototype Chain | ES6 classes | Static Methods | Inheritance between Classes: Constructor Functions, ES6 classes, Object.create() | prototype chain __proto__ | parent/child classes: Constructor Functions, ES6 classes, Object.create() | Encapsulation: Protected properties, Private/public fields, private/public methods | extends, super | chaining public methods | How to plan a web project | Project Architecture | Geolocation API | Leaflet Library | load external library | Implement workout app with leaflet map using OOP classes | Asynchronous/Synchronous JavaScript | new XMLHttpRequest | Request & Response theory | Callback Hell | Promises and the fetch API | The Promise Lifecycle: Pending, Settled, Fulfilled, Rejected | Build Promise | Consume Promise: fetch(), then(), json() | Chaining Promises, common mistakes | Handling Rejected Promises: catch(), finally() | manually throw Error: throw new Error() | Asynchronous Behind the Scenes: The Event Loop, Web API environment, Callback queue, microTasks queue, call stack | Practical demonstration of the event loop and microtask priority | Building a Promise | Promisify Callback Function | Async/Await promises | try…catch error handling | Running Promises in parallel: Promise.all | Other Promise Combinators: race(), allSettled(). any() | Modern JavaScript Development: Modules, third-party | Tools: babel, Webpack, parcel | How ES6 Modules are Imported | Exporting & Importing ES6: Named Export, Default Export, import, as, from | Top Level Await (ES2022) | CommonJS Modules overview | command line NPM install | NPM installing packages: leaflet, lodash-es | restore NPM packages from cloned git repo | Bundling with parcel | Configuring Babel and Pollyfilling | Writing Clean and Modern JavaScript | Declarative and functional JavaScript Principles | Building forkify app in a NPM parcel/babel/pollyfilled core-js environment | Event listener .forEach() event in array | Project architecture: MVC model | Components of any Architecture | Model-View-Controller (MVC) Architecture | MVC implementation in Forkify App | Refactoring for the MVC model | Fractional NPM package | Refactoring the html markup | Helpers and configuration files | Event handlers in MVC: Publisher-Subscriber Design Pattern | Event handlers in MVC: Implementation | MVC: Implementing Error and Success Messages | Refactoring classes | implementing search results pagination | Develop an Update DOM algorithm | Develop an update DOM algorithm | Implement bookmarks in local storage | small bug fixes | stack trace debugger | Implement upload recipe: FormData(), class constructor(), super(), refactoring GET and POST ajax calls, window.history.pushState (), API_KEY | annotating according to JsDoc Standard | publishing with netlify | npm build | continuous deployment from git repo

Course Keywords:

Course Keywords:

the movies database overview | the actors, directors, movies & revenues tables | create movies database tables | import movies database table data | creating databases & tables in PgAdmin 4 | deleting tables from databases | inserting single & multiple rows | escaping apostrophe in a string | returning clause | delete row | delete all rows | upsert on conflict do nothing | upsert on conflict update rows | aliasing with & without AS keyword | aliasing as a string | concatenating columns in a query | order by asc & desc | order by nulls fists & last | select distinct single or multiple columns or all | Comparison, Logical & Arithmetic Operators overview | And Or Operator, Combining And with OR Operator, order of execution | Where Clause Order of Operation & Alias in Where Clause | Using Comparison Operators with numeric, dates, text | Using Limit & Offset | Using Fetch | Using IN & Not IN | Using BETWEEN & Not BETWEEN | Using LIKE & ILIKE | Using Is NULL & IS NOT NULL | Concatenation, CONCAT & CONCAT_WS | Null values with ||, CONCAT & CONCAT_WS | Boolean & accepted values | CHAR, VARCHAR, TEXT differences & use cases | integers - SMALLINT, INT ,BIGINT & use cases | decimal/numeric, Real & Double precision & use cases | Default behaviours of Numeric, Real & Double Precision | Date and Time - Data, Time, Timestamp & TimestampTZ & use cases | interval function w/ date/time | timestampTZ nuances | UUID Data Type | hstore & selecting from a key=>value | JSON | JSONB & GIN indexing | network address data type | Add/modify Table Columns | cast using:: | Add Check or unique constraint to a column | implicit and explicit data conversion | explicit conversion of string to int, string to bool, string to double precision | string to date, timestamp & timestampTZ | string to interval | implicit to explicit data conversions | data conversion using case statement | TO_CHAR function | TO _NUMBER function | TO_DATE function | TO_TIMESTAMP function | Domain Data types: address example, positive number example, email validation regex example, enum set of values, list all domain data types, Drop domain type | Create composite address object | composite inventory item example | Enum data type and dropping | alter, rename, set schema and add attribute to data type | Alter enum type in production server | Enum with default value in table | Create a Type If Not Exists Using PL/pgSQL Function | Constraints: not null | unique | default | primary key | composite primary key | foreign key | check | drop a constraint | drop a FK constraint | create sequence | advance a Sequence | get current value | set value | restart & rename sequence | use PgAdmin 4 to alter a sequence | start with | increment | MinValue & MaxValue | sequence data type | cycle sequence | delete sequence | sequence datatype | Descending sequence | cycle sequence | delete sequence | attach sequence to table column | list all sequences in a database | share one sequence between two tables | create an alphanumeric sequence | String Functions: upper | lower | intcap | left | right | reverse | split_part | trim | btrim | ltrim | rtrim | lpad | rpad | length | char_length | position | strpos | substring | repeat | replace | count() | count(*) | count(1) | count with distinct | sum | sum with distinct | min | max | greatest | least | greatest() vs max() | avg | avg with null values | combining columns with mathematical operators | to_date() | to_timestamp() | to_char() | to_date() | to_timestamp() | make_date() | make_time() | make_timestamp() | make_interval() | make_timestamptz() | extract() | date_part() | math operators with date/time/timestamp/interval | ()overlaps() | current_date(), current_time(), current_timestamp(), localtime(), localtimestamp(), now(), transaction_timestamp() | statement_timestamp() | clock_timestamp() | timeofday() | age() | date accuracy with epoch | pg_timezone_names | pg_timezone_abbrevs | show time zone | set time zone | handling date and time fields in a database | date_part() | date_trunc() | inner join | aliasing tbl names | on clause | join clause | alias.* | inner join using | joining 2+ tables | using cast to join on dissimilar data types | left joins | right joins | full joins | self joins | cross join | natural join | using coalesce to combine data from two tables | on vs where | union | union all | union matched data types | union with filters & conditions | union with different number of columns | intersect | except | what is a schema | add,delete,alter schema | schema hierarchy | move table to new schema | schema search path | duplicate schema and data pg_dump | system catalogue pg_catalog | compare tables and columns in two schemas | schemas and privileges | int4range, numrange, tsrange, tstzrange, daterange open - closed | arrays | comparison operators with arrays & ranges | Inclusion operators with arrays & ranges | array constructions with concat ||, array_cat(), array_prepend(), array_append() | array_ndims() | array_dims() | array_length() | array_lower() | array_upper() | cardinality() | array search functions: array_position() & array_positions() | array_remove() | array_replace() | in & not in | all | any | some | array_to_string() | string_to_array | using arrays in table columns | insert & query array data | update array data | array dimensions are ignored! | unest() | multi-dimensional arrays | array vs jsonb | what is JSON? | JSON syntax | JSON & JSONB data types | representing JSON in postgresql | Creating tables with JSONB columns | select named pairs from JSONB data | update named:pairs: delete pair, update values | insert nested arrays into JSONB | remove elements from nested array in JSONB | row_to_json() | json_agg() | json_build_array() | json_build_object() | json_objects() | handling JSON nulls | jsonb_array_length() | jsonb_each() | jsonb_to_record() | jsonb_array_length() | jsonb_each() | jsonb_to_record() | existance operator | containment operator | Search JSON with postGreSQL functions | indexing JSONB with GIN | what is an index? | create an index (single-column, multi-column) sql|pgAdmin4 | create unique indexes (single-column, multi-column) | list all indexes | index size | pg_indexes_size() | pg_stat_all_indexes() | drop an index | SQL statement execution process | SQL statement executuion stages | query optimizer | optimizer node types | Query cost analysis: seq nodes | index nodes | index only nodes | Bitmap Index nodes | hash joins | merge joins | nested loop joins | working memory | b-tree index | hash index | brin index | gin index | explain statement | brin index | gin index | explain statement | explain output options | explain Analyze | query cost model & formula | cost of indexes (table size, index size, query speed) | indexes for sorted output | execution plans depend on input values | Using Organized Vs Random Data | index only vs index scan query plan speed | partial indexes | expression index | adding data while indexing | invalidating an index | re-index | what are views? | create view | rename view | delete view | create view with filters | using union joins in a view | using inner joins in a view | column order in a view | append a column to view | delete column from view? | regular view does not store data | updatable views | updatable view check option | check local | check cascade | what is a materialized view? | create matview | drop materialized view | changing materialized view data | populate matview in pg_class? | concurrent refresh mview | materialized views pros and cons | example of using matview for website stat analysis | pg query to find all matviews with no unique index | other useful pg matview queries | Subqueries | where | IN | subqueries with JOIN | using union without order by | subqueries with alias | select without from clause | correlated queries | select.. in(subquery) | any with subquery | all with subquery | subquery using exists | what is a cte | how to build a cte | using case statement in cte | join cte result set with table | simultaneous delete & insert with cte | recursive cte for parent child relationship | simultaneous delete & insert with cte | recursive cte for parent child relationship | summarisation with grouping | group by with rollup | using grouping, coalesce & case to produce a beatified rollup table | Intro to windows functions | prepare & understand global trades sample data | use: Agg functions, rollup on single & multiple columns, group by cube & grouping sets | group by cube | aggregation query performance | filter clause | Using Window Function | over clause | sorting inside a window | ordering inside a window | sliding dynamic window | understanding window framing: rows, Between proceeding, unbound, current | rows & ranges | using multiple windows in one query | ntile buckets | lead & lag function | last_value() | first_value() | nth_value() | corr() | row_number() window with partitions | row_number() with order by | row_number() within subquery to find nth record of each partition | apply row_number() to distinct rows | window functions summary | planning tips for window functions | rank vs dense rank | compute global and group ranks | partition by group averages | order by our own defined values | delete & insert in one query using with | intro to regex | regular expressions notations table | similar to | POSIX ~, ~*, !~, !~* | Using regular expression with substring() | regexp_matches() | regexp_replace() | regexp_split_to_table() | regexp_split_to_array() | drawbacks of %LIKE% based search queries | what is full text search | to_tsvector() | to_tsquery | build tsvector table | apply GIN index on tsvector | ts_headline | ts_rank() | what is a partition? | when a partition should be used | table inheritance theory | partition types: range, list & hash | Partition by Range CRUD | partition by list CRUD | partition by hash CRUD | default partition | multi-level partitioning | add new partition | detach partition | alter partition bounds within a transaction | partition_pruning | choseing a field to partition over | dimensioning the partition | partition advantages | common partition mistakes | postgreSQL as a development platform? | procedural languages | keep the data on the server! | functions vs stored procedures | user-defined functions | structure of a function | sql function syntax | create sql function | view function details in pgadmin4 | $$ and $body$ quotation | functions that return void | functions that return a single value | functions using parameters | a function that returns a composite (array of row data) .* or .column_name | select columns from a function return | return a table from a function | function default parameters | function based on views | drop a function | PL/pgSQL introduction | PL/pgSQL vs SQL | structure of a PL/pgSQL function | Declaring variables, using alias for | declaring variables in a function | variables initializing timing | using IN, OUT without RETURNS | scope of variables in block and subblock | how to return query results | Control Structures: IF statements, using if with table data, CASE statements (simple & searched) | loop statement | for loop | iterate over result set in for loop | continue statement | foreach loop | while loop | using return query | returning a table | return next | error and exception handling | eh – too_mny_rows | sqlstate codes for eh | data exception errors | functions vs stored procedures | create transactions | understand use of stored procedures | Returning a value from stored procedure | drop a stored procedure | intro to triggers | what is a trigger? | types of trigger | trigger table | pros & cons of triggers | trigger key points | steps to create a triger | create a data auditing trigger | trigger to modifiy data at insert event | a triggered function to view trigger variables | trigger function to disallow DELETE on a table | trigger function to disallow TRUNCATE on a table | creating an audit trigger | creating conditional triggers | disallow data change on primary key | use triggers very cautiously | what is an event trigger | event triggers usage scenarios | creating event triggers | event trigger events & variables | creating and audit event trigger | prevent schema changes | dropping a trigger | postgreSQL as a development platform? | procedural languages | keep the data on the server! | functions vs stored procedures | user-defined functions | structure of a function | sql function syntax | create sql function | view function details in pgadmin4 | $$ and $body$ quotation | functions that return void | functions that return a single value | functions using parameters | a function that returns a composite (array of row data) .* or .column_name | select columns from a function return | return a table from a function | function default parameters | function based on views | drop a function | PL/pgSQL introduction | PL/pgSQL vs SQL | structure of a PL/pgSQL function | Declaring variables, using alias for | declaring variables in a function | variables initializing timing | using IN, OUT without RETURNS | scope of variables in block and subblock | how to return query results | Control Structures: IF statements, using if with table data, CASE statements (simple & searched) | loop statement | for loop | iterate over result set in for loop | continue statement | foreach loop | while loop | using return query | returning a table | return next | error and exception handling | eh – too_mny_rows | sqlstate codes for eh | data exception errors | functions vs stored procedures | create transactions | understand use of stored procedures | Returning a value from stored procedure | drop a stored procedure | intro to triggers | what is a trigger? | types of trigger | trigger table | pros & cons of triggers | trigger key points | steps to create a triger | create a data auditing trigger | trigger to modifiy data at insert event | a triggered function to view trigger variables | trigger function to disallow DELETE on a table | trigger function to disallow TRUNCATE on a table | creating an audit trigger | creating conditional triggers | disallow data change on primary key | use triggers very cautiously | what is an event trigger | event triggers usage scenarios | creating event triggers | event trigger events & variables | creating and audit event trigger | prevent schema changes | dropping a trigger | understanding row by row operations | cursors and procedural language | steps to create a cursor | creating a cursor | opening a cursor | using a cursor | updating data | closing a cursor | creating a PL/pgSQL cursor | using a parametric cursor via function | what is a crosstab report? | installing the tablefunc extension | creating a crosstab report | order matters in crosstab reports | pivoting with sample rainfalls data | pivoting rows and columns | matrix report via a query | aggregate over a filter | static to dynamic pivots | dynamic pivot query via json | dynamic pivot table columns | interactive client-side pivot | handling missing values | global character set support | client and server encoding | what is a transaction? | how SQL protects database during transaction | ACID database | transaction setup | transaction analysis | how to fix aborted transactions | how to fix transactions on a crash | partial transaction rollback with savepoints | using savepoints with transactions | how to fix aborted transaction | how to fix transaction on crash | partial transaction rollback with savepoints | using SAVEPOINT with transaction | orders shipping to USA or france | total number of orders shipped to USA or france | orders shipped to latin america | show total order amount for each order | first the oldest and latest order date | total products in each category | list products that need reordering | freight analysis | customers with no orders | top customers with total orders amount | orders with many lines of ordered items | orders with double entry items | late shipped orders by employees | countries with customers or suppliers (union & cte) | customers with multiple orders in 4 day period | first order from each country | human resources database structure | quick overview of all tables | get highest, lowest, total & average salaries of employees | difference between highest & lowest salaries by job_id | get lowest paid salaries by each manager | average salary for each department with more than 10 employees | average salary for each department exluding programmers | max salary for each post where salary is equal or above $5000 | using alias name with columns | compute 15% of salaries for all employees | list all employee ids with each job id group | discard characters from employee email address | list all employees with first name beginning with A, B or M | string manipulation with upper, lower & initcap functions | using substring to get portion of string data | get unique designations in employees table | get employees with particular department id | select employees not in range | find 'c' in last name at 3rd or greater position | update phone number with strings | get monthly salary of each employee | calculate average salary with total number of employees | find employees with 6 letter names | select first or last records in a table | get the first or last record for each group | how to calculate cube root in PostGreSQL | security concepts & access levels | instance level security | add users to roles | use pgAdmin4 to create roles | database level security | schema level security |table level security | column level security | row level security | using CURRENT_USER with rls | row level policy for application users (session) | drop a RLS policy | inspecting table permissions | row level security performance | encrypted data in columns | connect to a local or remote database | switch connection to a new database | list all databases & tables | list all table space, schemas & indexes | list all sequences, roles, data types & domain data types | describe a table | edit SQL commands in an editor | display command history, run commands from a file | built in syntax reference for commands | represent NULL values on psql terminal | pretty a psql table layout | repeatedly execute a command | turn on query execution time | list database users, & database sizes with & without indexes | list all databases & schemas | list all tables and views | list all columns from a table | view system metadata via system iInformation functions | view privileges information across tables | using system administration functions | show all running queries | terminate running and IDLE process | how to check live and dead rows in table | file layout of PostGreSQL Tables | Using SELECT INTO to create a new table with joins | Duplicate a Table with or without Data | Import Data from CSV file | Export Data to CSV file | Deleting Duplicate records | Backup Your Database Regularly | Test Queries on a Test Database | Not Documenting your Process? | Database Operations and Table Size | Tracking Table Size | PostGreSQL autovaccum Process | Recovering Unused space with Vacuum | Generate Columns

Course Keywords:

Cisco CCNA R&S Course Overview:

Networking Fundamentals:

Network Components: Understanding the role and function of routers, Layer 2 and Layer 3 switches, next-generation firewalls, access points, controllers, endpoints, servers, and PoE (Power over Ethernet).
Network Topologies: Describing characteristics of different network topologies like two-tier, three-tier, spine-leaf, WAN, SOHO, and on-premise vs. cloud.
Cabling and Interfaces: Comparing physical interface and cabling types like single-mode fiber, multimode fiber, and copper, as well as connections like Ethernet shared media and point-to-point.
Protocols: Understanding the difference between protocols like IP, TCP, and UDP, and the differences between IPv4 and IPv6.

Network Access: Understanding Ethernet concepts and the operation of Cisco switches. Configuring and troubleshooting VLANs and inter-VLAN routing. Understanding the purpose and evolution of Spanning Tree Protocol. Configuring and troubleshooting EtherChannel.
Network Access: Understanding Ethernet concepts and the operation of Cisco switches. Configuring and troubleshooting VLANs and inter-VLAN routing. Understanding the purpose and evolution of Spanning Tree Protocol. Configuring and troubleshooting EtherChannel.
IP Connectivity: Describing the importance of IP addressing and naming schemes at various layers of data networks in both IPv4 and IPv6 environments. Designing, calculating, and applying subnet masks and addresses to fulfill requirements in IPv4 and IPv6 networks. Configuring and troubleshooting basic operations of routers in a small routed network, including routing protocols like OSPF and EIGRP.
IP Services: Configuring and troubleshooting DHCPv4, including understanding DHCP concepts. Describing the operations of Domain Name System (DNS) for both IPv4 and IPv6.
Security Fundamentals: Understanding and configuring access control lists (ACLs) for network security. Describing the current security threat landscape.
Automation and Programmability: The basics of network automation and programmability, introducing tools and technologies used in modern networking environments.
Cisco IOS: Using Cisco command-line interface (CLI) commands to perform basic router and switch configurations.
Troubleshooting: Configuring and troubleshooting basic operations of both routers and switches in a small network.
Network Design: Building a simple Ethernet network using routers and switches.
Configuration: Configuring Cisco Catalyst switches and Cisco IOS routers.

Microsoft Foundational C# Certification:

Write Your First Code Using C#:

Write Your First C# Code
Store and Retrieve Data Using Literal and Variable Values in C#
Perform Basic String Formatting in C#
Perform Basic Operations on Numbers in C#
Guided Project - Calculate and Print Student Grades
Guided Project - Calculate Final GPA

Create and Run Simple C# Console Applications:

Install and Configure Visual Studio Code
Call Methods From the .NET Class Library Using C#
Add Decision Logic to Your Code Using if, else, and else if statements in C#
Store and Iterate Through Sequences of Data Using Arrays and the foreach Statement in C#
Create Readable Code with Conventions, Whitespace, and Comments in C#
Guided Project - Develop foreach and if-elseif-else Structures to Process Array Data in C#
Challenge Project - Develop foreach and if-elseif-else Structures to Process Array Data in C#

Add Logic to C# Console Applications:

Evaluate Boolean Expressions to Make Decisions in C#
Control Variable Scope and Logic Using Code Blocks in C#
Branch the Flow of Code Using the switch-case Construct in C#
Iterate Through a Code Block Using the for Statement in C#
Add Looping Logic to Your Code Using the do-while and while Statements in C#
Guided Project - Develop Conditional Branching and Looping Structures in C#
Challenge Project - Develop Branching and Looping Structures in C#

Work with Variable Data in C# Console Applications:

Choose the Correct Data Type in Your C# Code
Convert Data Types Using Casting and Conversion Techniques in C#
Perform Operations on Arrays Using Helper Methods in C#
Format Alphanumeric Data for Presentation in C#
Modify the Content of Strings Using Built-In String Data Type Methods in C#
Guided Project - Work with Variable Data in C#
Challenge Project - Work with Variable Data in C#

Create Methods in C# Console Applications:

Write Your First C# Method
Create C# Methods with Parameters
Create C# Methods that Return Values
Guided Project - Plan a Petting Zoo Visit
Challenge Project - Create a Mini-Game

Debug C# Console Applications:

Review the Principles of Code Debugging and Exception Handling
Implement the Visual Studio Code Debugging Tools for C#
Implement Exception Handling in C# Console Applications
Create and Throw Exceptions in C# Console Applications
Guided Project - Debug and Handle Exceptions in a C# Console Application Using Visual Studio Code
Challenge Project - Debug a C# Console Application Using Visual Studio Code

Elliott Farmer Portfolio

Everything Web Design

My studies & courses

Click on any course to read more

HTML5, CSS3 & Javascript Courses

Dani Crossing – HTML5 & CSS3

43 lessons • 20h 10m

Study Duration • 4 Weeks

Dani Crossing – Basic Javascript

36 lessons • 9h 9m

Study Duration • 1 Week

Reece Kenney – Build an Online CV

52 lessons • 3h 56m

Study Duration • 1 Week

Jonas Schmedtmann – HTML5 & CSS3

151 lessons • 37h 30m

Study Duration • 8 Weeks

Jonas Schmedtmann – Advanced JavaScript

320 lessons • 69h 0m

Study Duration • 17 Weeks

OO PHP

Dani Crossing – Basic PHP

65 lessons • 15h 57m

Study Duration • 3 Weeks

Dani Crossing – Basic OO PHP

19 lessons • 4h 59m

Study Duration • 1 Week

Reece Kenney – Build Search Engine Clone

63 lessons • 5h 55m

Study Duration • 1 Week

Reece Kenney – Build Facebook Clone

182 lessons • 16h 51m

Study Duration • 2 Weeks

Reece Kenney – Build Youtube Clone

196 lessons • 18h 43m

Study Duration • 2 Weeks

Brad Travesy - PHP Front to Back

22 lessons • 5h 20m

Study Duration • 1 Week

Brad Travesy - OOP PHP & MVC

44 lessons • 6h 39m

Study Duration • 3 Weeks

D.Hollingworth – APIs in PHP basic to Advanced

89 lessons • 5h 10m

Study Duration • 3 Weeks

D.Hollingworth – PHP i18n Internationalisation

59 lessons • 3h

Study Duration • 1 Week

Database Courses

Colt Steele – MySQL Beginner to Expert

651 lessons • 37h 33m

Study Duration • 8 Weeks

AmigosCode – PostgreSQL Course for Beginners

61 lessons • 4h 19m

Study Duration • 2 Weeks

Adnan Waheed – PostgreSQL Bootcamp

629 lessons • 67h 30m

Study Duration • 17 Weeks

Frameworks

Brad Traversy – Laravel From Scratch

132 lessons • 13h 30m

Study Duration • 2 Weeks

Brad Traversy – VueJs Crash Course

55 lessons • 2h 57m

Study Duration • 1 Week

Morshedul Arefin – Laravel Travel Agency Website

127 lessons • 26h

Study Duration • 4 Weeks

Coding Tools

Bogdan Stashchuk – advanced GIT

320 lessons • 69h 0m

Study Duration • 8 Weeks

nil.pro.np – xampp Windows localhost domain

3 lessons • 0h 41m

Study Duration • 1 Week

netNinja – Docker Crash Course

13 lessons • 2h 07m

Study Duration • 1 Week

Alvin the PM – Jira Complete Course

20 lessons • 1h 33m