Course Code: GES339
Lesson 1: Introduction to SQL: Relational Database Basics
Our first lesson is an SQL tutorial for beginners. We’ll go over a brief history of SQL, as well as relational databases, popular databases, and SQL statements.
Lesson 2: Simple SELECTs
Lesson 2 will introduce you to the Northwind database, including SELECTing all columns in all rows, exploring the tables, SELECTing specific columns, and sorting records. We’ll learn about the WHERE clause and operator symbols and words, checking for NULL, and writing SELECTs with multiple conditions.
Lesson 3: Advanced SELECTs
In this lesson we’ll learn about calculated fields and calculating fields, as well as working with aggregate functions. Lastly, we’ll move on to data manipulation functions, including built-in.
Lesson 4: Subqueries, Joins, and Unions
This lesson covers subqueries, joins, and unions, including outer joins and the specifics of working with unions.
Lesson 5: Advanced Oracle SQL Queries: Users and Schemas
This lesson provides an introduction to users and schemas, teaching you all about the HR schema and creating an application schema.
Lesson 6: Pseudo Columns & Functions
Here you’ll learn how to use the dual table, including its functions and an exercise on using the SYSCONTEXT function. Then you’ll discover how to use ROWID and ROWNUM.
Lesson 7: Using Subqueries
This lesson will cover simple subqueries, inline views, correlated subqueries, and scalar subqueries.
Lesson 8: Joining Tables
Next we’ll review joins, including equijoins and cross, reflexive, non-key, and natural joins. Then we’ll go over semijoins and antijoins and using named subqueries.
Lesson 9: Rollup & Cube
Lesson 9 will teach you all about group processing, including EMP_DETAILS_VIEW, simple GROUP BY, the ROLLUP function, the GROUPING function, and using CUBE.
Lesson 10: Using Set Operators
First we’ll define set operators, before learning about their relationship to mathematical set theory and the various restrictions placed on them.
Lesson 11: Conditional Processing
In our lesson on conditional processing, we’ll review the DECODE function and the case expression.
Lesson 12: SQL Functions (Character)
Lesson 12 will answer the question, “What are SQL functions?” Then we’ll review character functions and regular expressions.
Lesson 13: SQL Functions (Non-Character)
This lesson covers non-character SQL functions, such as numeric, date/time, date format, date arithmetic, and null value functions.
Lesson 14: SQL Data Manipulation Language
In this lesson, you’ll learn about INSERT, UPDATE, and DELETE statements, as well as transactions, complex table references, and the MERGE statement.
Lesson 15: Oracle PL/SQL Training: The Environment for PL/SQL Development
Now we’ll start learning about the PL/SQL extension to Oracle. This lesson reviews connecting to Oracle, executing PL/SQL code, SQL developer configuration, and the PL/SQL development cycle.
Lesson 16: PL/SQL Basics
In our second PL/SQL lesson, we’ll discuss two different block structures: anonymous and named blocks. Then we’ll review executing blocks, calling PL/SQL functions, and executing PL/SQL blocks and functions.
Lesson 17: Declaring Variables
This lesson reviews variable usage, data types, naming, and assignment. Then you’ll learn all about complex variable types, as well as variable declaration, initialization, and display.
Lesson 18: Within the Block
Next, you’ll discover conditional processing and iterative processing. We’ll go over salary classification using conditional statements and salary increases using loops.
Lesson 19: Handling Exceptions
In this lesson you’ll learn about exceptions, including causing, handling, and identifying them. Then we’ll learn about the OTHERS exception handler, user defined exceptions, and exception handling for invalid salary.
Lesson 20: Use of SQL in PL/SQL
In this lesson, we’ll review a variety of topics, including implicit cursors, %TYPE and %ROWTYPE attributes, the EXECUTE IMMEDIATE statement, attributes of implicit and explicit cursors, and the cursor FOR loop.
Lesson 21: Nested Blocks
This lesson will show you how to nest blocks, with topics like scope of variables, scope of exceptions, nested subprograms, and exception propagation in nested blocks. Lastly, you’ll learn about block variable visibility.
Lesson 22: Introducing Subprograms
This lesson will introduce you to subprograms, reviewing anonymous blocks, types of subprograms, and finding subprograms through SQL Developer and in the Oracle Data Dictionary. We’ll end with a lesson on object dependencies.
Lesson 23: Stored Procedures and Functions
Here you’ll learn how to create, modify, and remove subprograms. Then we’ll move on to application maintenance, parameters, and subprogram development techniques. The lesson addresses SQL errors in compilation, directives for debugging, issues with Booleans, integrated development environments, and PL/SQL subprograms with parameters.
Lesson 24: Packages
In this lesson, you’ll review the structure and purpose of packages, including wrap utility, positional versus named parameter notation, subprograms omitted from specifications, and using PL/SQL packages.
Lesson 25: Database Triggers
Next, you’ll learn about the purpose of triggers, and how to invoke, code, validate, modify, view, and enable/disable them. Then we’ll teach you about trigger errors, system and user event triggers, and the logon counter trigger.
Lesson 26: Data Retrieval Techniques
In our lesson on data retrieval techniques, we’ll go over cursor parameters, cursor variables, dynamic SQL, and employee reports by state/province.
Lesson 27: Using Oracle Supplied Packages
In this lesson you’ll learn how to identify available packages and package subprograms. Then we’ll review selected Oracle supplied package demos, packages related to input/output and networking, dynamic SQL, working with URLS, and DBMS_APPLICATION_INFO.
Lesson 28: Specialized Topics
The specialized topics in this lesson include application partitioning, subprograms in other languages, statistical analysis, data mining, and using Oracle object features.
Lesson 29: Java Introduction
In this lesson, we’ll review how to write a Java program, set up your Java environment, create a class that can run as a program, and use the Java documentation.
Lesson 30: Java Basics
Lesson 30 introduces you to basic Java syntax, data, and mathematics, and teaches you how to create and use methods.
Lesson 31: Java Objects
In our lesson on Java objects, we’ll review String, StringBuffer, and StringBuilder, plus creating documentation comments and using Javadoc.
Lesson 32: Comparisons & Flow Control Structures
Now we’ll learn about controlling program flow, including break and continue statements. Then we’ll review Classpath, code libraries, and JAR files.
Lesson 33: Arrays
Next up, you’ll discover all you need to know about arrays, including the for-each loop, multi-dimensional arrays, and typecasting with arrays of primitives.
Lesson 34: Inheritance
This lesson covers inheritance, polymorphism, and creating a derived class. Then we learn about typecasting with object references, other inheritance-related keywords, and methods inherited from objects.
Lesson 35: Interfaces
First, we’ll define interfaces, before learning how to create and implement one. Then we’ll go over reference variables and interfaces, interfaces and inheritance, and some uses for interfaces.
Lesson 36: Exceptions
In Lesson 36, we’ll attempt risky code with the try and catch blocks, and guarantee execution of code with the finally block. Then we’ll learn about throwing and re-throwing an exception, exceptions and inheritance, creating and using your own exception classes, and initializer blocks.
Lesson 37: Generics and Collections
This lesson first reviews the fundamental collections: sets, lists, and maps. Then you’ll learn about iterators, creating collectible classes, and generics.
Lesson 38: Inner Classes
In our last lesson before your final exam and project, you’ll discover inner classes, also called nested classes. These are useful for grouping classes to make your package more streamlined, and making code more readable and maintainable.
Roger Sakowski has over 35 years of experience in technical training, programming, data management, network administration, and technical writing for companies such as NASA, Sun Microsystems, Bell Labs, GTE, GE, and Lucent, among other Fortune 100 companies. Roger has been an instructor for Webucator for six years and previously trained for other prominent technical training companies.
None, though some prior programming language knowledge is helpful.
Oracle This program can be taken only on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. NOTE: Dual monitors are helpful but NOT required. I. Oracle Database 10g/11g You need to have full administrative access to Oracle 10g or 11g. If you do not, you can use Oracle 11g Express Edition: 1. Download Oracle Database Express Edition for either 32 or 64 bit OS: http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html?ssSourceSiteId=ocomen. Note: you will need to register for a free account to gain access to the download. 2. Execute the file you downloaded by double-clicking on the folder and then double-clicking on Setup.exe. 3. Run through the Installer accepting all the defaults. Make your password system (all lowercase). Make sure to write down and keep your password. NOTE: For any IT Department personnel who are setting up a work computer for a student: o This class requires the use of the Oracle supplied HR demo schema, with the permissions and objects in the state in which Oracle created them. The HR schema is created by default during an install but is not always unlocked. Please unlock the schema, assigning a password. Please make sure the student has the password. If you will be using a work laptop at home, then install Oracle at home. If your IT department is installing it at work, make sure they disconnect from both the internet and the intranet before launching the install. The safest way to do this is to remove the ethernet connection from your laptop and turn off your wireless connection II. Oracle Client Options 1. Install Oracle SQL Developer 1. If you are on a Windows 32 bit platform click here. Download "Windows 32-bit - zip file includes the JDK1.6.0_35". 2. For Windows 64 bit and other platforms, click here. NOTE: For Windows 64 bit platforms download "Windows 64-bit - zip file includes the JDK 7". 2. Create a folder called sqldeveloper in the Oracle folder located on c: and then extract the sqldeveloper.zip to that sqldeveloper folder you just created. 3. Within that folder, open the sqldeveloper folder 4. Double-click sqldeveloper.exe to start SQL Developer III. Class Files 1. Download the class files. 2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily. 1. On Windows it is recommended the new folder have a path of C:\Webucator.* 2. Extract the files to the folder you just created. * If you are using XAMPP (e.g, for PHP classes), you must place the Webucator folder on the C:\xampp\htdocs folder. IV. Unlocking the HR Account 1. In SQL Developer, log in using this connection 1. Connection name: system 2. Username: system 3. Password: system (This should be the password you created when you installed Oracle) 2. Open the HR_Unlock_Account.sql file from your class files. 3. Click on the second green play button(F5) to execute the sql query. 4. To continue setup, click on the green + under the Connections tab, and add the criteria below: 1. Connection Name: hr 2. Username: hr 3. Password: hr 4. Click on Connect. A worksheet should open up on a tab that's labeled "hr". 5. Now that you're connected to HR, you're ready to test. 1. Enter the following in the worksheet: select * from regions; 2. Click on the "green arrow" to execute your code. 3. If you get back 2 columns and 4 rows then you are all Java This program can only be taken on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. I. Java Development Kit (JDK) Java SE Development Kit (JDK) 8 - Download Note: You do not need to download the bundles that include JavaFC, Java EE, or Netbeans. You only need the JDK that includes the JRE and command-line development tools. After installation, the files will be located on the C drive, usually at C:\Program Files\Java\jdk1x II. Java SE 8..0 API Documentation Download III. Java Runtime Environment (JRE) Java SE Runtime Environment (JRE) 8 Update XX - Download IV. Java Editors / IDEs Windows Option 1: Crimson Editor Note: Crimson Editor is probably the best option unless you have a specific reason for using the Eclipse Integrated Development Environment (IDE) listed below. 1. Go to http://www.crimsoneditor.com. 2. Choose the option for Download from the left-hand navigation menu. 3. Choose the most recent release from one of the download mirrors. 4. Execute the file you just downloaded by double-clicking on it. 1. Read the License Agreement and click on the button labeled I Agree. 2. When asked what components to install, you can leave the default settings. 3. Install Location can be left as default. 4. When the install finishes, click the button labeled Close. Option 2: Eclipse Integrated Development Environment (IDE) Note: Use of the Eclipse integrated development environment is optional for this class at the discretion of the instructor. 1. Go to http://www.eclipse.org/downloads. 2. Choose the option Eclipse IDE for Java Developers. This downloads a zip file. 1. For basic Java classes, we use Eclipse IDE for Java Developers, which does not include Java EE capabilities such as Servlets and JSPs. 2. For Java EE classes, download Eclipse IDE for Java EE Developers. 3. Unzip/Extract the downloaded file to C:\. The installation is a simple unzip to C:\ (Eclipse does not "install" - you run it directly from eclipse.exe, which will be in C:\eclipse after the unzip).
Our SQL class is designed with the beginner in mind. In the SQL portion, you’ll learn how to build applications or generate business reports, master SQL using an Oracle database, and learn PL/SQL extension language to write sophisticated queries against an Oracle database.
The Java programming portion covers most Java syntax elements, concentrating on fundamental and universally useful elements. Early in the course the concept of objects is introduced so that later concepts can be discussed from the perspective of object orientation. You will learn to write useful Java classes, apply object-oriented concepts such as inheritance, and create Java programs that work with these classes.
Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.
All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. When you register, you’ll receive twelve (12) months to complete the program.
The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee may be charged for an extension.
ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.
Upon successful completion of the program, you will be awarded a certificate of completion.
ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don’t provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.
Each student is paired with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.
In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don’t have to use the same computer to log-in to the program every time. We recommend that you have a word-processing program (Microsoft Word is the best) and the latest version of Internet Explorer.
If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button above). If you are visiting us during non-business hours, please feel free to send us a question using the “Contact Us” form to the right. You may also call us at 1-877-221-51511-877-221-5151 FREE. We will answer your questions promptly.
Our programs are all open enrollment. You can register and start the program as soon as you are ready.
Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.
This program does not prepare you for a certification but prepares you to enter the job market as an entry-Oracle SQL and/or Java Developer.
This program can be taken only on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. Dual monitors are helpful but not required. You will also need a working email account and a word-processing program—we recommend Microsoft Word.
You need to have full administrative access to Oracle 10g or 11g. If you do not, you can download the Oracle Database Express Edition for either 32- or 64-bit OS here. You will need to register for a free account to gain access to the download.
You will also need to install Oracle SQL Developer for either Windows 32- or 64-bit platforms. Download "Windows 32-bit - zip file includes the JDK1.6.0_35" here, or download " Windows 64-bit with JDK 8 included" here.
Download the class files here. Create a directory on your hard drive named "Webucator" that can be found easily and extract the files to the folder you just created. If you are using XAMPP (e.g., for PHP classes), you must place the Webucator folder on the C:\xampp\htdocs folder.
Unlock the HR account using the following steps:
Download the Java SE Development Kit (JDK) 8, Java SE 8.0 API Documentation, and Java SE Runtime Environment (JRE) 8 Update XX here. You do not need to download the bundles that include JavaFC, Java EE, or Netbeans. You only need the JDK that includes the JRE and command-line development tools. After installation, the files will be located on the C drive, usually at C:\Program Files\Java\jdk1x.
Download your Java editors/IDEs for Windows:
Option 1: Crimson Editor is probably the best option unless you have a specific reason for using the Eclipse Integrated Development Environment (IDE) listed below.
Option 2: Eclipse Integrated Development Environment (IDE), which is optional for this class at the discretion of the instructor.