UCLA Extension

February 2018 Digital Tech Newsletter

Spotlight

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

 

Reminders

-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.

image_print
Comments are closed.