Database Design & Development

ScheduleRegister for this courseOutline800 | WestLake Capstone Series: Fundamentals of Relational Databases

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

This Capstone series will teach the fundamentals of database design, and provide an education in Structured Query Language (SQL), the standard language used to access database structure and data. Any modern Web application built today uses a back-end database, usually a SQL-based tool. Learn the fundamentals of SQL, along with an introduction to database design, which will allow you to work with any database when building your Web applications. We will be using MySQL as the basis for this class, a popular open-source product that supports ANSI SQL.

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

  • Read and understand database model diagrams
  • Understand database vocabulary
  • Use Select, Insert, Update, and Delete to view and modify data
  • Query data simultaneously from multiple, related tables
  • Create, edit, and drop tables
  • Design efficient database structures
  • Ensure data integrity and quality
  • Enforce business logic and rules
  • Design sub-queries and correlated sub-queries
  • Use unions to combine queries into a single result set
  • Tune queries for performance
  • Apply views to shield users from underlying data complexity
  • Execute triggers and use stored procedures

This Capstone series consists of these classes:

Students can choose to enroll in this 5-day course or choose to attend classes individually. By enrolling in the Capstone Series instead of the individual courses, students benefit from a $100 savings off the total tuition. Students who successfully complete the class exercises and/or Capstone project will receive the WestLake Certification along with real-world sample code.

  • Prerequisites:
    Students should have a strong knowledge of HTML, particularly HTML forms, and be comfortable with client-server applications such as the ones covered in WestLake's Advanced HTML class. Experience using database-driven applications is helpful but not required.