- Course Overview
- Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
Expert
Online
₹ 479 1,299
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The SQL Made Easy for Beginners certification course was created by Arun Motoori, a Professional Software Testing Blogger and Trainer, and is offered by Udemy which is meant for students who want to master the principles of the structured query language. The SQL Made Easy for Beginners online course by Udemy focuses on teaching the principles of MySQL and Oracle SQL, as well as basic and advanced concepts.
SQL Made Easy for Beginners online classes are intended to teach students the skills needed to use the SQL language using MySQL and Oracle SQL by covering all aspects of SQL from beginning to end in a detailed, practical, and solution-oriented manner. Students will gain the skills necessary to establish a Linux virtual machine and to work with advanced frameworks such as putty software as a result of this course.
The highlights
- Certificate of completion
- Self-paced course
- 32 hours of pre-recorded video content
- Learning resources
Program offerings
- Online course
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the SQL Made Easy for Beginners online certification, students will be introduced to the fundamentals of SQL (structures query language). Students will learn about MySQL, Oracle SQL, and Oracle databases and how to use them. Students will learn about subqueries, JDBC, ODBC, statements, clauses, operators, and keywords. Students will also learn how to use the DBeaver Universal DB client tool, as well as the Linux virtual machine and putty software.
Who it is for
The syllabus
Introduction
Practice different SQL Statements, Clauses, Keywords and Operators
- How to Practice SQL without installing any Software?
- Select Command
- distinct keyword
- SQL is not case sensitive
- Semicolon
- Where Clause
- Using Relational Operators in Where Clause Condition
- Using Logical Operators (AND, OR, NOT)
- Between Operator
- Order By Clause (ASC, DESC)
- Using Between Operator with Text
- In Operator
- Like Operator and Wildcard Characters
- Aliases for Table Column Names (AS Keyword)
- Limit Keyword
- Breaking the Lengthy SQL Statement into multiple lines
MySQL Built-in Functions
- MySQL Built-in Functions
- upper() MySQL String Function
- lower() MySQL String Function
- length() MySQL String Function
- instr() MySQL String Function
- substr() MySQL String Function
- concat() MySQL String Function
- trim() MySQL String Function
- abs() MySQL Numeric Function
- mod() MySQL Numeric Function
- greatest() and least() MySQL Numeric Functions
- truncate() MySQL Numeric Function
- power() and sqrt() MySQL Numeric Functions
- current_date(), curdate(), current_time(), curtime(), now() and
- sysdate() MySQL
- year(),month(),day,monthname(),dayname() MySQL Date Time
- Functions
- avg(), max(), min(), count() and sum() MySQL Aggregate
- Functions
- Arithmetic Operators
Practicing SQL on MySQL
- Installing MySQL Server and Workbench Client for Practising
- SQL
- Creating, Deleting, viewing and using Databases
- Creating,Viewing, Describing and Deleting Tables
- Insert Into Statements (For inserting data into Tables)
- Data Types
- Null Value, Is Null Operator and Is Not Null Operator
- Delete Statement (For Deleting the Records from Table)
- Update Statement and Set Keyword (For Updating the Table
- Records)
- Rename statement and To Keyword (For Renaming Table Name)
- Alter Statement, Add, Modify Column, Rename Column and
- Drop Column Keywords
- Set Autocommit
- Commit Statement
- Rollback Statement
- Truncate Statement
- Single Line and Multi-Line Comments
- Group By Clause
- Having Clause
- Sequence of using where, group by, having and order by clauses
Set Operators
- Set Operators
- Union Operator
- Union All Operator
- Intersect Operator
- Minus Operator
Sub Queries and Other Advanced Concepts
- Tables and Aliases
- Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
- Sub Query (Explaining Single Row Sub Query by solving different SQL problems)
- In Operator
- Using In Operator with Multi-Row Sub Query
- Using Any Operator in Multi-Row Sub Query
- Using All Operator in Multi-Row Sub Query
- Exists Operator
- Using Sub Queries for retrieving the records from multiple tables
- Using Multiple Sub Queries in a single SQL statement
Integrity Constraints and other advanced concepts
- Integrity Constraints
- Not Null (Integrity Constraint)
- Unique (Integrity Constraint)
- Primary Key (Integrity Constraint)
- Foreign Key (Integrity Constraint)
- Check (Integrity Constraint)
- Default (Integrity Constraint)
- auto_increment
- Insert Into
- AS Keyword
- IfNull() function
- Case, When,Then and End Keywords
- Delimiter
- Delimiter usage in Stored Procedures
- Views
- Indexes
JDBC and ODBC
- JDBC (Connecting to MySQL Database from Java Programs)
- ODBC
Client Tools and other topics
- MySQL Shell Command Line Tool
- MySQL Command Line Client
- Using default Windows Command Prompt for connecting to MySQL Server
- Types of SQL Statements
- Grant and Revoke SQL Statements
- Temporary Tables
- Show Columns, Show Indexes, Show Privileges, and Show Grants
- Statements
- Inserting Null
- Using trim() for trimming the corner characters of the specified
- Table values
- Using wild-cards as normal characters
- Database Objects
Using MySQL In Linux Machine and Putty Software
- Creating Linux Virtual Machine
- Installing MySQL Server in Linux Ubuntu Machine
- Using Putty for Connecting to a Remote Machine having MySQL
- and performing SQL
Oracle SQL
- Oracle Database, SQL Plus, SQL Developer and Executing SQL
- Queries
- Oracle SQL Queries
- Oracle SQL Built-in functions
- Oracle SQL Queries (Part 2)
- Oracle SQL Queries (Part 3)
- Oracle SQL Queries (Part 4)
- Oracle SQL Queries (Part 5)
Other Tools for SQL
- DBeaver Universal DB Client Tool
- XAMPP for Practicing SQL
Interview Questions
- Question 1
- Question 2
- Question 3
- Question 4
- Question 5
- Question 6
- Question 7
- Question 8
- Question 9
- Question 10
- Question 11
- Question 12
- Question 13
- Question 14
- Question 15
- Question 16
- Question 17
- Question 18
Instructors
Mr Arun Motoori
Instructor
Freelancer
Articles
Popular Articles
Latest Articles
Courses of your interest
TOGAF 9 Combined Level 1 and Level 2 Training
SkillUp Online via Simplilearn
Advanced Certificate Program in DevOps
CMU School of Computer Science, ... via TalentSprint
Mastering Deep Learning Using Apache Spark
Simpliv Learning
Devops with AWS CodePipeline Jenkins and AWS CodeD...
Simpliv Learning
Machine Learning with Python from Linear Models to...
MIT Cambridge via Edx
Big Data Capstone Project
The University of Adelaide, Adel... via Edx
Computer Vision for Embedded Systems
Purdue University, West Lafayette via Edx
Computer Applications of Artificial Intelligence a...
Purdue University, West Lafayette via Edx
Advanced Power Searching With Google
Google via Edx