Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
MICROSOFT SQL SERVER 2005: CORE
SQL Training Overview

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you’ll learn about the features that are available in SQL Server, how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. You’ll learn about the new enhancements to the Transact-SQL programming language and how programmers can now use .NET languages like C# and Visual Basic to build database objects.

SQL Training Audience:

Those wanting a more thorough understanding of SQL Server 2005.

SQL Training Prerequisites

No prior experience with Microsoft SQL Server is required. Some programming experience is helpful, but not required.


SQL Training Course duration

1 days

SQL Training Course outline

A Tour of SQL Server 2005

  • SQL Server 2005 Editions, Components, and Tools
  • Editions
  • Server Components
  • Management Tools
  • Documentation and Samples
  • Using SQL Server Management Studio (SSMS)
  • Connecting Management Studio
  • The Object Explorer
  • Exploring the Sample Databases
  • Database Objects
  • Working with Tables and Queries
  • Creating Tables
  • Creating a View
  • Generating Scripts
  • New Transact-SQL Features
  • Common Table Expressions (CTEs)
  • Ranking Functions
  • TOP(n) and APPLY
  • PIVOT
  • FOR XML PATH
  • Try/Catch Error Handling
  • Using EXECUTE AS
  • Using Snapshot Isolation
  • Running CLR Code in SQL Server 2005
  • Business Intelligence Services
  • SQL Server Integration Services (SSIS)
  • SQL Server Business Intelligence Development Studio (BIDS)
  • Reporting Services
  • Analysis Services (SSAS)
Installing SQL Server 2005
  • Preparation for Installation
  • Hardware and Software Requirements
  • Multiple Instances
  • Upgrading an Earlier Version
  • Considerations
  • Upgrade Advisor
  • Installation Steps
  • Installing Prerequisites
  • System Configuration Checks
  • Customizing the Installation
  • Performing the Installation
  • Configuring the Server
  • SQL Server Configuration Manager
  • SQL Server Surface Area Configuration Tools
  • Server Configuration
Designing and Creating a Database
  • Relational Database Design Principles
  • The Origins of Relational Design
  • Data Normalization
  • Understanding Referential Integrity
  • Beyond Normalization
  • Implementing the Design
  • Database Storage
  • Creating Databases
  • Modifying Database Options
  • Creating Tables
  • Creating Constraints
  • Triggers
  • Creating Indexes
  • Using Database Diagrams
Data Selection Queries
  • Understanding Transact-SQL
  • Schemas and Naming in SQL Server 2005
  • The SELECT Statement
  • Selecting All Columns
  • Concatenating Columns
  • Naming Columns
  • Using DISTING to Limit Values
  • The WHERE Clause
  • Transact-SQL Comparison Operators
  • The LIKE Operator
  • The BETWEEN Operator
  • Using IS NULL to Test for Nulls
  • Multiple Conditions with AND, OR, and NOT
  • Operator Precedence
  • Using the IN Operator
  • Using ORDER BY to Sort Data
  • Sorting on a Single Column
  • Sorting by Multiple Columns
  • Sorting with Expression
  • The GROUP BY Clause
  • ‘Aggregate Functions
  • Counting Rows
  • Counting Columns
  • Counting with a WHERE Clause
  • Using GROUP BY
  • Using ORDER BY with GROUP BY
  • Using HAVING with GROUP BY
  • TOP Values Queries
  • Joining Tables
  • Cross Joins (Cartesian Products)
  • The Use of Keys in Joining
  • Join Notation
  • Inner Joins
  • Outer Joins
  • Self Joins
Modifying Data
  • Modifying Data
  • Inserting Data
  • Inserting a Single Value
  • Inserting Multiple Values
  • Inserting Multiple Rows
  • Creating a New Table Using SELECT INTO
  • Temporary Tables
  • Using Bulk Copy to Insert Data
  • Updating Data
  • Updating a Single Row
  • Updating Multiple Rows and Columns
  • Updating from Another Table
  • Updating with TOP
  • Updating Large Value Types with UPDATE.WRITE
  • Deleting Data
  • Deleting a Single Row
  • Deleting Multiple Rows
  • Understanding Transaction Isolation
  • Isolation Level Explained
  • Blocking and Deadlocks
  • Using Snapshot Isolation
Working with SQL Server Management Studio
  • Getting Starting with SSMS
  • Connecting to Management Studio
  • Configuring SSMS Options
  • SSMS Toolbars
  • Overview of SSMS Menu Options
  • Configuring SSMS Windows
  • Exploring the Object Explorer
  • Right-Click Menu Options
  • Server and Database Objects
  • Displaying and Filtering Objects
  • Finding Objects
  • Editing Database Objects in the SSMS Designers
  • Working with the Query Editor
  • Displaying Multiple Code Windows
  • Formatting and Editing Code
  • Scripting with SSMS
  • Executing Queries
  • Creating Projects and Solutions
  • Working Offline
  • Using SQL Server Books Online
  • Getting Help in SSMS

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy