FirebirdSQL – Base course

Duration: 1 days | Price: 300 €
Dates Rome: 26-06-2019, 31-07-2019, 28-08-2019, 25-09-2019, 30-10-2019, 27-11-2019, 25-12-2019


Requirements:


Description:

Installing Firebird it's easy and fast... pushing repeatedly the "next" button! Doing like this you lose the important oppurtunity to create an ad-hoc installation for the system we are preparing
Firebrd it's one of the RDBMS open-source databases, full of features and power.
This workshop, held by Fabio Dodebue, one of the Firebird Foundation members and certainly the most influential Firebird expert in Italy, it will allow you to master the configuration and installation of these wonderful database


Contents:

  • Classic, SuperClassic or Superserver?
    • Installation packages
    • Embedded Server for Windows
  • What is in the kit?
    • Default disk locations
    • Linux
    • Windows
  • Installing Firebird
    • Installing the Firebird server
    • Installing multiple servers
    • Testing your installation
    • Performing a client-only install
  • Server configuration and management
    • User management: gsec
    • Security
      • the pseudo table SEC$USERS
    • Windows Control Panel applets
    • Administration tools
  • Working with databases
    • Connection strings
    • Connecting to an existing database
    • Creating a database using isql
    • Firebird SQL
      • Data type
      • DDL
      • Transaction
      • PSQL
      • Context variable
      • operators, predicats, aggregate function
      • Internal and external function
  • Protecting your data
    • Backup
      • batch system for linux: examples of script se centOS
      • batch system windows: examples of script
    • Monitoring
      • $MON tables managing
        • MON$ATTACHMENTS
        • MON$DATABASE
        • MON$STATEMENTS
      • additional tool IBSurgeon