Start Dates: TBC
Duration: 1 Day
CPD Hours: 6 CPD Hours
Full Fee: €130
Network Members Fee: €90
Programme overview
Delegates will work with advanced queries to manipulate and index tables. They will also create transactions so that you can choose to save or cancel data entry process
Learning outcomes
To work more efficiently with advanced SQL queries
Who is the course for?
Delegates who want to learn about advanced querying
Modules
- Use Sub queries to generate query output.
- Manipulate table data by inserting and updating records in a table and deleting records from a table.
- Manipulate the table structure.
- Create views, manipulate data through views, modify the view structure, and drop views.
- Create indices on table columns and drop inefficient indices.
- Mark the beginning of a transaction, create a save point within a transaction, rollback a transaction, and commit a transaction
Trainer Profile
Please contact info@ifsskillnet.ie for more information on Training Providers.