Brochure
Enquire- What is the Database?
- Why Oracle Database?
- What is a Table?
- Special Gifts for Our Students
- What is a Relational Database?
- Entity Relationship Logic in Databases
- What is Pluggable Database?
- The Sample (HR) Schema Used in This Course
- What is SQL?
SQL for Beginners: The Easiest Way to Learn SQL Step by Step
BY
Udemy
Gain an understanding of the logical concepts and strategies associated with structured query language using real-world ...Read more
Beginner
Online
₹ 649 4099
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Structured Query Language (SQL) is a standard database language for creating, maintaining, and retrieving relational databases. SQL is a programming language that is used to handle relational databases and perform multiple operations on their data. SQL for Beginners: The Easiest Way to Learn SQL Step by Step online certification was created in partnership with Oracle Master Training - Oracle Architect & Instructor and is available on Udemy.
SQL for Beginners: The Easiest Way to Learn SQL Step by Step online training is a comprehensive program that incorporates 8 hours of hands-on learning resources along with 11 articles, 6 downloadable resources, assignments, and quizzes to provide applicants with a solid understanding of the foundational concepts of the structured query language. With SQL for Beginners: The Easiest Way to Learn SQL Step by Step online course, applicants will be taught about relational databases, SQL functions, SQL development, data manipulation, and much more.
The highlights
- Certificate of completion
- Self-paced course
- 8 hours of pre-recorded video content
- 11 articles
- 6 downloadable resources
- Assignments
- Quizzes
- Assessments
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
₹ 649 ₹4,099
certificate availability
Yes
certificate providing authority
Udemy
Who it is for
What you will learn
Database knowledge
Sql knowledge
After completing the SQL for Beginners: The Easiest Way to Learn SQL Step-by-Step certification course, applicants will develop a foundational understanding of the principles of SQL as well as will gain knowledge of the basic concepts involved with relational databases and SQL development. In this SQL certification, applicants will look into the fundamentals of data definition language and data manipulation language as well as will obtain knowledge of the functionalities of tables, SQL functions, SQL queries, and subqueries. In this SQL course, applicants will also learn about various database terminologies including grouping data, restricting data, filtering data, and data manipulation.
The syllabus
Database Concepts
Preparation for SQL Development
- About the Database Installation
- The Ways to Get a Database
- Option 1: Installing VMware and VirtualBox on Windows
- Option 1: How to Install VirtualBox on Mac OS X?
- Option 1: Downloading Virtual Machine Image
- Option 1: Configuring the VMware Virtualization Software
- Option 1: Configuring the Oracle VirtualBox Virtualization Software
- Option 1: Configuring SQL Developer inside of the Virtual Machine
- Option 2: Downloading And Installing the Oracle Database
- Option 2: Unlocking the HR Schema
- Option 2: Configuring and Using Oracle SQL Developer
- Option 3: Using Oracle Live SQL
- Option 3: About Oracle Live SQL Restrictions
Entering the Database!
- Basic SQL Statements
- SQL Coding Tips!
- Let's describe the tables!
- How to Get Data? (Select Statement)
- Aliasing The Columns
- Getting Different Rows - DISTINCT Operator!
- Concatenating The Returning Rows
- Arithmetic Expressions
- What is the NULL Value? Is it dangerous?
Conditional Retrieval
- Getting Data Just We Want - WHERE Clause!
- Comparison Operators
- Between...AND Operators
- IN Operator
- Get Me Something LIKE this
- What If Looking For Something NULL
- Logical Operators - AND, OR, NOT
Converting Data & Conversion Functions
- What is a Function?
- Why to Convert Data?
- Conversion Functions
- Converting to a Character - TO_CHAR Function
- Converting to a Date - TO_DATE Function
- NULL Value Conversion - NVL Function
Ordering The Results
- ORDER BY Clause
- ASC and DESC Operators
Single Row Functions
- About Single Row Functions
- Character Functions
- Number Functions
- Nesting Functions
- Date Functions
- DECODE Function
Grouping the data (Group Functions)
- What are group functions?
- MAX Function
- MIN Function
- Count() Function
- AVG Function
- SUM Function
Grouping the Data
- GROUP BY Clause
- HAVING Clause
Selecting From Multiple Tables (Joins)
- What is join?
- Types of Joins!
- Let's Join Tables!
- Join With USING Clause
- Join with ON Clause
- Join the table with itself!
- Joining Multiple Tables
- What are the Outer Joins?
- What are the Left Joins? (Left Outer Joins)
- What are the Right Joins? (Right Outer Joins)
- Full Outer Joins
- Cross Joins - Cartesian Product
Query inside a Query - Subqueries
- What is a subquery?
- Single Row Subqueries
- Multiple Row Subqueries
- Multiple Columns Subqueries
Combining Queries - SET Operators!
- What are SET Operators and why do we use them?
- Combine with "UNION" and "UNION ALL" Statements
- INTERSECT'ing and EXTRACT'ing Queries
- More in SET Operations
Manipulating and Playing with the Data (DML)
- What is DML and why it is used for?
- INSERTing a New Record!
- UPDATE the existing record!
- DELETE records!
- What are COMMIT and ROLLBACK Statements?
Manipulating Tables - DDL
- How to CREATE a Table With Many Ways and RENAME It?
- How to DROP an Existing Table?
- How to Add a New Column to a Table?
- How to Modify an Existing Column?
- How to Drop an Existing Column of a Table?
Appendix + Conclusion
- Appendix 1: Oracle Database 12c Installation into Your Computer
- Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
- Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c
- Course Gift: (SQL Cheatsheet)
- Bonus Lecture
Articles
Popular Articles
prev
next
Latest Articles
prev
next
Similar Courses
My SQL Basics
Great Learning
Introduction to Structured Query Language
Davidson College, Davidson via Edx
Oracle SQL Exam Prep
LearnQuest via Coursera
prev
next
Courses of your Interest
C++ Foundation
PW Skills
Advanced CFD Meshing using ANSA
Skill Lync
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Fundamentals of Agile Project Management
UCI Irvine via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
prev
next
More Courses by Udemy
prev
next
