MySQL is a database management system and free, open-source software, developed and supported by Oracle Corporation. It is exceptionally reliable and easy to use. In this tutorial, we are going to explain the steps on how to obtain and Install MySQL on Windows 10 systems.
On your web browser, search engine type Download MySQL. Click on the first link in the web search, mysql.com/downloads. It will take you to the MySQL obtain page.
Scroll to where you see MySQL Community GPL Downloads, click it.
Now on the MySQL Community obtain page, click MySQL Installer for Windows. It brings you to the My Community obtain Page. MySQL Installer.
Where you see, operating system, select Microsoft Windows.
You will see two windows (x86, 32-bit), MSI Installers, one of smaller size and the other of larger size. Select the one with the larger size (405.2M) because you do not have to connect to the internet.
On the next page at the bottom, select No thanks, just start my download.
A dialog box will appear requesting you to save the file. Click Save File. The file is downloaded.
Read: Difference between SQL and MySQL.
In the Explorer, double click the MySQL Installer. It will then prepare the installer.
A window will appear asking you ‘Do you want to allow the following program to install software on your computer‘ Click Yes. The installation will start.
You will see a MySQL Installer Wizard. Now choose a setup type; select Full because it includes all the products available in this catalog. Then Next.
If you try to click Next, a warning will pop up stating that ‘some programs will not be installed or upgraded on the Check Requirement window.
Do you want to continue’ (see photo above), click Yes?
On the Installation window. Click Execute. You will see your programs installed one by one. It will show which program was installed and which program failed. Then Next.
On the Product Configuration window, click Next.
On the Installation Complete window, click Finish. MySQL is Installed.
I hope this post is useful to you. If you have any questions, please comment below.
MySQL is the world’s most widely used open source database, and ranks a close second in popularity among databases overall. It’s an effective relational database management system that has been at the heart of popular applications for years. However, it can be challenging to use and there are many opportunities to Excellerate performance.
There have been some important new developments in the last few years for MySQL as well. This article updates a previous set of MySQL performance tuning tips provided by Baron Schwartz. Although the earlier article is still relevant, there are additional steps you can take to achieve the best performance for your MySQL deployment. Here are 10 more MySQL performance tuning tips to add to your list.
Schema design is one of the most important things that you will do in your database. This is a cross relational database technology principle, as normal forms were introduced back in the 1970s. Since MySQL moved to InnoDB as the default storage engine in version 5.6, the schema design becomes even more important.
Why is this? In InnoDB, everything is a primary key! This relates to the way InnoDB organizes the data. In InnoDB, the primary key is clustered and every secondary key adds an entry pointer to the primary key. If you don’t take this into account in your schema design, then your performance will be negatively impacted.
The data is also stored using B-tree indexes, so inserting data in an ordered way (i.e. using quasi-sequential values) prevents primary key fragmentation and thus reduces I/O operations required to find leaf nodes.
There are some use cases where sequential primary keys are not the right choice — a good example here is the Universally Unique IDentifier or UUID. You can find a deeper dive into issues around UUIDs and primary keys here. However, generally speaking, we recommend using sequential primary keys for most use cases.
Secondary keys are updated by a background process. As a result, the performance impact is not as serious as you would expect. Instead, the problem is around disk footprint because adding secondary keys will increase the storage requirements.
Filtering on a field that does not have an index could result in a full table scan every time the query runs. This can, of course, result in a huge performance impact. It’s therefore better to have a secondary key than miss one.
That being said, you should not over-index your databases, as running many indexes may not provide the performance improvements you want to achieve. At the same time, these additional indexes may increase your storage costs, and InnoDB has to perform many background operations to keep them up to date.
InnoDB can find and actually serve rows directly from indexes, whereas a secondary key points to the primary key and the primary key contains the row itself. If the InnoDB Buffer Pool is big enough, it can hold most data in memory too. You can even use composite keys, which are usually more effective for queries than individual per-column keys. MySQL can use one index per table access, so if you are running queries with a clause like WHERE x=1 and y=2
then having an index over x,y
is better than having individual indexes over each column.
Furthermore, a composite index over x,y
also can Excellerate the performance of the following query:
SELECT y FROM table WHERE x=1
MySQL will use the covering index and serve y
from the index, which is in memory.
In practice, you can Excellerate performance by using a composite index when you have the chance to do so. Whenever you’re designing indexes you need to think about them in the natural way that they are read. What this means is that indexes are read always from the left to right, so given a query like this:
SELECT a,b,c FROM table WHERE a=1 and b=2
Then an index over a,b
will help with the query. But if the query is in this format:
SELECT a,b,c FROM table WHERE b=2
Then the index will be useless and will cause a full table scan. The idea of always reading the indexes from the left also applies to some other cases. For example, given the following query:
SELECT a,b,c FROM table WHERE a=1 and c=2
Then an index over a,b,c
will read only the first column because there is no WHERE
clause filtering by column b
. So in this case MySQL can partially read the index, which is better than a full table scan, but still not good enough to get the best performance of the query.
Another element related to query design is the leftmost index approach, as this is a common optimization used in MySQL. For example, an index on a,b,c
will not cover a query like select a,c where c=x
because the query cannot skip the first part of the index, which is a,b
. The same goes for a query like select c,count(c) where a=x group by c
. This query cannot use the index on a,b,c
for the group by
because it cannot skip the index on b
. However, if you have a query like select c,count(c) where a=x and b=y group by c
, which filters on a,b
and performs a group by
on c
, then one index on a,b,c
can help with both the filtering and the group by
.
Just having a Formula One car doesn’t win the race. Not if you put an inexperienced driver behind the wheel, and they crash it on the first corner. Similarly, you might have the best-tuned MySQL server on earth, but if you have bad queries your database will be slower than it should be.
You should regularly review your query design over time as your application changes with new features and bug fixes. The dataset and usage patterns of the application are likely to change over time as well, all of which can impact the query performance.
Setting aside time for query reviews and monitoring query execution time is very important. You can use a slow query log or Performance Schema for this, but implementing a monitoring tool will help you get even better data.
Keep in mind that it’s not always the slowest query that is the most important one to fix. For example, you might have a query that takes 30 seconds but runs twice a day alongside one that takes one second and runs 100 times a minute. For a big win, you should start optimizing the second query, as improving that one could save a lot of time and resources over the longer term.
Monitoring is one of the key elements of performance tuning. Without knowing the current workload and patterns it is hard to deliver any specific recommendations. In latest years, MySQL has improved its exposure of low-level MySQL/InnoDB metrics, which can help in understanding the workload.
For instance, in earlier versions, the Performance Schema was a bottleneck and had considerable impact, especially if you had many tables. In the latest versions of MySQL, many changes like the new Data Dictionary have improved performance, and now you can have many tables without significant impact.
Most of the modern monitoring tools are using Performance Schema in some way, so a good recommendation is to check out these tools and choose the one that best fits your needs. This visibility into performance data can be a huge asset in your investigations.
Some general recommendations given by tuning tools will work in most use cases. However, every workload and every schema is different. In some cases the general recommendations of tuning tools do not work, and it is wise to be careful when trusting these recommendations. Even innodb_dedicated_server
, which is Oracle’s own tool and available in MySQL, can make questionable changes to the configuration.
For example, setting innodb_buffer_pool_size
to 75% of total RAM is a good general rule of thumb. However, nowadays you can have servers with hundreds of gigabytes of RAM. If you have 512GB RAM, that will leave 128GB free and not dedicated to the buffer pool, which is a lot of waste.
innodb_log_file_size
and innodb_log_files_in_group
are defined based on the amount of RAM too. On servers with more than 128GB of RAM, this setting makes little sense as it will create 64 redo log files (yes, 64!) of 2GB each. This will result in 128GB of redo logs stored on disk. In most cases there is no need for such big redo log files, even in the busiest environments. This is therefore not a good recommendation.
innodb_flushing_method
is the only value configured properly when automatic configuration is enabled. This variable sets the flushing method to O_DIRECT_NO_FSYNC
, which is the recommended method when using Ext4 or XFS file systems, as it avoids double buffering of data.
A good recommendation would be to set innodb_buffer_pool_size
to 75% or 80% on dedicated servers. On servers with large amounts of RAM, i.e., more than 128GB, increase this to 90% or even more with proper profiling of memory consumption. Similarly, for most cases with innodb_log_file_size
and innodb_log_files_in_group
, start with two files of 2GB each and monitor write log operations. Normally it is advisable to cover roughly one hour of writes when sizing redo logs.
Regarding innodb_flush_method
, this option should be set to either O_DIRECT
or O_DIRECT_NO_FSYNC
for modern Linux file systems like Ext4 or XFS.
MySQL and InnoDB try to minimize the number of I/O operations they carry out because accessing the storage layer is costly in terms of application performance. There are a few settings that can impact how many I/O operations InnoDB performs. Two of these settings are frequently misunderstood, and changing them will often cause performance issues.
innodb_io_capacity
and innodb_io_capacity_max
are variables that are related to the number of I/O operations for flushing in the background. Many customers increase the values of these settings to take advantage of modern SSDs that can provide very high I/O capacity at relatively low latencies. While the idea seems logical, increasing the I/O capacity settings can lead to a few problems.
The first issue is performance degradation by making InnoDB flush dirty pages too quickly, thus reducing the opportunity to modify a page more than once before being flushed. Keeping dirty pages in memory can significantly decrease the I/O operations needed to write data to storage.
Secondly, SSDs have an expected number of writes before they see a drop in performance. Increasing the amount of write operations can therefore affect the life span of your SSDs, even if you’re using high-end drives.
Cloud hosting is popular these days, and running your MySQL service instance in the cloud can be very useful. However, servers in the cloud will often have I/O limits or will charge more for using more I/O. By being aware of these limitations, you can carefully configure these parameters to make sure these limits are not reached and that I/O operations are minimized.
It’s important to mention innodb_lru_scan_depth
as well because this setting controls how far down the buffer pool LRU page list the page cleaner thread scans for dirty pages to flush. If you have a write-heavy workload with a big buffer pool and many buffer pool instances, you can try decreasing this variable to use fewer I/O operations.
A good recommendation to follow is keep the defaults unless you know you need to change them.
It is also worth mentioning that the latest SSDs are specifically optimized for transactional databases. One example is Western Digital, which sought out expert assistance to help them meet the requirements for the new wave of applications being created.
MySQL 8.0 saw the introduction of common table expressions (CTEs), which help to get rid of nested queries that will create derived tables. This new functionality allows you to create a custom query and reference the results as if they were a temporary table or a view. The difference is that CTEs can be referenced several times within a transaction without the need of explicitly creating and dropping them.
Given that CTEs are materialized only once, they tend to be faster in complex transactions that run multiple queries. Plus, CTE recursion is supported, so you can easily create complex structures in the SQL language like hierarchical models and series. If you want more details on CTEs, you’ll find an introduction here.
There are many different cloud options worth considering for a MySQL deployment, from implementing a MySQL server instance in a VM that you manage, to using a database as a service (DBaaS) solution. The range of options is vast.
Many of these services promise to deliver a significant performance boost and to make all of your issues go away. In some simple use cases that may be true. However, even in the cloud, you have to know and understand the basic principles of databases, or your costs will increase significantly. This cost increase often happens because you are essentially solving problems by throwing more hardware at the problem rather than fixing the design.
Welcome to our site. We hope you enjoy it and find it useful. Currently we have seven courses and a selection of feature items available. Over the next few years we are planning to create additional full and short courses at all levels of English.
All our courses are designed to work on mobiles, tablets and desktop computers - so wherever you are, you will be able to enjoy studying English with the BBC Learning English team. If you are using a desktop, you can obtain audio mp3 files and pdf transcripts.
Over the next few months we plan to add new types of materials and new functionality to the website.
This course will help you Excellerate your ability to understand and use English as it appears in everyday life. Session 1 brings you top tips for studying English and taking exams while in Session 2, News Review shows you how to use the language from news headlines in your everyday English. We answer Learners' Questions about English in Session 3 and we bring you top tips from The Teachers' Room in Session 4. And to round each unit off, we take a key word from the news and show you how to say it properly in Pronunciation in the News in Session 5.
This is a course for learners of English who are studying at a relatively high level. It is designed to help you become an even better speaker and to help you move towards a near-native level of English. In English Masterclass you can find tips for understanding English as it is really spoken, and see how words and phrases are used in authentic news stories and headlines in News Review. We bring you multiple uses of key vocabulary items in our story programmes and Tim's Pronunciation Workshop is up and running!
If your level of English is around C1, this video-based 30-unit course brings you the tools you need to take your English further. Dan and Finn have got lots of precious 90-second nuggets of information in English Class, while over in Stop Saying, Tim and Helen help you correct those little mistakes that stop your English sounding more natural. We take a good look at the words making the news in News Review - and the big stories of the week crop up in LingoHack. And after all that excitement, we've got functional English on the menu in our drama series The White Elephant.
If you are studying English at intermediate level or thereabouts, this course is for you. There are a total of 30 units in the course, with 5 sessions in each Unit, including 6 Minute Grammar, 6 Minute Vocabulary and drama. We'll also bring you lots of articles, audio and video clips alongside materials created specifically for you by our in-house team of language experts, so that unit by unit, session by session you will be able to Excellerate your grammar, vocabulary, pronunciation and comprehension of written and spoken English.
If your level of English is around lower intermediate, this course is for you. There are 30 units in the course. Each unit is based around a particular course and explores grammar and vocabulary related to that course as well as helping you to Excellerate your skills and pronunciation. You can find all our most popular features including 6 Minute Grammar, 6 Minute Vocabulary, and News Report, as well as lots of interactive materials based on original BBC audio and video, created just for you by our in-house team of language experts.
Shakespeare Speaks is a brand new series of 20 animated, voiced shorts produced by BBC Learning English in partnership with The Open University.
Popular English phrases and expressions, coined by William Shakespeare yet still very much used today are brought to life, explained and practised by The Bard himself with the help of a cast of imagined characters from Shakespeare’s life and times.
Each episode explains the meaning and use of a well-known modern English expression that originally appeared in Shakespeare’s work, such as:
o The world’s mine oyster
o A tower of strength
o In a pickle
o All that glisters is not gold
o As dead as a doornail
Features
This section of the website is mainly for our higher level learners. Here you'll find our most popular programmes. Pick up a bunch of new words with our weekly topical chat 6 Minute English. Find out the meaning of real English expressions - that don't always make it into the dictionary - in The English We Speak. Catch up on the news with News Report and our video news product LingoHack, which brings you authentic BBC News every Wednesday. And drama lovers can find our versions of some of the world's best-loved dramas such as Charles Dicken's A Christmas Carol and Lewis Carroll's Alice's Adventures in Wonderland.
In the Features area, you can also find our Pronunciation section, bringing you plenty of videos and activities to help you Excellerate your pronunciation, whatever your level!
The Learning Circles are a chance for you to help your family and friends learn English. You are the group leader. Follow the links in each session to obtain the different materials. They will take your group through the everyday English they need to survive in the UK.
There is a Trainer's Guide that will tell you how to run a Learning Circle and twelve fun sessions. With each one, you can learn new words with flashcards, watch and discuss videos about everyday life, discuss how to solve problems, learn some useful everyday phrases and play some games to practise what you have learnt. Have a great time!
In the first session you will find a video guide for group leaders on how to run a Learning Circle. This will explain what to do at each stage of the Leader's Session Plan.
Learning Circles are part of English My Way. If you would like to find out more, or to recommend classes to a friend or member of your family, visit this site.
We are interested to hear what you think about the site and the types of materials that you would be interested in. Please feel free to write to us using our contact us form.
Welcome to our site. We hope you enjoy it and find it useful. Currently we have seven courses and a selection of feature items available. Over the next few years we are planning to create additional full and short courses at all levels of English.
All our courses are designed to work on mobiles, tablets and desktop computers - so wherever you are, you will be able to enjoy studying English with the BBC Learning English team. If you are using a desktop, you can obtain audio mp3 files and pdf transcripts.
Over the next few months we plan to add new types of materials and new functionality to the website.
This course will help you Excellerate your ability to understand and use English as it appears in everyday life. Session 1 brings you top tips for studying English and taking exams while in Session 2, News Review shows you how to use the language from news headlines in your everyday English. We answer Learners' Questions about English in Session 3 and we bring you top tips from The Teachers' Room in Session 4. And to round each unit off, we take a key word from the news and show you how to say it properly in Pronunciation in the News in Session 5.
This is a course for learners of English who are studying at a relatively high level. It is designed to help you become an even better speaker and to help you move towards a near-native level of English. In English Masterclass you can find tips for understanding English as it is really spoken, and see how words and phrases are used in authentic news stories and headlines in News Review. We bring you multiple uses of key vocabulary items in our story programmes and Tim's Pronunciation Workshop is up and running!
If your level of English is around C1, this video-based 30-unit course brings you the tools you need to take your English further. Dan and Finn have got lots of precious 90-second nuggets of information in English Class, while over in Stop Saying, Tim and Helen help you correct those little mistakes that stop your English sounding more natural. We take a good look at the words making the news in News Review - and the big stories of the week crop up in LingoHack. And after all that excitement, we've got functional English on the menu in our drama series The White Elephant.
If you are studying English at intermediate level or thereabouts, this course is for you. There are a total of 30 units in the course, with 5 sessions in each Unit, including 6 Minute Grammar, 6 Minute Vocabulary and drama. We'll also bring you lots of articles, audio and video clips alongside materials created specifically for you by our in-house team of language experts, so that unit by unit, session by session you will be able to Excellerate your grammar, vocabulary, pronunciation and comprehension of written and spoken English.
If your level of English is around lower intermediate, this course is for you. There are 30 units in the course. Each unit is based around a particular course and explores grammar and vocabulary related to that course as well as helping you to Excellerate your skills and pronunciation. You can find all our most popular features including 6 Minute Grammar, 6 Minute Vocabulary, and News Report, as well as lots of interactive materials based on original BBC audio and video, created just for you by our in-house team of language experts.
Shakespeare Speaks is a brand new series of 20 animated, voiced shorts produced by BBC Learning English in partnership with The Open University.
Popular English phrases and expressions, coined by William Shakespeare yet still very much used today are brought to life, explained and practised by The Bard himself with the help of a cast of imagined characters from Shakespeare’s life and times.
Each episode explains the meaning and use of a well-known modern English expression that originally appeared in Shakespeare’s work, such as:
o The world’s mine oyster
o A tower of strength
o In a pickle
o All that glisters is not gold
o As dead as a doornail
Features
This section of the website is mainly for our higher level learners. Here you'll find our most popular programmes. Pick up a bunch of new words with our weekly topical chat 6 Minute English. Find out the meaning of real English expressions - that don't always make it into the dictionary - in The English We Speak. Catch up on the news with News Report and our video news product LingoHack, which brings you authentic BBC News every Wednesday. And drama lovers can find our versions of some of the world's best-loved dramas such as Charles Dicken's A Christmas Carol and Lewis Carroll's Alice's Adventures in Wonderland.
In the Features area, you can also find our Pronunciation section, bringing you plenty of videos and activities to help you Excellerate your pronunciation, whatever your level!
The Learning Circles are a chance for you to help your family and friends learn English. You are the group leader. Follow the links in each session to obtain the different materials. They will take your group through the everyday English they need to survive in the UK.
There is a Trainer's Guide that will tell you how to run a Learning Circle and twelve fun sessions. With each one, you can learn new words with flashcards, watch and discuss videos about everyday life, discuss how to solve problems, learn some useful everyday phrases and play some games to practise what you have learnt. Have a great time!
In the first session you will find a video guide for group leaders on how to run a Learning Circle. This will explain what to do at each stage of the Leader's Session Plan.
Learning Circles are part of English My Way. If you would like to find out more, or to recommend classes to a friend or member of your family, visit this site.
We are interested to hear what you think about the site and the types of materials that you would be interested in. Please feel free to write to us using our contact us form.
Prepare for the career you want by enrolling in an associate degree program online or on campus. You'll learn from industry experts and gain the knowledge and skills you need to advance in your career. You'll have the support of academic and career advisors who are dedicated to your success, and can take advantage of some of the lowest online tuition rates in the nation.
The benefits of earning your associate degree from SNHU include:
Earning your associate degree at SNHU will help prepare you for entry-level positions or promotion opportunities. Or, you can choose to continue your education seamlessly with one of our bachelor's programs.
Explore our associate degrees today.
Whether you’re looking to get ahead in your current job or break into a new field, earning an associate degree is a great step in taking your career to the next level. Designed to be completed in as little as 2 years – or even faster if you have transfer credits – the associate degree is an attractive option for learners looking to further their education.
With the job market becoming increasingly difficult to maneuver, earning an associate degree can open doors to new opportunities. According to the U.S. Bureau of Labor Statistics, jobs requiring at least an associate degree are expected to rise 11% from 2016-2026.*
After taking time off school and struggling to find her niche in healthcare, Emma Gilbert ’14 decided to branch out and enroll in an associate degree program at SNHU. “My supportive husband suggested I should take some courses in business administration to broaden my scope of practice,” she said. Shortly after beginning her schooling, Gilbert received a job offer.
Her story isn’t a coincidence, either. On average, people who have earned an associate degree are less likely to be unemployed than those who didn’t pursue a degree beyond high school.**
It isn’t just entry-level job seekers who are affected by the demand for candidates with college degrees. Increasingly, adults with workforce experience are enrolling in associate degree programs to help advance their careers.
“Recently, I have seen my company leaning more towards people with degrees when considering promotions,” said associate in business administration student Michael Hall. “I decided to step out of the shadows and go back to school for business administration.”
Beyond opening doors to more job opportunities, earning your associate degree is a good way to invest in yourself. On average, associate degree holders earn 17.4% more than those with only a high school degree.**
An associate program is also a great option if you’re on the fence about pursuing your bachelor’s degree. Some students choose to use their associate degree as a stepping-stone to earn general education credits that can later be put toward a bachelor’s program of choice.
When Michele Hale ’17 initially enrolled at SNHU, she had the goal of earning her associate in accounting. After successfully completing the program, she was inspired: “Now with the encouragement of my academic advisor, I am looking forward to enrolling for my BS.”
The good news is when you earn your associate degree at SNHU, choosing to continue your education isn’t a chore – you can seamlessly transfer your credits to one of our bachelor’s programs down the road.
Want to learn how SNHU can help you see yourself succeed? Request information today
If you turn on the TV or radio, you’re likely to hear and see one official after another giving updates on the COVID-19 pandemic. Whether it’s President Donald Trump, Massachusetts Gov. Charlie Baker, Boston Mayor Marty Walsh or others, you’re sure to hear leaders share crucial information — typically all in English, and without interpreters.
What’s being done to reach people whose primary language isn’t English? In a time when an onslaught of vital news changes at a rapid pace, the need to share accurate and clear information with communities who speak languages other than English may be more important than ever.
According to the City of Boston, about 17 percent of its residents 5 and older speak English “less than very well.”
This weekend, the city plans to deliver a document with important coronavirus information in six languages to every door for every resident, said Jerome Smith, chief of civic engagement and director of the Mayor’s Office of Neighborhood Services. It will be in Spanish, Haitian Creole, Chinese, Vietnamese, Cabo Verdean Creole and Russian as well as English. Information in other languages, such as Portuguese and Arabic, will be available on the city’s website.
“What we’re going to be doing is we’re translating all our documentation regarding what is the COVID virus, how to protect themselves, how to take precautions … the food sites that we’re setting up for the school kids so they can get their two meals a day,” Smith said. “We’re gonna put out information regarding the new fund that was created.”
While the city is just trying to get the basic information out right now, Smith said the document they’ll be passing out will direct residents to the city's website for updates. They’ll also have volunteers who will pass out that information in communities where internet access may not be as readily available.
“So this is not going to be just a one weekend thing and then walk away. As this evolves and as more information comes out, we’re going to see more opportunities for volunteers to go out and again to just drop literature the old-fashioned way,” he said. “‘Cause that, we feel, is the best way to get as much information out to the public as we can.”
Other local leaders have also stepped up. State Sen. Sonia Chang-Diaz’s Twitter feed has been filled with information about local resources in both English and Spanish.
The Latina senator from Jamaica Plain said even when there’s not an emergency, she’s always thinking about how crucial information gets out to those who may not speak English well.
“It continues on as a core question for me in the case of a public health crisis but, you know, not just from a sort of equity and justice, but now from a public health standpoint,” she said. “I mean, we as a state are only as healthy and as prepared for this epidemic as are our most vulnerable members of the community. … It’s incumbent upon all of us to make sure we are reaching all places and all peoples.”
Local advocacy groups are also trying to do their part.
Karen Chen, executive director of the Chinese Progressive Association, or CPA, said her community faces cultural and language barriers with the systems in place.
“I think that, you know, on an everyday basis we have been working with community members to even Excellerate things like language access,” she said. “And at the time when there’s no crisis, it’s hard. So you can imagine what it’s like right now.”
Chen said people have contacted the CPA because they need help applying for unemployment benefits.
Suzanne Lee, the president emeritus of CPA, pointed out the lack of access to direct resources locally can lead to inaccurate information getting spread.
“For immigrants, they rely on either friends or organizations or institutions that can do some translation for them … but then you open the door for all these rumors flying around and you don’t know what is real and what is not,” she said.
Chen said City Councilor Ed Flynn, whose district includes Chinatown, has been making sure people have been getting accurate information. Lee also pointed out that State Rep. Aaron Michaelwitz has taken up similar efforts. She said both have used WeChat, a Chinese messaging app, to reach the community.
But Chen and others in the community are still working to make sure their voices are heard.
“So we anticipate to continue to be in contact with the community and then also on the other hand, you know, working with coalitions to advocate to make sure that the vulnerable members of our community gets access to information and resources,” she said.
Register By: December 31 Classes Start: January 02
Develop the accounting and business skills that employers desire with an online Associate of Science (AS) in Accounting from Southern New Hampshire University. The associate degree in accounting is perfect for professionals who want to enter an accounting-related field or lay the groundwork for continuing their education in accounting or business.
Once you earn your associate degree, you'll be prepared to jump into entry-level roles in your industry. You'll learn how to apply financial, managerial and cost accounting principles to your daily work and become an asset to any company.
You'll get practice with accounting tools including Microsoft Suite, Excel, PowerPoint and Word. You'll also have the opportunity to earn certifications in Wiley Excel for Accountants, and identify how Excel can be used for mission-critical tasks such as calculating profits, losses and margins; doing what-if analysis; and analyzing large data sets.
The credits you earn from your associate accounting degree at SNHU seamlessly stack into our online BS in Accounting. This means you can earn 2 degrees in the same time it takes to get just 1. Plus, if you'd like to become a certified public accountant (CPA), our bachelor's program aligns with the 2024 CPA exam update.
No matter where your education takes you, earning your associate degree could be a good investment. According to data from the U.S. Bureau of Labor Statistics, median weekly earnings of those with associate degrees were $154 more than those whose education stopped after graduating high school.1
In the associate in accounting program, you'll learn how to:
If you're interested in higher-level education, check out our bachelor's in accounting degree online.
The online associate degree in accounting provides a solid foundation in accounting principles and practices to prepare you for entry-level positions in nearly every industry. And when it comes to office and administrative support, earning your associate in accounting could position you well for many roles.
According to the U.S. Bureau of Labor Statistics (BLS), bookkeeping, accounting and auditing clerks made a median annual salary of $45,560 in 2021.1 Similarly, financial clerks were reported to make $44,760 in the same time period.1
With your associate degree in accounting, you'll be qualified for these roles and a number of entry-level jobs including:
The technical skills you'll gain from your associate degree in accounting will be integral in these positions. But you might find that being a good candidate for a particular role requires other qualities – like being analytic, inquisitive and proactive.
"Do research, ask questions, keep searching for the whys and what-ifs, and take advantage of opportunities to learn new technologies," said Mona Stephens, accounting lead faculty at SNHU. "Employees who can demonstrate these skills will stand out."
Earning an associate degree can also make a significant financial impact on your life. In 2020, associate degree holders' weekly earnings were almost 20% higher than those of workers who did not continue their education beyond high school, according to the BLS.1 People with associate degrees also experienced lower unemployment rates in 2020 than workers with a high school diploma.1
“An AS degree is a great starting point for those who want to work in a specific field, gain some necessary experience, and continue their education to Excellerate employment longevity,” said Dr. Mark Hobson, an associate dean of business.
If you want to move on to higher-paying roles in accounting, you'll want to continue your education after finishing your associate degree. Our bachelor's in accounting is an obvious next step, but we also provide a myriad of other business degrees – and beyond – that are worth exploring.
That's exactly what Makya Vandiver-Hawkins '21 decided to do after completing her associate degree program.
"I am continuing on to a bachelor’s in business administration with a concentration in accounting because of all of the work that I have completed in obtaining my associate in accounting degree," said Vandiver-Hawkins.
And if the end goal is becoming a qualified accounting professional, a bachelor's degree in accounting can also provide some of the educational requirements necessary to pursue professional certifications such as certified management accountant (CMA) and certified public accountant (CPA). Requirements to sit for the CPA exam vary from state to state. Our licensure and certification disclosure page outlines SNHU's programs and fulfillment of CPA exam requirements by state.
Flexible
With no set class meeting times, you can learn on your schedule and access online course materials 24/7.
Affordable
As part of our mission to make higher education more accessible, we’re committed to keeping our tuition rates low. In fact, we offer some of the lowest online tuition rates in the nation.
Respected
Founded in 1932, Southern New Hampshire University is a private, nonprofit institution with over 100,000 graduates across the country. SNHU is accredited by the New England Commission of Higher Education (NECHE), a regional accreditor, which advocates for institutional improvement and public assurance of quality.
Recently, SNHU has been nationally recognized for leading the way toward more innovative, affordable and achievable education:
Network
At Southern New Hampshire University, you'll have access to a powerful network of more than 300,000 students, alumni and staff that can help support you long after graduation. Our instructors offer relevant, real-world expertise to help you understand and navigate the field. Plus, with our growing, nationwide alumni network, you'll have the potential to tap into a number of internship and career opportunities.
96.5% of students would recommend SNHU (according to a 2019 survey of 9,200+ online students). Discover why SNHU may be right for you.
Expanding access to quality higher education means removing the barriers that may stand between you and your degree. That’s why you can apply at any time and get a decision within days of submitting all required materials:
Acceptance decisions are made on a rolling basis throughout the year for our 6 (8-week) undergraduate terms.
If you’re ready to apply, follow these simple steps to get the process going:
If you have questions or need help filling out your application, call 1.888.387.0861 or email enroll@snhu.edu.
This 60-credit online accounting degree curriculum can deliver you a foundation in essential accounting principles and practices. You’ll understand how to handle a company’s finances, the basics of economics, statistics and how marketing plays a role in the world of accounting. Courses are taught by instructors with professional credentials and experience in accounting, taxation and fraud examination.
Interested in accounting, but afraid of taking math courses? Don't be. According to our instructors, communication skills are more important than being a math whiz when it comes to accounting.
"We have technology to do the math," said Mona Stephens, accounting lead faculty at SNHU. "Accounting is really all about problem-solving and storytelling."
Throughout your studies, you'll gain a foundational understanding of accounting. Some expected courses in your associate in accounting program include:
These courses are taught by instructors with years of experience in accounting and who are committed to helping you earn your degree.
"The instructors at SNHU are remarkable," said Tabitha Paige Tillery '20. "They made sure that you knew they were there for you. Didn't matter the hours I was doing my schoolwork, someone was always there to help."
Akeda Toby-Locke '19 agreed.
"My instructors were always one call or email away when I had concerns or questions about my courses," she said. "They guided me on completing my assignments to their expectations and the best of my ability, and shared helpful resources and information that provided additional knowledge and insights about the courses."
No matter the course, our instructors can help equip you with the relevant specialized accounting skills you need to start a career in accounting.
But according to our own faculty, accountants need to be more than just technically proficient in accounting.
"The accountant of the future needs to be intellectually curious, always learning, able to figure out how to solve problems, analyze and visualize data, and effectively communicate with non-accountants," said Stephens. "A great way to start is to hone those intellectual curiosity and problem-solving skills."
That's why the associate accounting curriculum integrates other general education and business-related knowledge. Major courses include some less expected classes such as:
When you graduate with your associate degree in accounting, you can count on having both widely applicable skills and highly specified accounting knowledge. This means you can go on to pursue entry-level jobs or more advanced degrees in any number of fields.
Curriculum Requirements & Resources
Courses May Include | ||
---|---|---|
AS in Accounting | ||
ACC 201 | Financial Accounting | Students will learn the steps of the accounting cycle and how to prepare financial statements in accordance with industry established rules and regulations. Students will develop skills needed to analyze financial accounting information, communicate this information to stakeholders, and understand the accounting procedures that produce this information. |
ACC 202 | Managerial Accounting | Students will explore the financial impact of short-term and long-term business decisions. By learning how accounting and other productivity information can be used to assess and Excellerate performance of an organization, managers will be provided the essential information they need to execute growth strategies and select opportunities that create business value. |
ACC 317 | Intermediate Accounting I | In this course, students will take an in-depth look at financial statement elements and the interplay of various financial transactions represented on a financial statement. Students will apply theoretical frameworks and research accounting principles and concepts for the proper preparation and interpretation of financial statements. Students will utilize authentic industry tools and technologies to prepare financial statements and connect concepts learned to the importance of financial information for its users. |
ACC 330 | Federal Taxation I | In this course, students will learn about current US tax laws and the Internal Revenue Code (IRC), as well as the relevant source documents, associated with federal tax returns for individuals. Students will research and apply the appropriate tax laws in relation to the specific circumstances and tax liabilities. Students will prepare federal tax returns and communicate various tax return information to stakeholders. |
BUS 210 | Managing and Leading in Business | Students will explore leadership and management theories and how to incorporate them in one's own personal style for effective contribution and collaboration in diverse team environments, and learn about the skills necessary to lead in various organizational structures and areas of business. Students will also examine how the functional areas of business are interrelated and work together in organizations. |
BUS 225 | Critical Business Skills for Success | Students will learn the critical business skills required for successful leadership and management in organizations. By applying business research skills and data analysis, students will solve problems and support business decisions. Students will also explore various techniques and forms of professional communications and their uses in business contexts. |
Total Credits: 60 |
Component Type |
PC (Windows OS) |
Apple (Mac OS) |
---|---|---|
Operating System |
Currently supported operating system from Microsoft. |
Currently supported operating system from Apple. |
Memory (RAM) |
8GB or higher |
8GB or higher |
Hard Drive |
100GB or higher |
100GB or higher |
Antivirus Software |
Required for campus students. Strongly recommended for online students. |
Required for campus students. Strongly recommended for online students. |
SNHU Purchase Programs |
||
Internet/ Bandwidth |
5 Mbps Download, 1 Mbps Upload and less than 100 ms Latency |
5 Mbps Download, 1 Mbps Upload and less than 100 ms Latency |
Notes:
As a private, nonprofit university, we’re committed to making college more accessible by making it more affordable. That’s why we offer some of the lowest online tuition rates in the nation.
We also offer financial aid packages to those who qualify, plus a 30% tuition discount for U.S. service members, both full and part time, and the spouses of those on active duty.
Online Undergraduate Programs | Per Course | Per Credit Hour | Annual Cost for 30 credits |
---|---|---|---|
Degree/Certificates | $960 | $320 | $9,600 |
Degree/Certificates (U.S. service members, both full and part time, and the spouses of those on active duty)* | $675 | $225 | $6,750 |
Tuition Rates are subject to change and are reviewed annually. *Note: students receiving this rate are not eligible for additional discounts.
Additional Costs No Application Fee, $150 Graduation Fee, Course Materials ($ varies by course)
Yes, you can. An associate degree in accounting is a great way to jumpstart an accounting career and can help you gain professional experience faster.
While many accounting jobs require a bachelor’s degree, an accounting associate degree will deliver you the skills you need to succeed in entry-level roles. The credits you earn from an AS in Accounting degree from SNHU can also easily stack into a BS in Accounting – meaning you could earn 2 degrees in the same amount of time it takes to get 1.
With an online associate degree in accounting, you’ll gain a strong foundation of key career skills through general education courses, including communication, critical thinking, problem-solving and decision making.
You’ll also explore accounting, finance and business topics, and learn how to apply this knowledge to daily accounting work. Your accounting associate degree will explore:
It depends on your career path. While earning an associate degree in accounting can help you earn more than workers without a college degree, specific salaries will vary.
The median annual salary for bookkeeping, accounting and auditing clerks, for example, was $45,560 in 2021.1 The highest paid 10% in this field earned more than $61,980.1 Financial clerks earned a median salary of $44,760 and bill and account collectors earned a median salary of $37,700 the same year.1
Continuing your accounting education with a bachelor’s degree, online master’s in accounting, accounting certification or a graduate certificate in accounting can open up more job opportunities and lead to higher pay.
The best online college for accounting is the one that prepares you for the career you want and offers the flexibility to help you achieve your goals, whether you’re working full time or balancing coursework with family obligations.
That's why Akeda Toby-Locke '19 chose Southern New Hampshire University.
"In the beginning, I was very nervous, as this was my first time studying online," she said. "But as time went by, it became my norm, and I really enjoyed the flexibility to study and complete my assignments by the specific deadlines on my time."
At SNHU, the online associate in accounting is designed to deliver you the skills you need to get started in entry-level accounting jobs faster. And our innovative online programs ensure you have the support you need to complete your degree.
Online students have access to a wide range of virtual student services, including writing help, tutoring and academic and career advising.
During her associate degree program, Makya Vandiver-Hawkins '21 relied on these resources and the continuous support of her SNHU community to help her earn her degree.
"Studying online was, at times, difficult when there were times that I needed to have someone by my side walking me through something," said Vandiver-Hawkins. "Thankfully there is 24/7 tutoring that I took advantage of during these times."
Online clubs and student organizations are also offered to help you grow your personal network and get hands-on learning experience.
SNHU’s generous transfer policy allows up to 45 credits from a previous institution to be applied to one of our associate degree programs. If you’ve completed some college coursework already, this means you can save money and time, and start your career even faster.
If you want to start your accounting career right away, then yes. With an associate in accounting, you can gain the skills you need to kick off an accounting career and start gaining valuable professional experience faster.
“In the current employment market, more students are seeking degrees and credentials on a faster pace to meet the needs of employers," said Dr. Mark Hobson, an associate dean of business.
Earning an online associate degree in accounting can also help boost your long-term earning and career potential.
According to the U.S. Bureau of Labor Statistics (BLS), associate degree holders earned nearly 20% more each week in 2021 than workers with only a high school diploma.1 Workers with an associate degree also saw lower unemployment rates in 2021, at just 4.6% compared to 6.2% for workers with a high school diploma.1
But there's more to an associate degree in accounting than just earning potential. It's an opportunity to put your goals within reach.
"[This program] helped me get a degree that I can use and helped prove to myself that I could accomplish anything," said Tabitha Paige Tillery '20.
If you want to advance your career even further, earning an associate degree can deliver you a head start toward earning a bachelor’s in accounting degree. An SNHU bachelor’s degree in accounting can provide the educational requirements needed to pursue valuable professional certifications, like certified management accountant (CMA) and certified public accountant (CPA).
It varies based on your specific role and the industry in which you work. For example, the median annual salary for bookkeeping, accounting and auditing clerks was $45,560 in 2021, or about $21.90 per hour for full-time workers.1
But pay varied for bookkeeping, accounting and auditing clerks depending on the industry in which they worked. Bookkeepers working full time in finance and insurance earned a median salary of $46,910 in 2021, while full-time bookkeepers working in retail earned a median wage of $37,710 in that same time period.1
Accountants earned a median salary of $77,250 in 2021.1 But these jobs typically require a bachelor’s degree or master’s degree in accounting, and may require a professional certification.
Yes, they are. As technology evolves and more of our daily lives move online, students and employers alike are recognizing the value of an online degree.
Online learning continues to grow in higher education. According to the National Center for Education Statistics, some 75%, or 11.8 million, undergraduate students were enrolled in at least one distance education course in the Fall of 2020 as a result of the COVID-19 pandemic, while another 44%, 7 million, took exclusively distance education courses. While this number has come down since the peak of the pandemic, some aspects of distance education are expected to stay in schools across the U.S. for the foreseeable future. In many ways, online learning was normalized in a permanent way as a result of the pandemic.2
At SNHU, we have been offering online coursework for over 25 years. Our online accounting courses are taught by faculty with years of experience in the field, ensuring you have access to the most up-to-date information and accounting practices. And while your coursework may be online, you’ll gain key career skills through hands-on learning opportunities, so you can apply your learning to the day-to-day work of accounting right away.
Southern New Hampshire University is a private, nonprofit institution accredited by the New England Commission of Higher Education (NECHE) as well as several other accrediting bodies.
This program and its concentrations are accredited by the Accreditation Council for Business Schools and Programs (ACBSP). Student achievement data can be found on College Navigator.
Whether you want to start your own business or help existing companies grow, earning a business degree is a great first step toward a career in finance, marketing or business management. Learn more about what you can do with a business degree.
Business administration is a versatile field of study that can be applied to many different career paths. Holders of bachelor's degrees in business enjoy good job prospects and career options.
The four Ps of marketing refer to the traditional elements surrounding a service or product that a business owner or marketer has to consider and evaluate to succeed. Although the four Ps are still relevant, there's a lot more to consider when developing a marketing strategy.
1Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook, on the internet, at:
2National Center for Education Statistics, Distance Learning Fast Facts, on the internet, at https://nces.ed.gov/fastfacts/display.asp?id=80 (viewed July 13, 2022)
The English Garden is a recreational dream for all hobby athletes: cyclists and joggers train on 78 kilometers of paths. In spring, summer and fall, tightrope walkers stretch their slacklines between trees, Frisbee players throw their discs and amateur kickers meet for soccer.
You shouldn't necessarily be a pro, but you should be an expert if you dare to go surfing at the southern end of the Eisbach. There, the surfers show their tricks in the cold water at any time of the year - under the views of many spectators.
The Kleinhesseloher See lake at the border of the northern English Garden is lively sometimes and relaxed at other times. The lake is not suitable for swimming, but you can spend a perfect day on the water with a rowing or pedal boat. Hundreds of people like to sit at the shore, not just during summer.
In the northern part of the park, you'll always see groups of people doing yoga or Thai Chi. Also, all horse lovers would be excited to visit, because asides a selection of riding trails, the university's riding school is located here.