Learn SQL in a simplified manner

Name: Learn SQL in a simplified manner
Rating: 4.4 (743 reviews)

Learn SQL in just four weeks, right from scratch !

Created byParteek Bhatia

Last updated 9/2021

English

English [Auto],

What you'll learn

SQL is one of the most in demand tech skills today, and learning SQL would surely be one of the fastest and most efficient way to improve ones career prospectus. After the completion of course, one will be able to read, write and comprehend simple to most complex queries of SQL, using which they could work upon any SQL database such as Oracle, Amazon Redshift and others.

Course content

5 sections • 15 lectures • 2h 0m total length

Introduction to SQL7:12
Learn the basics of sql in a simplified manner, a non procedural query language used to perform insert, update, delete, and select operations by submitting structured requests to a database.
Demonstartion of Live SQL (Cloud Platfrom to exceute SQL Commands)4:03
This video sessions shows how we can work on Oracle without installing this on machine. We just need Internet to access this over cloud server and we can execute SQL and PL/SQL code from browser.
Performing Basic Operations with SQL12:59
Demonstrate how to create a student table, define column types, and perform basic SQL operations—insert, select, update, delete, and simple ordering—using practical examples.
Introduction to SQL

Need of Constraints4:43
Not Null, Unique and Primary Key Constraint11:04
Learn how not null, unique, and primary key constraints enforce data integrity in a student table, including single and composite keys that ensure mandatory and unique values.
CHECK constraint6:37
FOREIGN KEY Constraint7:21
Explore the foreign key constraint to enforce data integrity between employee and department data, using a master department table and on delete options such as cascade and set null.
Demonstration of Foreign Key constraint9:34
Demonstrates creating a master table and an employee table with a foreign key constraint referencing department numbers, and shows how on delete cascade and undelete options enforce or relax integrity.
Creation of Table with constraints

Joining of tables and Its Types9:12
OUTER JOIN6:26
Use left and right outer joins to display all departments with their employees, including departments without matches, as demonstrated in the session.
SELF JOIN10:20
Learn to use a self join in sql to pair employees with managers, handle missing managers with left joins, and identify those who joined before their managers.
Table Alteration and SQL joins

Requirements

Zero prior technical experience is required! All you need is a computer with good Internet connectivity!
Although for running SQL queries, Oracle software is required.

Description

Learn SQL in a simplified manner is one of the best SQL course on Udemy crafted in a way that it would serve both the beginner and software professionals who want to learn or refresh their knowledge on one of the most in demand skill of tech world - SQL. The course is designed in a way that one could complete it in less than 4 weeks with 0 prior experience to programming.

Who is the course for?

This course is designed for the learners who are:

beginners in this field
want to prepare for University examinations
want to prepare for placement interviews
software professionals who want to quick start there carrier as SQL expert

in a short time span.

What topics will this course cover?

Create Tables in SQL
Perform Basic Operations of database like Insert, Update, Delete and Retrieve with SQL
Integrity Constraints
Alteration in existing table structure
Learn to Join one and more Tables in the database
Learn Grouping of Data

What will you achieve?

By the end of the course, you'll be able to...

Design tables to store data
Demonstrate the use of Insert, Update, Delete and Retrieve operations on database
Apply integrity constraints during creation of tables
Perform alteration in structure of existing table
Access data from multiple tables with the use of Join operations
Perform grouping of data on one or more columns
Perform selection of groups
Explore the use of database in modern world

Learn and Explore the world of Database !

HAPPY LEARNING !!!!

Who this course is for:

Anyone who is interested in learning more about SQL.

Learn SQL in a simplified manner

What you'll learn

Explore related topics

Course content

Basics of SQL3 lectures • 24min

Creation of Tables with Constraints5 lectures • 39min

Table Alteration2 lectures • 15min

Joining of Tables3 lectures • 26min

Grouping of Data2 lectures • 16min

Requirements

Description

Who this course is for: