HOME > IT & Software > Fundamentals of SQL

Fundamentals of SQL

SynopsisFundamentals of SQL, available at Free, has an average rating...
Fundamentals of SQL  No.1

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

  • Fundamentals of SQL  No.2
    Ajay Dhruv, Ph.D.
    Instructor at Udemy
  • Fundamentals of SQL  No.3
    Sharvari Satose
    Student
  • Fundamentals of SQL  No.4
    Sejal Shriyan
    Student at udemy
  • Fundamentals of SQL  No.5
    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!