CareerVision Training

SQL For Oracle Training DVD

CareerVision Training
En Birmingham (Inglaterra)

£72 - ($58.307)

Información importante

  • Training
  • Beginner
  • Birmingham (Inglaterra)
  • Duración:
  • Cuándo:
    A definir

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Información importante

¿Dónde se da y en qué fecha?

comienzo Ubicación
A definir
Careervision 61 Caroline Street,, B3 1UF, West Midlands, Inglaterra

¿Qué aprendes en este curso?

Oracle Training


A Practical SQL for Oracle Training Course That Teaches Real World Skills

In this project-based Learning SQL For Oracle video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Learning SQL For Oracle training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Learning SQL For Oracle subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Learning SQL For Oracle tutorial, online or offline... so you'll know the exact steps for your own projects.

  • Duration: 9 hours - 111 tutorial videos
  • Date Released: 2014-08-20
  • Works on: Windows PC or Mac
  • Format: DVD and Download
  • Instructor: Steve Perry

Course Description

In this Oracle SQL training course, expert author Steve Perry teaches you everything you need to know about this graphical user interface. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle SQL is required.

You will start by learning about a basic SQL select statement, including how to retrieve data from a table, use mathematical and text expressions, and sort the results using column names. Steve will then show you how to restrict data, join tables, and summarize data. This video tutorial will also cover data subsets, restricting data, using subqueries, and data modeling. Other topics that are covered include creating tables and manipulating data, single-row functions, creating and using views, database management, and legacy SQL techniques.

Once you have completed this computer based training course, you will be able to use Oracle SQL as your main productivity tool for development. Working files are included, allowing you to follow along with the author throughout the lessons.

Course Outline

01. Introduction To Oracle SQL Introduction And About The Author What Is SQL? Relational Databases Explained - Part 1 Relational Databases Explained - Part 2 How To Query Data From A Database The Difference Between SQL And PL/SQL Setting Up An Oracle Apex Account Running SQL Using Oracle Apex Assignment 1 Assignment 1 - Solution 0111 How To Access Your Working Files 02. Basic SQL Select Statement Retrieving All Data From A Table Retrieving Some Data From A Table Restricting The Retrieval Of Rows From A Table Using Mathematical And Text Expressions Sorting The Results Using Column Names Assignment 2 Assignment 2 - Solution 03. Restricting Data - The Basics 0301 What Is A Primary Key? 0302 Comparison Operators 0303 Logical Operators 0304 Dealing With Null Values 0305 Sorting The Results Using Column Position 0306 Assignment 3 0307 Assignment 3 - Solution 04. Joining Tables - The Basics 0401 What Is A Foreign Key? 0402 Inner Joins With The Using Clause 0403 Joins With The On Clause 0404 Joins And The Order Of Processing 0405 Assignment 4 0406 Assignment 4 - Solution 05. Summarizing Data 0501 Aggregate Functions 0502 The Count Functions 0503 The Min And Max Functions 0504 The Avg And Sum Functions 0505 Concatenating Data 0506 Aggregates - Order Of Processing 0507 Assignment 5 0508 Assignment 5 - Solution 06. Joining Multiple Tables 0601 Many-To-Many Relationships - Part 1 0602 Many-To-Many Relationships - Part 2 0603 Join Multiple Tables With The Using Clause 0604 Join Multiple Tables With The On Clause 0605 Eliminating Duplicate Rows From The Results 0606 Sorting The Results Using Column Aliases 0607 Assignment 6 0608 Assignment 6 - Solution 07. Data Subsets 0701 Using The Group By Clause 0702 Using The Having Clause 0703 Having With Compound Conditions 0704 Assignment 7 0705 Assignment 7 - Solution 08. Restricting Data - Advanced Concepts 0801 Using The In Operator 0802 Using The Between Operator 0803 Using The Like Operator For Pattern Matching 0804 Outer Joins 0805 Assignment 8 0806 Assignment 8 - Solution 09. Using Subqueries - The Basics 0901 How Do Subqueries Work? 0902 Subqueries With The In Operator 0903 Subqueries Using A Comparison Operator 0904 Subqueries Vs. Joins 0905 Using A Subquery Vs. A Self-Join 0906 Assignment 9 0907 Assignment 9 - Solution 10. Data Modeling - The Basics 1001 How Data Is Organized In A Relational Database 1002 The Entity-Relationship Approach 1003 Normalization Guidelines - Part 1 1004 Normalization Guidelines - Part 2 1005 Assignment 10 1006 Assignment 10 - Solution 11. Creating Tables And Manipulating Data 1101 Creating Tables - Part 1 1102 Creating Tables - Part 2 1103 Specifying Keys 1104 The Check Constraint 1105 Creating Indexes 1106 Modifying And Removing Tables 1107 More Constraints 1108 Adding Data To A Table 1109 Changing Data In A Table - Part 1 1110 Changing Data In A Table - Part 2 1111 Removing Data From A Table 1112 Assignment 11 1113 Assignment 11 - Solution 12. Single-Row Functions 1201 String Functions - Part 1 1202 String Functions - Part 2 1203 Number Functions 1204 Date Functions 1205 Limiting Rows And The Dual Table 1206 Assignment 12 1207 Assignment 12 - Solution 13. Creating And Using Views 1301 Creating And Using Views 1302 Set Operators 1303 Assignment 13 1304 Assignment 13 - Solution 14. Database Management 1401 Transaction Management 1402 Concurrency Control 1403 Security Considerations 1404 Stored Procedures And Triggers 1405 Database Integrity 1406 Assignment 14 1407 Assignment 14 - Solution 15. Legacy SQL Techniques 1501 Implicit Joins 1502 Subqueries With Modifiers 1503 Subqueries Using The Exists Clause 1504 Assignment 15 1505 Assignment 15 - Solution 16. Conclusion 1601 Difference Between Oracle And Other SQLs 1602 SQL In A Programming Language 1603 Embedded SQL 1604 What Is Next?