SQL Introduction for SQL Server

Training Provided by Aspect Training Aspecta ™s Introduction to T-SQL for SQL Server training class teaches attendees the T-SQL and SQL Server skills they need to develop queries and data reports using SQL.. Aspect Traininga ™s course will enable delegates to: Understand how SQL Server works Learn to select the required records Learn to use SQL to output reports with SQL Server

SQL Introduction for SQL Server Brief History of SQL
Relational Databases
may be compressed due to attendee
experience
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management
System
SQL Server Objects
Valid Object References
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)
Simple SELECTs with SQL Server
Introduction to the Northwind
Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator
Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator
Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
Writing SELECTs with Multiple
Conditions
Advanced SELECTs with SQL Server
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Subqueries, Joins, and Unions with
SQL Server
Subqueries
Joins
Table Aliases
Multi-table Joins
Outer Joins
Unions
UNION ALL
UNION Rules

About The Training Provider: Aspect Training

More Training from Aspect Training

• Adobe Dreamweaver Advanced
• Adobe Dreamweaver Introduction Intermediate
• Adobe Fireworks Introduction Intermediate
• Adobe Flash ActionScript
• Adobe Flash Introduction Intermediate
• Adobe Illustrator Advanced
• Adobe Illustrator Introduction Intermediate
• Adobe InDesign Advanced
• Adobe InDesign Introduction Intermediate
• Adobe Photoshop Advanced
• Adobe Photoshop Introduction Intermediate
• Advanced Sales Skills
• AJAX and JavaScript
• ASP Introduction
• ASPNet Introduction
• AutoCAD 2D Introduction Intermediate
• AutoCAD 3D Introduction Intermediate
• Beginning JSP and Servlets
• C Sharp . Net Advanced
• C Sharp . Net Introduction
• Core Management Skills
• Crystal Reports Advanced
• Crystal Reports Introduction Intermediate
• CSS Essentials
• Essential Sales Skills
• Excel Advanced
• Excel Financial Modelling
• Excel Intermediate
• Excel Introduction
• HTML Introduction
• Java Programming
• JavaScript Introduction
• jQuery for Developers Training
• MapInfo Introduction Intermediate
• Mentoring Skills for Managers
• Microsoft Access Advanced
• Microsoft Access Introduction Intermediate
• Microsoft Access VBA
• Microsoft Excel VBA
• Microsoft Expression Web Advanced
• Microsoft Expression Web Introduction Intermediate
• Microsoft Outlook Introduction
• Microsoft PowerPoint Advanced
• Microsoft PowerPoint Introduction Intermediate
• Microsoft PowerPoint VBA
• Microsoft Project Advanced
• Microsoft Project Introduction Intermediate
• Microsoft Visio Introduction Intermediate
• Microsoft Word Advanced
• Microsoft Word Intermediate
• Microsoft Word Introduction
• Microsoft Word VBA
• Moving from QuarkXpress to InDesign
• PHP and MySQL Introduction
• Problem Solving and Decision Making
• QuarkXPress Introduction Intermediate
• Sage Instant Accounts Introduction Intermediate
• Sage Line 50 Introduction Intermediate
• Sales Management Skills
• SEO Search Engine Optimisation Training
• SPSS Introduction Intermediate
• SPSS Syntax Introduction
• SQL Advanced for SQL Server
• Time Management
• Train the Trainer
• VBNet Advanced
• VBNet Introduction Intermediate
• VBScript Introduction Intermediate
• XML Introduction Intermediate
• XQuery for Developers
• XSLT Introduction Intermediate