SQL Programming

Hands On Technology Transfer, Inc.
Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha, etc., United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Students Will Learn:Database Design Issues
Data Normalization
SQL Statement Syntax
Modifying Tables with DML
Query Analysis
Table Indexing
Triggers and Stored Procedures

Description: This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. 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 SELECT, INSERT, UPDATE and DELETE statements. Extensive hands on exercises are used throughout to reinforce learning and develop real competency.

The information in this course is also contained in the SQL Server Administration and SQL Server Developer courses. Students requiring those additional skills should register for those courses instead.

Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

SQL Programming Course Overview:
Relational Database Fundamentals
Overview of Relational Database Concepts
Relational Databases and Relational Database Management Systems
SQL, DML and DDL Languages
Manipulating Query Results

Using Row Functions
Character
Numeric
Data and Time
Data Conversion
Using Column Functions
Handling NULLs
Aggregating Results using GROUP BY
Restricting Groups with the HAVING Clause
Writing Basic SQL Queries
Displaying Table Structures
Column Datatypes
SELECTing Column Data FROM a Table
SELECT DISTINCT Values
COUNTing Rows
Restricting Rows using the WHERE Clause
Using Operators
Mathematical
Logical
Comparison
Concatenation
Set Operators
Sorting Results Using ORDER BY
Joining Multiple Tables
Using Column and Table Aliases
Pseudo Columns

Advanced Query Techniques
Outer Joins
Joining a Table to Itself
Subqueries
Hierarchical Queries
Using the Data Dictionary
Writing SQL with SQL
Tips for Developing Complex SQL Queries
Manipulating Table Data Using SQL’s Data Manipulation Language (DML)
INSERT into Tables
UPDATE Table Data
DELETE from Tables
TRUNCATE Tables
Controlling Transactions
COMMIT
ROLLBACK
SAVEPOINT


Creating a Database
Database Development Methodology Overview
Building a Logical Data Model
Identifying Entities and Attributes
Isolating Keys
Relationships between Entities
Creating Entity-Relationship Diagrams
Transforming to Physical Design
Migrating Entities to Tables
Selecting Primary Keys
Defining Columns
Enforcing Relationships with Foreign Keys
Constructing the Database using DDL
Creating Tables, Indexes, Constraints and Views
Using Table and Column COMMENTs
Using SYNONYMs
Facilitating Development Using CASE Tools
Managing Database Objects
Dropping Tables, Indexes and Views
ALTERing Tables, Indexes and Views
Enabling and Disabling Constraints
Managing Security
Backup and Recovery Planning
Performance Tuning

Writing Efficient SQL
EXPLAIN Query Analysis
Indexing for Performance
Index-Organized Tables
Clustering

Stored Procedures
Definition and Benefits of Use
Perils and Pitfalls
CREATE PROCEDURE
Syntax
Variables and Parameters
Code Examples
Temporary Tables
Control of Program Flow
ALTER and DROP PROCEDURE
Implementation Differences
User-Defined Functions
Definition and Benefits of Use
CREATE FUNCTION
Syntax
RETURN Clause and the RETURNS Statement
Scalar vs. Table Functions
Comparison with Stored Procedures
Returning Scalar Values and Tables
ALTER and DROP FUNCTION

Triggers
Definition and Benefits of Use
Alternatives (e.g., Constraints)
CREATE TRIGGER
Syntax
Trigger Types
"Inserted" (or "NEW") and "Deleted" (or "OLD") Tables
Event Handling and Trigger Execution
Nested and Recursive Triggers
ALTER and DROP TRIGGER

...''

Phone:1-800-413-0939

School Address:

Hands On Technology Transfer, Inc.
14 Fletcher Street
One Village Square, Suite 8
Chelmsford, MA 01824 USA


Jobs & Resumes: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha
Houses & Roommates: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha

ASP.NET 2.0 Programming Using C#
ASP.NET 2.0 Programming Using Visual Basic.NET
C# 2.0 Programming for Windows Applications
Windows Applications Programming for Experienced C# Programmers
Visual Basic.NET 2.0 Programming for Windows Applications
Windows Applications Programming for Experienced Visual Basic.NET Programmers
ASP.NET 2.0 Programming for Experienced C# Programmers
ASP.NET 2.0 Programming for Experienced Visual Basic.NET Programmers
Advanced C# Programming with the .NET 2.0 Framework
Advanced Visual Basic.NET Programming with the .NET 2.0 Framework
Relational Database Design Concepts
Microsoft SQL Server 2005 Administration
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Reporting Services
SQL Server 2005 Business Intelligence Application Development
SQL Server 2005 Business Intelligence: Integration Services and Analysis Services
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory and Security Design
MCSE 2003 Certification

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.