Tag Archives: database

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

 

Advertisements

Training PostgreSQL Administration using Navicat – 2 days

Class overview :

This course covers the installation and use of Navicat for administering PostgreSQL database. It will cover the administration, tuning, backup and recovery of PostgreSQL databases using the Navicat Database Administration Tool.

Class goals :

This course covers the installation and use of Navicat for administering PostgreSQL database. It will cover the administration, tuning, backup and recovery of PostgreSQL databases using the Navicat Database Administration Tool.

Content of PostgreSQL Administration using Navicat

INavicat for PostgreSQL – installation and configuration

Configuring connectivity

  • SSL vs. non SSL
  • Tunneling connections through SSH
  • Understanding Connection keep-alives
  • connection parameter storage

Navicat and Cluster Management

  • Adding and dropping databases
  • Configuring database defaults
  • Carrying out database VACCUUM and ANALYZE operations
  • Duplicating database objects

Using server monitor to modify and manage systems

Backup and Recovery

  • creating backups
  • Converting a backup files into an SQL Script
  • Running recovery scripts
  • Exporting data using Navicat Data export tools

Working with the Navicat Data Viewer/Editor

  • Form and Grid Views
  • BLOB and large text editing
  • custom display formats
  • Sorting & Searching
  • Following Primary Key – Foreign key relationships
  • more complex record filtering

Working with the Navicat Query Builder

  • Overview and features – Syntax highlighting. SQL code completion
  • SQL console
  • Navicat Query logging

Importing and exporting data

  • importing via ODBC
  • importing data from MS-Excel, CSV, Text, DBF …
  • exporting data to Excel, Access, PDF, HTML

Graphical exploration of database/table structure

Managing schemas, view and stored procedures

Managing privileges amd access control

  • visual user manager
  • cloning users and their permissions
  • group membership management

Overview of the Navicat Report Management Tools

  • Report Builder
  • Report Viewer
PostgreSQL Administration using Navicat
Training PostgreSQL Administration using Navicat

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, …

Training PC Applications Series: Database – 1 day

Class overview :

After taking this course, the learner will be able to work with a database application to create a database, create, use, and change a data entry form, retrieve information, and create reports.

Class goals :

  • Open, close, create, and update a database
  • Revise and save records
  • Create, use, and revise a data entry form
  • Create and refine a query
  • Select and sort data
  • Create and edit a report

Content of PC Applications Series: Database

  • Database concepts
  • Opening and closing a database application
  • Adjusting settings
  • Defining table fields
  • Finalizing tables
  • Creating table relationships
  • Adding and revising records
  • Working with forms
  • Searching records
  • Filtering and sorting records
  • Queries
  • Advanced query functions
  • Creating reports
  • Working with reports
  • Printing information
PC Applications Series
Training PC Applications Series

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, …