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

Write review
Noble Desktop Ad

NY State-Licensed Certificates in Design, Coding & AI — Online

Learn More → Financial Edge Ad

The Investment Banker Certification

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.

Sign up for free
Someone learning on their laptop while sitting on the floor.