future savvy logo
image

SQL Introduction to Querying

Unlock the power of SQL with our 2-day SQL Introduction to Querying course. Start with the basics, learning to query databases and extract business insights, then progress to advanced techniques like unions, sub-queries, and complex joins. Led by expert instructors, this hands-on course equips you with the essential skills to confidently manage and manipulate databases in your daily work.

  • Virtually Online Or On-Site

  • 2 Days

  • Next Running:

    2nd December
UPCOMING COURSES
Monday

2nd December 2024

Virtually Online
£795.00

EX. VAT

Tuesday

4th February 2025

Virtually Online
£795.00

EX. VAT

Thursday

3rd April 2025

Virtually Online
£795.00

EX. VAT

Thursday

5th June 2025

Virtually Online
£795.00

EX. VAT

Monday

4th August 2025

Virtually Online
£795.00

EX. VAT

Tuesday

2nd December 2025

Virtually Online
£795.00

EX. VAT

Course Information - SQL Introduction to Querying

Master SQL querying with our comprehensive 2-day SQL Introduction to Querying course, designed for both beginners and those looking to enhance their skills. This hands-on course combines the fundamentals of SQL with advanced techniques, offering a complete learning experience.

On day one, you'll explore the basics of SQL, including what SQL is, how to query databases, and how it can be applied to your business needs. You'll learn to write basic SELECT queries, understand database structures, and retrieve data from multiple tables—perfect for those who want to use SQL in day-to-day operations.

On day two, you'll dive into advanced topics such as unions, subqueries, complex joins, and manipulating data. You'll learn to add, update, and delete data, create and manage databases, and gain full control over your data environment.

Course requirements


This course is ideal for anyone from beginners with no prior SQL experience to experienced users looking to solidify their skills. Familiarity with basic computer concepts and database structure is helpful but not required.

What you will learn

By the end of this course, you’ll be able to confidently query, manipulate, and manage relational databases, equipping you with skills that are immediately applicable in the workplace.



Course Outline

  • 1
    Introduction to databases and SQL
    • Database concepts
    • Understanding SQL concepts
  • 2
    Introduction to the SELECT statement
    • An overview of the SELECT statement
    • Syntax rules you’ll want to know
  • 3
    Calculating data
    • Aggregate functions
    • Column aliases
    • Performing calculations
    • Date functions
  • 4
    Selecting specific rows
    • The WHERE clause
    • The ORDER BY clause
  • 5
    Working with other operators
    • Searching for text
    • Logical operators
    • NULLs
  • 6
    Grouping data
    • The GROUP BY clause
    • The HAVING clause
    • Comparing the WHERE and HAVING clauses
  • 7
    Multi-table queries
    • Joins
    • Joining tables
    • Outer joins
  • 8
    Querying with unions and advanced joins
    • Querying multiple tables with unions
    • Advanced Joins
    • Calculating with COMPUTE
  • 9
    Querying with subqueries
    • Subqueries
  • 10
    Adding data
    • Inserting data
    • SELECT INTO
  • 11
    Updating and removing data
    • Updating records
    • Deleting records
    • Deleting the contents of tables
  • 12
    Manipulating tables and views
    • Creating tables
    • Modifying tables
    • Deleting tables
    • Adding and removing views
  • 13
    Manipulating indexes
    • Adding and removing indexes
  • 14
    Ensuring data integrity with transactions
    • Transactions
  • 15
    Creating databases
    • Creating a database with SQL
    • Deleting a database

Private courses.

We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!

  • Tailored
  • Post Course Support
  • Cost Effective
Enquire

Reviews

  • Excellent Course, Lee is extremely knowledgeable, and happy to answer any questions from anyone

    Michelle
  • I really enjoyed this course and thought that Noel was an excellent trainer - very clear and easy to understand

    Sally
  • Lee is an excellent trainer

    Julia