SQL Advanced for SQL Server
- Level
- Total time
SQL Advanced for SQL Server
Provider rating:
Starting dates and places
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
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.