1 option
SQL Queries Made Easy/ with Deepa Maddala.
- Format:
- Video
- Author/Creator:
- Maddala, Deepa, speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Video recordings.
- Physical Description:
- 1 online resource
- polychrome
- Place of Publication:
- Carpenteria, CA: linkedinchescom, 2021.
- System Details:
- Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Pluginches JavaScript and cookies must be enabled. A broadband Internet connection.
- Summary:
- Get up and running with database tables using SQL. This course helps beginners not only learn key concepts, but also practice working on real-world business scenarios.
- Get up and running with database tables using SQL. This course was designed to help beginners build a strong foundation in SQL queries, and start using common statements to manipulate data within tables. First, instructor Deepa Maddala defines what SQL is and covers some naming conventions that make the code more readable. She goes over the different types of tables used in SQL and introduces you to various datatypes. Deepa shows you three ways to insert new rows into a table, as well as how to change the values in specific rows or columns, delete duplicate records, and merge rows. She demonstrates how to commit changes and how to revert changes made in the database. Deepa introduces you to data definition language statements by showing you how to create and modify tables, then how to drop, rename, and truncate tables. Deepa concludes by showing you several possible next steps in your learning process.
- Participant:
- Presenter: Deepa Maddala
- Notes:
- 1/25/2021
- 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.