- Learn how to write and execute SQL queries in a simpler way.
- Free tutorial
- Rating: 4.4 out of 54.4 (311 ratings)
- 9,520 students
- 1hr 48min of on-demand video
- Created by Ajay Dhruv, Ph.D., Sharvari Satose, Sejal Shriyan, Sejal Jadhav
- English
What you’ll 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.
Requirements
- No prior knowledge is required.
- A working computer system with MySQL installed in it to run your Queries(optional)
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.
Who this course is for:
- Anyone who wants to learn how to use SQL and MySQL within 2 hours
Show less
Course content
12 sections • 16 lectures • 1h 48m total lengthCollapse all sections
Introduction1 lecture • 3min
- Overview of SQL02:54
Commands in SQL3 lectures • 13min
- DDL Commands05:37
- DML Commands04:52
- DCL Commands02:46
Keys in SQL1 lecture • 6min
- Keys and their types06:02
Aggregate Functions in SQL1 lecture • 4min
- Aggregate Functions03:38
Clauses in SQL1 lecture • 10min
- Clauses in SQL10:24
Set Operations in SQL1 lecture • 5min
- Set Operations in SQL04:53
Joins in SQL2 lectures • 17min
- Joins in SQL-108:10
- Joins in SQL-208:45
Operators in SQL2 lectures • 30min
- Operators in SQL-113:45
- Operators in SQL-216:22
Views in SQL2 lectures • 8min
- Views in SQL07:56
- Correction00:07
Case Study1 lecture • 12min
- Pratical Implementation with MySQL11:59
References and Acknowledgement1 lecture • 1min
- References and Acknowledgement00:01
Final Quiz0 lectures • 0min
- Final Test10 questions