PCWorkshops

      SQL Server 3-Day Training Course

      5.0 ausgezeichnet 6 Meinungen
      PCWorkshops
      In Köln
      • PCWorkshops

      835 
      MwSt.-frei
      *Orientierungspreis
      Originalpreis in GBP:
      £ 750
      PREMIUM-KURS

      Wichtige informationen

      Tipologie Kurs
      Ort Köln
      Unterrichtsstunden 21h
      Dauer 3 Days
      Beginn nach Wahl
      • Kurs
      • Köln
      • 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.co.uk 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.co.uk without hesitation. You won’t regret it!

      Wichtige informationen
      Schildern Sie dem Nutzer, sobald Sie die Kontaktdaten von Emagister erhalten haben, wie es von nun weitergeht. Beispielsweise ob "Sie sich per E-Mail in Kontakt setzen", "sich telefonisch innerhalb von 24 Stunden melden werden", "welche Unterlagen benötigt werden", etc. Geben Sie weder Telefonnummern noch Bankverbindungsdaten an.

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

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

      Einrichtungen (1)
      Wo und wann
      Beginn Lage
      nach Wahl
      Köln
      Nordrhein - Westfalen, Germany
      Karte ansehen
      Beginn nach Wahl
      Lage
      Köln
      Nordrhein - Westfalen, Germany
      Karte ansehen

      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
      Server
      Server
      MS SQL Management Studio
      Databases and Tables
      Database Concepts
      Subqueries and Joins
      Subqueries and Joins

      Themenkreis

      Session 1,2and 3: Comprehensive revision of mySql select queries, covering WHERE clauses, In, Between, AND/OR, Distinct, Limit, Expressions, CASE, working with nulls Inner joins, aggregates. 
      Session 4: LIMIT, UNION and AGGERGATE Functions 
      The LIMIT clause, Union, Union all, Aggregate, GroupBy , Rollup with group By, Having. 
      Session 5: Joins and Subqueries. Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins. Cartesian products. 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. Custom Functions. 
      Session 8: Create and drop Databases. Create, alter and drop Tables. Datatypes. Constraints. 
      Session 9: Create, alter and drop Indexes. 
      Session 10: Managing Data 
      Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits 
      Session 11: Access Control Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges 
      Session 12: Import and Export