Tag Archives: sql

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 SQL 1 users – 4 days

Class overview :

This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users.

Class goals :

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 subqueries.
• Developing simple SQL*Plus reports.
• Creating and maintaining database tables.
• Taking advantage of new features such as the use of regular expressions.
• 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.
• Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
• Developing complex SQL*Plus reports and using SQL*Plus scripts.

Content of Oracle SQL 1 users

The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:
• Application designers and developers.
• Database administrators.
• Business users and non-technical end 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, …

This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users.

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 SQL Queries / Advanced – 3 days

Class overview :

This Oracle SQL training class helps students master SQL using an Oracle database and prepares students for a PL/SQL course. Note that this course covers SQL, not PL/SQL.

Class goals :

– Learn to create Users and Schemas.
– Learn to use pseudo-columns and functions.
– Learn to write simple and correlated subqueries.
– Learn to write simple and complex joins.
– Learn to use ROLLUP and CUBE.
– Learn to use SET operators.
– Learn to use character and non-character SQL functions.
– Learn to write INSERT, UPDATE, and DELETE statements.
– Learn to create tables.
– Learn to use keys and constraints to protect data integrity.
– Learn to use views, indexes, sequences, and synonyms.

Content of Training Oracle SQL Queries / Advanced

  1. Users and Schemas
    1. Introduction to Users and Schemas
      1. Definitions and Client Tools
      2. SQL Developer Login
    2. About the HR Schema
      1. Sample Schemas
      2. HR Schema Entities
    3. Creating An Application Schema
    4. Exercise: Create a User
  2. Pseudo Columns & Functions
    1. Using The Dual Table
    2. Functions
    3. Exercise: Use the SYSCONTEXT function
    4. Pseudo-Columns
    5. Using Rowid
    6. Using Rownum
    7. Exercise: Use ROWNUM
  3. Using Subqueries
    1. Simple Subqueries
      1. Definition
      2. Nested Subquery
    2. Inline Views
      1. Subquery in the HAVING clause
    3. Correlated Subqueries
    4. Scalar Subquery
    5. Exercise: Subqueries
  4. Joining Tables
    1. Review of Joins
    2. Equijoins
      1. Inner Joins
      2. Outer Joins
    3. Cross Joins
    4. Reflexive Join
    5. Non-Key Join
    6. Natural Joins
    7. Semijoins and Antijoins
    8. Using Named Subqueries
    9. Exercise: Join Exercises
  5. Rollup & Cube
    1. About Group Processing
    2. EMP_DETAILS_VIEW
    3. Simple GROUP BY
    4. ROLLUP Function
    5. GROUPING Function
    6. Using Cube
    7. Exercise: Practice GROUP BY, ROLLUP and CUBE
  6. Using Set Operators
    1. Set Operators Defined
    2. Relationship to Mathematical Set Theory
    3. Restrictions on Set Operators
    4. Exercise: Set Operators Exercise
  7. Conditional Processing
    1. The DECODE Function
    2. The Case Expression
    3. Exercise: Conditional Processing
  8. SQL Functions (Character)
    1. What Are SQL Functions?
    2. Character Functions
      1. CONCAT
      2. LENGTH
      3. INSTR
      4. REPLACE
      5. UPPER
      6. LOWER
      7. INITICAP
      8. LPAD
      9. RPAD
      10. TRIM
      11. TO_CHAR
      12. SOUNDEX
    3. Regular Expressions
    4. Exercise: Character Functions
  9. SQL Functions (Non-Character)
    1. Numeric Functions
      1. The TO_CHAR Function with numbers
    2. Date/Time Functions
    3. Date Format Functions
    4. Date Arithmetic Functions
    5. Null Value Functions
    6. Exercise: SQL Non-Character Functions
  10. SQL Data Manipulation Language
    1. The INSERT Statement
      1. INSERT Statement Categories
    2. The UPDATE Statement
    3. The DELETE Statement
    4. Transactions
    5. Complex Table References
    6. The MERGE statement
    7. Exercise: Data Manipulation Language (DDL)
Oracle SQL Queries / Advanced
Training Oracle SQL Queries / Advanced

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 SQL using Oracle / Introduction – 2 days

Class overview :

This Oracle training course is designed for students new to writing SQL queries with Oracle. The SQL learned in this course is standard to all modern databases, but Oracle will be used in class and syntax and functionality specific to Oracle will be pointed out.

Class goals :

– Understand how Oracle works
– Learn to use Oracle to output reports
– Learn to write queries getting data from multiple tables.

Content of Training SQL using Oracle / Introduction

  1. Relational Database Basics
    1. Brief History of SQL
    2. Relational Databases
      1. Tables
      2. Rows
      3. Columns
      4. Relationships
      5. Datatypes
      6. Primary Keys
      7. Foreign Keys
      8. Relational Database Management System
    3. Popular Databases
      1. Commercial Databases
      2. Popular Open Source Databases
      3. Valid Object References
    4. SQL Statements
      1. Database Manipulation Language (DML)
      2. Database Definition Language (DDL)
      3. Database Control Language (DCL)
  2. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
    3. SELECTing All Columns in All Rows
    4. Exploring the Tables
    5. SELECTing Specific Columns
    6. Sorting Records
      1. Sorting By a Single Column
      2. Sorting By Multiple Columns
      3. Sorting By Column Position
      4. Ascending and Descending Sorts
    7. The WHERE Clause and Operator Symbols
      1. Checking for Equality
      2. Checking for Inequality
      3. Checking for Greater or Less Than
      4. Checking for NULL
      5. WHERE and ORDER BY
    8. Using the WHERE clause to check for equality or inequality
    9. Using the WHERE clause to check for greater or less than
    10. Checking for NULL
    11. Using WHERE and ORDER BY Together
    12. The WHERE Clause and Operator Words
      1. The BETWEEN Operator
      2. The IN Operator
      3. The LIKE Operator
      4. The NOT Operator
    13. More SELECTs with WHERE
    14. Checking Multiple Conditions
      1. AND
      2. OR
      3. Order of Evaluation
    15. Writing SELECTs with Multiple Conditions
  3. Advanced SELECTs
    1. Calculated Fields
      1. Concatenation
      2. Mathematical Calculations
      3. Aliases
    2. Calculating Fields
    3. Aggregate Functions and Grouping
      1. Aggregate Functions
      2. Grouping Data
      3. Selecting Distinct Records
    4. Working with Aggregate Functions
    5. Built-in Data Manipulation Functions
      1. Common Math Functions
      2. Common String Functions
      3. Common Date Functions
    6. Data Manipulation Functions
  4. Subqueries, Joins and Unions
    1. Subqueries
    2. Joins
      1. Table Aliases
      2. Multi-table Joins
    3. Using Joins
    4. Outer Joins
    5. Unions
      1. UNION ALL
      2. UNION Rules
    6. Working with Unions
  5. Conditional Processing with CASE
    1. Working with CASE
  6. (If time allows) Challenge lab
    1. Create your own SQL reports from the Northwind database
SQL using Oracle / Introduction
Training SQL using Oracle / Introduction

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 Foundations of SQL for PostgreSQL – 3 days

Class overview :

This is a course that covers SQL for querying and modifying databases, as well as database transaction processing, creation and dropping of tables and databases and tables. The aim is to provide a sound foundation of SQL, both in general, and in the context of PostgreSQL.

The course is a hands on course and the emphasis is on creating SQL scripts textually, rather than through a GUI.

Class goals :

This is a course that covers SQL for querying and modifying databases, as well as database transaction processing, creation and dropping of tables and databases and tables. The aim is to provide a sound foundation of SQL, both in general, and in the context of PostgreSQL.

The course is a hands on course and the emphasis is on creating SQL scripts textually, rather than through a GUI.

Content of Foundations of SQL for PostgreSQL

Introduction to Database Concepts

  • overview of relational database and the client – server model
  • database concepts – tables, rows and columns, primary keys and foreign keys
  • database data types

Introduction to SQL

  • creating and running SQL scripts
  • overview of SQL syntax
  • guidelines for writing readable and maintainable SQL

Retrieving data – SELECT, WHERE and ORDER

  • Overview of the SELECT statement and its clauses
  • specifying source table(s) – using the FROM clause
  • specifying which columns in a table ( or the entire table ) are to be retrieved
  • result sets
  • Renaming columns using aliases
  • Sorting the query results using ORDER BY

Filter Results using the WHERE clause

  • logical expressions using numeric and string comparison Operators
  • basic numeric and string based filtering
  • filtering based on results of calculations
  • duplicate removal – using DISTINCT
  • combining and extending logical expressions using AND , OR and NOT
  • specifing ranges – BETWEEN and IN
  • handling NULL values
  • basic pattern matching – LIKE
  • Using UNION, INTERSECT and EXCEPT to join SELECT Results
  • Conditional expressions
    • The CASE statement
    • The COALESCE function
    • The NULLIF function

Queries involving multiple tables

  • Overview of the concept of a Join
  • Specifying specific columns in specific tables
  • Inner Joins, Outer Joins , Cross joins, Natural joins
  • Systematic techniques for devising and simplifying complex joins

Working with the Standard PostgreSQL Functions

  • overview and syntax
  • Math, String and Conversion Functions
  • Date modification and calculation functions
  • replacing NULLs with a specific value
  • standard PostgreSQL functions in WHERE clauses

Grouping and Summarizing Results

  • Overview of the Aggregate Functions (MAX(), SUM(), AVG(), COUNT() … )
  • Correct use of Aggregate functions
  • GROUP BY clause
  • HAVING clause

Subqueries

  • Overview of Subqueries and their use
  • Strategies fo designing and constructing subqueries
  • Filtering using subqueries
  • Derived Columns based on subqueries

Views

  • The VIEW concept
  • VIEWS as a means of simplifying complex queries
  • Creating and Dropping Views

Inserting, Updating and Deleting Data

  • Inserting single and multiple rows
  • specifying which columns values are to be inserted in – by column position vs. column name
  • working with Auto-Incrementing Values
  • handling NULL values
  • Inserting Data from one Table into Another
  • Updating and Deleting Data
  • Modifying Data through a View

Inserts, Updates and Deletes in a Transaction Oriented Environment

  • the concept and purpose of a transaction
  • setting up a Transaction Environment
  • Checking the Work to be done
  • Undoing Changes with ROLLBACK
  • Committing a Transaction

Creating and Modifying Tables

  • The CREATE TABLE clause
  • Specifying Primary and Foreign Keys
  • DEFAULT values
  • Constraining Input values
  • Creating and using Temporary Tables
  • Creating a New Table From an Existing Table
  • Altering and Dropping Tables
Foundations of SQL for PostgreSQL
Training Foundations of SQL for PostgreSQL

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