Database Management and Programming Online Classes
Introduction to Access, 2010
Take control over your data! Whether you're a novice or an experienced database user, this course will show you how to harness the full power of Microsoft Access 2010.
Introduction to Access, 2007
Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important business, personal, or scientific data. You'll gain practical, hands-on experience with tables, relationships, custom data entry forms, queries, mailing labels, macros, and more. Increase productivity, reduce data entry errors, conduct comprehensive searches, and produce handsome and professionally formatted reports.
Intermediate Access 2007
Take your Microsoft Access 2007 skills to new heights! In this course, you'll learn the tools and techniques you need to create user-friendly Access 2007 databases. We'll work with multiple tables, one-to-many forms and reports, macros, and much more.
Introduction to Crystal Reports 10
Learn how to use Crystal Reports to convert raw database or accounting data into meaningful and readable reports. Impress your peers, clients, and superiors by discovering new ways to convey information. By the time you finish this course, you'll be able to create a wide variety of handsome and sophisticated reports that communicate more--much more--than mere facts. You'll also be able to use charts and maps to present information visually, and cross-tabs to show correlations between loosely related data items. You'll even find out how to save yourself time and effort by creating a library of custom functions you can use over and over in report after report.
C++ for the Absolute Beginner
Learn how to program in C++, even if you have no prior programming experience! Create programs for Microsoft Windows using Borland C++ Builder. Learn Object-Oriented techniques, how to create windows and forms, and how to program in a step-by-step nature. This course is ideal whether you're an enthusiast, a business person hoping to advance your career, or someone who already knows how to program but wants to move ahead to C++ and Object-Oriented Programming.
Introduction to C# Programming
Learn the fundamentals of computer programming with the hot new C# programming language. You'll begin with an exploration of input/output operations, decision making, looping, and object oriented programming principles. Then, you'll gain hands-on experience using sequential data files, and you'll build your very own Graphical User Interface (GUI) application. Learn to program the right way: by using a state-of-the-art language to build impressive and professional-looking applications on your schedule and on your very own computer.
Intermediate C# Programming
Build upon your current knowledge of programming logic by writing Graphical User Interface applications in the C# programming language. Learn how to write applications with menus, toolbars, and files, and find out how to interact with databases and write SQL queries.
Introduction to Database Development
A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.
Introduction to Java
If you want to learn Java but don't have any prior programming knowledge, you'll enjoy this course. Explore this exciting new language in a friendly and supportive environment. Build up your confidence with easy-to-understand examples and plenty of skill-building exercises.
Introduction to Oracle
Learn how to use the Oracle database management system to plan, organize, and manage your data. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database. You will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database.
Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, and you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing.
Introduction to Perl Programming
Learn Perl, a powerful and easy-to-use scripting language used on PCs, servers, and on the Internet for a wide range of programming problems. Perl is as capable - and often as fast - as C, C++, and Java, but is easier to learn and does not require the sort of software development tools and environments required by those languages. Perl is also more portable and supported on a greater variety of computers than many other computing languages. Perl programming skills are especially valuable for Web developers, software developers, and system administrators.
Introduction to PHP and MySQL
Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your site's visitors. You'll see how to use the PHP programming language to generate dynamic Web sites that automatically change as your data changes. You'll also learn how to use the popular MySQL database server with PHP to store and retrieve data over the Web.
Intermediate PHP & MySQL
Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. In this six-week online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.
Python 2.5 Programming, Introduction
The Python programming language was developed with the idea that programmers should have a way to develop code that's easy to create and understand. While Python contains the same basic structures of other languages, it also offers unique functionality that makes the programmer's life easier.
This course will show you how to create basic programming structures like decisions and loops. After that, we'll move on to object-oriented techniques with classes and exceptions. You'll also learn how to use some unique Python data structures like tuples and dictionaries. You'll even learn how to create graphical elements from simple squares and circles to graphical user interface objects like buttons and labels.
By the end of the course, you'll have the foundational knowledge you need to create a variety of Python files, whether they be short scripts, full programs, or graphical user interfaces.
Introduction to Ruby Programming
Learn how to create an interactive Web blog that allows visitors to register and post articles and comments. You'll see how the popular Ruby on Rails framework environment creates much of the code for you, and how to use the Ruby programming language to modify the code to customize your Web site. The blog we'll create also uses the popular MySQL database server to store the blog data that appears on the site, and it provides a search feature to allow visitors to easily search past blog entries.
Introduction to SQL
Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language. You'll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.