SQL Queries Made Easy

5.0 /5

(1 Rating)

Offered byLinkedin Learning

SQL Queries Made Easy
at
Linkedin Learning
Overview

Duration	1 hour
Total fee	₹1,150
Mode of learning	Online
Difficulty level	Beginner
Credential	Certificate

SQL Queries Made Easy
at
Linkedin Learning
Highlights

1 exercise file for practice
4 quizzes to test knowledge

SQL Queries Made Easy
at
Linkedin Learning
Course details

More about this course

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 learner to various datatypes
Deepa shows learner 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

SQL Queries Made Easy
at
Linkedin Learning
Curriculum

Introduction

Making a statement with SQL

How to use the exercise files

Creating Tables in Databases

What is a table and naming conventions?

Database table types

Datatypes for columns in tables

Manipulating Data

Add rows in tables

Modify rows and columns in tables

Delete rows in tables

Merge rows in tables

Transaction Control

Committing database changes

Rollback in database changes

Data Definition Language

Different ways to create tables

Alter tables

Drop, rename, and truncate tables

Conclusion

Next steps

SQL Queries Made Easy
at
Linkedin Learning
Faculty details

Deepa Maddala

Testing Automation | API Testing | Azure Devops | SQL | PL/SQL

SQL Queries Made Easy
at
Linkedin Learning
Students Ratings & Reviews

5/5

1 Rating

4-5
1

Sai Siddhardha

SQL Queries Made Easy

Offered by Linkedin Learning

Learning Experience: It was a great experience in this course the content was very understanding and the challenges are not that hard overall it's was good to learn

Faculty: Good Yes they are updated and the assessments all are based on the concepts like for each concepts there are few videos by the end of every concept there are assignments we should complete them to get they certificate

Reviewed on 31 Jan 2023Read More