Learn practical SQL querying skills in Central London
This Central London located course will provide you with the core knowledge and skills to create queries using Structured Querying Language (SQL).
Topics ADDED FREQUENTLY include: Agile | PRINCE2 | .NET / C# | SQL | Train the Trainer
Need other locations? Scroll down for further delivery options or Contact Us to discuss your requirements.
|Date (DMY) *1
|Fee - Discounts Available
Offer: £695 View Offer »
|£895 Book Now »
|£895 Book Now »
* QA pricing from their website 15/10/2023. QA class sizes up to 16 possibly mixed Virtual and In-Person attendees on the same event. Prices INCLUDE VAT.
Achieve your next career step by attaining skills in this sought-after data querying language!
This course will provide you with the core knowledge and skills to create queries using Structured Querying Language (SQL). The course syntax is primarily that of ANSI / ISO SQL so the majority of the content is relevant to Microsoft, Oracle, MySQL and other database systems.
It will teach you how to select, filter and sort data from multiple tables and how to use views, functions and stored procedures. Additionally it introduces intermediate techniques to create efficient queries relevant to most businesses.
Each learner is provided with access to the full SQL Server product and utilises SQL Server Management Studio (SMSS) to progress through the exercises.
The course delivery includes discussions, presentations and a high ratio of hands-on exercises to build your knowledge, skills and confidence in data querying.
The course is designed to provide practical concepts and skills for querying SQL databases and as such this will help build skills for certification programs without covering the breadth of any particular certification.
The audience for this course is very wide as databases are used by the vast majority of organisations and querying skills are beneficial to businesses and employees alike. This course is designed for anyone with a requirement to query SQL data either to produce reports or as part of a developer role. It is aimed at an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.
Example audience roles include:
Contact us for an informal chat about the value of learning SQL.
After completing this Practical SQL Querying London Course, students will be able to:
Contact us to discuss the course objectives.
The course is designed for an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.
To attend you'll simply need basic PC literacy and Business English.
Please contact us for further information and an informal discussion about how SQL querying skills will be of use to you.
Materials include courseware, hands-on learning environment and related subject matter.
The public course duration is two days - for onsite, part-time and weekend courses this may vary.
The first module provides the necessary background to allow understanding of the key concepts and associated terminology required to achieve core SQL querying skills. Once these are attained, the technical documentation provided with SQL Server will become more accessible and a further benefit will be ease of communication with persons holding technical roles.
This module covers the core concepts and skills for using the SELECT Statement. The WHERE clause and predicate logic are examined as is ORDER BY. Column level aliases and logical processing order are introduced.
This module explores the more common data types and functions.
This module introduces comprehensive usage of the SELECT Statement and its main clauses.
This module introduces joining tables using the SQL 92 JOIN syntax.
This module covers additional querying strategies where joins are not sufficient.
This module explores the concepts of Table Expressions. These include Views, Table Valued Functions (TVFs), Derived Tables and Common Table Expressions (CTEs).
This module introduces the remaining Set Operators which allow the combining and comparison of queries and further strategies for querying NULL values.
This module discusses more advanced manipulations of data.
This module introduce Stored Procedures are typically encapsulated SQL statements that are stored within the database. Dynamic SQL, queries generated from text or parameters, is also introduced.
This module provides a high-level introduction to the SQL Windowing Functions.
This module introduces the key concepts of maintaining data.