SQL Advanced Querying

Course Description
Course Outline

Course Overview

Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.

Prerequisites

SQL Fundamentals of Querying or equivalent knowledge.

Benefits

Students will learn how to change, update and manipulate an SQL database.

Target student

Students should already understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins.

We offer a range of SQL training courses

Querying with unions and advanced joins
Querying multiple tables with unions Advanced Joins Calculating with COMPUTE
Querying with subqueries
Subqueries
Adding data
Inserting data SELECT INTO
Updating and removing data
Updating records Deleting records Deleting the contents of tables
Manipulating tables and views
Creating tables Modifying tables Deleting tables Adding and removing views
Manipulating indexes
Adding and removing indexes
Ensuring data integrity with transactions
Transactions
Creating databases
Creating a database with SQL Deleting a database

Publisher:	Open
Version:
Length:	1 day
Course-ID:	077421

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The trainer took the trouble to find out what we required before the course and adapted the material to our needs very well

- Gillette