1 option
Advanced SQL Practice : Schema Changes / with Scott Simpson.
- Format:
- Video
- Author/Creator:
- Simpson, Scott, speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Physical Description:
- 1 online resource
- Place of Publication:
- Carpenteria, CA : linkedin.com, 2025.
- System Details:
- Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
- digital
- Summary:
- Learn how to manage data for a text-based chat application by practicing schema modifications and data manipulation through interactive code challenges.
- In this course, Scott Simpson explores the intricacies of using SQL to manipulate and alter the schema of existing databases. Learn how to add, modify, and remove columns efficiently, expand field lengths, and update data types by completing practical code challenges. Discover how to manage and structure data for a text-based chat application. Gain hands-on experience with SQL commands such as ALTER TABLE, CREATE TABLE, and UPDATE statements, as well as techniques to ensure data integrity and correct functionality. Use the interactive format of the course to test your solutions and immediately see the results in a practical learning experience. This course equips you with the necessary skills to maintain and optimize existing databases effectively.
- Participant:
- Presenter: Scott Simpson
- Notes:
- 1/24/202512:00:00AM
- Access Restriction:
- Restricted for use by site license.
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.