Databases

I am a very experienced programmer in several database systems (SQL and No-SQL), but specially with relational databases and SQL.

SQL

I am a very experienced SQL programmer and an enthusiast of PostgreSQL. See several of my repositories in my github account such as this about Dominican missions in the Philippines .

CREATE OR REPLACE FUNCTION order_absent_dioceses_edm (order_searching INT)
  RETURNS TABLE (
    r_order_id int, r_order_acronym varchar, r_order_nickname varchar,
    r_diocese_id INT, r_diocese_name varchar, r_country VARCHAR)
LANGUAGE  plpgsql
AS $$

BEGIN
  RETURN query
  WITH diocconfrailes AS
   (SELECT DISTINCT diocese_id, order_id FROM vistas.b_edm_ss_sa b),
   -- cruzamos todos los datosde diócesis y órdenes
  cruzada AS
    (SELECT r.order_id,
      CASE
        WHEN r.year_foundation = '4th Century' THEN '350'
        WHEN r.year_foundation = '6th Century' THEN '550'
        ELSE r.year_foundation
      END AS fundacionorder,
      diocese_id, (other_data->'gcatholic'->>'foundation')::integer AS fundaciondioc
     FROM general.dioceses d, general.religious_orders r),
    -- miramos donde noestán
   diocsinfrailes AS (
     SELECT order_id, fundacionorder, diocese_id, fundaciondioc
     FROM cruzada c
     WHERE NOT EXISTS (SELECT 1, 2 FROM diocconfrailes df
                       WHERE df.diocese_id = c.diocese_id AND df.order_id = c.order_id )),

   -- lo hacemosmás presentable
  SELECT d.order_id, r.order_acronym, r.order_nickname,
         diocese_id, dd.diocese_name, p.country
  FROM diocorrg d
  JOIN general.dioceses dd USING(diocese_id)
  LEFT JOIN general.places p USING(place_id)
  WHERE d.order_id = order_searching
END;
$$

No-SQL

I have experience in using MongoDB for of the Atlantocracies project .