MS SQL Server Intermediate Course 3-Day Course

PCWorkshops

Course

Online

Save 10%
£ 675 VAT exempt

The best SQL Server courses

See all

See all

Description

  • Type

    Intensive workshop

  • Methodology

    Online

  • 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

Online

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

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

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 8 years

Subjects

  • 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

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

Read more:
https://pcworkshopslondon.co.uk/sql-intermediate-3-day-course.html

See related categories

MS SQL Server Intermediate Course 3-Day Course

£ 675 VAT exempt

The best SQL Server courses

See all

See all