course-premium

MS SQL Server Intermediate Course 3-Day Course

5.0
6 reviews
  • It was easier than I thought, SQL is not hard at all when your tutor is Sarah. She gave lots of tasks from easy to harder ones and it helped a lot.
    |
  • Friendly teacher taught me a lot and I also like how its not private one to one because that would make me nervous.
    |
  • You will be given many exercises and tasks to work on but they will all help you consolidate your knowledge and that's what I really liked about this course.
    |

Course

In Jersey Guernsey (UK Offshore Dependencies)

Save 6%
£ 700 VAT exempt

Learn how to get valuable information, trends, summaries, statistics and insights from your company data!

  • Type

    Intensive workshop

  • Location

    Jersey guernsey (UK Offshore Dependencies)

  • Class hours

    21h

  • Duration

    3 Days

If you are looking for a complete training in SQL, then this SQL Server Intermediate 3-day Course (Using MS SQL Management Studio), organized by PCWorkshops and listed at Emagister is the right choice for you.

With this course, you will understand different concepts of SQL in order to get important information from your company such as trends, statistics, summaries and insights in order to make better decisions in the daily business routine. This company’s data could be either from CRM, online sales or search stats it doesn’t matter is it small or vast.

This is why this course is ideal for managers who want to start making decisions based on facts analyzed with the SQL server, in order to be one step beyond other companies and enhance the business intelligence.

No existing knowledge on SQL is required. Beginners and intermediate users will be in one course. So, if you want more information about this programme contact PCWorkshops through Emagister without hesitation. You won’t regret it!

Facilities

Location

Start date

Jersey Guernsey (Channel Islands)
See map

Start date

Different dates availableEnrolment now closed

About this course

This course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information.

No existing knowledge on SQL is required. - Beginners and Intermediate in one course.

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

5.0
excellent
  • It was easier than I thought, SQL is not hard at all when your tutor is Sarah. She gave lots of tasks from easy to harder ones and it helped a lot.
    |
  • Friendly teacher taught me a lot and I also like how its not private one to one because that would make me nervous.
    |
  • You will be given many exercises and tasks to work on but they will all help you consolidate your knowledge and that's what I really liked about this course.
    |
100%
5.0
excellent

Course rating

Recommended

Centre rating

Francy Dickens

5.0
24/12/2018
What I would highlight: It was easier than I thought, SQL is not hard at all when your tutor is Sarah. She gave lots of tasks from easy to harder ones and it helped a lot.
What could be improved: Nothing.
Would you recommend this course?: Yes

Pat Cadogan

5.0
04/09/2017
What I would highlight: Friendly teacher taught me a lot and I also like how its not private one to one because that would make me nervous.
What could be improved: Nothing.
Would you recommend this course?: Yes

John Taylor

5.0
04/05/2017
What I would highlight: You will be given many exercises and tasks to work on but they will all help you consolidate your knowledge and that's what I really liked about this course.
What could be improved: Nothing.
Would you recommend this course?: Yes

Sandra Schaefer

5.0
16/04/2017
What I would highlight: Sarah makes it very easy to learn SQL, she explains things very clearly and just makes the whole process fun and interesting. If you want to learn SQL, learn with Sarah she will make sure you understand it very well.
What could be improved: Nothing.
Would you recommend this course?: Yes

Kat Platt

5.0
24/09/2015
What I would highlight: I felt very comfortable to ask questions to confirm my understanding. The repetition of exercises was great, I just want to recommend this course to everyone!
What could be improved: nothing at all!
Would you recommend this course?: Yes

Cassiana Platt

5.0
01/09/2015
What I would highlight: My tutor's explanations were very good and the course material was very useful to learn.
What could be improved: Nothing.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

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

  • Server
  • Database
  • SQL
  • Database training
  • Data Management
  • SQL Server
  • MS SQL Management Studio
  • Databases and Tables
  • Database Concepts
  • Subqueries and Joins
  • GroupBy
  • Subqueries
  • Original syntax
  • Table aliases
  • Drop Indexes
  • Replacing rows

Teachers and trainers (1)

Mary  Smith

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 Contents:

Session 1, 2 Brief revision of Basics

Session 3: Union, Union All, Intersect, Minus

Session 4: AGGERGATE Functions

Aggregate, GroupBy , Rollup with group By, Having.

Session 5: Joins

Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products.

Session 5: Subqueries.

Correlated and uncorrelated Subqueries.

Session 6: Numeric and Character Functions. DATE, TIME and Other functions.

Session 7: Create, alter and drop Views. Stored procedures, without and with parameters.

Session 7: Custom Functions.

Session 8: Managing Data

Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits

Session 9: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints.

Session 10: Create, alter and drop Indexes.

Session 11: Access Control

Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges

Session 12: Import and Export

MS SQL Server Intermediate Course 3-Day Course

£ 700 VAT exempt