SQL Advanced for SQL Server

Level
Total time
Logo Aspect Training
Provider rating: starstarstarstarstar 9.8 Aspect Training has an average rating of 9.8 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Aspect Training offers their products as a default in the following regions: Surrey

Description

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Overview

Building upon the skills mastered in Aspect Training's Introduction to SQL and Database Design course, Advanced SQL and Database Programming teaches the development techniques needed to take full advantage of powerful and flexible data-driven applications. We'll turn from the prior course's concern with data modelling and database design to how to use data in extensive, enterprise-class databases. We will be using MySQL as the basis for the examples and exercises.

Entity-Relationship Diagrams

Text Functions

Matching Patterns with LIKE

Text manipulation functions

Recommendations for LIKE and Wildcard

pattern substitution:

Dates in SQL Server

Conversion Functions

Using Union…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, Microsoft ProClarity, Client - Server, and Oracle.

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Overview

Building upon the skills mastered in Aspect Training's Introduction to SQL and Database Design course, Advanced SQL and Database Programming teaches the development techniques needed to take full advantage of powerful and flexible data-driven applications. We'll turn from the prior course's concern with data modelling and database design to how to use data in extensive, enterprise-class databases. We will be using MySQL as the basis for the examples and exercises.

Entity-Relationship Diagrams

Text Functions

Matching Patterns with LIKE

Text manipulation functions

Recommendations for LIKE and Wildcard

pattern substitution:

Dates in SQL Server

Conversion Functions

Using Union to Combing Queries

Transact-SQL's CASE statement

A Review of Aggregate Functions

GROUP BY

HAVING

WITH CUBE and WITH ROLLUP

WITH ROLLUP

WITH CUBE

Applications of Data Cubes

COMPUTE BY

Querying Data Across Tables

Joins the ANSI-92 Way

A Few Guidelines

Outer Joins

Sales Information

Self Joins

Chart

Subqueries

Correlated Subqueries

Performance Tuning

Connecting to Data in Other Databases

Beginning Transact-SQL Programming

Introduction to Stored Procedures

Transactions in SQL Server

Calculate YTD Sales

Triggers

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.