Oracle SQL for Beginners – The fundamentals
Oracle SQL for Beginners – The fundamentals, available at $34.99, has an average rating of 4.5, with 84 lectures, based on 101 reviews, and has 1416 subscribers.
You will learn about Learn Oracle SQL using Livesql, no software installation required. 84 lectures (5.5 hours of content) teaching you the fundamentals of SQL Statements. Every SQL statement explained word by word. Each lesson contain sample files attached. This course is ideal for individuals who are Anyone who want to learn SQL It is particularly useful for Anyone who want to learn SQL.
Enroll now: Oracle SQL for Beginners – The fundamentals
Summary
Title: Oracle SQL for Beginners – The fundamentals
Price: $34.99
Average Rating: 4.5
Number of Lectures: 84
Number of Published Lectures: 84
Number of Curriculum Items: 84
Number of Published Curriculum Objects: 84
Original Price: $89.99
Quality Status: approved
Status: Live
What You Will Learn
- Learn Oracle SQL using Livesql, no software installation required.
- 84 lectures (5.5 hours of content) teaching you the fundamentals of SQL Statements.
- Every SQL statement explained word by word.
- Each lesson contain sample files attached.
Who Should Attend
- Anyone who want to learn SQL
Target Audiences
- Anyone who want to learn SQL
Learn the basic concepts that you will need to write SQL statements.
What is SQL?
SQL (Structured Query Language) is the primary language responsible for managing data and data structures contained within a relational database management system (RDBMS). Put simply, SQL is the language you use to interact with a database.
Build a strong foundation in SQL with this tutorial for beginners.
-
Database basic concepts
-
Retrieving, filter data
-
Creating tables, modify tables
-
Manipulate data, sort data
-
Join tables
-
SQL functions
-
Grouping result set.
-
Database objects
-
Understanding users/ roles/privileges
-
Complex queries
-
Understanding the concept of transactional database
-
SQL types classification
-
Next steps
Why should you learn SQL?
-
Because you can earn really good money : SQL Developers have good incomes.
-
Because SQL is one of the most sought-after skills by hiring employers :Employers are seeking individuals who know SQL
-
Because you can get an answer to any question you ask about your data stores in a database :Think of all the questions you ask about your data on a regular basis. What were our sales last year? What is the average income for our employees? How many goods entered the company this month? Those are all questions that can be answered using SQL.
-
Because you no longer have to deal with Excel crashing : Ever crashed Excel because you had a ton of rows in a spreadsheet? Relational databases are designed to store millions and millions of rows of data. And you will need SQL for communicating with the database.
Content and Overview
Suitable for beginners, through this course of 84 lectures and 5.5 hours of content, you’ll learn all of the SQL fundamentals and establish a strong understanding of the concepts behind databases. Each lessons have attached files with examples, you can put your new skills into practical use immediately.
No need for a software installation for starting with the examples. No need for a database installation. You just create an free account on Livesql and you are ready to start, all the steps are described in the course
The Next Steps lesson with show you what are the next steps if you want to take the experience accumulated in this course to the next level.
Course Curriculum
Chapter 1: Database basic concepts
Lecture 1: What is data?
Lecture 2: What is a database?
Lecture 3: What is DBMS ?
Lecture 4: What is SQL ?
Lecture 5: What is a table
Lecture 6: LiveSQL
Lecture 7: Data types
Lecture 8: Summary
Chapter 2: Retrieve data, compare data
Lecture 1: Retrieve data
Lecture 2: Basic comparison operators
Lecture 3: Comparing 2 columns same table
Lecture 4: Comparison operator BETWEEN
Lecture 5: Comparison operator IN NOT IN
Lecture 6: Comparison operator LIKE
Lecture 7: NULL , IS NULL and IS NOT NULL
Lecture 8: Logical operators AND OR NOT
Lecture 9: Aritmetic operators
Lecture 10: Summary
Chapter 3: Table structure definition
Lecture 1: Create table
Lecture 2: Alter table
Lecture 3: Constraints
Lecture 4: Unique constraint
Lecture 5: Primary key
Lecture 6: Foreign key
Lecture 7: Check constraint
Lecture 8: Disable constraints
Lecture 9: Naming convention
Lecture 10: Create table as
Lecture 11: Drop table
Lecture 12: Summary
Chapter 4: Table data manipulation, sorting, set operators
Lecture 1: Insert data
Lecture 2: Update data
Lecture 3: Delete data
Lecture 4: Sorting data
Lecture 5: Set operators
Lecture 6: DISTINCT clause
Lecture 7: Summary
Chapter 5: Joins
Lecture 1: Joins
Lecture 2: Inner join
Lecture 3: Left, right join
Lecture 4: Full outer join
Lecture 5: Natural join
Lecture 6: Cross join
Lecture 7: Multiple join tables
Lecture 8: Old syntax joins
Lecture 9: Summary
Chapter 6: Functions
Lecture 1: Data types
Lecture 2: Dual
Lecture 3: Functions
Lecture 4: Numeric functions
Lecture 5: Character functions returning character
Lecture 6: Character functions returning number
Lecture 7: Datetime functions
Lecture 8: General comparison functions
Lecture 9: Conversion functions
Lecture 10: Encoding and decoding functions
Lecture 11: NULL related functions
Lecture 12: Enviroment functions
Lecture 13: Agregate functions
Lecture 14: Analitic functions
Lecture 15: Summary
Chapter 7: Grouping
Lecture 1: GROUP BY Clause
Lecture 2: HAVING Clause
Lecture 3: Summary
Chapter 8: Database objects
Lecture 1: Overview
Lecture 2: View
Lecture 3: Sequence
Lecture 4: Synonim
Lecture 5: Index
Lecture 6: Other database objects
Lecture 7: Sample schema in livesql
Lecture 8: Summary
Chapter 9: Roles and privilleges
Lecture 1: Roles/ Privilegies
Lecture 2: GRANT, REVOKE
Lecture 3: Summary
Chapter 10: Complex queries
Lecture 1: CASE
Lecture 2: Subqueries
Lecture 3: EXISTS
Lecture 4: Summary
Chapter 11: Transactional database, Types of SQL statements
Lecture 1: Transactional database
Lecture 2: Types of SQL statements
Lecture 3: Summary
Chapter 12: Next steps
Lecture 1: Next steps
Lecture 2: Install an Oracle database locally
Instructors
-
Sultana Iulian
Oracle developer
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 2 votes
- 3 stars: 18 votes
- 4 stars: 33 votes
- 5 stars: 48 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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024