Keywords
advanced database design olap procedures security sql stored triggers views
Advanced SQL Training Course
Designing an SQL database is a specialised skill that needs a deep understanding of the use, application and storage of information in computer systems.
Database designers must balance various conflicting requirements, such as providing the performance required for an on-line transaction processing (OLTP) system while simultaneously ensuring quick and easy reporting. The need for on-line analytical processing (OLAP) drives the design and development of a data warehouse to centralise the information for reporting. Well designed data marts can improve the reporting performance by a factor of up to 1,000.
Databases designed for OLTP systems are typically normalised for performance but then require various de-normalised views, as well as functionality incorporated into the database via stored procedures and triggers. In particular, stored procedures help to maintain the integrity of the data and protect against security threats such as SQL injection attacks.
This course covers:
- the design of databases, including normalisation.
- improving performance with indices and partitions.
- presenting different perspectives on the data with views.
- programming databases with stored procedures and triggers.
- data warehouses and data marts.
- protecting against data degradation and SQL injection.
Click here to see the full course description of the Advanced SQL training course.
Training Courses in Wellington New Zealand
The Advanced SQL training course will run in Wellington New Zealand on the following dates: 14 March 2012.
Click here to see the list of courses in Wellington New Zealand.
