Orange Coast Databases Blog

We have several Microsoft Access courses based on the courseware from Logical Operations. We are lowering the prices on the base courses at this time. There is a 20% discount for small groups.

• AIN100A - Level 1 - 1 day - basics - $165 per student.
• AIN100B - Level 2 - 1 day - more on forms and reports - $165 per student
• AIN100 - Discount package. Both levels 1 and 2. - $295 per student

Tags: access, microsoft

After a COVID-19 hiatus we are picking up our course offerings again. This time with an on-line orientation. We closed our training facility in San Juan Capistrano due to the pandemic and will probably not re-open it. We will still go onsite to teach a class if desired but we can also conduct them on-line via Zoom. Many have found this more convenient and accessible for a small group or for tutoring. Without the overhead of a training facility we should also be able to lower our prices and that we will be doing over the next weeks.

Tags: online, training facility

We just added a new short coursed - LCD201DS - Database Diagramming with Lucidchart. Lucidchart is a web based drawing tool with much of the functionality of Visio. Our short course focuses on the database diagramming aspects. It is becoming popular these days as a quick way to diagram a database and  share the results.  In this class we will show you how to create an Entity Relationship Diagram (ERD). We will cover all the relationship types from 1 to to 1 through many-to-many and even sub-types.  Learn more at LCD201DS...

Tags: database design, database diagramming, entity relationship diagram, erd, lucidchart

We recently added a new database diagramming course. It shows how to create an ERD (Entity Relationship Diagram) in Visio. It is a short course - only three hours so you can take it in a morning or afternoon. The newer versions of Visio do not have the database development capabilities that older versions did but they are still great tools for illustrating a design. And the new versions are rather elegant in the way they operate. Below is the link to the course description.

VIS201DS Visio Database Diagramming

Tags: database design, database diagramming, erd, relational database

We are now teaching Python Coding. We have a 5 hour introductory class that gives an overview of coding concepts using Python. Python is a simple, yet very powerful scripting language that is becoming a big player in the emerging big data and data science fields. This course parallels our similar course using Java. We are going to run classes during the week and on Saturday. Our d2associates blog has more posts on Python including screenshots.

Tags: big data, data science, python

We just updated our catalog. There are a couple of new database design courses and several others. You can download the catalog from the following link...

Download Catalog 

Regards,

Dan D'Urso

Product Director

Tags: catalog ocdatabases

I ran across a wonderful site for experimanting with JavaScript and HTML - jsfiddle.net. It opens up a window with four panes, one to display the output, the other three are an HTML pane a JavaScript pane and a CSS pane. You don't need complete HTML pages, just a fragment. You click run or CTRL Enter and it displays the output in the output pane. You can save the scripts you have created as what they call a fiddle. There is a dashboard that allows you to select one of your prior fiddles and work on that or create a new fiddle. It's a great tool for experimenting.

Have fun!

---Dan

Tags: jsfiddle javascript css html

We are expanding our database design curriculum based on materials from Logical Operations. To date we have mostly based our database design courses on the college text by David Kroenke. Both of the courses below are one day.

One course is based on MySQL.

Relational Database Design with MySQL
In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying the relational database design techniques taught in this course. MySQL will be used for implementation and is the basis for the manual. However, another database can be substituted upon request as much of the course content is not specific to any particular database. Visio or equivalent design tools may be used for design.

Another course uses Microsoft Access

Relational Database Design - A Practical Approach
Covers the general principles involved in designing a database that complies with the relational database model. The conceptual content of this course is not specific to any software application but Microsoft Access will be used to perform the tasks in the lessons pertaining to queries. Visio or an equivalent modeling tool may be used for diagramming exercises. With advance notice other databases and/or...

Tags: database design, microsoft access, mysql, relational databases

We added a new course that teaches the fundamentals of using a PC. This version is based on Windows 7 since most of our studio desktops are Windows 7.  Future versions will add
Windows 10.  This course could be good for someone who needs a little background training before going on with Microsoft Office training. It is being rolled out in conjunction with our revised Passport program so it can be taken without really paying any additonal tuition.

---Dan D'Urso

949-489-1472

Tags: pc, windows

We are adding a new series of low-cost courses to be offered in our San Juan Capistrano studio. They will be aimed at absolute beginners. We have found that many beginning students are not actually beginners. They just have not taken formal training and have questions on the finer points of Excel. This interferes with the learning of students who are truly new to Excel and just need to learn how to use spreadsheets. So we have decided to implement a new series for the absolute beginner. It will use the same lab manual but the more advanced material will be skipped in favor of more extensive treatment of the fundamentals. If you are looking for a review at the basic level then our current Excel Basics class is just right.

We will extend this same thinking to PowerPoint and other Microsoft Office courses over time. The absolute beginner classes will all be 5 hours in length, a bit less than our standard 6 hours, and cost only $140.

Tags: excel