Business Intelligence school training courses in Columbia, SC (public, in-house or online)

In this course, students will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Objective :
Upon successful completion of this course, students will be able to: - install Oracle Database 10g. - describe the basics of the Oracle Database 10g architecture. - create a database. - configure Oracle Net services. - use SQL and P...

Full archival course description>>

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the Reporting Services management and administrative tools.

Objective :
After completing this course, students will be able to: - Describe SQL Server Reporting Services and its components. - Create a Reporting Services report. - Enhance a Reporting Services report. - Create and manipulate data sets. - U...

Full archival course description>>

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Objective :
After completing this course, students will be able to: - Describe SQL Server Integration Services and its tools. - Create an Integration Services package. - Implement control flow in an Integration Services package. - Implement data flow in an Integration Services package. - Implement log...

Full archival course description>>

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube.

Objective :
After completing this course, students will be able to: - Describe how SQL Server Analysis Services can be used to implement analytical solutions. - Create multidimensional analysis solutions with SQL Server Analysis Services. - Implement dimensions ...

Full archival course description>>

In this course, students learn about relational database principles and SQL queries using Oracle.

Objective :
- A summation of relational database principles and an introduction to the Oracle relational database server. - Using the iSQL*Plus web-based database interface and other traditional interfaces. - Writing simple SQL queries and moderately complex SQL queries using various join techniques. - Summarizing, grouping and sorting data. - Advanced query techniques such as correlated...

Full archival course description>>