SQL Training
SQL (Structured Query Language) is the world’s most widely used database language, used in a large variety of database systems for creating queries and manipulating data. SQL is supported by database programs such as MySQL, Microsoft SQL Server, and Oracle Database.
REASONS TO CHOOSE
The world’s leading database language
Speak the language of thousands of database professionals
Learn to confidently navigate around and take command of databases
SQL is highly sought after in the IT industry
SQL is easy to create and simple to understand
SQL Training
Become the master of databases
Introduction to SQL
Introduction to SQL Course Outline
This Introduction to SQL training course explores the following modules:
SQL – An Overview
- Relational Databases
- Using SQL
- Using Object Explorer
- Hiding system objects
Creating databases
- Designing databases
- Primary keys
- Indexing fields
Working with tables
- Creating tables
- Allowing nulls
- Identity fields
- Database diagrams
- Designing database diagrams
- Joining tables
Data Manipulation Language
- SELECT, DISTINCT Operations
- Functions
- Ordering Data
- Inserting, Updating & Deleting rows
Queries
- Writing queries
- Indentation and case
- Setting criteria using WHERE
- Wildcards
- Setting criteria for dates
- Dealing with nulls
Exporting
- Results, text, and grid options
- Copying and pasting column headings
- Exporting using SQL & the menu
Calculations
- Calculated columns
- Aliases
- String functions and concatenation
- Using GetDate
- Converting dates
- Useful date functions
Joins
- Inner joins
- Table aliases
- Left and right outer joins
- Cross joins
- Full outer joins
- Self joins
Aggregation and grouping
- SUM, AVG, MIN, MAX
- Counts
- Grouping by fields
- Using HAVING to filter results
Views
- The view designer
- Limitations of the designer
- Scripting views
What will you gain from this Introduction to SQL Course?
During this course you will:
- Learn how read SQL
- Learn how to write queries
- Learn how to work with tables and fields
- Learn how to join multiple tables together in a query
- Learn how to output data for analysis
Price – From €795
Contact us for pricing information and receive upto 20% discount.
Who should this SQL Training Course?
This training course is designed for anyone who is interested in learning more about SQL language and databases.
Prerequisites
There are no formal prerequisites – this course is open to any individuals looking to develop their knowledge of Structured Query Language. Some experience of using Windows and relational databases would be useful but is not compulsory.
Introduction to SQL Course Overview
SQL (Structured Query Language) is the most popular database language in the world. It is used widely by a variety of database systems to create queries and manipulate data. SQL is generic and compatible with many database systems, which explains its widespread use and why SQL certified individuals are highly valued by businesses.
During this SQL training course, delegates will be introduced to the fundamentals of SQL and will gain an insight into the essentials of relational databases. As this is a 1-day course, delegates will quickly acquire an understanding of vital querying language concepts and will emerge from this course as well-informed individuals who are able to implement their knowledge immediately within their own organisation.
Throughout this training course, delegates will engage in tasks and exercises to ensure that they become familiar with the basic features of SQL in practical terms. On course completion, delegates will be able to comfortably use SQL to select, organise, insert, delete, and review data within a database. They will also understand some advanced SQL statements and be familiar with the main functions of SQL such as conversions, SQL syntax, and dates.
Advanced SQL
Advanced SQL Course Outline
Stored Procedure Basics
- Pros and cons of stored procedures
- Creating stored procedures
- Three ways to execute
- System stored procedures
Variables
- Declaring variables
- SET versus SELECT
- Tricks with variables and rowsets
- So-called global variables
Parameters and Return Values
- Passing parameters
- Default values and WHERE clauses
- Output parameters
- Using RETURN
Avoiding Scalar Functions
- What are scalar functions?
- Some examples
- Disadvantages of scalar functions
- Three advantages
Testing Conditions
- IF/ELSE statement
- Using CASE where possible
Looping
- Syntax of WHILE
- Breaking out of a loop
- Basic transactions
- Beginning a transaction
- Committing/rolling back
- Deleting and updating
- Using DELETE and UPDATE
- Sys.Objects
- Dropping objects
Creating Tables
- Creating Tables in SQL
- Inserting data
- Inserting single rows
- Inserting multiple rows
Temporary Tables and Table Variables
- Using temporary tables
- Creating table variables
- Pros and cons of each approach
Table Valued Functions
- In-line table-valued functions
- Multi- Statement table-valued functions
- Limitations of user-defined functions
Derived Tables and CTEs
- Using derived tables
- Common Table Expressions (CTEs)
- Recursive CTEs
Subqueries
- The concept of a subquery
- Using ALL, ANY, and IN
- Correlated subqueries
- Using EXISTS
Cursors
- Syntax of fetching rows
- When to use (and when not to)
Error-Handling
- Using TRY/CATCH
- System error functions
- Custom error messages
- The obsolete @@ error function
Debugging
- Version differences
- The Visual Studio debugger
- The SQL Server debugger
- Debugging (breakpoints, etc.)
Price – From €1295
Contact us for pricing information and receive upto 20% discount.
Who should attend this Advanced SQL Course?
The Advanced SQL Training Course is designed for individuals who want to strengthen their knowledge of Structured Query Language (SQL) and learn advanced techniques for database management and data manipulation. This course will benefit a wide range of professionals, including:
- Senior Data Analysts
- Database Administrators
- SQL Developers
- Data Engineers
- Software Engineers
- Database Architects
- IT Professionals Specialising in Databases
Prerequisites of the Advanced SQL Course
There are no formal prerequisites to attend the Advanced SQL Course. However, delegates are recommended to have a foundational understanding of SQL.
Advanced SQL Course Overview
The Advanced SQL Training Course delves into complex database querying, optimisation, and management techniques. As data becomes more crucial across industries, SQL proficiency is indispensable. This course explores advanced SQL concepts like stored procedures, triggers, advanced joins, and query optimisation strategies, empowering individuals to tackle intricate database challenges proficiently.
Proficiency in Advanced SQL is essential for Data Engineers, Analysts, and Database Administrators aiming to optimise database performance and handle intricate data operations. Mastering this subject allows professionals to streamline database systems, enhance data retrieval efficiency, and unlock deeper insights, enabling better decision-making from complex datasets.
This intensive 2-day training equips delegates with specialised skills to navigate complex databases efficiently. Delegates will gain hands-on experience crafting intricate queries, optimising database performance, and implementing advanced SQL functionalities. The course focuses on practical applications, providing real-world scenarios for comprehensive understanding and immediate implementation.
Course Objectives
- To understand and implement complex SQL queries with multiple joins and subqueries
- To utilise advanced SQL functions, stored procedures, and triggers effectively
- To optimise database performance through indexing and query optimisation techniques
- To master techniques for managing large datasets and data integrity in SQL
- To comprehend and apply transaction management and concurrency control methods
- To practice advanced SQL techniques through hands-on exercises and case studies
- To create and optimise views and indexes for improved data retrieval
After completing this SQL Training, delegates will receive a certification acknowledging their proficiency in Advanced SQL. This SQL Course is a testament to their expertise in handling complex databases, optimising query performance, and effectively managing intricate data scenarios, enhancing their career prospects in the data-driven industry.
Introduction to MySQL
Introduction to MySQL Course Outline
The Fundamentals of MySQL training course will cover the following topics:
- Database concepts
- Using MySQL client
- Date, time, and other functions
- Managing data
- Limit, aggregate and union functions
- Indexes and views
- Basic select
Price – From €795
Contact us for pricing information and receive upto 20% discount.
Who should attend this MySQL Training Course?
This course is ideal for professionals who are required to work with a MySQL Database
Prerequisites
There are no official prerequisites for this course
Introduction to MySQL Course Overview
MySQL is an open-source relational database management system (RDBMS) which is based upon SQL (Structured Query Language). SQL is the most used language for adding, accessing, and managing the content within a database and is used by a large variety of database systems, including MySQL. This course aims to teach delegates the basics of MySQL, including managing data, database concepts, and SQL expressions. By completing this course, delegates will be able to apply what they have learned and improve how they use MySQL, subsequently improving the quality of their organisation’s databases.