Vi ste ovdje
Overview/Description
SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and...
Overview/Description
Database design is an important process for creating databases. In an organization, the process sets the foundation for good database implementation and ensures that everything required for the business is provided. It also ensures that the database will perform as expected for the users. This course discusses what database modeling is and how it is used to aid database design. This course also describes the four steps in the database design life cycle, which are: requirements gathering and analysis, conceptual database design, logical database design, and physical...
Overview/Description
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.2
Lesson ObjectivesIntroduction to PL/SQL
recognize the correct structure...
Overview/Description
Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and...
Overview/Description
Database Management Systems, DBMSs, are used to control, maintain, and use a relational database where the data is stored. A relational database consists of the data records, files, and database objects. An important part of each organization is allowing users to gain access to the data for them to view and manipulated if required. In order for users to do this query languages are used which enable users to write queries and send them to the database to retrieve the appropriate data and return it to them. Queries can also be written to manipulate the data by updating,...
Overview/Description
To manage dependencies and recompile PL/SQL units
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
1.4
Lesson ObjectivesManaging Dependencies
retrieve local dependency information for a given...
Overview/Description
SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It outlines the considerations involved with deploying SSAS projects. This includes project deployments using various methods and synchronization. The course also covers analysis services security solutions related to securing an instance and securing user access. A discussion about disaster recovery, including high-availability solutions and backup solutions is also...
Overview/Description
This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is...
Overview/Description
To use LOBs and the DBMS_LOB package
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
1.9
Lesson ObjectivesManipulating Large Objects in PL/SQL
associate internal and external LOBs with their...
Overview/Description
SkillSoft Mentors are available 24 hours a day, 7 days a week to help students with their studies for exam 1Z0-040 Oracle Database 10g: New Features for Administrators. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.
Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.
Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
