SQL Programming Training

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 SQL developer training class is intended for analysts, developers, designers, administrators, and managers who need to exploit the power of the SQL programming language.

Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write advanced SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout this SQL programming class to reinforce learning and develop real competency.

Students Will Learn:

• Designing normalized table structures for relational databases
• Creating databases and tables
• Using primary and foreign keys
• Writing SQL queries
• Using inner and outer joins
• Using set operators (UNION, INTERSECT, EXCEPT)
• Using DML for SELECT, INSERT, UPDATE, DELETE
• Using subqueries
• Using triggers and stored procedures
• Using aggregate functions to return totals and subtotals
• Using table expressions