English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 56m | 159 MB
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.
Table of Contents
1 Making a statement with SQL
2 How to use the exercise files
3 What is a table and naming conventions
4 Database table types
5 Datatypes for columns in tables
6 Add rows in tables
7 Modify rows and columns in tables
8 Delete rows in tables
9 Merge rows in tables
10 Committing database changes
11 Rollback in database changes
12 Different ways to create tables
13 Alter tables
14 Drop, rename, and truncate tables
15 Next steps
Resolve the captcha to access the links!