SQL Made Easy for Beginners

SQL Made Easy for Beginners, available at $54.99, has an average rating of 4.3, with 127 lectures, based on 41 reviews, and has 184 subscribers.

You will learn about SQL from Basics to the Advanced Level Learning SQL on both popular MySQL and Oracle RDBMS Software This course is ideal for individuals who are Beginners who want to learn SQL from scratch to the advanced level It is particularly useful for Beginners who want to learn SQL from scratch to the advanced level.

Enroll now: SQL Made Easy for Beginners

Summary

Title: SQL Made Easy for Beginners

Price: $54.99

Average Rating: 4.3

Number of Lectures: 127

Number of Published Lectures: 127

Number of Curriculum Items: 127

Number of Published Curriculum Objects: 127

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

SQL from Basics to the Advanced Level

Learning SQL on both popular MySQL and Oracle RDBMS Software

Who Should Attend

Beginners who want to learn SQL from scratch to the advanced level

Target Audiences

Beginners who want to learn SQL from scratch to the advanced level

This course will teach you how to use the SQL language with MySQL and Oracle, by covering all the topics of SQL from scratch to advanced level in a detailed, step by step, practical, solution oriented and easiest manner.

Check the course contents to see the number of topics I covered int this video course to make you an SQL expert by teaching the SQL from basics and scratch to the advanced level.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)

Chapter 2: Practice different SQL Statements, Clauses, Keywords and Operators

Lecture 1: How to Practice SQL without installing any Software?

Lecture 2: Select Command

Lecture 3: distinct keyword

Lecture 4: SQL is not case sensitive

Lecture 5: Semicolon

Lecture 6: Where Clause

Lecture 7: Using Relational Operators in Where Clause Condition

Lecture 8: Using Logical Operators (AND, OR, NOT)

Lecture 9: Between Operator

Lecture 10: Order By Clause (ASC, DESC)

Lecture 11: Using Between Operator with Text

Lecture 12: In Operator

Lecture 13: Like Operator and Wildcard Characters

Lecture 14: Aliases for Table Column Names (AS Keyword)

Lecture 15: Limit Keyword

Lecture 16: Breaking the Lengthy SQL Statement into multiple lines

Chapter 3: MySQL Built-in Functions

Lecture 1: MySQL Built-in Functions

Lecture 2: upper() MySQL String Function

Lecture 3: lower() MySQL String Function

Lecture 4: length() MySQL String Function

Lecture 5: instr() MySQL String Function

Lecture 6: substr() MySQL String Function

Lecture 7: concat() MySQL String Function

Lecture 8: trim() MySQL String Function

Lecture 9: abs() MySQL Numeric Function

Lecture 10: mod() MySQL Numeric Function

Lecture 11: greatest() and least() MySQL Numeric Functions

Lecture 12: truncate() MySQL Numeric Function

Lecture 13: power() and sqrt() MySQL Numeric Functions

Lecture 14: current_date(), curdate(), current_time(), curtime(), now() and sysdate() MySQL

Lecture 15: year(),month(),day,monthname(),dayname() MySQL Date Time Functions

Lecture 16: avg(), max(), min(), count() and sum() MySQL Aggregate Functions

Lecture 17: Arithmetic Operators

Chapter 4: Practicing SQL on MySQL

Lecture 1: Installing MySQL Server and Workbench Client for Practising SQL

Lecture 2: Creating, Deleting, viewing and using Databases

Lecture 3: Creating,Viewing, Describing and Deleting Tables

Lecture 4: Insert Into Statements (For inserting data into Tables)

Lecture 5: Data Types

Lecture 6: Null Value, Is Null Operator and Is Not Null Operator

Lecture 7: Delete Statement (For Deleting the Records from Table)

Lecture 8: Update Statement and Set Keyword (For Updating the Table Records)

Lecture 9: Rename statement and To Keyword (For Renaming Table Name)

Lecture 10: Alter Statement, Add, Modify Column, Rename Column and Drop Column Keywords

Lecture 11: Set Autocommit

Lecture 12: Commit Statement

Lecture 13: Rollback Statement

Lecture 14: Truncate Statement

Lecture 15: Single Line and Multi-Line Comments

Lecture 16: Group By Clause

Lecture 17: Having Clause

Lecture 18: Sequence of using where, group by, having and order by clauses

Chapter 5: Set Operators

Lecture 1: Set Operators

Lecture 2: Union Operator

Lecture 3: Union All Operator

Lecture 4: Intersect Operator

Lecture 5: Minus Operator

Chapter 6: Sub Queries and Other Advanced Concepts

Lecture 1: Tables and Aliases

Lecture 2: Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)

Lecture 3: Sub Query (Explaining Single Row Sub Query by solving different SQL problems)

Lecture 4: In Operator

Lecture 5: Using In Operator with Multi Row Sub Query

Lecture 6: Using Any Operator in Multi Row Sub Query

Lecture 7: Using All Operator in Multi Row Sub Query

Lecture 8: Exists Operator

Lecture 9: Using Sub Queries for retrieving the records from multiple tables

Lecture 10: Using Multiple Sub Queries in a single SQL statement

Chapter 7: Integrity Constraints and other advanced concepts

Lecture 1: Integrity Constraints

Lecture 2: Not Null (Integrity Constraint)

Lecture 3: Unique (Integrity Constraint)

Lecture 4: Primary Key (Integrity Constraint)

Lecture 5: Foreign Key (Integrity Constraint)

Lecture 6: Check (Integrity Constraint)

Lecture 7: Default (Integrity Constraint)

Lecture 8: auto_increment

Lecture 9: Insert Into

Lecture 10: AS Keyword

Lecture 11: IfNull() function

Lecture 12: Case, When,Then and End Keywords

Lecture 13: Delimiter

Lecture 14: Delimiter usage in Stored Procedures

Lecture 15: Views

Lecture 16: Indexes

Chapter 8: JDBC and ODBC

Lecture 1: JDBC (Connecting to MySQL Database from Java Programs)

Lecture 2: ODBC

Chapter 9: Client Tools and other topics

Lecture 1: MySQL Shell Command Line Tool

Lecture 2: MySQL Command Line Client

Lecture 3: Using default Windows Command Prompt for connecting to MySQL Server

Lecture 4: Types of SQL Statements

Lecture 5: Grant and Revoke SQL Statements

Instructors

Arun Motoori
Software Testing Blogger & Trainer

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 19 votes

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