Core-Origins: putting our staff and clients first in IT.|info@core-origins.com
    • The course includes industry standard techniques for data analysis and database design and places them in a modern day development environment. After an introductory session covering database design, sound theoretical concepts are linked to practical considerations. The course sequence moves from logical data analysis and data model development through to physical database design and optimisation. […]
    • Data warehousing has evolved into a unique and key component of IT strategy for many organisations. Dimensional modelling is the proven technique for developing understandable, high performance data warehouses and data marts. This course introduces data warehouses, demonstrates the techniques involved in developing dimensional models and shows how these models fit in to the process […]
    • General Concepts. Tables. Data Integrity. Some other Database Obejects.
    • SQL Advanced

      JOIN and Set Operations. Subqueries. Data Manipulation.
    • SQL Basic

      The basic SELECT statement. CASE Expression.