The Complete SQL Course
4.7 /5- Offered byUDEMY
The Complete SQL Course at UDEMY Overview
The Complete SQL Course
at UDEMY
Duration | 5 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
The Complete SQL Course at UDEMY Highlights
The Complete SQL Course
at UDEMY
- 10 Hours of Learning
- Earn a certificate upon successful completion
- Gain Lifetime Access to Courseware
The Complete SQL Course at UDEMY Course details
The Complete SQL Course
at UDEMY
Who should do this course?
- Anyone who wants to learn SQL, from someone who wants to query data for reporting or analytics, to a developer who needs to improve data access skills.
- Anyone who might know the basics of SQL, but needs a bit more exposure to advanced techniques and structueres
What are the course deliverables?
- Use SQL to query data in a database
- Use SQL string, numeric, and date functions
- Write subqueries, joins, unions, and other advanced SQL concepts
- Understand keys, unique constraints indexes, foreign keys
- Update, insert, and delete data
More about this course
- Mastering SQL is a fundamental skill in almost any enterprise software solution. From accessing databases from within code as a developer, to querying data as an analyst, the ability to write and execute SQL is critical.
The Complete SQL Course at UDEMY Curriculum
The Complete SQL Course
at UDEMY
Introduction to the Course
Setting up the Training Environment
Install Oracle Database Express
install SQL Developer
Create User and Tables
SQL Fundamentals
SELECT Statement
WHERE Clause
ORDER BY
JOINs
COUNT and GROUP BY
Aggregate Functions
String Functions
Numeric Functions
Date and Conversion Functions
Subqueries
In Condition Subqueries
Uncorrelated Subqueries
Correlated Subqueries
Exists Condition Subqueries
Keys and Indexes
Primary Keys
Unique and NonUnique Indexes
Unique Constraints
Foreign Keys
Database CatchUp
Unions and Outer Joines
Expand the Data Model
UNION and UNION ALL
Outer Joins
Cross Joins
Updates, Deletes, and Inserts
Updates
Deletes
Inserts
Combined Examples
Other courses offered by UDEMY
₹599
10 hours
– / –
View Other 2344 Courses
S
Shiva Raj Devarakonda
The Complete SQL Course
Offered by UDEMY
5
Learning Experience: Learnt SQL thoroughly
Course Support: No
Reviewed on 16 Sep 2022Read More
The Complete SQL Course
Offered by UDEMY
5
Learning Experience: In SQL course we understand all basic concept and learn more about joins
Faculty: Imtiaz Ahmed
In each section we need to take assesment and course structure is very good
Course Support: No
Reviewed on 30 Jul 2022Read More
S
Suraj Sinha
The Complete SQL Course
Offered by UDEMY
5
Other: Excellent course for beginners who are are looking to understand the fundamentals of SQL. The faculty presented the tutorial in a very concise manner.
Reviewed on 26 Sep 2021Read More
N
Naga Raghavendra Indukur
The Complete SQL Course
Offered by UDEMY
4
Other: Learnt about various concepts in SQL, and understood the level of importance to upskill my career.
Reviewed on 6 Nov 2020Read More
S
Sujeet Lohar
The Complete SQL Course
Offered by UDEMY
4
Other: The course is good. Learnt about sql and how to work on database.
Reviewed on 15 Oct 2020Read More
View All 6 Reviews
The Complete SQL Course
at UDEMY
Student Forum
Anything you would want to ask experts?