Speak to our team now  0118 324 3000

SQL Advanced Querying

  • Level: Advanced
  • Duration: 1 Day

Course Information

Overview

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

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.

Benefits

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

Prerequisites

SQL Fundamentals of Querying or equivalent knowledge.


Course Outline

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
Ensuring data integrity with transactions
  • Transactions
Creating databases
  • Creating a database with SQL
  • Deleting a database

Whats included in this course?

  • image
    Course Manual
  • image
    Experienced Trainers
  • image
    Certificate of Attendance
  • image
    Unlimited Post Course Support

If you need something more custom, please get in touch with our team.

Request a Quote

Testimonials

  • I thoroughly enjoyed this course but do feel that the duration should be extended in order to allow more time to cover all of the topics. Noel was a fantastic trainer, happy to answer any questions and very good at explaining how to do something, thank you.

    image
    Laura Chesters

    HSBC