Access 2010 Level 2: Accessing the Possibilities |
THIS CLASS WILL COVER BOTH ACCESS 2007 AND 2010.
Learn the fundamentals of Access as you work with tables, queries, reports, forms and macros. Build your own personal contact management system in class, beginning with table creation, look up wizards and data value intelligence, and then to create command buttons and menus. Fieldwork is assigned to ensure you master the material. Learn to build relational databases and avoid potential pitfalls to using Access. |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
ACCESS2010-LVL2 (04JUN2013)
Learn More... |
Jun 4, 2013 |
Jun 18, 2013 |
Briarcliff Campus |
$525.00 |
Greg Creech
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
ACCESS2010-LVL2 (01AUG2013)
Learn More... |
Aug 1, 2013 |
Aug 15, 2013 |
Briarcliff Campus |
$525.00 |
Greg Creech
|
Register |
MYSQL |
MySQL is the world's most popular open-source DBMS and, along with Php, is the backbone of social media platforms such as Facebook, WordPress, Joomla and Drupal. This course covers the basics of installing MySQL using WAMP, critical database concepts of Normalization, Joins, table construction, storing, retrieving, filtering and updating data with heavy emphasis on the SQL language. Students will learn numerous functions for statistical analysis and manipulation of numeric, character and date data. Lastly, this 3-day course will explore the phpMyAdmin GUI giving students familiarity with virtually every web-host's cPanel interface to develop their own online data for their Capstone project. (It is suggested that developers take this course before attending Php Level 1 Programming, if scheduling permits.)
CLICK HERE FOR REQUIRED BOOK
|
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
MYSQL (15JUL2013)
Learn More... |
Jul 15, 2013 |
Jul 19, 2013 |
Briarcliff Campus |
$915.00 |
Doc Roberts
|
Register |
SQL Level 1: Introduction to SQL |
SQL is a ‘must know’ technology for anyone in the IT industry! Use SQL to create queries that extract and manipulate information from relational databases. Learn to create expressions that calculate and summarize information and search, filter and sort your data. SQL can be used with almost all relational databases such as Microsoft Access, Microsoft SQL Server and Oracle, as well as business applications such as Crystal Reports, Business Objects and many more.
In this fun and informative class you will learn how to use over 30 different SQL clauses and functions and leave with a good working knowledge and understanding of the SQL language.
CLICK HERE FOR REQUIRED BOOK
|
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
SQL-LVL1 (10JUN2013)
Learn More... |
Jun 10, 2013 |
Jun 11, 2013 |
Briarcliff Campus |
$685.00 |
Paul Dunlop
|
Register |
| Section |
Start Date |
End Date |
Campus |
Tuition |
Instructor |
Action |
|---|
SQL-LVL1 (26AUG2013)
Learn More... |
Aug 26, 2013 |
Aug 27, 2013 |
Briarcliff Campus |
$685.00 |
Paul Dunlop
|
Register |
Access 2010 Level 1: Introduction |
| You have worked with Microsoft Access 2007(or earlier) and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course you will be introduced to the new features available in Microsoft Office Access 2010. Using the new and enhanced features in Access, you will be able to create a highly functional database. Knowing the tools that allow you to accomplish these operations will greatly expand your Access capabilities. The textbook for this class is provided. |
| Inquire |
SQL Level 2: Intermediate |
Take your SQL skills to the next level by learning how to do more work with SQL inside the database before pushing data across the network to your applications. This class takes a time efficient ‘problem / solution/ discussion’ approach and covers the topics that are important to today’s SQL developers.
This class teaches you how to use window functions, pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set. Also covered is the topic of ‘bucketization’, how to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques.
CLICK HERE FOR REQUIRED BOOK |
| Inquire |
