SQL For Beginners

SQL For Beginners, available at $44.99, has an average rating of 4.85, with 29 lectures, based on 109 reviews, and has 6907 subscribers.

You will learn about Understand the terminologies of DB, DBMS, RDBMS, SQL Understand how to query a database using SQL Statements Analyse the case studies and write SQL Statements for the given question Knowing the features of the SQL This course is ideal for individuals who are Computer Science Aspirants or Software Engineering Aspirants or Anyone who wants to learn SQL It is particularly useful for Computer Science Aspirants or Software Engineering Aspirants or Anyone who wants to learn SQL.

Enroll now: SQL For Beginners

Summary

Title: SQL For Beginners

Price: $44.99

Average Rating: 4.85

Number of Lectures: 29

Number of Published Lectures: 29

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: ?1,199

Quality Status: approved

Status: Live

What You Will Learn

Understand the terminologies of DB, DBMS, RDBMS, SQL

Understand how to query a database using SQL Statements

Analyse the case studies and write SQL Statements for the given question

Knowing the features of the SQL

Who Should Attend

Computer Science Aspirants

Software Engineering Aspirants

Anyone who wants to learn SQL

Target Audiences

Computer Science Aspirants

Software Engineering Aspirants

Anyone who wants to learn SQL

Welcome to my course on SQL For Beginners. It is very essential to know and understand the importance and implementation of database systems in the real world. To interact with a lot of DBMS Softwares available out there, SQL becomes the most wanted language. SQL stands for Structured Query Language which interprets the data in forms of tabular structures. This short term course will give you a good understanding on

1. Fundamentals of Relational Database Management Systems.

2. Procedure to write SQL Statements for any given case study.

After completing this course, you’ll be able to perform case studies, form the database and write SQL Queries for the same.

The topics that will be covered in this course are:

1. DDL Statements

2. DML Statements

3. Types of Constraints in SQL

4. Datatypes in Oracle SQL

5. Primary, Foreign Keys

6. Select Statement

7. Select Distinct

8. Where clause

9. Group By clause

10. Order By clause

11. Having clause

12. Aggregate functions

13. Different types of joins in SQL – Inner, Left, Right, Full

14. Sub Queries

And so on.

I will follow a step by step procedure in my pedagogy which will greatly gain you the momentum which accelerates your pace to complete this course at the earliest. Furthermore, None of the Technical Interviews will go without SQL. So, The concepts you learn will gain not only the knowledge but also boosts your confidence levels.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to SQL, RDBMS

Lecture 2: Types of SQL Statements – DDL Statements

Lecture 3: Other types of SQL Statements

Chapter 2: DDL Statements

Lecture 1: Datatypes in Oracle SQL

Lecture 2: Create Table in SQL

Lecture 3: Constraints in SQL – Unique, Not Null, Check

Lecture 4: Primary and Foreign Key Constraints in SQL

Lecture 5: Alter table in SQL

Lecture 6: How to use Oracle Live SQL

Chapter 3: DML Statements

Lecture 1: Insert into Statement

Lecture 2: Introduction to Select Statement

Lecture 3: SQL Select Distinct

Lecture 4: SQL Where Clause

Lecture 5: Case Study 1

Chapter 4: DML Statements – Part 2

Lecture 1: SQL Order By Statement

Lecture 2: SQL Update

Lecture 3: SQL Aggregate Functions

Lecture 4: The Concept of Pattern Matching – SQL Wildcards

Lecture 5: Case Study 2 – Pattern Matching

Lecture 6: SQL Group By Statement

Lecture 7: SQL Having Statement

Lecture 8: Example – Using Having and Where Clause in SQL

Chapter 5: SQL Joins

Lecture 1: Types of Joins in SQL

Lecture 2: Inner Join in SQL

Lecture 3: Left Join in SQL

Lecture 4: Right Join in SQL

Lecture 5: Full Outer Join in SQL

Chapter 6: Subqueries and Final Case Study

Lecture 1: SQL Subqueries

Lecture 2: Final Case Study – Test your skills!

Instructors

Sujithkumar MA
Engineer | Course Instructor

Rating Distribution

1 stars: 3 votes

2 stars: 1 votes

3 stars: 20 votes

4 stars: 40 votes

5 stars: 45 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!