BroadBit project events and news

Working with SQL

without comments

Brief course description and Objectives: ‘Working with SQL’ explains the concept of relational databases, and teaches students to work with SQL through practical examples and exercises.

At the end of the course students will be able to: define new databases and tables, create and update data entries, query data entries, manage user access rights.

Ask for a course!

Intended audience
This course is suitable for software programmers who will be working with SQL, and also for SQL database administrators.

Prerequisites
None

Course duration
2 days hands-on

Course thematics
1. Defining databases and tables
2. Table structure: data field types, key index, auto-indexing
3. Creating new data entries
4. Querying data entries
5. Updating existing data entries
6. Complex queries with the JOIN statement
7. Exporting and importing databases
8. User rights administration

Training equipment requirements
- Classroom with projector
- Each participant has training computer with internet access

Written by BroadBit

November 11th, 2008 at 3:33 pm

Posted in

Leave a Reply

You must be logged in to post a comment.