Udemy – Master Oracle SQL: From Basics to Advanced Techniques 2024-11

What you will learn

• Basics of Data and Databases: Understand the basic concepts of data and databases.
• SQL Basics and Database Administration: Learn the basics of SQL and how it works, and learn how to download, install, and configure an Oracle database.
• Basic Query Techniques: Learn basic query techniques such as using SELECT, WHERE and ORDER BY.
• Basics of SQL Functions: Learn about SQL’s built-in functions for manipulating strings, working with dates, and performing mathematical operations.
• Advanced Conditional Expressions in SQL: Learn about conditional expressions like CASE and how to use them in your queries.
• Techniques for combining data with SQL Joins: Learn how to use JOINs to combine data from multiple tables.
• Set Operators: Get to know the UNION, INTERSECT and EXCEPT operators.
• Manipulating data with SQL: Learn how to add, edit, and delete data using the INSERT, UPDATE, and DELETE commands.
• Managing transactions and constraints: Learn how to manage transactions and ensure data integrity.
• Aggregation and data analysis: Learn how to use aggregation functions such as COUNT, SUM, and AVG.
• Subqueries: Learn how to use subqueries to extract specific data from a database.
• Database Design Fundamentals: Understand the fundamentals of database design.
• Adverbs and Keys: Learn about different adverbs and keys in the database.

This course is suitable for people who

• complete beginner
• Future data analysts
• Current IT professionals
• Students and recent graduates
• Business professionals
• People who want to change their career