SQL Advanced

Course length: 1 day (6 Hours)

Course description

Overview: Students will build upon the skills learned in Structured Query Language (SQL): Fundamentals of Querying,learning advanced queries and how to add, update, and delete data, tables, views, and indexes.

Prerequisites: To ensure your success, you must have first completed the Software Training course, Structured Query Language (SQL): Fundamentals of Querying, or have extensive equivalent knowledge.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

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

Target student: Students enrolling in this course should 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.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

· Use advanced techniques for querying a database.

· Query with subqueries.

· Add data to a database.

· Change and delete data from a database.

· Create, alter, and delete tables, and create, use, and delete views.

· Create and delete indexes.

· Manage how data is altered through the use of transactions.

· Create and drop databases.

Course content

Lesson 1: Querying with unions and advanced joins

Querying multiple tables with unions

Advanced Joins

Calculating with COMPUTE

Lesson 2: Querying with subqueries

Subqueries

Lesson 3: Adding data

Inserting data

SELECT INTO

Lesson 4: Updating and removing data

Updating records

Deleting records

Deleting the contents of tables

Lesson 5: Manipulating tables and views

Creating tables

Modifying tables

Deleting tables

Adding and removing views

Lesson 6: Manipulating indexes

Adding and removing indexes

Lesson 7: Ensuring data integrity with transactions

Transactions

Lesson 8: Creating databases

Creating a database with SQL

Deleting a database