Lynda - SQL Queries Made Easy

Duration: 56m 17s | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 153 MB
Genre: eLearning | Language: English
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.