Oracle 11g Introduction to SQL
Oracle 11g Introduction to SQL
Learning Oracle 11g Introduction to SQL is easy with instructor-led Video Training
If you're curious about the latest generation of Oracle and SQL, you're not alone. Oracle 11g offers over 500 new features that promise better automation, technical innovations, simplified solutions, and reduced administrative costs.
The self-paced Oracle 11g Introduction to SQL CBT is an excellent resource for a self-directed examination of the new SQL 11g features. This course covers a variety of topics including language functionality enhancements, executing dynamic SQL, performance improvement enhancements, language usability enhancements, coding trigger enhancements, data warehousing enhancements, and SQL Developer enhancements.
The Oracle 11g Introduction to SQL training CD is packed with high quality video segments featuring an expert instructor who helps you explore the Oracle and SQL environments. As you watch the Oracle 11g Introduction to SQL training videos, you'll get an up close view of the features in action and you'll learn exactly how to use them.
The self-paced Oracle 11g Introduction to SQL CBT blends the best of instructor-led training with the best of computer based training. End result: you learn from the best and reinforce your learning with hands-on practice.
Install the Oracle 11g Introduction to SQL training CD on your PC or laptop and enjoy 24/7 access to training videos, simulations, hands-on labs, and interactive content. The course covers many complex concepts. Instead of taking extensive notes as you would do in a regular class, you can simply re-watch any of the Oracle 11g Introduction to SQL training videos as often as you need. In addition, you can jump ahead to topics you need to understand now.
Traditional classes require a huge and regular time commitment. Unfortunately, many working professionals have heavy workloads that can't accommodate another commitment. Instead of juggling work and school, use the Oracle 11g Introduction to SQL training CD. With this delivery format, you are in charge of your studies. You set the time and date and you decide how long to devote to your learning. This format is flexible, convenient, interactive, and effective. You can learn about Oracle 11g and SQL even if you are short on time.
Oracle 11g Introduction to SQL Essential Training Video CBT Features:
Training Videos: An instructor introduces each learning module and gives you a preview of the topics that are covered. Instead of relying on reading written introductions, simply click on the video presentations for an interesting, informative summary of the concepts that you will be learning next. You will be learning these topics directly from an expert instructor who really knows the material.
Hands-On Labs: Interactive hands-on lab scenarios are included for you to practice your skills. In fact, you don't even need the software on your computer in order to receive this hands-on training. Simulations are critical to the learning process. By modeling a real system and letting you perform the same tasks you would perform on the real system, you are reinforcing your knowledge.
Player Controls: You can navigate freely with the player controls. You can play, pause, rewind, forward, and stop any video topic. The controls are familiar and easy to use. Simply click the control that matches the functions you want. If you are interrupted during your studies, click the pause button so that you won’t miss a single minute of the video training.
Course Map: Choosing which topic you want to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users can pick up where they left off. The course map allows you to pick and choose the topics that interest you and tailor the learning. You can even use it as a quick launch for reviewing specific topics.
Search Function: Find the topics you need instantly. Just type in the word that describes your topic and view the search results. Don't waste countless minutes trying to find something you need now. The Search function is fast, accurate, and easy to use. Relevant search results and fast hyperlinks will jump you to your desired topic in a blink of an eye.
Note Taking: Put away your notebook and pencil. Instead, jot down notes or questions for later reference by using the useful notepad feature. If an idea comes to mind or if you need to remind yourself of something important while studying, click on the notepad directly from the course interface and type out your thoughts without ever having to lift a pencil.
Bookmarking: Self-paced study is designed to take place over several sessions which makes bookmarking extremely useful. You can exit your training and quickly reference areas of study you wish to revisit later by using bookmarks. If you want to pay special attention to a particular topic, simply use the bookmark feature so that you can spend extra time mastering the concept.
Print: Do you need a hard copy? Sometimes, it’s just not practical to log on to your computer when you have a quick question or want to review. The print function lets you print out a hard copy for those times when you need to study offline. Anything that you see on the screen can be printed out for future reference.
Certificate of Completion: Each interactive course comes with a certificate of completion. After you have finished the course, you just type in your name and print. It's that simple. Get recognized of your accomplishments with our courses.
Multi-User Licensing: The best single and multi-user licensing agreement in the industry. Our licensing agreements accommodate individual students as well as companies with large training requirements. Single user licenses, single PCs licenses, multiple-user (non-concurrent) licenses, and unlimited corporate server site licenses are all available. This level of flexible licensing can’t be beat. No matter what you need, we have a license.
Fundamental of SQL
Lesson 1: Introduction
Lesson 2: Retrieving Data Using SQL Select Statements
Lesson 3: Restricting and Sorting Data
Lesson 4: Using Single-Row Functions to Customize Output
Lesson 5: Using Conversion Functions and Conditional Expressions
Lesson 6: Reporting Aggregated Data Using the Group Functions
Lesson 7: Displaying Data from Multiple Tables
Lesson 8: Using Subqueries to Solve Queries
Lesson 9: Using the Set Operators
Lesson 10: Manipulating Data
Lesson 11: Using DDL Statements to Create and Manage Tables
Lesson 12: Creating Other Schema Objects
Lesson 1: Controlling User Access
Lesson 2: Managing Schema Objects
Lesson 3: Managing Objects with Data Dictionary Views
Lesson 4: Manipulating Large Data Sets Managing
Lesson 5: Data in Different Time Zones
Lesson 6: Retrieving Data Using Subqueries
Lesson 7: Regular Expression Support
Specs and Support
Content: CD-ROM disc (sealed in a DVD-case)
Platform: Windows Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
Hard drive space: 10MB
CD-ROM Drive speed: 24X
Technical Support: firstname.lastname@example.org