GBP 380.00
Details
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 your questions in small, friendly classroom training. Save hours of online training.
This course is Platform Independent.
- SQL Course Certificate on completion (assessment based)
- SQL Course notes
- Please bring your own Laptop. To use ours, let us know beforehand.
- Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
- Tea, coffees, but no lunch
- To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
- Max group size on this SQL Course is 4.
This course is Platform Independent.
What is included in this SQL Course:
- SQL Course Certificate on completion (assessment based)
- SQL Course notes
- Please bring your own Laptop. To use ours, let us know beforehand.
- Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
- Tea, coffees, but no lunch
- To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
- Max group size on this SQL Course is 4.
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 Select Statement
- The Select and From Clauses
- Conditions and the Where Clause
- The Order By Clause
- Arithmetic Operations
- Column Aliases
Summarizing and Grouping Data
- Aggregate Functions
- The Group By Clause
- The Having Clause
Querying Multiple Tables
- Joining Tables
- Inner Joins
- Column Qualification and Table Aliases
- Outer Joins
- Self Joins
- Alternative Join Syntax
Additional SQL Features
- Combining Queries
- The Union, Intersect and Minus Operators
- Basic Subqueries
Reviews
Be the first to write a review about this course.
Write a Review
PCWorkshops is a specialist provider of training courses in Java programming, databases and MS Project.
Customisation:- We can tailor courses. In addition, we are able to offer in-house training.
- What makes us different: all our Access Database, Excel, Word, Publisher, PowerPoint are offered as a standard on a 1-1 basis.
- The Excel VBA, Database Design, SQL, SSRS, SQL Report Builder and Java Courses are in groups of 4, but could also be 1-1.
- Software companies, testing companies,companies who employ software developers
- Coders and new coders who need Accredited Java qualification
- Data analysts and all others who use large sets of data
- Up-to-date relevant courses for todays’ business world
- Trainers with professional experience
- Award Winning Trainer
- 21 Years In Business
- Excellent Client References
- Classroom training with max class-size 4 people, virtual classrooms, 1-1 mentoring
- Customised training
- Assessment-based certificate, Oracle exam vouchers
- Weekdays, Evenings and Weekends
- At PCWorkshops, we love out job!
- MS Project Training.
- Database design and Data Normalisation.
- SQL Courses. ...