Live Remote Classroom or On-Demand Streaming
Duration: 5 Days | Price: $1,895
Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
Description: This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views.
This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Course Overview:
Relational Database Fundamentals
|
Writing Basic SQL Queries
|
Creating a Database
|
Manipulating Query Results
|
Advanced Query Techniques
|
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
|
User-Defined Functions
|
Stored Procedures
|
Triggers
|
Complex Queries
|
T-SQL Code Constructs
|
Working with Data Types and Functions
|
Using T-SQL Cursors
|
Working with Views
|
Alabama
Birmingham
Montgomery
Arkansas
Fort Smith
Fayetteville
Delaware
Dover
Wilmington
Hawaii
Honolulu
New Hampshire
Portsmouth
Montana
Billings
Great Falls
Nebraska
Lincoln
North Dakota
Fargo
Bismarck
Grand Forks
South Carolina
Columbia
South Dakota
Rapid City
Sioux Falls
Vermont
Burlington
West Virginia
Charleston
Huntington
Wisconsin
Madison