future savvy logo
image

SQL Fundamentals of Querying

Dive into SQL fundamentals with our Future Savvy 1-day beginner's course. Master SQL basics, database querying for business insights, and practical skills with experienced instructors. Ideal for enhancing daily operations with SQL, covering SELECT statements, calculations, and multi-table queries. Perfect for those looking to understand SQL from the ground up and apply it effectively in their work.

  • Virtually Online Or On-Site

  • 1 Days

Course Information - SQL Fundamentals of Querying

We believe that learning SQL should be as easy as possible! We can teach you the SQL fundamentals of Querying in just 1 day with hands-on learning from real instructors.

The Future Savvy 1-day SQL course for beginners will teach you the basics of SQL, including what SQL is and how it can help you query a database to answer questions related to your business needs. This is ideal for users who want a better understanding of SQL and want to learn how to use it in their day-to-day operations, from experienced instructors.

Course requirements

We recommend that SQL students are familiar with the components that make up the PC, including input, output, and storage devices. To get the best out of the SQL course, it helps to be familiar with concepts related to database structure and terminology.

We recommend that our students taking the SQL Fundamentals of Querying training course have knowledge of Windows Introduction or the equivalent to get the best out of the course.

What's Next

SQL Fundamentals of Querying is the first course in this series. Students who want to learn more advanced features of the language can take SQL Advanced Querying.


Quick Links

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
footer image

© 2024 - All Rights Reserved.

All trademarks are owned by their respective owners.

  • image
  • image
  • imgae