Students Will Learn:
- Database Design Issues
- Data Normalization
- SQL Statement Syntax
- Modifying Tables with DML
- Query Analysis
- Inner and Outer Joins
- 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 SQL 2008 Courses: Microsoft SQL Server 2008 Administration, SQL Server 2008 Reporting Services, SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2008 Business Intelligence: Integration Services and Analysis Services
Follow-up SQL 2012 Courses: Microsoft SQL Server 2012 Administration, SQL Server 2012 Reporting Services, SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2012 Business Intelligence: Integration Services and Analysis Services
SQL Programming Course Overview:
|Relational Database Fundamentals
Manipulating Query Results
|Writing Basic SQL Queries
|Advanced Query Techniques
||Manipulating Table Data
Using SQL's Data Manipulation Language (DML)
|Creating a Database
||Managing Database Objects
"The instructor was extremely knowledgeable, experienced, helpful, energetic, and enthusiastic about helping me become better with SQL and answering questions to real life situations."
L.D., Flagler County Sheriff
"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