Database Design & Development

ScheduleRegister for this courseOutline825 | Advanced SQL and Database Programming

2 days, 9am-4pm (1.2 CEUs)
Delivery: Open-Enrollment | Customized Onsite | Virtual Classroom
Price: $1,170 or 2 Vouchers

Building upon the skills mastered in WestLake's popular Introduction to SQL and Database Design course, Advanced SQL and Database Programming teaches the development techniques needed to take full advantage of powerful and flexible data-driven applications. We'll turn from the prior course's concern with data modeling and database design to how to use data in extensive, enterprise-class databases. Again, we will be using MySQL as the basis for the examples and exercises.

By the end of the class students will be able to:

  • Query data simultaneously from multiple, related tables
  • Design subqueries and correlated subqueries
  • Use unions to combine queries into a single result set
  • Performance-tune queries
  • Implement transactions
  • Execute triggers
  • Create and execute stored procedures
  • Handle error conditions