Training

815 | Introduction to Structured Query Language (SQL) and Database Design

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

Databases drive nearly every Internet and Intranet Web site. WestLake's Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.

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

• Understand database vocabulary
• Use queries to access information in the database
• Implement aggregate functions and calculations
• Use joins
• Modify the data in the database
• Apply views to shield users from underlying data complexity
• Create, edit, and drop tables
• Incorporate relational database concepts and data modeling
• Ensure data quality