Learn SQL from Industry Experts
Learn to create, read, update, and delete data from a database, and how to use SQL to analyze data.
Lectures -81
Resources -1
Duration -6.5 hours
30-days Money-Back Guarantee
Get your team access to 9000+ top Tutorials Point courses anytime, anywhere.
Course Description
“Learn SQL from Industry Experts” is a project-based online course that will help you master the fundamentals of SQL from scratch easily and quickly. SQL can skyrocket your career in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, that's why it's so popular and backed by Oracle.
Learn SQL from Industry Experts Overview
This SQL course will teach you the basics of SQL, a powerful language for querying and manipulating data and quickly get up to speed with Oracle SQL. We will explain SQL query skills in a step-by-step fashion to help you understand it in a simpler way.
This will help you learn and understand essential concepts like how to write SQL codes easily and think analytically about the problem in your company. By the end of this course, you will be able to use SQL to solve a variety of problems in data analysis and business intelligence.
This Course is for:
University or College students
Fresh graduates or professionals
Intermediates on SQL
All Software Developers (Java/.Net/ Python, etc.) interacting with the Oracle Database
Anyone who wants to Learn SQL
Goals
What will you learn in this course:
Analyze, read, and write SQL queries easily.
Learn database terminology.
Acquire data from the database.
Use SQL Functions, group data, and use the subqueries.
Manipulate data and create analytical solutions for any SQL problems.
Restrict and filter data.
Sort the results.
Join multiple tables.
Combine the results using Oracle SET Operators.
Create, modify, alter, and drop your own tables.
Prerequisites
What are the prerequisites for this course?
A computer installed with Windows/Linux /OS X.
Ability to use an Operating System.
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Introduction + Welcome
1 Lectures
- Course Introduction 02:04 02:04
Database Concepts
6 Lectures
Preparation for SQL Development
9 Lectures
Entering the Database
9 Lectures
Conditional Retrieval
7 Lectures
Converting Data & Conversion Functions
6 Lectures
Ordering the Results
2 Lectures
Single-Row Functions
6 Lectures
Group Functions (Grouping the Data)
6 Lectures
Grouping the Data (Grouping Multiple Records)
2 Lectures
Joins (Combining Data from Multiple Tables)
12 Lectures
Query inside a Query (Subqueries)
4 Lectures
Combining Query Results (Using SET Operators)
4 Lectures
Manipulating and Playing with the Data (DML - Data Manipulation Language)
4 Lectures
Manipulating Tables (DDL - Data Definition Language)
2 Lectures
Instructor Details
Omer Faruk Ince
Oracle SQL, PL/SQL, SQL Tuning, Python, PHP, Java, RubyWelcome to my courses.
I've been working for more than 25+ years on software development in many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 25+ years on SQL & PL/SQL programming using many different Oracle Technologies.
Currently, I work as a Project Manager on a huge database that has more than 20+ million active users, and at the same time, teaching SQL, PL/SQL, and many other programming languages such as Python, C, Java, and PHP programming, etc.
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now