SQL Programming

Duration: 3 days | Price: $1495 | Class Dates:

Students Will Learn:

Database Design Issues
Data Normalization
SQL Statement Syntax
Modifying Tables with DML

Query Analysis
Table Indexing
Triggers and Stored Procedures

Course 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.

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

Follow-up Courses: Microsoft SQL Server 2008 Administration, Microsoft SQL Server 2005 Administration, SQL Server Reporting Services, SQL Server Business Intelligence Application Development

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 Date 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 Grouping, Filtering and Sorting Query Results 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 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

Student Testimonials

"This course was exactly what I needed to learn SQL. I will definitely refer to HOTT in the future for my instructional needs."
– J.P., Hayes Management Consulting

"This was the best course and best instructor I've had in 10 years. Instructor is very knowledgeable and kept class interested. Great job!"
– J.W., Cendant Car Rental Group

"I really enjoyed this class and I feel comfortable with the thought of going back to our office and knowing what I'm doing with SQL! I also thought that the instructor did a great job explaining everything so a beginner like me understood everything clearly."
– K.S., Knox and Associates

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299