SQL Queries Made Easy

Go to class
Write Review

Free Online Course: SQL Queries Made Easy provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL Queries Made Easy is taught by Deepa Maddala.

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