Category Archives: Training DB Administration

Training Microsoft SQL Server – 5 days

Class overview :

Implementation and maintenance. This course is intended for professionals who typically pursue careers as database administrators, database developers, or business intelligence developers. Additionally, they can be people who do not work with Microsoft SQL Server as a part of their primary job functions but who want to show their breadth of technology experience, such as developers, systems administrators, and others.

Class goals :

This course measures your ability to accomplish the technical tasks listed below.
-Installing and Configuring SQL Server
-Implementing High Availability and Disaster Recovery
-Supporting Data Consumers
-Maintaining Databases
-Monitoring and Troubleshooting SQL Server Performance
-Creating and Implementing Database Objects

Content of Microsoft SQL Server

Student will learn how to install and configure SQL Server 2005, create databases and database objects, SQL server security, creating views, partitions, and linked servers, transact-SQL programming, working with constraints, triggers, and stored procedures, backup and restore of SQL server with SQL agent jobs, data redundancy and availability, using the service broker,  XML data support, SQL server performance monitoring and tuning, troubleshooting server and database errors.

Microsoft SQL Server
Training Microsoft SQL Server

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

Implementation and maintenance. This course is intended for professionals who typically pursue careers as database administrators, database developers, or business intelligence developers. Additionally, they can be people who do not work with Microsoft SQL Server as a part of their primary job functions but who want to show their breadth of technology experience, such as developers, systems administrators, and others.

PIXYSTREE SCS

Rue Beeckmans, 53
1180 Bruxelles

Tel : +32 2 412 04 10
Fax : +32 2 412 04 19
Gsm : +32 485 212 722
Email : selossej@pixystree.com

http://www.pixystree.com

Advertisements

Training Oracle DB Administration I – 9 days

Class overview :

Course Description This course, Oracle Database 10g: Administration I, will address critical skills needed by Oracle Database 10g administrators and prepare students for the Oracle Database 10g: Administration I (1Z1-042) exam.

pixystree-your-Business-solution-in-training-brussels

Class goals :

  • Perform key administrative tasks in Oracle Database 10g
  • Creating and controlling databases
  • Administering users
  • Implementing security features
  • Monitoring performance
  • Performing backup and recovery

Content of Oracle DB Administration I

This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers, and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology. Students will also have knowledge of SQL *Plus, iSQL *Plus, and PL/SQL.

 

Oracle DB Administration I
Training Oracle DB Administration I

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

Course Description This course, Oracle Database 10g: Administration I, will address critical skills needed by Oracle Database 10g administrators and prepare students for the Oracle Database 10g: Administration I (1Z1-042) exam.

PIXYSTREE SCS

Rue Beeckmans, 53
1180 Bruxelles

Tel : +32 2 412 04 10
Fax : +32 2 412 04 19
Gsm : +32 485 212 722
Email : selossej@pixystree.com

http://www.pixystree.com

 

Training Oracle SQL 2 users – 4 days

Class overview :

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

Class goals :

Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations.
• Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
• Understanding basic database security and object privileges.
• Using the powerful set of built-in SQL functions.
• Protecting the database and extending the basic data model using declarative constraints.
• Developing complex SQL*Plus reports and using SQL*Plus scripts.

Content of Oracle SQL 2 users

The target audience for this course is all Oracle professionals. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.

Oracle SQL 2 users
Training Oracle SQL 2 users

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

PIXYSTREE SCS

Rue Beeckmans, 53
1180 Bruxelles

Tel : +32 2 412 04 10
Fax : +32 2 412 04 19
Gsm : +32 485 212 722
Email : selossej@pixystree.com

http://www.pixystree.com

Training Oracle DB Administration II – 9 days

Class overview :

Course Description A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.

Class goals :

learn how to control and manage an Oracle installation.

Content of Oracle DB Administration II

This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology, including some experience with SQL*Plus, iSQL*Plus, and PL/SQL.

Oracle DB Administration II
Training Oracle DB Administration II

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

Course Description A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.

PIXYSTREE SCS

Rue Beeckmans, 53
1180 Bruxelles

Tel : +32 2 412 04 10
Fax : +32 2 412 04 19
Gsm : +32 485 212 722
Email : selossej@pixystree.com

http://www.pixystree.com