Introduction to SQL 1-Day Course
-
Training Time well spent
Usual high standard of training given at a pace which suits me. Trainer was friendly and efficient and able to provide a great background on the topic. Support materials are helpful and appropriate.
← | →
-
I recommend Sarah Barnards and her org PCWorkshop for full stack training.
I have known Sarah for a short time. I am head of an organization that is bringing a new product in the Apartment and house rental field to market. The reason I hired Sarah was so that I could understand what my programmers were creating. We are in the middle of the training right now, we have already discussed many items in SQL and I must say I feel much more relaxed and confident about how SQL works and I believe that my programmers will be able to talk to me and I will be able to listen and understand them in a more comprehensive way. I think I will not feel overwhelmed and that I will be able to comment on the coding and ask questions and clarifications. Sarah's method is straightforward with many examples. She has answered my every question and I feel I have learned a lot. My rule was no homework for me. haha. She has been able to teach me and not give me homework to do. I look forward to our every lesson. Presently we study together 4 days a week, 2 hours at a time. She has managed to modify her method to teach me. I recommend Sarah Barnard and her org PCWorkshop.
← | →
-
I am glad a 1 day course exists as I am quite a busy person and this course is just perfect for someone like. I felt like I mastered everything quite quickly and that's what everyone wants in a course. Would recommend.
← | →
Short course
In Jersey Guernsey (UK Offshore Dependencies)
Learn SQL from the beginning to an intermediate level!
-
Type
Short course
-
Location
Jersey guernsey (UK Offshore Dependencies)
-
Class hours
7h
-
Duration
1 Day
Immerse yourself in the world of SQL with this Introduction to SQL intensive course, offered by PCWorkshops, that Emagister.co.uk has added to its educational catalogue.
Thanks to this course, you will get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training. Save hours of online training.
This course is Platform Independent. You will learn Relational Database Concepts, SQL Language Essentials, to summarize and group data, to query multiple tables, and some additional SQL features such as how to combine queries, the Union, Intersect and Minus Operators and basic subqueries.
So, if you want more information about this programme contact PCWorkshops through Emagister.co.uk without hesitation. You won’t regret it!
Facilities
Location
Start date
Start date
About this course
Learn SQL from the beginning to an intermediate level, including aggregates and join.
Data Professionals who would like to gain SQL skills for better use of BI Programs or to understand queries already supplied, or to enter into this new discipline.
Some understanding of data.
Internal Certificate.
This course is lead by experienced professionals who concentrate on delivering quality training. The course content is organized into clear, well-structured and well-paced lessons with practical examples and exercises.
Reviews
-
Training Time well spent
Usual high standard of training given at a pace which suits me. Trainer was friendly and efficient and able to provide a great background on the topic. Support materials are helpful and appropriate.
← | →
-
I recommend Sarah Barnards and her org PCWorkshop for full stack training.
I have known Sarah for a short time. I am head of an organization that is bringing a new product in the Apartment and house rental field to market. The reason I hired Sarah was so that I could understand what my programmers were creating. We are in the middle of the training right now, we have already discussed many items in SQL and I must say I feel much more relaxed and confident about how SQL works and I believe that my programmers will be able to talk to me and I will be able to listen and understand them in a more comprehensive way. I think I will not feel overwhelmed and that I will be able to comment on the coding and ask questions and clarifications. Sarah's method is straightforward with many examples. She has answered my every question and I feel I have learned a lot. My rule was no homework for me. haha. She has been able to teach me and not give me homework to do. I look forward to our every lesson. Presently we study together 4 days a week, 2 hours at a time. She has managed to modify her method to teach me. I recommend Sarah Barnard and her org PCWorkshop.
← | →
-
I am glad a 1 day course exists as I am quite a busy person and this course is just perfect for someone like. I felt like I mastered everything quite quickly and that's what everyone wants in a course. Would recommend.
← | →
Course rating
Recommended
Centre rating
Tim Rawlings
Howard Haimovitch
Jaime Deverall
Adina Sims
Rachel Ashton
Dirk-Abe Schaafsma
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- MySQL
- Database2
2 students say they acquired this skill
- SQL
22 students say they acquired this skill
- Database training
22 students say they acquired this skill
- SQLite
- Syntax
11 students say they acquired this skill
- SQL Database
22 students say they acquired this skill
- Oracle SQL*Plus
- SQL Server
11 students say they acquired this skill
- Relational Database
22 students say they acquired this skill
- Multiple tables
11 students say they acquired this skill
- SQL queries
22 students say they acquired this skill
- Additional SQL Features
11 students say they acquired this skill
Teachers and trainers (1)
Mary Smith
Tutor
How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.
Course programme
Course Outline
Relational Database Concepts
- What is a Relational Database?
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
- Getting Started
SQL Language Essentials
- The SQL Select Statement
- The SQL Select and SQL From Clauses
- Conditions and the Where Clause
- The SQL Order By Clause
- Arithmetic Operations
- Column Aliases
Summarizing and Grouping Data
- SQL Aggregate Functions
- SQL Group By
- The Having Clause
Querying Multiple Tables
- Inner Joins
- Column Qualification and Table Aliases
- Multiple table joins
- Left Joins
- Self Joins
Additional SQL Features
- Union, Union All
- Intersect Operator
- Minus / Except Operators
- Basic Subqueries
Introduction to SQL 1-Day Course
£ 350 VAT exemptAdd similar courses
and compare them to help you choose.{title}{centerName}{price}{price} {priceBeforeDiscount} {taxCaption}Training by subject
Courses of Business Courses of Design and Media Courses of Finance Courses of Health Courses of Humanities, Social Science, Education Courses of Industry and Science Courses of IT, Computing, Telecommunications Courses of Languages Courses of Law and Defence Courses of Personal Development Courses of Sales and Marketing Courses of Sports and Leisure Courses of Tourism and Hospitality - SQL