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

Go to class Write review
Datacamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Coursera Ad

Save 43% on 1 Year of Coursera Plus

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

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.