3756,3757,3761,3776,3781,3787,3790,3815,3819,3827,3830,3832,3833,3834,3835,3836,3837,3839,3848,3849,3843,3844,3846,3858,3859,3860,3861,3862,3863,3864,3865,3866,3867,3878,3884,3887,3886,3881,3889,3891,3893,3895,3896,3897,3899
Skip to content
-
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.
-
JOIN and Set Operations. Subqueries. Data Manipulation.
-
The basic SELECT statement. CASE Expression.
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. […]
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 […]
