Introduction to SQL 1-Day Course

PCWorkshops

Short course

Distance

£ 163.50 VAT exempt

*Indicative price

Original amount in EUR:

190 €

The best SQL Server courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Distance Learning

  • Duration

    1 Day

Immerse yourself in the world of SQL with this Introduction to SQL intensive course.
This course is platform and you would be able to apply the standard SQL to MS SQL Server, mySQL, Prostgres SQL, Google Bigquery and other databases.

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.

You will learn Relational Database Concepts,
SQL Language Essentials: where clauses, alias, expression queries.
Summarize and group data, joins to query multiple tables, and some additional SQL features such as how to combine queries, the Union, Intersect and Minus Operators and basic subqueries.

Facilities

Location

Start date

Distance Learning

Start date

Different dates availableEnrolment now closed

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

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

  • Database
  • SQL
  • Database training
  • SQLite
  • Syntax
  • SQL Database
  • Oracle SQL*Plus
  • SQL Server
  • Relational Database
  • Multiple tables
  • MySQL
  • SQL queries
  • Additional SQL Features

Teachers and trainers (1)

Sarah Barnard

Sarah Barnard

Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

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
Read more: https://pcworkshopslondon.co.uk/sql-beginners-1-day-course.html

See related categories

Introduction to SQL 1-Day Course

£ 163.50 VAT exempt

*Indicative price

Original amount in EUR:

190 €

The best SQL Server courses

See all

See all