Sparen Sie 7%
Sparen Sie 7%
PCWorkshops

MS SQL Server Intermediate Course 3-Day Course

5.0 ausgezeichnet 6 Meinungen
PCWorkshops
In London (England), Berlin, Hannover und an 2 weiteren Standorten
  • PCWorkshops
Emagister-Preis

874 € 816 
MwSt.-frei
*Orientierungspreis
Originalpreis in GBP:
£ 750  £ 700
PREMIUM-KURS

Wichtige informationen

Tipologie Intensiv-Workshop
Ort An 5 Standorten
Unterrichtsstunden 21h
Dauer 3 Days
Beginn nach Wahl
Beschreibung

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!

Wichtige informationen
Ist dieser Kurs für mich?

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

Preis für Emagister-Nutzer: 5% Discount for emagister users

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

Einrichtungen (5)
Wo und wann
Beginn Lage Uhrzeiten
nach Wahl
Berlin
Berlin, Germany
Karte ansehen
11am - 6pm
nach Wahl
Hannover
Niedersachsen, Germany
Karte ansehen
11am - 6pm
nach Wahl
nach Wahl
Köln
Nordrhein - Westfalen, Germany
Karte ansehen
11am - 6pm
nach Wahl
London
8 Duncannon Street, WC2N 4JF, London, England
Karte ansehen
11am - 6pm
nach Wahl
Milton Keynes
Exchange House, 494 Midsummer Boulevard, MK9 2EA, Buckinghamshire, England
Karte ansehen
11am - 6pm
Beginn nach Wahl
Lage
Berlin
Berlin, Germany
Karte ansehen
Uhrzeiten 11am - 6pm
Beginn nach Wahl
Lage
Hannover
Niedersachsen, Germany
Karte ansehen
Uhrzeiten 11am - 6pm
Beginn nach Wahl
nach Wahl
Lage
Köln
Nordrhein - Westfalen, Germany
Karte ansehen
Uhrzeiten 11am - 6pm
Beginn nach Wahl
Lage
London
8 Duncannon Street, WC2N 4JF, London, England
Karte ansehen
Uhrzeiten 11am - 6pm
Beginn nach Wahl
Lage
Milton Keynes
Exchange House, 494 Midsummer Boulevard, MK9 2EA, Buckinghamshire, England
Karte ansehen
Uhrzeiten 11am - 6pm

Meinungen

5.0
ausgezeichnet
Kursbewertung
100%
Empfehlung der User
5.0
ausgezeichnet
Anbieterbewertung

Meinungen über diesen Kurs

S
Sandra Schaefer
16.04.2017
Das Beste: 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.
Zu verbessern: Nothing.
Kurs abgeschlossen: April 2017
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
P
Pat Cadogan
04.09.2017
Das Beste: Friendly teacher taught me a lot and I also like how its not private one to one because that would make me nervous.
Zu verbessern: Nothing.
Kurs abgeschlossen: September 2017
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
J
John Taylor
04.05.2017
Das Beste: 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.
Zu verbessern: Nothing.
Kurs abgeschlossen: Mai 2017
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
C
Cassiana Platt
01.09.2015
Das Beste: My tutor's explanations were very good and the course material was very useful to learn.
Zu verbessern: Nothing.
Kurs abgeschlossen: September 2015
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
K
Kat Platt
24.09.2015
Das Beste: 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!
Zu verbessern: nothing at all!
Kurs abgeschlossen: September 2015
Würden Sie diesen Bildungsanbieter weiterempfehlen?: Ja
*Erhaltene Meinungen durch Emagister & iAgora

Was lernen Sie in diesem Kurs?

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

Themenkreis

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