Training Capstone Courseware

Training goals dlearning

Version 1.0

This course provides an in-depth introduction to the Structured Query Language, or SQL. Students learn key concepts of relational databases and query design, and have extensive opportunities to write database queries. The course also introduces table design and database update statements.

Learning Objectives

  • Understand the structure of relational databases.
  • Write simple select-from-where style queries.
  • Write standard and correlated subqueries.
  • Write queries that use all styles of table join.
  • Build database tables, and write insert, update, and delete statements to modify data.

Conspect Show list

  1. Relational Databases and SQL
    • Relational Databases
    • SQL
    • Schema
    • Integrity
    • DDL
    • DML
  2. Tools
    • Tools and Environment
    • Creating the Course Schema
  3. The select Statement
    • SQL Syntax
    • Basic Query Structure
    • Null Values
    • Result Sets
  4. The select Clause
    • The Expression List
    • Character Expressions
    • Column Headers and Aliases
    • Mathematical Expressions
    • Functions
    • Using distinct
  5. The where Clause
    • Filtering Predicates
    • SQL Operators and Precedence
    • Equality and Inequality Operators
    • Logical Operators
    • between
    • like
    • in
    • is null
    • Functions
  6. The order by Clause
    • Sorting by Column Names
    • Sorting by Expressions
    • Sorting by Ordinal
  7. Aggregate Functions
    • Aggregates
    • count
    • avg
    • Querying Groups
    • Grouping and the where Clause
    • Choosing and Filtering Groups
  8. Standard Subqueries
    • What is a Subquery?
    • Standard Subqueries
    • Using Aggregate Functions
    • Subquery Operators
  9. SQL-Standard Joins
    • Why Joins?
    • Foreign Keys and Joins
    • Qualifying Columns
    • Table Aliases
    • Inner and Outer Joins
  10. Correlated Subqueries
    • Correlated Subqueries
    • Subqueries and Scope
    • Performance
  11. DDL for Tables
    • Tables
    • Object Names
    • Data Types
    • Creating a Table
    • Dropping a Table
  12. Maintaining the Data in Tables
    • Identifying Column Position and Data Type
    • The insert Statement
    • The update Statement
    • The delete Statement
    • Transaction Control
    • Auto-Commit
Download conspect training as PDF

Additional information

Requirements
  • No formal prerequisites.
Difficulty level
Duration 3 days
Certificate

The participants will obtain certificates signed by Capstone Courseware.

Trainer

Authorized Capstone Courseware Trainer.

Capstone Courseware show more courses
Training thematically related

Programming

Databases

Contact form

Please fill form below to obtain more info about this training.







* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

725 EUR

close

Discount codes

Discount code may refer to (training, producer, deadline). If you have a discount code, enter it in the appropriate field.
(green means entering the correct code | red means the code is incorrect)

FORM OF TRAINING ?

close

Traditional training

Sessions organised at Compendium CE are usually held in our locations in Kraków and Warsaw, but also in venues designated by the client. The group participating in training meets at a specific place and specific time with a coach and actively participates in laboratory sessions.

Dlearning training

You may participate from at any place in the world. It is sufficient to have a computer (or, actually a tablet, or smartphone) connected to the Internet. Compendium CE provides each Distance Learning training participant with adequate software enabling connection to the Data Center. For more information, please visit dlearning.eu site

TRAINING MATERIALS ?

close

Paper materials

Traditional Materials: The price includes standard materials issued in the form of paper books, printed or other, depending on the arrangements with the manufacturer.

Ctab materials

Ctab materials: the price includes ctab tablet and electronic training materials or traditional training materials and supplies provided electronically according to manufacturer's specifications (in PDF or EPUB form). The materials provided are adapted for display on ctab tablets. For more information, check out the ctab website.

 

SELECT TERM TRAINING

No deadlines for this training.

Suggest your own appointment

Upcoming Capstone Courseware training

Training schedule
Capstone Courseware