課程介紹

LAST UPDATED: November 2020

(Source Code Included for Lectures)

Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hot

…[更多細節]

哪些人適合這堂課？

• Anyone willing to get into the software development career
• Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer
• Anyone willing to work hard in mastering the SQL language
• Anyone who is interested in passing the Oracle 1Z0-071 exam!

學習目標

• Become Job Ready to Start Contributing as a Database Developer Day 1
• Program in the SQL Language to Solve a Variety of Database Problems
• Code along with me to PRACTICE and IMPLEMENT everything you learn
• Become a SQL Ninja and Understand How the Oracle Database Works
• MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
• Obtain the Skills that are Necessary to Land a Job as a SQL Developer
• Have the Ability to Solve any SQL Problem

課程介紹

* List Price temporarily reduced from $74.99 to $19.99

Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, ma

…[更多細節]

哪些人適合這堂課？

• Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition.
• Aspiring application or database developers looking to work with Oracle databases.
• Anyone taking or planning to take Oracle SQL or PL/SQL courses.
• College/University students who need to learn and use SQL for Oracle to pass their database-related courses.

學習目標

• You will take advantage of many useful features that will make you more effective and efficient at work
• You will learn a lot of tricks and enjoy being seen as an SQL Developer expert
• You will learn how to create and share beautiful and interactive reports
• You will learn how to Install and customize SQL Developer in a way that works and feels best for you
• You will learn how to take full advantage of all the basic features of the tool

課程介紹

★ Last Course Updates:

(Jul, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

(Jun, 2021): New Brand Content was added!

(May, 2021): More Quiz Questions were added!

Important Notice: This course will be c

…[更多細節]

哪些人適合這堂課？

• Anyone willing to step into the software development career!
• Anyone dreaming to get a well-paid SQL Development Job!
• Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
• Anyone who wants to Become an in-demand SQL Professional!

學習目標

• Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
• Be Able to Answer any SQL Interview Questions Confidently!
• Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
• Learn Oracle SQL by Professionally Designed Content Step by Step!
• Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
• Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
• Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
• Lifetime Support from the Instructors. Get a Well-Organized Recap Document!

課程介紹

★ Here is the most comprehensive SQL Tuning course that you will not need to take any other courses in anywhere.

★ This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuni

…[更多細節]

哪些人適合這堂課？

• SQL Developers
• Data Analysts
• Data Scientists
• PL/SQL Developers
• Oracle DBAs
• Oracle BI Developers

學習目標

• Learn How to Solve Critical Performance Problems with Step by Step Approach!
• Learn Advanced Indexing Techniques for Ultimate Database Performance!
• Learn How to Use Various Performance Tuning Tools for In-Depth Assistance!
• Maximize the Query Performance by Using Advanced Tuning Tecniques!
• Learn Oracle Database Architecture by “Tuning” aspects.
• Identify and Optimize the Performance of poorly performing (bad) SQLs.
• Understand SQL Tuning Terminologies
• Learn How to Create “Better” Queries
• Learn How to Prioritize your SQL Tuning Efforts.
• Learn the Details of How an SQL Code is Interpreted
• Learn Useful Hints to improve Performance of your Queries
• Learn & Improve How to Use Oracle Optimizer and Execution Plans Well
• Various Tips and Tricks to make the Oracle SQL queries run faster.
• Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
• Learn Efficient Schema Design
• Lifetime Support from the Authors.
• Weekly Quizzes & Assesment Tests
• Working materials and always up to date!

課程介紹

***SQL course which gained immediate popularity with the launch on UDEMY***

============================================================================

***Continuously being updated with new topics/videos***

***Added lecture SQL vs NOSQL*** > 19

…[更多細節]

哪些人適合這堂課？

• Students interested in database back end programming
• Programmers in any other front end language like Java or PHP or Python etc, must learn SQL
• Engineering students, Computer Science students, Science / Commerce students – All pursuing UG or PG or completed with degree
• Management people who are required to draw ad-hoc data as per requirement

學習目標

• SQL over Oracle 19 C version on Oracle LiveSQL platform
• A to Z in SQL on Oracle’s latest version
• Go from an absolute beginner to an advanced SQL developer in less than 15 hours
• RDBMS fundamentals and explanation on various terminologies for interview preparation
• This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web
• Structure of basic query statement – Projection, Predicate and Verb
• Use of Logical Operators – AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE
• Various important properties of ORDER BY clause with examples
• Deal with NULL values – IS NULL, NVL, NVL2, COALESCE
• All forms of Sub-queries / Nested Queries – Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators
• All forms of JOIN operations – Inner, Equijoin, Natural, Non-equijoin, Selfjoin, Outer Join operator, OUTER JOIN clause
• GROUP BY clause concept – Group Functions MAX, MIN, SUM, AVG, COUNT – Group function tricky queries
• Analytical / Aggregate form of Function – ROLLUP, CUBE, RANK, DENSE_RANK, DECODE vs CASE
• SQL General Functions – Conversion, Numeric, String, Date functions – Query examples
• Database Transaction Concepts – DML statements and forms – Rows Locking FOR UPDATE NOWAIT clause – Transaction Consistent Read SET TRANSACTION READ ONLY
• SQL commands DELETE vs TRUNCATE – Difference and similarities
• CREATE TABLE from scratch and copy from existing table – ALTER TABLE – Add/drop columns – Change column datatypes/widths and limitations – RENAME columns/Table
• Constraint Metadata – Enable / Disable Constraint – Data Validation
• Data Integrity Concepts – Data Integrity Constraints – Column / Table level constraint definitions – Referential Integrity through FOREIGN KEY constraint
• IMMEDIATE vs DEFERRED constraints – Transaction level constraint validation.

課程介紹

* List Price of this Oracle SQL course has been temporarily reduced from $129.99 to $24.99

* Covers Oracle Database 11g, Oracle 12c, Oracle 18c, and Oracle 19c

Oracle is currently the most popular relational database management system in the world.

…[更多細節]

哪些人適合這堂課？

• Aspiring application or database developers looking to acquire solid SQL knowledge to improve their careers.
• College/University students who need SQL knowledge to pass their database-related courses.
• Anyone with only basic SQL knowledge wanting to solidify their skill and use the language with confidence.
• This course is not for you if you are already an experienced Oracle SQL developer looking to learn the most advanced features of the language.
• This course is not for you if you are looking for a theoretical course.

學習目標

• You will be able to use Oracle SQL to retrieve, filter, analyze, format and present information from Oracle databases.
• You will be able to use SQL to insert, modify and delete information from Oracle databases.
• You will understand Oracle SQL code written by other people and feel confident to modify it.
• You will be able to write the SQL code needed to solve the most common problems found in real work situations and academic tests.
• Please note that PL/SQL is not covered in this course.

課程介紹

Data Migration is an important function anyone working with a database should be able to carry out.

There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracl

…[更多細節]

哪些人適合這堂課？

• Beginner database administrators
• Beginner Data Analyst
• Anyone who wants learn database migration

學習目標

• Migrate SQL Database to Oracle
• Connect to third party database
• Capture third party source data
• Configure third party database connection
• Convert Captured Data Model to Oracle
• Create Migration Repository
• Generate Migration Scripts to create Target Database
• Translate Third Party SQL Objects to Oracle
• Move Data from SQL Server into Oracle

課程介紹

*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support***

Please note that this course will be continuously getting updated with more videos to keep you up to date on Oracle SQL Tuning. Yo

…[更多細節]

哪些人適合這堂課？

• Oracle SQL Developers who want to optimize the SQL queries.
• Aspirants seeking career opportunities in Oracle Database and SQL.
• DBA, Developers, Support Analyst who wants to troubleshoot Oracle SQL queries and fix it.

學習目標

• Step by Step approach on troubleshooting badly performing SQL queries.
• Identify how internal Oracle components affects the performance of the SQL query.
• Identify potential performance bottlenecks by reading the Explain plan of the queries.
• Tips and Tricks to make the Oracle SQL query run faster.
• Compare BAD vs GOOD Queries with Examples.
• Understand how STATISTICS and CARDINALITY affects the performance of the SQL Query.
• Implications of JOINS and ACCESS Methods on the performance of the Query.
• Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
• Advanced SQL Query Tuning Steps.

課程介紹

This course is the foundation for the Oracle Database SQL 1Z0-071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or

…[更多細節]

哪些人適合這堂課？

• This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
• This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.

學習目標

• Create tables in a database and ALTER columns in the table.
• Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
• Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
• JOIN two or more tables together, finding missing data.
• INSERT new data, UPDATE and DELETE existing data, and export data into a new table.
• Create constraints, views and sequences, subqueries and CTEs
• Use UNION, CASE, MERGE and error checking
• Apply ranking and analytic functions, grouping
• Learn about transactions, indexes, users, privileges, roles and more

課程介紹

学习并掌握Oracle数据库基本的select语句语法，包括：查询数据、排序数据、过滤数据和使用单行函数。为学员继续学习Oracle数据库奠定基础。 

==========课程大纲===========
一、基本查询课程概述和安装环境
（*）课程概述
（*）导入Virtual Box虚拟机
（*）在虚拟机上安装Oracle数据库
（*）验证Oracle数据库环境
（*）Oracle的基本概念和体系结构
（*）Oracle的集群基础
（*）Oracle数据库的数据文件和scott用户

二、基本

…[更多細節]

哪些人適合這堂課？

• Oracle数据库开发人员和在校大学生。

學習目標

• 掌握Oracle数据库的基础知识和基本的SQL语句