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
Contact us for pricing information and receive upto 35% 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.)
Contact us for pricing information and receive upto 35% 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.
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
Contact us for pricing information and receive upto 35% 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.