SQL (STRUCTURED QUERY LANGUAGE)
Two days of hands-on training (8:00 am - 4:00 pm) - $895.00 - Enroll Now!
SQL is today's standard for accessing and manipulating data and is recognized by most desktop and enterprise database systems, including MS Access, Oracle, IBM DB2, and MySQL. This course will teach you everything you need to fully leverage your company's data to meet business goals: all the way from basic SQL commands, such as SELECT, to advanced concepts, such as stored procedures, functions, inner joins, and triggers.
Class Topics include:
• Create new tables for various data types, including dates, text, and numbers
• Add data records to your tables using appropriate syntax for each data type
• Update selected records using the UPDATE and WHERE commands
• Remove out-of-date records
• Retrieve precisely the data you need using the SELECT command
• Script different SQL functions including math, string, and date functions
• Incorporate database triggers when you need to keep track of data changes
• Create efficient relationships between tables using inner joins
• Create robust SQL scripts as stored procedures