Introduction to SQL
- Learners will have a solid foundation in SQL and be equipped to handle data using best practice for management, manipulation, querying and analysis.
Prepares learners for developing their visual analysis in Power BI as part of their learning and development
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,680 people .
- Over 14,066 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.8% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
Contact us for details
Training Course Content
Introduction to SQL
Explanation of SQLImportance and common application of SQL
Types of Databases that use SQL
Relational Databases
What is a database?Relational databases
Components of a relational database
SQL Basics
Understanding SQL syntaxUsing SQL to manipulate data
Common SQL commands
Creating Databases and Tables
Creating databasesCreating tables
Defining table relationships
Data Manipulation with SQL
Retrieving data using SELECT statementFiltering data with WHERE clause
Sorting data with ORDER BY clause
Advanced SQL Commands
JOIN clausesSubqueries
Aggregate functions
SQL Functions
String FunctionsDate and Time Functions
Numeric Functions
Managing Data with SQL
Inserting data into tablesUpdating data in tables
Deleting data from tables
Data Integrity
Primary keys and foreign keysIndexes
Constraints
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 5
I thought it was excellent thank you; I just wish I had more time to practice!
Absolutely amazing course - Serena has vast knowledge and really helped me when I didn't feel I was understanding the logic. Great trainer :)
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
I found the sessions very helpful - thank you! I would say I learnt the most through the exercises we were given. I would say that maybe a few extra 5-10 min breaks throughout t...