Data modelling and Database Design 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 […]
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 in Data Warehouse Design introduces data warehouses, demonstrates the techniques involved in developing dimensional models and shows how these models fit […]
Most businesses, and yours surely too, have a lot of data, from customer details and employee records to product specifications data and invoicing and scheduling systems. How can you manage them easily? With Microsoft Access, you can get to grips with how to store that data effectively in tables, transform and do calculations on them […]
In this course of SQL you will learn how to work with the basics of SQL. Learn to consult data from SQL tables using simple queries. In here you’ll learn about execution order, the basic select statement and the case statement.