Introduction to SQL - Edinburgh

Data querying skills are essential for many IT, Big Data, Analyst and Project Management roles. Structured Query Language (SQL) is the most widely used data querying language in the world.

Watch the video: The video is available - simply click on the Watch this video on YouTube link on the Course Media Tab (below) for an overview of the course.

Attend this two day duration SQL Querying course in Central Edinburgh to gain not just the key concepts and skills required but also effective ways to query and organise data. Using a live installation of Microsoft's SQL Server product with a balanced ratio of interactive discussions and lives hands-on exercises you'll quickly master selecting, ordering and grouping data from multiple database tables along with additional powerful techniques.

Your trainer, a certified instructor with over 20 years SQL experience, is available to speak with before booking your course. During the training they'll guide you through the concepts and skills from the ground up ensuring that you understand and retain your new learning.

Certificate of Completion

Digital certificate - Included

This SQL Querying course in Central Edinburgh will provide you with the essential knowledge and skills to create basic 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.

You are provided with access to the live SQL Server product and will use SQL Server Management Studio (SMSS) to progress through the exercises.

The course is very comprehensive with carefully designed and tested content and at completion you'll be able to:

• Describe the basic architecture and concepts of Microsoft SQL Server
• Understand at a practical level the concepts that underpin SQL Queries
• Have working knowledge of SQL Server Management Studio
• Write SELECT queries - including ORDER BY
• Query multiple tables - Joins and Subqueries
• Sort and filter data - using WHERE and HAVING
• Describe the use of key data types in SQL Server
• Use key built-in functions
• Group and aggregate data - including key Aggregate Functions
• Use Subqueries
• Use Table Expressions - including Views, TVFs, Derived Tables and CTEs
• Use Set Operators - UNION, EXCEPT and INTERSECT
• Understand Window Functions including ROWNUMBER, RANK, NTILE
• Understand Pivoting and Grouping Sets
• Execute Stored Procedures
• Modify data using Transact-SQL

SQL skills are required in many roles. Here are some examples:

• Professionals with data related roles
• Human Resources employees requiring Data Querying and Report Writing skills
• Software Developers new to SQL
• Project Managers - SQL skills are a common requirement on projects
• Development Team Managers
• Business Analysts
• Report Writers

This SQL Querying course in Central Edinburgh 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.

You have the option to bring your own familiar PC or Mac or TrainX will provide you with a PC for the duration of the course.

SQL is such a prevalent skill that attending this SQL Querying course in Central Edinburgh is relevant for many career paths including:

• Human Resources
• Software Developers
• Project Managers
• Development Team Members
• Professionals with data related roles
• Business Analysts
• Report Writers