About This Course:

Every business has a story. Accounting tells the financial story of a business. How much profit does the company make? Can the company afford to grow or pay its employees more? What are its assets and liabilities? Is the company in good credit or an investment risk? These types of questions can be answered through the use and understanding of the stories that financial statements tell.

In this course, you will explore standard business activities and follow them through to the financial statement phase to determine how those activities then contribute to the company’s profits. After taking this class, you should be able to:

  • Record and present financial information by applying the appropriate framework and guidelines of accounting for business transactions including:
    • Creating various financial statements based on various forms of financial data.
    • Analyzing financial data to inform decision-making using a given framework.
    • Explaining financial information to stakeholders to support business practices.
  • Determine asset accounts and their disclosure in the financial statements by:
    • Applying valuation methods to value account inventory
    • Determining account values
    • Developing financial statements
  • Determine liability and equity accounts and their disclosure in the financial statements by:
    • Identifying types of liabilities
    • Distinguishing between current and long-term liabilities
    • Evaluating financial impacts of long-term debt
    • Explaining the difference between retained earnings and owners’ equity
What You’ll Learn:
  • Record financial transactions according to industry standards
  • Prepare financial statements aligned with industry practices
  • Analyze the results of transactions and statements
  • Report financial information to appropriate stakeholders

Meet Your Instructors:

pearson advance :: Zuzana Buzzell

Zuzana Buzzell

Dr. Zuzana Buzzell oversees multiple programs within the graduate and undergraduate business portfolio at Southern New Hampshire University including accounting, economics and project management. She has 15 years of experience developing, training and teaching multiple successful accounting, finance and economics programs in traditional, hybrid and online settings for academic institutions, government agencies and the private sector. She also held various leadership positions in one of the largest financial service companies in the U.S. Dr. Buzzell earned her PhD in International Business with concentration in Finance in 2013, her master’s in finance in 2004 and an MBA in 2001.
pearson advance :: Mona Stephens

Mona Stephens

Mona Stephens has been teaching accounting courses, both online and campus, for more than 20 years. At Southern New Hampshire University, she is an online accounting faculty lead. She also serves as a subject matter expert for the university in all areas of accounting, based on her experience and knowledge in both educational and corporate accounting environments. Of Stephens’ 25 years of professional accounting experience, 18 of those were as the finance and accounting administrator for a regional government office. She is also Certified Public Accountant (CPA) and has MS degrees in both accounting and data analytics.

About This Course:

The Business and Professional Communications for Success program will provide learners with the essential knowledge to create eye-catching, appropriate business presentations, and apply proper techniques in their business communications, all while working in diverse environments. This program also examines the various types of business presentations in the work environment and allows learners to apply their knowledge to create a stunning presentation.

Professional Business Presentations, will dive into the world of presenting information both in written and verbal form using presentation templates or creating from scratch. This course discusses how to effectively create high-quality presentations with proper formatting, design elements (color scheme, layout, etc.), and organization. The learner will identify the appropriate presentation format and software for their audience. Learners will have the opportunity to utilize the skills gained to create an engaging PowerPoint presentation. Learners will also use their skills to create a professional handout with infographics and record a video presentation, graded by staff, as part of their final project in the course.

What You’ll Learn:

By the end of this course learners will be able to:

 Evaluate the organizational steps of a presentation

 Examine various supporting materials for presentations

 Evaluate and discuss various presentation software

 Examine design principles for presentations

 Discuss storytelling for presentations

 Develop a presentation

  • Present via video a polished presentation

Meet Your Instructor:

Debora Sepich - Pearson Advance

Debora Sepich

EdD MBA at Doane University
Debora Sepich is an entrepreneur turned educator who has spent the last 15 years blurring the lines between the world of work and the halls of education. Debora is the Director of Graduate Business and Technology Programs at Doane University. Prior to working at Doane University, she founded Dolphin Software, an environmental health and safety software company focused on supporting pharmaceutical companies, hospitals and other highly regulated industries focus on protecting people, the planet while also making sustainable profits. Debora is delighted to be marrying her years of applied business experience with online education.

About This Course:

The Business and Professional Communications for Success program will provide learners with the essential knowledge to create appropriate business messages and apply proper business writing techniques in their written business communications, all while working in diverse environments. This program also examines the various types of business presentations in the work environment and allows learners to apply their knowledge to create and present their work.

Business Writing Techniques will expand on the different communication styles of business writers. We will discuss business writers’ best practices by providing real-world scenarios and applications such as proofreading and rewriting. Learners will examine how to use the 6 C’s to enhance their business messages. Learners will also discuss the proper etiquette of business writing and examine the use of emoji in business communications.

What You’ll Learn:

By the end of this course learners will be able to:

 Identify Parts of a business letter

 Examine the 6 C’s for business messages

 Evaluate Direct Vs. Indirect messages

 Examine the use of emojis in the business setting

Meet Your Instructor:

Debora Sepich - Pearson Advance

Debora Sepich

EdD MBA at Doane University
Debora Sepich is an entrepreneur turned educator who has spent the last 15 years blurring the lines between the world of work and the halls of education. Debora is the Director of Graduate Business and Technology Programs at Doane University. Prior to working at Doane University, she founded Dolphin Software, an environmental health and safety software company focused on supporting pharmaceutical companies, hospitals and other highly regulated industries focus on protecting people, the planet while also making sustainable profits. Debora is delighted to be marrying her years of applied business experience with online education.

About This Course:

The Business and Professional Communications for Success program will provide learners with the essential knowledge of effective business communications to aid in their company’s success. Learners will create appropriate business messages through business letters and messaging and apply proper business communications techniques and business writing techniques. Learners will examine the basics of business communication while working in diverse business environments with diverse team members. This program also examines the various types of business presentations in the work environment. It allows learners to apply their knowledge to create and present their work for internal and external communication.

Learners will engage with the fundamentals of business communication. Learners will discover different communication styles and how to address them in a business setting. Learners will also assess their listening styles and emotional intelligence and how both can affect their communication skills.

What You’ll Learn:

  • By the end of this course learners will be able to:
  • Define communication
  • Examine the communication principles
  • Identify the Communication Model
  • Identify ways to effectively listen
  • Identify their communication style
  • Examine Emotional Intelligence and its use in communication

Meet Your Instructor:

Debora Sepich - Pearson Advance

Debora Sepich

EdD MBA at Doane University
Debora Sepich is an entrepreneur turned educator who has spent the last 15 years blurring the lines between the world of work and the halls of education. Debora is the Director of Graduate Business and Technology Programs at Doane University. Prior to working at Doane University, she founded Dolphin Software, an environmental health and safety software company focused on supporting pharmaceutical companies, hospitals and other highly regulated industries focus on protecting people, the planet while also making sustainable profits. Debora is delighted to be marrying her years of applied business experience with online education.

About This Course:

Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis. Learn about types of data and types of databases to store data, as well as design for scalability. You’ll also learn to prepare digital data storage using the relational model, including resolving integrity constraints, and proper assignments of primary and foreign keys. In addition, you’ll construct and analyze queries to address data requirements.

What You’ll Learn:

Understanding what SQL isHow to use SQL statements such as:SelectFromWhereHavingGroup byOrder byMaxMinCountCount distinctJoinsImport/exportReading schemasCreating database schemasImporting/exporting dataTroubleshooting queriesModifying tables and data structuresAnalyzing SQL outputs

Meet Your Instructors:

Scott Overmyer

Associate Dean of Information Technology at Southern New Hampshire University Dr. Overmyer started his career in the software field in 1983 with TRW, Inc. as a user interface designer and requirements engineer on the Space Defense Operations Center project in Colorado's Cheyenne Mountain NORAD Complex. After completing several government projects with TRW, he was appointed manager of TRW's Research and Technology Center in Virginia. He earned a Ph.D. in Information Technology (Information and Software Systems Engineering), while appointed as Research Instructor in George Mason University's Center of Excellence in Command, Control, Communications and Intelligence. Dr. Overmyer has nearly 10 years of industrial experience, followed by nearly 30 years of academic experience. During his academic career, he has been awarded 2 summer faculty fellowships at NASA's Johnson Space Center and has been a PI or co-PI on several National Science Foundation research grants. While an Associate Professor at Drexel University, he was also the Founding Director of the Pennsylvania Governor's School for Information Technology, a 5-week summer residential program for talented high school students. Internationally, he served at Subject Coordinator for both Software Engineering and Information Systems while at Massey University in NZ, and a (founding) Professor of Computer Science at Nazarbayev University in Astana, Kazakhstan, as well as Acting Chair of the Physics Department there. He is currently an Associate Dean for Information Technology for Southern New Hampshire University, and works remotely from his farm in South Dakota. On Dr. Overmyer’s free time, he enjoys researching artificial intelligence for automatic student assessment, online poker, and wine making.

Ben Tasker

Technical Program Facilitator – Data Science and Data Analytics at Southern New Hampshire University Ben Tasker owns his own consulting business, where he enjoys solving complex data science problems with innovative solutions for clients ranging from Fortune 500 companies, small businesses and even the White House. He believes any company can reach the next phase of machine learning, artificial intelligence or even basic data analytics and enthusiastically provides that expertise to his clients. He applies this knowledge daily as a technical program facilitator at Southern New Hampshire University, where he creates cutting edge data science programs. Ben also holds a clinical Professorship at the College System of New Hampshire, where he teaches data science topics at both the undergraduate and graduate level. Before he ventured into consulting and education, he was the manager of analytics and data warehousing for the Community College System of NH, where he managed 12 data scientists and helped developed an algorithm that kept students enrolled in college, flagging the students at the highest risk of failure. This flag allowed the colleges to deploy resources for each of those students, ultimately helping them complete college. He also earned a MS in Data Analytics and Data Science from the University of New Hampshire. In his free time, Ben can be found at his local Crossfit Gym, doing box jumps, hang power cleans and kettle bell swings

About this course

Want to study for an MBA but unsure of the basic data analysis still required? This online course prepares you for studying in an MBA program and in business generally.

Data analysis appears throughout any rigorous MBA program and in today’s business environment understanding the fundamentals of collecting, presenting, describing and making inferences from data sets is essential for success.

The goal of this course is to teach you fundamental data analysis skills so you are prepared for your MBA study and able to focus your efforts on core MBA curriculum, rather than continually playing catch-up with the underlying statistical knowledge needed.

We also hope that learning these data analysis skills will equip you with the ability to understand, to a greater degree, the data you encounter in your working lives and in the world around you – an essential life-skill in today’s data driven environment

This course assumes no prior knowledge of data analysis. Concepts are explained as clearly as possible and regular activities give you the opportunity to practice your skills and improve your confidence.

What you’ll learn

  • Presenting and summarising your data
  • Decision making under uncertainty
  • Data-based decision making
  • Modelling for decision making

Syllabus

Topic 1 – Presenting and summarising your data
Topic 2 – Decision making under uncertainty
Topic 3 – Data-based decision making
Topic 4 – Modelling for decision making

Meet your instructors

David Lefevre

David is the Director of the EdTech Lab at Imperial College Business School. He is also the course leader on the Business School’s Pre-study module in Maths. David holds an MSc in Computing Science and a PhD in the field of instructional systems from Imperial College London and, perhaps most importantly, a BSc in Mathematics from the University of East Anglia (UEA). David and his EdTech Lab team launched the Global Online MBA program in 2015 and have received awards along the way including a Gold award at the IMS Learning Impact awards in 2010 and an Effective Practice Award at the Sloan-C Blended Learning Conference in 2011.

Catarina Sismeiro

Dr. Catarina Sismeiro is an Associate Professor at Imperial College Business School where she teaches on the Full-Time and Executive MBA programs. Catarina’s research has been published in The Journal of Marketing Research, Management Science, and The International Journal of Research in Marketing and has won several awards. Previously she was an Assistant Professor at Marshall Business School, University of Southern California. She holds a PhD in Management from the Anderson School, UCLA, and a Licenciatura in Management from Faculdade de Economia do Porto (Portugal).

About MIT horizon

MIT Horizon is an expansive content library built to help you explore emerging technologies. Through easy-to-understand lessons, you’ll be guided through the complexities of the latest technologies and simplified expert-level concepts. Designed for both technical and non-technical learners, you can examine bite-size content that can lead to maximum career outcomes.

For a limited time, gain access to the complete MIT Horizon library.

Register today for exclusive entry.

About this course

Want to know how to avoid bad decisions with data?

Making good decisions with data can give you a distinct competitive advantage in business. This statistics and data analysis course will help you understand the fundamental concepts of sound statistical thinking that can be applied in surprisingly wide contexts, sometimes even before there is any data! Key concepts like understanding variation, perceiving relative risk of alternative decisions, and pinpointing sources of variation will be highlighted.

These big picture ideas have motivated the development of quantitative models, but in most traditional statistics courses, these concepts get lost behind a wall of little techniques and computations. In this course we keep the focus on the ideas that really matter, and we illustrate them with lively, practical, accessible examples.

We will explore questions like: How are traditional statistical methods still relevant in modern analytics applications? How can we avoid common fallacies and misconceptions when approaching quantitative problems? How do we apply statistical methods in predictive applications? How do we gain a better understanding of customer engagement through analytics?

This course will be is relevant for anyone eager to have a framework for good decision-making. It will be good preparation for students with a bachelor’s degree contemplating graduate study in a business field.

Opportunities in analytics are abundant at the moment. Specific techniques or software packages may be helpful in landing first jobs, but those techniques and packages may soon be replaced by something newer and trendier. Understanding the ways in which quantitative models really work, however, is a management level skill that is unlikely to go out of style.

What you’ll learn

  • Variability in the real world and implications for decision making
  • Data types and data quality with appropriate visualizations
  • Apply data analysis to managerial decisions, especially in start-ups
  • Making effective decisions from no data to big data (what should we collect and then what do we do with all this data?)

Meet your instructors

Rick Cleary

Professor Rick Cleary is a statistician and mathematician with research and consulting interests in a variety of fields including sports, biomechanics, and statistical approaches to fraud detection and audit risk. Prior to coming to Babson College in 2013, Professor Cleary taught at St. Michael’s College in Vermont, Cornell University, Bentley University, and Harvard University. He has held many leadership positions in the Mathematical Association of America, including six years on the Executive Committee as Associate Treasurer and a term as chair of the Joint Data Committee. He is currently on the Nominations Committee and the Polya lecturer selection committee. Professor Cleary enjoys working with mathematics teachers at all levels to improve statistics education and he gives frequent talks and workshops on ways to encourage statistical thinking.

Nathan Karst

Dr. Nathan Karst received his B.S. in electrical and computer engineering from Franklin W. Olin College of Engineering in 2007 and his doctorate in applied mathematics from Cornell. He is an avid teacher and researcher, having won the Dean’s Award for Excellence in Undergraduate Teaching in 2014 and the Dean’s Award for Excellence in Scholarship in 2015. Most recently, his research has focused on the role of nonlinear dynamics in microvascular networks and event-scale streamflow recession variability.

Davit Khachatryan

Dr. Davit Khachatryan is an Assistant Professor of Statistics and Analytics at Babson College. He is an applied statistician with research interests in analyzing intellectual property data to study the formation and diffusion of knowledge in emerging industries. Davit’s current and former research has produced publications in academic, peer-reviewed journals such as Journal of the Royal Statistical Society (Series C), The American Statistician, IEEE Transactions on Engineering Management (forthcoming), and Quality and Reliability Engineering International. Prior to joining Babson College, Davit was a Senior Associate at the National Economics and Statistics practice of Pricewaterhouse Coopers (PwC). In the latter role he consulted in the area of predictive modeling and advanced data analytics, helping clients from financial, healthcare, and government sectors with building automatic predictive models and enhancing business intelligence solutions. Davit has earned his B.S. in Applied Mathematics and Informatics from Yerevan State University, M.S. in Statistics and Ph.D. in Management Science from the University of Massachusetts, Amherst.

George Recck

Mr. Recck has taught at Babson College since 1984. He currently serves as the Chair of the Business Analytics/Statistics Education special interest group for the American Statistical Association (ASA). Mr. Recck is also the founder of Total Information, Inc., an consulting firm specializing in providing information service to small businesses.

Babak Zafari

†Dr. Zafari is an Assistant Professor of Analytics and Statistics in the Math & Science Division. His area of interests are Predictive Modeling and Data Mining Methods for Business Applications, Bayesian Statistics, Healthcare Fraud Analytics and Online Auctions. Prior to joining Babson College, he was a Visiting Assistant Professor at The George Washington University School of Business teaching courses in Data Analysis and Decisions, Business Analytics and Data Mining. He was also a senior statistician consultant at Integrity Management Services where he was responsible for developing statistical models for fraud detection in Medicare and Medicaid programs. He received his B.S. in Applied Mathematics from Sharif University of Technology, M.S. in Operations Research/Computer Science from Bowling Green State University and Ph.D. in Decision Sciences from The George Washington University School of Business.

About MIT horizon

MIT Horizon is an expansive content library built to help you explore emerging technologies. Through easy-to-understand lessons, you’ll be guided through the complexities of the latest technologies and simplified expert-level concepts. Designed for both technical and non-technical learners, you can examine bite-size content that can lead to maximum career outcomes.

For a limited time, gain access to the complete MIT Horizon library.

Register today for exclusive entry.

About This Course:

Perhaps the most popular data science methodologies come from machine learning. What distinguishes machine learning from other computer guided decision processes is that it builds prediction algorithms using data. Some of the most popular products that use machine learning include the handwriting readers implemented by the postal service, speech recognition, movie recommendation systems, and spam detectors.

In this course, part of our Professional Certificate Program in Data Science, you will learn popular machine learning algorithms, principal component analysis, and regularization by building a movie recommendation system.

You will learn about training data, and how to use a set of data to discover potentially predictive relationships. As you build the movie recommendation system, you will learn how to train algorithms using training data so you can predict the outcome for future datasets. You will also learn about overtraining and techniques to avoid it such as cross-validation. All of these skills are fundamental to machine learning.

What You’ll Learn:

  • The basics of machine learning
  • How to perform cross-validation to avoid overtraining
  • Several popular machine learning algorithms
  • How to build a recommendation system
  • What is regularization and why it is useful?

Frequently Asked Questions:

Honor code statement
HarvardX requires individuals who enroll in its courses on edX to abide by the terms of the edX honor code. HarvardX will take appropriate corrective action in response to violations of the edX honor code, which may include dismissal from the HarvardX course; revocation of any certificates received for the HarvardX course; or other remedies as circumstances warrant. No refunds will be issued in the case of corrective action for such violations. Enrollees who are taking HarvardX courses as part of another program will also be governed by the academic policies of those programs.

Research statement
By registering as an online learner in our open online courses, you are also participating in research intended to enhance HarvardX’s instructional offerings as well as the quality of learning and related sciences worldwide. In the interest of research, you may be exposed to some variations in the course materials. HarvardX does not use learner data for any purpose beyond the University’s stated missions of education and research. For purposes of research, we may share information we collect from online learning activities, including Personally Identifiable Information, with researchers beyond Harvard. However, your Personally Identifiable Information will only be shared as permitted by applicable law, will be limited to what is necessary to perform the research, and will be subject to an agreement to protect the data. We may also share with the public or third parties aggregated information that does not personally identify you. Similarly, any research findings will be reported at the aggregate level and will not expose your personal identity.

Please read the edX Privacy Policy for more information regarding the processing, transmission, and use of data collected through the edX platform.

Nondiscrimination/anti-harassment statement
Harvard University and HarvardX are committed to maintaining a safe and healthy educational and work environment in which no member of the community is excluded from participation in, denied the benefits of, or subjected to discrimination or harassment in our program. All members of the HarvardX community are expected to abide by Harvard policies on nondiscrimination, including sexual harassment, and the edX Terms of Service. If you have any questions or concerns, please contact harvardx@harvard.edu and/or report your experience through the edX contact form.

Who can take this course?

Unfortunately, learners from one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. EdX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.

Meet Your Instructor:

Ansaf Salleb-Aouissi

Ansaf is a Lecturer in discipline of the Computer Science Department at the School of Engineering and Applied Science at Columbia University. She received her her BS in Computer Science in 1996 from the University of Science and Technology (USTHB), Algeria. She earned her masters and Ph.D. degrees in Computer Science from the University of Orleans (France) in 1999 and 2003 respectively.

About MIT Horizon:

MIT Horizon is an expansive content library built to help you explore emerging technologies. Through easy-to-understand lessons, you’ll be guided through the complexities of the latest technologies and simplified expert-level concepts. Designed for both technical and non-technical learners, you can examine bite-size content that can lead to maximum career outcomes.

For a limited time, gain access to the complete MIT Horizon library.

Register today for exclusive entry.

3+ Hours of Video Instruction

Video instruction, demonstrations of Amazon Web Services and third-party cloud solutions provide a clear guide to understanding networking with Amazon Virtual Private Cloud.

Overview

Networking in Amazon Web Services (AWS) LiveLessons reviews key concepts related to networking, how those concepts apply to Amazon Virtual Private Cloud, and how networking enables high availability, fault tolerance, performance, and security. AWS Certified Solutions Architect Professional and AWS Authorized Instructor Richard A. Jones covers concepts and methods necessary to design and build secure networks within Amazon Web Services (AWS).

For applications running on EC2, the architecture begins with the network; in AWS, that is the Virtual Private Cloud or VPC. In order to gain the highest degree of security, resiliency, and performance, you need to design the network accordingly. In this series of videos from Richard A. Jones, you learn how network design can help leverage multiple availability zones and how the application of routing, network access control lists, and security groups contribute to security. You also see how to extend on-premises networks into AWS with VPN and Direct Connect, review how to achieve the best performance, and much more.

Gaining an in-depth understanding of the concepts unique to cloud computing is essential for being a valuable asset to any business leveraging AWS for their computing and storage needs.

Topics include:

  • Networking Review
  • Amazon VPC Part 1: Basics
  • Amazon VPC Part 2: Advanced Concepts
  • Network Security
  • Connecting VPCs and On-Premises Networks
  • Performance and Other Notes

Skill Level

  • Intermediate

Learn How To

  • Leverage multiple availability zones via network design
  • Contribute to security via application of routing, network access control lists, and security groups
  • Extend on-premises networks into AWS with VPN and Direct Connect and achieve the best performance

Who Should Take This Course

  • Working solutions architects, network administrators, and system administrators looking to understand and implement Amazon Virtual Private Cloud within their AWS infrastructure

Course Requirements

  • Basic understanding of AWS, including definitions of regions and availability zones

Lesson Descriptions

Lesson 1, “Networking Review,” reviews fundamental knowledge needed throughout the use of AWS VPC, IPv4, and IPv6 addresses as well as classless-interdomain routing, and C.I.D.R notation as a way of specifying ranges of IP addresses.

Lesson 2, “Amazon VPC Part 1: Basics,” discusses Amazon Virtual Private Cloud and how subnets enable the use of multiple availability zones as well as routing, internet access, and how public IP addresses can be allocated and assigned to EC2 instances.

Lesson 3, “Amazon VPC Part 2: Advanced Concepts,” demonstrates how to keep EC2 instances private and protected from the internet while still allowing egress only, or one-way internet access. Review network address translation, third-party virtual network appliances, and VPC endpoints.

Lesson 4, “Network Security,” discusses network security and demonstrates the use of network access control lists and security groups. Amazon VPC provides all the tools needed to create a secure network, but responsibility is needed to use those tools appropriately.

Lesson 5, “Connecting VPCs and On-Premises Networks,” reviews VPC peering, various VPN solutions, and AWS Direct Connect. While isolated networks like Amazon VPC provide powerful means of controlling network traffic and protecting instances, there are plenty of use cases where resources in VPCs need access to resources in other VPCs or on-premises.

Lesson 6, “Performance and Other Notes,” reviews how to achieve the best network performance with Amazon VPC with the knowledge of other features and options. With a rich collection of enablement and security tools, it is capable of high performance.

About Pearson Video Training

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at  http://www.informit.com/video.

Meet your instructor

Richard A. Jones

Richard A. Jones is a certified AWS Solution Architect and an experienced instructor having taught the IT teams of numerous Fortune 500s and postgraduate students at the University of Colorado. Programming since age 10, Richard has spent more than 25 years furthering his knowledge and skills of information technologies. He studied network switching systems in the U.S. Army, attained a degree in Digital Media, and has a long history of web and mobile application development. Beginning with a funded startup in 2009, Richard has dedicated more than nine years to building reliable, secure, and cost-effective systems in Amazon Web Services, and has taught hundreds of IT professionals how to do the same. Richard holds seven AWS certifications including the AWS Solution Architect and DevOps Engineer Professional certifications, and the AWS Advanced Networking Specialty certification.

About MIT horizon

MIT Horizon is an expansive content library built to help you explore emerging technologies. Through easy-to-understand lessons, you’ll be guided through the complexities of the latest technologies and simplified expert-level concepts. Designed for both technical and non-technical learners, you can examine bite-size content that can lead to maximum career outcomes.

For a limited time, gain access to the complete MIT Horizon library.

Register today for exclusive entry.

About This Course:

This is the 1st course in the introductory, undergraduate-level offering that makes up the larger Introduction to Databases MicroBachelors Program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

  1. Introduction to Databases
  2. Advanced Database Queries
  3. Advanced Database Administration

These topics build upon the learnings that are taught in the introductory-level Computer Science Fundamentals MicroBachelors program, offered by the same instructor.

This course is an introduction to the basic concepts, organization, and implementation models of databases, with an emphasis on the relational model. Among the topics covered are the development of simple queries that retrieve and mutate the data in a database. Data Manipulation Language (DML) is a subset of SQL that is used by database developers to create, maintain, and query facts in the database. Students gain a thorough understanding of the DML syntax and the options available when retrieving facts back from the database. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The course utilizes the open-source relational database MySQL. MySQL and it’s open-source fork MariaDB are used in millions of web apps to persist the application data and provide query processing. The applied SQL labs expand on the classroom lectures to provide students with hands-on experience with a relational database management system (RDBMS) and structured query language (SQL).

If you successfully complete all the courses within the program, with a passing grade of 70% or better via the verified (paid) track, you’ll not only receive a certificate highlighting your achievement, but also have the option to collect real college credit (included in the price!) that you can count towards a pursuit of a bachelor’s degree.

Industry Certification Preparation
This program covers much of the material that is assessed on the MySQL8.0 Database Developer Oracle Certified Professional exam. The exam is not included in the cost of the program.

What You’ll Learn:

  1. Use tools to issue queries to a database
  2. Develop queries in SQL to create data stored in a database.
  3. Develop queries in SQL to read data stored in a database.
  4. Develop queries in SQL to update data stored in a database.
  5. Develop queries in SQL to delete data stored in a database.

Meet Your Instructor:

Aspen Olmsted

Adjunct Professor at New York University Tandon School of Engineering Aspen Olmsted is an adjunct faculty member in the New York University Tandon School of Engineering in the Computer Science and Engineering department. Aspen's fulltime job is as an assistant professor and Graduate program director at the College of Charleston. He obtained a Ph.D. in Computer Science and Engineering from The University of South Carolina. Before his academic career, he was CEO of Alliance Software Corporation. Alliance Software developed N-Tier enterprise applications for the performing arts and humanities market. Dr Olmsted’s research focus is on the development of algorithms and architectures for distributed enterprise solutions that can guarantee security and correctness while maintaining high-availability. In his Secure Data Engineering Lab, Aspen mentors over a dozen graduate and undergraduate students each year