Complete Seminar Details
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. Three days. Fee per person: $1495.
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
Sponsor Background:
First-rate materials. Expert instructors. Small classes. Well-structured, challenging hands on exercises. These are the critical elements of a truly effective training program – and the key reasons why Hands On Technology Transfer, Inc. (HOTT) should be your source for software skills training.
HOTT is dedicated to providing programming professionals like you with the skills and knowledge necessary to enhance competency and productivity. Whether you are moving into a new technology or advancing your current skill set, HOTT will provide you with an unparalleled learning environment.
- Perspective - Task-Oriented, Cross-Platform Training
As an independent, dedicated training organization, HOTT offers a practical, realistic and unbiased view of competing technologies and products that you won’t get at training centers authorized by a particular software vendor. Our courses emphasize task-oriented, not product-oriented training – training that integrates technologies the way your business does. Because our instructors have cross-platform knowledge and experience, you’ll get the full picture – not just how to use a particular tool, but the issues involved in using multiple tools in today’s open environments, including practical design, architecture, and coding issues.
- Convenience - Convenient Locations Save You Time and Money
HOTT offers courses at frequent intervals in a number of cities across the United States to help provide a location convenient to you. Easy access helps you minimize your travel time and expenses as well as down time from your job. There’s no financial penalty if you have to withdraw or change your plans after you register, so you can reserve your place as early as you’d like. And registration’s as easy as reaching for the phone.
- Quality - Skilled Instructors Who Are Professionals in Their Fields
In addition to being seasoned professional trainers, our instructors also have many years of training and industry experience working in their respective fields. Practiced developers, software engineers, and system administrators, they understand the challenges you face in your job and have first-hand knowledge of the skills you need to succeed.
- Substance - Small Class Sizes, Exceptional Curriculum and Courseware
HOTT class sizes are kept significantly smaller than classes at other national training firms in order to provide you with more personalized attention, more focused content, and greater access to instructors for problems and questions. With an average class size of under 12 students, you’re assured full attention from the instructor.
We continually refine and upgrade our courseware to reflect new product features and industry requirements. Course materials, including student and lab guides and your lab software, are yours to keep. Certain courses also include a complimentary industry textbook, which provides additional supporting information and reference material.
You’ll find HOTT labs exceptionally challenging. Their objective is to provide an in-depth, hands on experience that replicates real work experience and trains you to deal with the complexities of real scenarios.
- Value- Enjoy Superior Training at Significantly Lower Cost
HOTT delivers high-quality training, with all the benefits of small-size classes, at highly competitive prices. Special rates for large groups attending our public classes save you even more. And if you’re in a remote location our fixed cost travel packages allow you to simultaneously save money and fix your budget. For extensive individual needs, HOTT’s Training Pass provides an extremely cost-effective option.
Quote From Past Participants:
"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
