Fundamentals of SQL

Fundamentals of SQL, available at Free, has an average rating of 4.46, with 16 lectures, 1 quizzes, based on 509 reviews, and has 12260 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone who wants to learn how to use SQL and MySQL within 2 hours It is particularly useful for Anyone who wants to learn how to use SQL and MySQL within 2 hours.

Enroll now: Fundamentals of SQL

Summary

Title: Fundamentals of SQL

Price: Free

Average Rating: 4.46

Number of Lectures: 16

Number of Quizzes: 1

Number of Published Lectures: 16

Number of Published Quizzes: 1

Number of Curriculum Items: 17

Number of Published Curriculum Objects: 17

Original Price: Free

Quality Status: approved

Status: Live

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.

Who Should Attend

Anyone who wants to learn how to use SQL and MySQL within 2 hours

Target Audiences

Anyone who wants to learn how to use SQL and MySQL within 2 hours

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 CALCULATIONSand 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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Overview of SQL

Chapter 2: Commands in SQL

Lecture 1: DDL Commands

Lecture 2: DML Commands

Lecture 3: DCL Commands

Chapter 3: Keys in SQL

Lecture 1: Keys and their types

Chapter 4: Aggregate Functions in SQL

Lecture 1: Aggregate Functions

Chapter 5: Clauses in SQL

Lecture 1: Clauses in SQL

Chapter 6: Set Operations in SQL

Lecture 1: Set Operations in SQL

Chapter 7: Joins in SQL

Lecture 1: Joins in SQL-1

Lecture 2: Joins in SQL-2

Chapter 8: Operators in SQL

Lecture 1: Operators in SQL-1

Lecture 2: Operators in SQL-2

Chapter 9: Views in SQL

Lecture 1: Views in SQL

Lecture 2: Correction

Chapter 10: Case Study

Lecture 1: Pratical Implementation with MySQL

Chapter 11: References and Acknowledgement

Lecture 1: References and Acknowledgement

Chapter 12: Final Quiz

Instructors

Ajay Dhruv, Ph.D.
Instructor at Udemy

Sharvari Satose
Student

Sejal Shriyan
Student at udemy

Sejal Jadhav
Student at Udemy

Rating Distribution

1 stars: 3 votes

2 stars: 13 votes

3 stars: 55 votes

4 stars: 191 votes

5 stars: 247 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!