- Learn SQL in just four weeks, right from scratch !
- Free tutorial
- Rating: 4.5 out of 54.5 (714 ratings)
- 22,773 students
- 1hr 56min of on-demand video
- Created by Parteek Bhatia
- English
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
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.
Show less
Course content
5 sections • 15 lectures • 2h 0m total lengthCollapse all sections
Basics of SQL3 lectures • 24min
- Introduction to SQL07:12
- Demonstartion of Live SQL (Cloud Platfrom to exceute SQL Commands)04:03
- Performing Basic Operations with SQL12:59
- Introduction to SQL5 questions
Creation of Tables with Constraints5 lectures • 39min
- Need of Constraints04:43
- Not Null, Unique and Primary Key Constraint11:04
- CHECK constraint06:37
- FOREIGN KEY Constraint07:21
- Demonstration of Foreign Key constraint09:34
- Creation of Table with constraints8 questions
Table Alteration2 lectures • 15min
- Alter Table Add Option06:56
- Alter Table: Modify and Drop Option07:39
Joining of Tables3 lectures • 26min
- Joining of tables and Its Types09:12
- OUTER JOIN06:26
- SELF JOIN10:20
- Table Alteration and SQL joins6 questions
Grouping of Data2 lectures • 16min
- GROUP BY Clause11:29
- Inbuilt Functions of SQL04:40
- Grouping of Data6 questions
