Fundamentals of SQL

Learn how to write and execute SQL queries in a simpler way.

4.61 (409 reviews)
Udemy
platform
English
language
Other
category
10,866
students
2 hours
content
May 2021
last update
FREE
regular price

What you will learn

Basics of SQL.

Detailed knowledge of various commands in SQL.

Write simple to complex SQL queries across single and multiple tables.

Execute Queries on MySQL.

Description

Want to learn the most mainstream language used for accessing databases?

Are you a beginner who is curious to learn SQL but don't know where to start?

Well, then your search ends here!

We bring to you a course covering major fundaments of SQL in a simpler way, required for a basic understanding of SQL and to get a feel of how it works.

SQL stands for Structured Query Language. SQL is a database computer language designed for the retrieval and management of data in a relational database. 

By the end of this course you will be able to BUILD QUERIES, CREATE TABLES, PERFORM AGGREGATE CALCULATIONS and SET OPERATIONS. You will learn how to JOIN TABLES together for more robust reporting, and how to CREATE VIEWS, gain insights of various COMMANDS, CLAUSES AND OPERATORS IN SQL.

This course also includes a CASE STUDY which will help to you understand how to write and execute queries on MySQL. You can take up the QUIZ at the end to test your knowledge gained from this course.

So whether you are brand new to SQL, or need a refresher, you will find this 'Fundamentals of SQL' course highly useful, and easy to learn.

So be ready to update your CV for better career prospects by attending this course.

Content

Introduction

Overview of SQL

Commands in SQL

DDL Commands
DML Commands
DCL Commands

Keys in SQL

Keys and their types

Aggregate Functions in SQL

Aggregate Functions

Clauses in SQL

Clauses in SQL

Set Operations in SQL

Set Operations in SQL

Joins in SQL

Joins in SQL-1
Joins in SQL-2

Operators in SQL

Operators in SQL-1
Operators in SQL-2

Views in SQL

Views in SQL
Correction

Case Study

Pratical Implementation with MySQL

References and Acknowledgement

References and Acknowledgement

Final Quiz

Final Test

Screenshots

Fundamentals of SQL - Screenshot_01Fundamentals of SQL - Screenshot_02Fundamentals of SQL - Screenshot_03Fundamentals of SQL - Screenshot_04

Reviews

Claudia
September 27, 2023
Course was not appealing an visuals are very poor and do not support efficiently what is being said. There are only lists of words with no visual representations of how it looks like in real life.
Lesley-Anne
July 21, 2023
The explanations are clear and straightforward. The examples really helps with understanding a particular section.
Rachel
April 20, 2022
I found her accent to be too strong to understand everything she said and the closed captions are auto-generated, so they are not useful.
Chinasa
April 8, 2022
I think it’s a good course for a starter… easy to understand…I’m on my way to becoming better at this!
Victor
June 21, 2021
This is a great course to start the knowledge for the SQL databases, I think with this basic knowledge you can start another courses with more skills
Aditya
June 14, 2021
very excellent & explained in very easy way to understand quickly & effectively with examples; also there are resources which provides ready reference to the topics explained.
Rahul
May 26, 2021
I absolutely loved the course. I would recommend this to all the beginners. Excellent content given for free. The resources attached are really helpful.
Manasi
May 26, 2021
I felt the content provided was really curated.I love how they have include examples of every concept.The resources provided is also a plus point. Worth watching!!
Anuja
May 25, 2021
This course teaches SQL right from basics. Perfect course for beginners in database. Thanks for this course!

Charts

Price

Fundamentals of SQL - Price chart

Rating

Fundamentals of SQL - Ratings chart

Enrollment distribution

Fundamentals of SQL - Distribution chart

Related Topics

4015358
udemy ID
4/29/2021
course created date
5/26/2021
course indexed date
Bot
course submited by