February 2018 Digital Tech Newsletter


Database Management Certificate

The Database Management Certificate is a 32-unit program designed for information technology professionals who would like to become involved in the development and support of database management systems. The Certificate provides training in creating and maintaining databases based on fundamentals of relational database, and Structured Query Language (SQL). Additionally, the certificate includes courses in Microsoft SQL Server administration and reporting services.

Required Courses:


Instructor Interview

This month we interviewed our instructor, Ray Han. Ray teaches a number of courses here at UCLA Extension; including Introduction to SQL, Relational Database Management, and Advanced Database Management Concepts.

UCLAx: Please tell us about yourself and how you got to where you currently are in your career?

Ray: I was born in the US. My dad was an aerospace scientist, and my mom was an elementary school teacher. I went to Yale for undergrad and studied applied math and computer science and I went to grad school in systems engineering at Stanford. I have also studied at Tsinghua, Peking, and Renmin Universities in China. I have worked at Honeywell, Oracle, and Arthur Andersen (Accenture). I can say I worked pretty hard but there were some lucky breaks along the line. The key is to never quit. Expect good things to happen if you try hard.

UCLAx: Is there anything you are currently working on that you would like to share with us?

Ray: I am on the board of three startups. One of them Law Totem is already making money. In this role, I helped them with building training software for lawyers preparing for the bar exam in China. Outside of my involvement in the startup world, my focus is now on helping UCLA students connect, and I think the Silicon Beach Innovation Lab is a great way for people to connect and get more involved in STEM fields and the larger tech world.

UCLAx: Could you tell us about your course “Relational Database Management” and what students can expect to take away from it? 

Ray: Notice that this class is called Relational Database Management and not Intro to Databases. By the end of class, the students should be able to understand relational databases i.e. MS Access, MySQL, SQL Server, and Oracle pretty well. The class moves quickly so I would say by the end of the class the student should be good enough to be ready for an intro job in the field. In the final project, we design an actual RDBMS. We cover ER diagraming, normalization, and SQL in depth. We learn Access and touch upon SQL Server and Oracle.

UCLAx: What advice can you give to our students trying to break into the Database Management field?

Ray: Start small then move up. If you are entirely new to the field try smaller databases and easier books. Try learning the small personal database Access first. We do this in my class. We then move to MS SQL Server and then to Oracle. I would start with an easy book. We use the lightweight book by Kroenke then build up to a more advanced book Silberschatz. Also, try to have friends in the class and in the field. Almost every CS person has some knowledge of databases. The small PC database MS Access comes with MS Office. Instead of using forms, etc., actually do the SQL. Also, it would be great if you could use Apporto, which allows you to work with SQL Server and Management Studio. In our class, the student gets access to Apporto and they can work with many sample databases which can be attached. Nothing beats hands-on experience. So play around with Access and Apporto.


Spring Course Preview

Relational Database Management

Understanding client-relational database design is vital to system design and implementation. Learn relational database technology, data modeling, SQL, data normalization, and the translation of logical designs to physical storage structures. Additional topics include indexes; storage management; transactions; database integrity; concurrency control; recovery; client/server relational database management; and introduction to query optimization.

Spring availability:
Online from 4/4/18 – 6/6/18 with Ronald Landers, ID# 359662
In-person from 4/4/18 – 6/6/18 with Ray Han in Woodland Hills, ID# 359677
In-person from 4/5/19 – 6/7/18 with Mickey Pujji in Westwood, ID# 359666


Advanced Database Management Concepts

Designed for individuals with a basic understanding of data modeling, logical database design, and relational database management systems, this course introduces important considerations in database application development and various technologies that, when combined with recent developments in relational database technology, have made possible database publishing on the Internet. Topics include review of EER modeling, object-oriented concepts and modeling, introduction to data warehousing, client/server and Internet database environments, introduction to OLAP, enterprise database application development, distributed and object-oriented database processing, and an introduction to Sun Microsystems J2EE and Enterprise JavaBean (EJB) technologies.

Spring availability:
Online from 4/2/18 – 6/4/18 with Ray Han, ID# 359679


Network Communication with TCP/IP

Learn network communications, from the basics of network topologies, OSI layering, and Ethernet to networking hardware and packet-switching fundamentals. The course focuses on TCP/IP and its plethora of protocols and services. Topics also include IP addressing, routing, switching, reliable data transfer, and congestion management. Students study many TCP/IP services, including DNS, DHCP, and VPN. Instruction also reviews network security as well as application layer protocols (such as HTTP, FTP, and email) and client/server network applications. The course provides hands-on examples using Windows, Linux, and Solaris. Students also learn how networks and TCP/IP work, and how to work TCP/IP.

Spring availability:
Online from 4/2/18 – 6/4/18 with Irfan Ahmed, ID# 359681
In-person from 4/5/18 – 6/7/18 with Fred Zerez, ID# 359680



-Spring enrollment will open on February 5. Spring quarter beings the week of April 2, 2018.

Save up to 10% during early enrollment with code EARLY*

*Discount code available on most courses at least 30 days before course start date. Discounts cannot be combined. Code is case sensitive.

-You can follow us on Facebook @UCLAxDigitalTech or connect with us on LinkedIn @UCLAx Digital Technology.

January 2018 Digital Tech Newsletter


Applications Programming Certificate

This 32-unit certificate program is designed to provide training in developing software applications. Students who complete this certificate will be able to develop software applications based on user requirements specifications. Students will learn to develop software code in high-level languages such as C#, Java, and others. They will be able to test, debug and execute their programs on a variety of computer platforms and operating systems. Emphasis is given to the use of object-oriented methodology in developing software applications. This program meets I-20/F1 Visa requirements and is VA approved.

Required Courses:

  • Java Programming I
  • Website Development with Adobe Software, Photoshop, Dreamweaver, and Animate
  • Introduction to SQL
  • Programming in C# For Visual Studio .NET Platform I
  • Programming in C# For Visual Studio .NET Platform II
  • Three elective courses


Instructor Interview:

This month we interviewed our newest instructor, Joshua Cook. Joshua has a Master’s in Computer Science from Georgia Institute of Technology and a Master’s in Education from UCLA. We are really excited to have him join our Digital Technology team.

UCLA Extension: Please tell us about yourself and how you got to where you currently are in your career?

Joshua: I have been in academia on one side of the desk or the other for most of my life. I love teaching and learning (and often learn more as a teacher then I do as a student). One of the things that really excites me about data science and machine learning is that it is so research oriented even when being applied to a real-world application.


I have been programming since I was a kid. I got my first computer, a Commodore Vic 20, in 1982! I really started my transition into data science, though, when I was teaching high school. I learned to code in Perl and wrote test generation software to use in my class. When I stopped teaching high school, I went back to school and got a degree in applied math. At this time, the data science boom was already underway so I was able to take a lot of classes in numerical python and scientific computing. About the same time, I discovered Jupyter notebooks. After school, I worked for a variety of startups and was able to develop a handful of machine learning models that are still in production. Last year, I returned to the classroom, this time as a data science instructor at General Assembly in Santa Monica.


All of that brings me to teaching the Data Science Intensive here at UCLA Extension. As a Bruin, I am very excited to be returning to UCLA as an instructor and hope to grow my data science practice by helping students begin and develop their own.

UCLA Extension: Is there anything you are currently working on that you would like to share with us?

Joshua: Last year, I published my first book, Docker for Data Science (Apress, 2017, https://www.apress.com/us/book/9781484230114). I really enjoyed the writing process and digging into a topic to develop a deeper discussion. I am currently working on my second book, Introduction to Linear Algebra with Python. I am excited to be working on this, not only because I really enjoy the writing process, but also because I have a great passion for the subject of linear algebra and especially its applications in machine learning and data science.

UCLA Extension: What excites you about this field?

Joshua: I love the combination of theory and practice that is data science. I love being able to dig deeper into the theory of a particular method, but that there is always a practical application to what I am learning in the end.

I also love the power of the techniques we are applying. Lately, I have been working with a technique called latent semantic analysis (LSA). LSA is a natural language processing technique that allows you to find hidden patterns in a large body of text information. For example, you could use this technique on all the tweets sent from the UCLA campus last week and start to develop an understanding of what Bruins were talking about. I just think it is so cool that you can apply mathematical modeling to something as open and unstructured as text data and learn things that are useful and understandable even to someone without an expertise in the field!

UCLA Extension: What advice can you give to our students trying to break into the data science field?

Joshua: Three things:

1) Stay curious and keep learning. This is a field defined by change. The ability to adapt can be almost as important as learning to understand the different models.
2) Never underestimate the linear model. With all of the fancy talk about neural networks and boosted decision trees, remember that regression is still incredibly useful and powerful.
3) There is always an open door for the passionate and motivated, but it might not look like what you expect it to. What I mean by this is, don’t hold out for what you think is the perfect data science job. Get your foot in the door and let your passion and enthusiasm for data science carry you to where you want to be.


Spring Course Preview:


Anyone who does web work needs to understand HTML (Hypertext Markup Language) and CSS (Cascading Style Sheets). Together they provide the foundation on which web pages are built. HTML labels types of information and CSS specifies how that information will look. Using step-by-step code writing exercises, students learn how HTML and CSS work together to create responsive web pages, starting with the very basics up to the intermediate level. Topics include HTML5 tags and elements, links, forms, lists, images, and color. Also covered are page layout, properties, selectors, CSS3, media queries, menus, the box-model, specificity, the cascade, pseudo elements and classes, adding video, animation, JavaScript, and jQuery, as well as site deployment. Free software is used and there are no prerequisites. (Offered online from 4/4/18 – 6/6/18 with Gideon Arom, ID#359707; or in-person from 4/5/18 – 6/7/18 with Dan Vaughan, ID# 360113)



Web users today expect sites to provide dynamic user interfaces, fast response times, and advanced features. JavaScript delivers these features, which is why JavaScript has become such an important programming language for web developers. This course benefits anyone who is involved with web development, including server-side programmers who use ASP, JSP, PHP, or other languages, and web designers who use XHTML and CSS and would like to build rich Internet applications (RIAs) with JavaScript and DOM scripting. Students learn XHTML and CSS skills and learn how to use Firefox and its free Firebug extension to debug JavaScript applications. Additionally, students learn how to use arrays, functions, regular expressions, exception handling, libraries, and user-defined objects. The course provides an introduction to closures, recursion, prototype-based inheritance, extension of built-in JavaScript objects, and an object-oriented approach to data validation that students can use as a model for their own applications. Students also learn how to use DOM Scripting to build applications that run slide shows, do image rollovers, use dropdown menus, rotate headlines, sort the data in tables, and provide animation. The course also covers how to use the objects, methods, and properties of a web browser and how to use third-party libraries, such as jQuery and Dojo. (Offered Online from 4/4/18 – 6/6-18 with Prentiss Knowlton, ID# 359709)



Spring enrollment will open on February 5. Spring quarter beings the week of April 2, 2018.

Save up to 10% during early enrollment with code EARLY.*

*Discount code available on most courses at least 30 days before course start date. Discounts cannot be combined. Code is case sensitive.

You can follow us on Facebook @UCLAxDigitalTech or connect with us on LinkedIn @UCLAx Digital Technology.


Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!