Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Queries Made Easy

via LinkedIn Learning

Overview

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.

Syllabus

Introduction
  • Making a statement with SQL
  • How to use the exercise files
1. Creating Tables in Databases
  • What is a table and naming conventions?
  • Database table types
  • Datatypes for columns in tables
2. Manipulating Data
  • Add rows in tables
  • Modify rows and columns in tables
  • Delete rows in tables
  • Merge rows in tables
3. Transaction Control
  • Committing database changes
  • Rollback in database changes
4. Data Definition Language
  • Different ways to create tables
  • Alter tables
  • Drop, rename, and truncate tables
Conclusion
  • Next steps

Taught by

Deepa Maddala

Reviews

4.6 rating at LinkedIn Learning based on 1058 ratings

Start your review of SQL Queries Made Easy

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.