USA & Canada: +1 240-200-6131 International Call: +1 240-391-8360
9am-6pm DC time or 1pm-10pm GMT
Workshop Code: hsts-w6
You will learn:
Design normalized table structures for relational databases
Create 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 triggers and stored procedures
Using aggregate functions to return totals and subtotals
This SQL programming and database design workshop 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 workshop 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. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
General computer knowledge. Familiarity with relational database concepts is helpful but not required.