Spring2017CEWD

23 / 60

SPRING 2017 • • 301.624.2888 21
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.
In this course, you’ll learn about the basic structure of relational databases and
how to read and write simple and complex SQL statements and advanced data
manipulation techniques. First, you’ll learn about the traditional database structure,
the structure and history of the relational database, and what structured query
language (SQL) is and how it relates to the relational-database structure. Next, you’ll
discover how to use SQL to sort and retrieve data from tables and how to use SQL
to filter retrieved data. You’ll learn how to reformat retrieved data with calculated
fields and how to merge columns and create alternate names for columns. You’ll
also learn how to gather significant statistics from data using aggregate functions,
and you’ll see how to extract data from multiple tables simultaneously using joins
and subqueries. In addition, you’ll learn how to manipulate data using the INSERT,
UPDATE, and DELETE statements. We’ll also cover how to use SQL to create and
maintain tables, and you’ll learn how to create and use views to simplify complex
queries, summarize data, and manipulate data stored in tables. You’ll discover how
transaction processing, constraints, and indexes are implemented in SQL. And finally,
you’ll discover how stored procedures, triggers, and cursors are implemented in SQL.
By the end of this course, you’ll have a solid working knowledge of structured query
language. You’ll feel confident in your ability to write SQL queries to create tables;
retrieve data from single or multiple tables; delete, insert, and update data in a
database; and gather significant statistics from data stored in a database.
ONL140 | 24 hours | $149 fee
INSTRUCTOR: CE Instructor
3212 Online 1/18–2/24
3213 Online 2/15–3/24
3214 Online 3/15–4/21
3216 Online 4/12–5/19
3218 Online 5/17–6/23
Introduction to C# Programming
Learn the fundamentals of computer programming with C#, the in-demand and
incredibly useful programming language that incorporates the best features of
Visual Basic, C++, and Java. You’ll first develop your understanding of programming
fundamentals: input/output operations, decision making, and looping. Then, we’ll
explore the many benefits of object oriented programming, with plenty of vivid,
real-life examples. Then, you’ll gain hands-on experience with sequential data
files, and you’ll be able to build a professional-looking and intuitive Graphical User
Interface (GUI) application on your very own computer. Because there is no better
way to learn programming than hands-on practice, almost every lesson includes
practical examples and assignments you can use to develop your knowledge of
programming. Learn to program the right way: by using a state-of-the-art language
to build impressive applications on your schedule and on your very own computer.
ONL183 | 24 hours | $149 fee
INSTRUCTOR: CE Instructor
3198 Online 1/18–2/24
3199 Online 2/15–3/24
3200 Online 3/15–4/21
3201 Online 4/12–5/19
3202 Online 5/17–6/23
COMPUTERS &TECHNOLOGY
Introduction to Java Programming
If you want to learn computer programming but don’t have any prior experience,
you’ll enjoy a tour of Java, one of the most widely used computer languages in the
world. It’s a breeze to learn in a friendly and supportive environment. Start with the
basics of programming and go on to write your own programs and integrate input
and output, calculations, decision making, and loops. Build your knowledge and
confidence with easy-to-understand examples and plenty of skill-building exercises.
So whether you just want to try it out to see if you like it or plan on doing more with
Java, this is a great place to start! We’ll use the latest release of Java, from Oracle, the
company that maintains and supports the language. We’ll also use BlueJ, a graphical
development environment designed especially for students. Both are free open-
source products, and I’ll give you the proper instructions to download them. By the
time we’re done, you’ll be comfortable with Java programming and ready for more!
ONL184 | 24 hours | $149 fee
INSTRUCTOR: CE Instructor
3203 Online 1/18–2/24
3204 Online 2/15–3/24
3205 Online 3/15–4/21
3206 Online 4/12–5/19
3208 Online 5/17–6/23
WEBSITE DEVELOPMENT
WordPress, Level I
This introductory hands-on course will focus on what WordPress is, what it can do,
and how to use it for a blog, a website, or both. Students will work on WordPress site
provided for them for use during the class. This class is perfect for staff responsible
for a company WordPress website or blog.
Note: Prerequisite: Computer and web browser proficiency.
INT171 | 5 hours | $149 fee
INSTRUCTOR: Jeannine Morber
3139 S 9am - 2pm 3/11 FCC/H260
WordPress, Level II
Learn to add more functionality to their WordPress website and blog by installing
and configuring WordPress plugins. Students will also learn to change the look of
the website by installing and configuring a new theme. This is a hands-on workshop
where students will work on WordPress sites provided for them to use during class.
Note: Prerequisite: WordPress Level One or permission of the instructor.
INT174 | 6.5 hours | $199 fee
INSTRUCTOR: Jeannine Morber
3515 S 9am - 4pm 3/18 FCC/H260
WordPress, Level III
Explore more advanced plugins and features of WordPress such as search engine
optimization, website backup, spam filters, and login in tracking and security
plugins. This is a hands-on workshop where students will work on WordPress sites
provided for them to use during class.
Note: Prerequisite: WordPress Level Two or permission of the instructor.
INT173 | 6.5 hours | $199 fee
INSTRUCTOR: Jeannine Morber
3142 S 9am - 4pm 3/25 FCC/H260
ONL Note: There are multiple sections available for this course. Please ensure
the one for which you are registering is the date you want. Access information
will be sent 24-48 hours before class start date.