MS SQL Server Course. 3 Day Intermediate.

In this SQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using MS SQL Server.

This course is ideal for managers and data analysts who need to get business intelligence from data. Create your own queries with ease.

Beginners: Attend all 3 days: day 1,2,3

Intermediate: If you know all about where clauses, joins and aggregate, then day 2 and 3 are for you. Select the ticket at checkout.

Read more.

MS SQL Server Course Schedule

Day 1

2 Hours:

Session 1: Database Concepts

What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

Session 2: Basic SQL SELECT statement

The SQL SELECT statement, WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT / TOP, Distinct

2 Hours:

Session 3:

Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).

Dates, Built-in Functions.

2 Hours:

Session 4: SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), Group By, Having.

Session 5: Joins: SQL Cartesian products, SQL Joins (Inner join, Left join, Right join, Full join) Table aliases, Natural joins, Multi-table joins.

Union, Union All, Except, Intersect.

Day 2

2 Hours:

Session 6: SQL Subqueries, Nested Subqueries, “WITH AS”, Correlated and uncorrelated subqueries. Global and Local Temp Tables.

2 Hours:

Session 7: SQL Functions: Numeric Functions (ABS, SIGN, MOD, etc.) and String Functions (Locate, Left, Right, Concat, etc), DATE and TIME functions.

2 Hours:

Session 8: AutomationSQL Views (Create, alter and drop),Stored Procedures (Create, alter and drop, Input and Output parameters);Custom Functions (Create, alter and drop).

Day 3

2 Hours:

Session 9: Managing Data

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

2 Hours: Session 11: Creating Databases and Tables (Create, alter and drop); Constraints (Add, alter and drop).

2 Hours: Session 10: SQL Indexes (Create, alter and drop).Session 12: Import data into SQL and Export from SQL. Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line.

Virtual Classroom Requirements:

This is an online event. You need an internet connection with audio. Please email us about your database connection and our sample data.

How does it work:

• Instructor-led
• Fully interactive, with screen-sharing
• Clear explanations with demonstrations and examples
• Practical exercises to be tried out by delegate
• Ask your questions and get the solutions straight away.
• Just as good as a classroom session.

What to do:

When you make the booking, it will give you the connection instructions.

Included:

PCWorkshops's SQL Course Certificate

Course notes, exercises and code examples

System requirements: Your SQL Database, query interface and sample data must be ready before the course starts.

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