Core-Origins: putting our staff and clients first in IT.|info@core-origins.com

    SQL Languages

    • 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 […]
    • The main purpose of this 5 days instructor led  course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course […]
    • 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.