SQL Queries Made Easy

Focused View

Deepa Maddala

56:17

0 View

01 Introduction

001 Making a statement with SQL.mp4

00:57

002 How to use the exercise files.mp4

02:18

02 Creating Tables in Databases

001 What is a table and naming conventions .mp4

01:51

002 Database table types.mp4

01:44

003 Datatypes for columns in tables.mp4

03:11

03 Manipulating Data

001 Add rows in tables.mp4

06:47

002 Modify rows and columns in tables.mp4

07:10

003 Delete rows in tables.mp4

04:50

004 Merge rows in tables.mp4

05:03

04 Transaction Control

001 Committing database changes.mp4

02:06

002 Rollback in database changes.mp4

02:59

05 Data Definition Language

001 Different ways to create tables.mp4

07:56

002 Alter tables.mp4

05:09

003 Drop rename and truncate tables.mp4

03:31

06 Conclusion

001 Next steps.mp4

00:45

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Deepa Maddala

Instructor's Courses

Experienced Consultant and PL/SQL Developer in information technology and services industry. Worked on SQL, Pl/SQL, Requirements Analysis, Production Support, SDLC. Skilled in SAP Security, GRC, SAP ECC6.0. Experience in projects.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.