Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - ANSI SQL

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCSY155

ANSI SQL
DURATION: 3 days

FEE: $1,185

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Webmaster
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. SQL and Relational Database Management Systems
      • Examine the concepts and terminology of a RDMS: Relational Database Management System.
      • Review and expand upon the concepts specific to the environment of the client organizations sending the students for the training.
    2. SQL Datatypes
      • Display columns with a variety of datatypes and recognize datatype errors.
      • Code a series of SELECT statements which retrieve data with a variety of datatypes.
      • Perform calculations on a character string column.
      • Display datatype information from the system catalog.
    3. Creating and Modifying Database Objects
      • Utilize the procedures required for creating tables, views, and indexes.
      • Create a simple table with an index.
      • Load sample data into the new table.
    4. Altering and Destroying Objects
      • Utilize the procedures for altering the properties and columns of a table.
      • Add a new column to the table created previously.
    5. Data Manipulation
      • Modify the data into an existing table.
      • Add, update, and delete rows in a table.
      • Handle operations that have been rejected by the database.
    6. Transactions and Locks
      • Recognize the consequences of locks and deadly embrace.
      • While running multiple statements, force the system into a deadly embrace.
      • Monitor the locks and ensuing error condition.
    7. Retrieving Data
      • Code simple and complex SQL queries.
      • Code SQL which calculates derived columns, uses complex conditions, performs a single join, and performs a subquery.
    8. Multi-table Queries
      • Code intermediate and more complex SQL queries.
      • Code SQL that joins multiple tables using multiple types of joins.
      • Code SQL to perform multi-level sub queries from two and three tables.
    9. SQL Functions
      • Utilize functions for string and date manipulation.
      • Extract a string from a column, produce a proper name from a string, and translate the values.
      • Determine the number of days between dates and display the date in a variety of formats.
    10. SQL Operators
      • Code SQL using a variety of operators.
      • Extract data based on pattern masking.
      • Code several complex conditions including inline tables.
    11. Procedural Extensions
      • Recognize how to use stored procedures and pass parameters.
      • Code and invoke a stored procedure without and with arguments.
      • Code and invoke a stored procedure returning a single value.
      • Code and invoke a stored procedure returning a resultset.
    12. ANSI Extensions
      • Acquire familiarity with ANSI extensions.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.