Relational Database Skills
Business intelligence and data management are of increasing
importance to companies, and often central to regulatory
compliance. Every major database product requires relational
database skills, including Oracle, IBM DB2, Microsoft SQL
Server, MySQL, Teradata, and others.
Skills range from the industry-standard Structured Query
Language (SQL) for everyday operation, to the data-modelling
and design skills needed for project work. Beyond the core
database, Business Intelligence tools from database vendors and
third parties depend on fundamental skills in data warehouse
design.
Relational Database Skills courses from QA-IQ are
vendor-neutral. The skills covered are platform-independent and
are based on international standards and best practice.
*Note that for hands-on practical work, a nominated database
product will be used.
These courses provide individuals with the core understanding
and practical skills required to work with relational data on
different vendors platforms. Within this section you will
find three core training courses:
-
For strong database maintenance skills,The Structiured
Query Language (SQL) course teaches students how to write
good SQL for querying, updating and maintaining databases.
-
For creation and management of databases the database
design course details how real-world data requirements are
modelled, a logical design produced and, most importantly,
mapped efficiently onto an relational database management
system (RDBMS)
-
For those planning and supporting business intelligence,
the Data Warehouse design course covers techniques and
terms such as OLAP, data-mining and data-cubes. This
practical, vendor-neutral course provides delegate with the
knowledge and skills required to get the most from
vendor-specific Business Intelligence courses.
Relational Database Skills courses