MS SQL Server Intermediate Course 3-Day Course
-
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)
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
Start date
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.
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 rating
Recommended
Centre rating
Francy Dickens
Pat Cadogan
John Taylor
Sandra Schaefer
Kat Platt
Cassiana Platt
This centre's achievements
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
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