Google updates Search Console

Google has been testing the new version of search console in beta for a few months and will now start making it available to all verified users. Users will receive a message once their site is available in the new Search Console.

Functionality will include redesigned Search Performance and Index Coverage, as well as AMP status and Job Posting reports. Users will welcome the expansion of data in Search Performance to 16 months, making it easier to analyze long term trends. Google has also added the ability to share reports internally within an organization, to simplify internal knowledge sharing and collaboration.

While #Google continues work on adding features the two versions will exist side by side, and users will be able to move easily between the old and new Search Console via links in the navigation bar.

Search Performance

Search performance is similar to the current Search Analytics. It has 16 months of data, which is something users have been requesting. The data will also be made available via the Search Console API in the near future.

Search Performance

Search Console gives full details about the Search Performance feature.

Index Coverage

The updated Index Coverage report gives a comprehensive insight into how your site is being indexed by Google and makes it easy to find tools to test and resubmit URLs. Google says:

“It shows correctly indexed URLs, warnings about potential issues, and reasons why Google isn’t indexing some URLs. The report is built on our new Issue tracking functionality that alerts you when new issues are detected and helps you monitor their fix.”

Index Coverage

Google’s screenshot outlines the process in these numbered steps:

1.Clicking any error URL brings up page details and links to diagnostic tools to help understand the source of the problem.

2.The new Share button in Search Console lets you share the report within your team to facilitate a fix.

3.Select a flagged issue and click on Validate Fix to confirm you’ve resolved the problem. Google will recrawl and reprocess the URL with higher priority.

4.Google says the Index Coverage report works best for sites that have submitted a sitemap. You can use the sitemap filter to focus on an exact list of URLs.

Search Console’s report on Index Coverage gives more details.

The AMP status and Job Posting reports also focus on providing error data. You’ll be able to see which AMP urls have errors, get diagnostic help, and resubmit once fixed. For those with job listings on their site, the Job Posting report will show indexing stats and any errors.

For full details on the new Search Console rollout, see Google’s blog post.

#ABCO #Technology teaches a comprehensive program for web design. Call our campus between 9 AM and 6 PM Monday through Friday at: (310) 216-3067

Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who qualify for funding.

ABCO Technology is located at:
11222 South La Cienega Blvd. STE #588
Los Angeles, ca. 90304

Build successful web pages today!

The State of Mobile User Experience

The State of Mobile User Experience
By Charles Pascal

Summary: Ten years from the original iPhone, the field of mobile UX has finally reached maturity.

The original iPhone was released in June 2007. In late 2009, when ABCO Technology wrote the research for the first article of our mobile report, most people still had primitive mobile devices with horrible user experience. At the time, anything that was half-way decent was a pleasant experience compared with the misery caused by most mobile devices and most mobile sites.

Three years ago, when the second article of the mobile report came out, we did a thorough evaluation of the state of mobile usability. At the time, we were happy to report that mobile usability was no longer an oxymoron— and we finally saw many sites and apps with decent usability. With the new third 2018 article of our mobile-UX research report, we continue to see progress.

Today, most mobile sites and applications offer a good user experience. There are still the occasional glitches and sacrifices of usability in favor of aesthetics, but we can confidently say that the field has progressed in the past two years since the last article. Most of the egregious errors are not there anymore. When we tried to update the examples for many of our mobile guidelines, we discovered that the companies had fixed their problems and some of the issues that we discussed were no longer common. Yet we also encountered revivals of problems we thought almost extinct two years ago. In the business of usability, mistakes (like trends) tend to be cyclic: one generation identifies them and creates design patterns that avoid them, but later generations, no longer having witnessed the UX problem, make the same error again in their quest for refreshed designs. It’s always two steps forward and one step backward.

Content vs. Chrome

The importance of prioritizing content over UI elements (that is, chrome) was one of the lessons learned from responsive design. The hamburger-menutrend was a consequence of that lesson: designers were trying to minimize the number of UI elements visible on the screen because these took away precious content space. Two years later, designers continue to value the screen real estate on mobile devices — but they’ve reached measure in hiding the chrome. A break has been put on the hamburger trend. It’s still very widespread (as we argue elsewhere, hidden navigation is the only option for some sites), but many have understood that it should not be used if a better pattern (such as a visible navigation bar) is available.

Prioritizing content over chrome has trickled in other design areas: for instance, we no longer see results pages headed by fat filters that occupy half the page. Or, the nested-doll pattern, which involved having users make a sequence of selections through multiple pages before encountering content, is no longer as popular as it used to be. At least some companies have started to understand that it’s better to flatten the navigation structure on mobile: show people a variety of content right away and allow them to later narrow it down to a specific category of interest.

Walgreens.com used the nested-doll navigation pattern, which used to be popular in the past but is becoming less widespread. It required users to make 4 category selections before they could see any products. However, Walgreens tried to create the illusion of content by adding product images to the some of the category-selection pages, which suggests that designers were likely aware of the tedium of this category-based design.

#Google Express for iPhone: Instead of listing all the subcategories under Grocery, a few items were displayed under each. Instead of using a category-based design where users had to decide among different categories, the app rightly used a content-based design.

Use of Gestures

Gestures solve the problem of too much chrome on a too small screen, but they are notoriously hard to discover and learn. Some of the original gesture enthusiasm (embodied by gesture-only apps such as Clear Todos) has dampened down, but gesture use is still one of the more promising directions in mobile design.

Clear Todos for iPhone, whose first version appeared around 2012, used a variety of gestures to compensate for the lack of visual interface elements. These gestures were hard to remember.

Unfortunately, gestures are a chicken-and-egg problem: they won’t become easy to learn and use until a standard vocabulary of gestures used across apps and websites is built, and all applications and websites use these gestures consistently. But, on the other hand, designers are forced to stay away from gestures because they have so little familiarity among their user base.

Apple has had multiple attempts to expand the standard vocabulary of gestures (with the introduction of 3D Touch for iPhone 6S) and to delegate some of the visible chrome to gestures. Their attempts have culminated with the iPhone X — which got rid of the iPhone’s only physical button to replace it with a series of swipe gestures. The result has been a more effective use of the screen at the expense of some initial learning hurdles for people used with the old Home button.

#3D Touch was a promising direction, but it is still relatively rarely used by applications. However, two other (old) gestures are increasing in popularity to the point of being added to that basic gesture vocabulary: the swipe-to-delete for exposing some contextual actions including delete, and the two-finger scroll for moving around a map embedded on a webpage. While the swipe-to-delete simply adds a convenient way to perform contextual actions on a list element, the two-finger scroll solves the problem of swipe ambiguity, often encountered when maps are embedded in web pages. These gestures are becoming more and more familiar to users, although we still recommend that designs which use them add other redundant ways to perform the same actions or at least have good contextual tips to guide users.

The two-finger scroll gesture is becoming a standard for map scrolling and solves the problem of swipe ambiguity (where users attempt to scroll the page and accidentally scroll the map or viceversa).

Better Integration Between the Mobile Web and the App Web

Transitioning from the web to an app used to require a specific user action: on iOS, people had to explicitly choose to open an app and then perform a search inside it. From iOS 9 on, it’s become possible to easily transition between the mobile web and the app web— if I search for a movie in a search engine, some of the search results will seamlessly open corresponding application pages (when users have these applications installed).

When a link to a movie on the search-results page was selected, the control moved from Safari to the iMDb app. The Back-to-appbutton was displayed in the top left corner of the status bar and was labeled with the name of the previously used app (Safari).

This seamless transition from browser to app, or, more generally, from one app to the next ensures that the experience of consuming content is optimal — because, most often, applications will have a better user experience than sites(simply because they are closer to the mobile platform for which they were designed).

Unfortunately, with this design we also see a new burden placed on users: that of keeping track of where they are and knowing how to navigate back. Applications still have to accommodate that need — for example, we still notice that many apps (like iMDb above) do not include logos on their deep pages, which makes it more difficult for users to orient themselves in this new expanded app-plus-web universe.

A notable improvement, possibly related to the increased ease of switching from browser to app, has been a lower number of interstitial app ads. (Almost) gone are the days when navigating to a new site was preceded by an interstitial inviting the user to download the app. Most of the time, the app is simply advertised in a banner at the top of a web page.

Better Use of Phone Features

Although not perfect, more and more sites and apps take advantage of basic phone functionality. Checking out on many ecommerce sites has become a breeze due to integrated systems like Apple Pay and Android Pay. And most sites and apps take into account the user’s current location. Biometric authentication promises to get us closer from the problem of remembering passwords, and can even make desktop login easier by allowing users to easily transfer information (and thus automatically log in) across devices.

When setting up a new iPhone, there was no need to type in credentials to authenticate: they were automatically transferred from a nearby device.

Fewer Tutorials: Stagnation

A few years ago, any respectable app started with a lengthy tutorial that catalogued all the different features available in the app. These tutorials were at worst annoying and at best ineffective — no user could remember the plethora of commands listed in a lengthy tutorial. Nor were they motivated to remember any of them — after all, who could say in advance what features would be actually useful?

Today, those tutorials have been largely replaced with general overviews of the apps, meant to convince the user to go beyond the login walland create an account. Ideally, these login walls should disappear completely and users should be able to experience the app without having to register at all. The initial app overviews play the function of an ad — and most people hate to have to sit through an ad, especially if they’ve already spent the effort to download the app.

Steps Backward

Although overall the responsive-design trend has been a positive influence, the quest for building across multiple interaction modalities has pushed some towards strange solutions like using a split-button for menus or accordions. The intent behind the split-buttonmenu is to replicate desktop’s hover-plus-click interaction for categories in the main navigation — that is, to allow access both to a category landing page and to a submenu. Yet it is a highly unusable solution — not only because it crams two targets in a small space and makes the job of acquiring each of them more difficult for human fingers, but also because it violates users’ expectations and the mobile patterns that they have learned so far.

Another somewhat surprising development has been the disappearance of guest checkout. Sites and apps that used to offer this functionality in the past have eliminated it — some rely on Check out with Apple Payor Check out with PayPalto compensate for the lack of guest checkout. But many still force users to create an account although they may be one-time purchasers. On the plus side, registration has been simplified in many designs — it is fairly common nowadays to be asked only for an email and a password in order to create an account.

The popularity of the overlay has increased, with many sites implementing menus as overlays. Two years ago, many mobile overlays were buggy and created funny effects (such as content behind the overlay suddenly appearing on top of it). Today’s overlays are much better. But they often look like full pages, and people treat them as such — expecting to be able to use the Backbutton to close them and navigate back to the previous view. Often, they get disoriented when that does not happen and instead they are spit out of the site. When an entire flow is moved in overlays (as it is the case with the increasingly popular sequential menus), the opportunity for errors increases even more, with people forgetting to use the menu’s Back button to ensure correct navigation in the overlay and instead using the browser or the phone’s Backbutton.

LATimes.com: The menu was displayed in an overlay that looked like a new page (left). In spite of the Closebutton in the top left corner, people will still be tempted to tap the browser’s Backbutton to close the overlay. If they did so, they would be taken to the previously visited page (the search-engine page — right) instead of to the LA Times homepage.

Conclusion

Ten years from the first iPhone, the field of mobile user experience has finally reached a reasonable level of maturity. It was about time — according to a recent report by comScore, in many parts of the world, more than half of the online time is spent on mobile. So it’s only right that mobile usability catches up with desktop usability. It doesn’t mean that mobile sites and apps have reached a state of usability perfection: there’s no such thing as a perfect design. It simply means that a lot of them offer a decent user experience, and that many flagrant errors of the past have been fixed.

ABCO Technology teaches a comprehensive course for E-commerce. Call our technical college campus today. You can reach us between 9 AM and 6 PM Monday through Friday at: (310) 216-3067.

Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who qualify for funding.

ABCO Technology is located at:
11222 South La Cienega Blvd. STE # 588
Los Angeles, Ca. 90304

Build highly successful webpages today!

Google’s assistant competes with Amazon

Amazon Echo and its voice assistant, Alexa, might be the current market leaders in voice-activated smart technology, but recent announcements from the 2018 Consumer Electronics Show have shown that Google fully intends to challenge Amazon for that crown.

The past few days have seen some big developments – and a couple of even bigger teasers – for the future of Google’s smart assistant, the imaginatively-named Assistant.

On Tuesday, the first day of CES 2018, Google published a post to its official blog announcing partnerships with more than a dozen electronics companies to produce Google Assistant smart speakers – some with a very significant upgrade.

The blog post also highlighted the breadth and depth of “Actions”, the name given to built-in apps and integrations for the Google Assistant. At the same time, Search Console users began receiving notifications that their podcast, recipe and news content was eligible to be included in a new “Actions directory”, which is being rolled out over the next few days.

This appears to be part of an increased focus on what can be accomplished with Assistant, shifting its emphasis from finding information (Google’s long-time speciality) to carrying out tasks.

There’s a lot of news to unpack, so let’s look at what exactly these developments involve, and what they mean for SEOs and the wider industry.

SEOs using structured data are first to the Google Assistant party

While a comparatively smaller development than the flashy revelations of major electronics partnerships and smart displays, Google’s introduction of native support for podcasts, recipes and news to the Assistant is nevertheless big news for SEOs.

I owe a hat tip to Aaron Bradley of SEO Skeptic, whose post to the Semantic Search Marketing Google+ group first tipped me off to this development. In turn, he was tipped off by SEO consultant Dan Shure, who tweeted about a Google Search Console alert he’d received inviting him to “improve discovery” of his podcast in the Google Assistant

Google is gradually rolling out a browsable directory of Actions for the Google Assistant, allowing users to more easily discover what the Assistant is capable of.

Podcasts, recipes and news will be the first wave of content added to this directory – though only content published with AMP, or marked up with structured data such as Schema.org, will be getting the nod.

This means that webmasters and SEOs who have been marking up their content with structured data are already ahead of the curve in making that content available via voice – while those who haven’t must hop on the structured data (or AMP) bandwagon if they want to be eligible.

Structured data has long been touted by its fans as a great way to get search engines to better surface content from your site, particularly in the form of things like rich snippets or Quick Answers. But it can be time-consuming to add and maintain, and the immediate benefit isn’t always so obvious.

This new use case, however, shows that there is a huge potential advantage to “future-proofing” your website by adding structured data markup. If Google continues to make Assistant a primary focus going forward, then this could be the key to content optimization and discovery in a voice-driven world.

Hey, Google – look what I can do!

As discussed, Google is clearly keen to shift the focus of its voice capabilities away from information discovery towards actions.

To this end, it’s heavily promoting “Hey, Google” as the slogan for the Google Assistant, placing it in huge letters on top of its CES installation, and creating a #HeyGoogle Twitter hashtag (complete with a unique Assistant emoji) to accompany their Assistant-related updates.

But wait, you might be thinking – isn’t “OK Google” the wake phrase for the Assistant?

Yes, Google has been a bit unclear on this point, but it seems that “Hey, Google” has been an alternative wake phrase for the Assistant for a while now. In late 2016, the website Android Police reported that the Google Home responds to both “OK Google” and “Hey, Google”, but Google voice search (e.g. on mobile) responds only to “OK Google” – making it possible to differentiate if you have multiple devices within earshot.

Now, as Google moves its focus away from search and towards actions, “OK Google” is out and “Hey, Google” is in.

#ABCO #Technology teaches E-commerce courses in its web design program. Voice search is powerful and you need to get onboard with it now! Call our campus between 9 AM and 6 PM Monday through Friday. You can reach us at: (310) 216-3067.

Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who qualify for funding.

ABCO Technology is located at:
11222 South La Cienega Blvd STE #588
Los Angeles, Ca. 90304

Get started marking your pages for voice search today!

#Amazon Echo and its voice assistant, Alexa, might be the current market leaders in voice-activated smart technology, but recent announcements from the 2018 Consumer Electronics Show have shown that Google fully intends to challenge Amazon for that crown.

The past few days have seen some big developments – and a couple of even bigger teasers – for the future of Google’s smart assistant, the imaginatively-named Assistant.

On Tuesday, the first day of #CES 2018, Google published a post to its official blog announcing partnerships with more than a dozen electronics companies to produce Google Assistant smart speakers – some with a very significant upgrade.

The blog post also highlighted the breadth and depth of “Actions”, the name given to built-in apps and integrations for the Google Assistant. At the same time, Search Console users began receiving notifications that their podcast, recipe and news content was eligible to be included in a new “Actions directory”, which is being rolled out over the next few days.

This appears to be part of an increased focus on what can be accomplished with Assistant, shifting its emphasis from finding information (Google’s long-time speciality) to carrying out tasks.

There’s a lot of news to unpack, so let’s look at what exactly these developments involve, and what they mean for SEOs and the wider industry.

#SEOs using structured data are first to the Google Assistant party

While a comparatively smaller development than the flashy revelations of major electronics partnerships and smart displays, Google’s introduction of native support for podcasts, recipes and news to the Assistant is nevertheless big news for SEOs.

I owe a hat tip to Aaron Bradley of SEO Skeptic, whose post to the Semantic Search Marketing Google+ group first tipped me off to this development. In turn, he was tipped off by SEO consultant Dan Shure, who tweeted about a Google Search Console alert he’d received inviting him to “improve discovery” of his podcast in the Google Assistant

Google is gradually rolling out a browsable directory of Actions for the Google Assistant, allowing users to more easily discover what the Assistant is capable of.

Podcasts, recipes and news will be the first wave of content added to this directory – though only content published with AMP, or marked up with structured data such as Schema.org, will be getting the nod.

This means that webmasters and SEOs who have been marking up their content with structured data are already ahead of the curve in making that content available via voice – while those who haven’t must hop on the structured data (or AMP) bandwagon if they want to be eligible.

Structured data has long been touted by its fans as a great way to get search engines to better surface content from your site, particularly in the form of things like rich snippets or Quick Answers. But it can be time-consuming to add and maintain, and the immediate benefit isn’t always so obvious.

This new use case, however, shows that there is a huge potential advantage to “future-proofing” your website by adding structured data markup. If Google continues to make Assistant a primary focus going forward, then this could be the key to content optimization and discovery in a voice-driven world.

Hey, Google – look what I can do!

As discussed, Google is clearly keen to shift the focus of its voice capabilities away from information discovery towards actions.

To this end, it’s heavily promoting “Hey, Google” as the slogan for the Google Assistant, placing it in huge letters on top of its CES installation, and creating a #HeyGoogle Twitter hashtag (complete with a unique Assistant emoji) to accompany their Assistant-related updates.

But wait, you might be thinking – isn’t “OK Google” the wake phrase for the Assistant?

Yes, Google has been a bit unclear on this point, but it seems that “Hey, Google” has been an alternative wake phrase for the Assistant for a while now. In late 2016, the website Android Police reported that the Google Home responds to both “OK Google” and “Hey, Google”, but Google voice search (e.g. on mobile) responds only to “OK Google” – making it possible to differentiate if you have multiple devices within earshot.

Now, as Google moves its focus away from search and towards actions, “OK Google” is out and “Hey, Google” is in.

ABCO Technology teaches E-commerce courses in its web design program. Voice search is powerful and you need to get onboard with it now! Call our campus between 9 AM and 6 PM Monday through Friday. You can reach us at: (310) 216-3067.

Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who qualify for funding.

ABCO Technology is located at:
11222 South La Cienega Blvd STE #588
Los Angeles, Ca. 90304

Get started marking your pages for voice search today!

Top tips for voice search and mobile usage

Voice search and mobile usage are both on the rise and look set to shape the SEO industry for some time to come. Nonetheless, 62% of marketers have no specific plans for voice search in 2018.

How can marketers take action today to tap into two of the most important trends in the industry?

As mobile usage continues to grow, more and more users are comfortable with speaking to their devices rather than typing their queries.

Of equal importance are the advances in speech recognition technology that have allowed the likes of Google, Amazon, and Apple to offer a satisfying voice search experience.

There is plentiful context to make marketers aware of these emerging trends, with both mobile and voice search set to shape the future of the industry:

◾Voice-enabled personal assistants are installed by default on all smartphones

◾Google has revealed that more than 20% of searches on an Android device are voice searches

◾The Amazon Alexa app recently topped the app store charts. The Google Home app occupied second position

◾The Amazon Echo was once again the best-selling item on Amazon this holiday season

◾Speech recognition accuracy is now north of 95% for all of the major technology providers

◾Google’s mobile-first indexis rolling out and will soon be applied to all sites

◾comScore predicts that 50% of all searches will be by voice in 2020.

Though the two are not perfectly aligned, there is a clear correlation between the growth of voice search and the ongoing rise of mobile.

As the Internet of Things takes off, voice will be one of the most important unifying factors across all hardware. Whether at home, in the car, or at work, there will always be a voice-enabled device close to hand.

And yet, a recent study by BrightEdgereported that 62% of marketers are unlikely to implement a specific strategy for voice search over the next 12 months.

This is not due to a lack of awareness of the trend, but rather a lack of direction when it comes to preparing for its implications.

In a clear indication of how significant the shift to voice-based searches will be, Google recently released a new set of Search Quality Rating Guidelines for the Google Assistant.

Though specific to the Google Assistant, we can safely assume that the same rules and objectives underpin the functioning of other digital assistants too.

As such, this document can prove both illuminating and instructive as we look to move beyond the hype that voice search brings and arrive at some tips to direct our mobile SEOefforts.

The findings in Google’s official guidelines for voice search evaluation, along with the best practices we already have for mobile SEO, can help us create a hybrid set of tips to improve any site’s chances of ranking in this new landscape.

This begins with some technical considerations, then moves on to a more nuanced understanding of how consumers are using voice to interact with their devices. Finally, we must create the right content to fit our target contexts, and find a way to measure our progress.

Technical SEO for mobile devices

As with so many aspects of SEO, crawlability is the foundation upon which a mobile SEO strategy for voice search must be built.

Put simply, if a search engine cannot access and understand your content, your chances of appearing in search results are slim. This as always been important, but it takes on a new level of significance when viewed through the lens of voice search.

Often, voice search removes the traditional search engine results page (SERP) and instead aims to provide one answer in response to a query. This is a search engine’s first port of call; it is only when one answer cannot conclusively answer the query that a more traditional list of results will be displayed.

Fortunately, there are some guidelines we can follow to increase the likelihood of our content ranking via voice search:

◾Schema markup: By adding schema markup, we can help to add structure to our website’s data. For example, we can alert search engines to elements that relate to events, prices, and people – among many others. When a search engine is trying to locate a response to a voice search, this extra information can prove invaluable.

◾XML sitemaps: Having a clearly structure sitemap that can be navigated easily both by people and by search engines will increase the likelihood that your information can be sourced quickly in response to a query.

◾Site structure: The structure of a website should mirror the journeys that users typically take when considering and making a purchase. For example, faceted navigation on an ecommerce site should aim to match common query strings.

◾Carry out a mobile SEO audit: Before embarking on any of the more innovative aspects of voice search, conduct a full mobile SEO site audit to ensure that you are in a solid position.

◾It is also worth reviewing the basics of mobile SEO to keep in mind the distinctions that set it apart from traditional SEO.

Understanding context

All language is contextual. The exact same query, at surface level, can in fact mean many different things based on how, when, where, and by whom it is said.

This is not a new discovery, but it is only recently that search engines have been able to understand the context of a query.

In part, this has been due to more sophisticated algorithms like Google’s Hummingbird update, which brought the concept of semantic searchto life.

However, the biggest source of contextual information is the smartphone. Our phones are constantly sending and receiving data, all of which can be processed to comprehend our past, present, and even our future behaviors.

Now, when a user searches for a term like [canon cameras], a search engine can use smartphone data to understand the implied intent of the query:

cameras

This implicit intent, now known to a search engine, can help to shape and personalize the results that the user sees.

There are other effects of this deeper understanding.

Varied queries can ultimately express the same underlying intent. For example:

sunny

The expression of the response may differ, but all variations are ultimately answering the same question. The user wants to know what the weather will be like tomorrow.

This is helpful, as it allows us to see that we don’t need to answer every single possible query that is out there. Many guides on voice SEO suggest creating FAQ pages as a way to grow traffic, but this seems a stop-gap solution when we can do better. SEO needs to move away from creating “SEO pages” on websites that serve no real purpose other than to attract organic search clicks.

Thus far, our industry has focused mainly on what has been said by searchers. We pull a list of keywords with search volumes, difficulty scores and so on, and we map those to our pages. Where a page does not exist for a group of keywords, we create one.

A further level of nuance can be added by segmenting the keywords by purchase stage: informational, navigational or transactional, for example. These can also be categorized as ‘Know’, ‘Go’, and ‘Do’ moments.

That is useful, but it is overly simplistic. What we often end up with is a comforting illusion; a spreadsheet that smooths over the rough edges to provide a digestible view of what people search for, cell by cell.

Reality does not fit so readily into neat compartments.

In a presentationgiven last year, Tom Anthony of Distilled mapped out what the new ecosystem looks like, based on the huge amount of data a smartphone both sends and receives:

tom_anthony

Even this is a reduction, but it does at least provide insight into the broader picture.

What this means is that when working on a mobile SEO strategy, we should identify the contexts in which our content could rank.

These contexts can be strung together to create a map of the typical user journey.

This can be informed by demographic data, as there are telling differences between the generations. In particular, we should note that younger generations are more comfortable with voice search and use it in very different situations to their older counterparts.

voice_search_today

Stone Temple Consulting produced an excellent, in-depth study that goes further still to segment this data by income. voice search seo incomeSource: Stone Temple Consulting

What we find through this report is that there are notable variations at every level of analysis. By location, gender, device, income level, and age, we find that people use voice search differently.

Marketers would do well to perform research of their own to pinpoint the right contexts for their business to target, through qualitative research and quantitative analysis.

Creating the right content at the right time

Once we have plotted out the potential contexts in which we could communicate with our audience, we need to create the content that will hopefully help us rank via voice search.

Though this is a nascent field, there are already some useful studies that can guide us in this process.

Voice queries tend to be longer, due to their closer relationship to natural speech patterns. This provides a significant amount of data for us to analyze, compared with the shorter queries we have grown accustomed to.

Where once we had to infer a consumer’s intent based on feedback signals (click-through rate, bounce rate, conversion rate), we can now start this process much earlier.

We should also bear in mind the anticipated input-output relationship between the consumer and the device. For example, a spoken query that prompts a spoken response will need to be fed by content that is clear, concise, and conclusive.

Google’s Research Blogoffers the following areas for assessment when it comes to this kind of voice search:

◾Information Satisfaction: the content of the answer should meet the information needs of the user.

◾Length: when a displayed answer is too long, users can quickly scan it visually and locate the relevant information. For voice answers, that is not possible. It is much more important to ensure that we provide a helpful amount of information, hopefully not too much or too little. Some of our previous work is currently in use for identifying the most relevant fragments of answers.

◾Formulation: it is much easier to understand a badly formulated written answer than an ungrammatical spoken answer, so more care has to be placed in ensuring grammatical correctness.

◾Elocution: spoken answers must have proper pronunciation and prosody. Improvements in text-to-speech generation, such as WaveNet and Tacotron 2, are quickly reducing the gap with human performance.

This insight should flow directly into the site experience. If we know which task our consumer is trying to complete, we can make this process and seamless and as painless as possible.

There are some points that apply to any site aiming to create content for voice search:

◾Remember that a voice search is only the start of the user journey. If your mobile site experience does not match the user’s intent, they will complete the journey elsewhere. Use a user-agent switcher or a site like http://mobiletest.me/to see how your mobile experience matches up.

◾Create content that responds to the most common conversational queries. Provide clear information that can easily be picked up by a search engine as it tries to provide one, true answer for each voice query. Tools like Answer the Publicare useful for this task, but try to assimilate this information naturally into your content rather than creating a host of FAQ pages.

◾Map this content to a logical site hierarchy that is crawlable for search engines and useful for consumers.

◾Google is preparing to add voice queries to Search Console, so we will soon be able to assess and track our voice search performance.

Given that voice searches on a mobile device are frequently completed on the go, it should not be surprising that users often want help with navigation.

Interestingly, the growth in the number of ‘near me’ searches has slowed as people have come to expect Google to understand this implied intent.

Google uses its own Maps product to respond to these queries, so we can optimize our own Maps listings to help search engines and people to navigate better. There are a few tips to keep in mind when working on a voice search strategy for local SEO:

◾Ensure that names, addresses and phone numbers are accurate across all locations.

◾Consider using a specialist platform to manage your local listings and monitor your local search performance. There is a growing range of mobile SEO tools that can help with these tasks.

◾Make it easy for consumers to act on their intentions. This means adding in clear calls to action and directions to further information.

What’s next for search?

It is important to understand Google’s vision for the future of search.

The technology has improved dramatically, but it is still some distance from fulfilling the ambitions of Google and Amazon. When this technology reaches its potential, there may be no need for a query at all, as the digital assistant will be able to pre-empt our actions.

For now, marketers need to assist the assistants in the manner outlined above.

In essence, technology is enabling behaviors that have their basis in pre-existing states of intent. The industry is growing in complexity, but simultaneously it is developing into a more realistic representation of how people want to search.

Through better understanding of both people and technology, marketers can create a voice search strategy that will stand the test of time.

ABCO Technology teaches an excellent course for the Certified Webmaster, which includes search engine optimization. Call our campus between 9 AM and 6 PM Monday through Friday. You can reach us at: (310) 216-3067.

Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who qualify for funding.

ABCO Technology is located at:
11222 South La Cienega Blvd STE #588
Los Angeles, Ca. 90304

Build successful voice search webpages today!

Poor website performance is hurting your business

Poor website performance is one of the most widespread problems for business websites, yet it’s the most essential one hurting your company on many levels, from lost customers to a bad online reputation.

These easy-to-use tools will help you solve the problem.

Despite what some people may think, site speed is not a purely technical issue. Marketers have been talking about the necessity to speed up your page load for ages. Not only does poor page load time hurt your site usability, but it also hinders your rankings (by devistating your page engagement metrics), conversions, social media marketing campaign performance and so on.

Fixing the page load time issue is not that simple. It does take a strong development budget and good diagnostics tools. Luckily, I can help you with the latter:

Page Speed Insights

Google’s Page Speed Insights measures your page speed and provides Page Speed suggestions to make your web site faster.

page speed

The Page Speed Score ranges from 0 to 100 points. A score of 85 or above means your page speed is optimal. The tool distinguishes two main criteria: How fast your page above-the-fold loads and how fast the whole page loads. Each page is tested for mobile and desktop experience separately.

Each Page Speed suggestion is rated based on how important it is.

Pingdom

Pingdom monitors your site and reports if your site seems slow or down. It operates a network of over 60 servers to test your website from all over the world, which is very important for a global business website because your server location effects in which parts of the world your site reports well.

Pingdom also has a free tool you can test here. While Pingdom is mostly known as Uptime monitoring solution (you can read about Uptime here), it also does performance monitoring.

Because I monitor a lot of metrics for many websites, I use Cyfe to integrate Pingdom stats into my website monitoring dashboard:

cyfe

WP Super Cache

WP Super Cache turns your dynamic WordPress blog pages into static HTML files for the majority of your users. This way your web server serves static files instead of processing the heavier WordPress PHP scripts.

This plugin will help your server cope with traffic spikes. It makes the pages faster to load, and stops those traffic overloads from happening in the case of a viral hit.

If you operate a huge database-driven website, a better solution for you would be setting up a content delivery network.

Incapsula

Speaking of your website being slow in remote parts of the world, Incapsula is a set of premium tools helping you to solve that problem. The platform offers a reliable Content Delivery Network, i.e. a network of servers all over the world allowing your site visitors to load files from the server located closer to them.

This means your site is fast wherever your future customers choose to load it from.

If you want to know more about how CDN works, here’s a very good resource to read and bookmark.

cdn-for-your-wordpress-blog-infographic

Compressor.io

Compressor.io is a handy tool to optimize your image size to allow for faster page load. As most web pages have images these days, this is a must-bookmark and use tool.

Compressor.io reduces the size of your images while maintaining a high quality. You’ll be surprised to find no difference in your images before and after compression.

The tool supports the following image formats: .jpg, .png, .gif, .svg. I have found it invaluable to animated GIF compression because all the tools I use produce really huge images.

compress

The tool is absolutely free and there’s no need to register to use it. Your files will be stored on the servers for 6 hours and then deleted, so don’t forget to download your optimized images!

If you want to learn how to optimize your website for search engines, call ABCO Technology. We can be reached from 9 AM to 6 PM Monday through Friday. Call us today at: (310) 216-3067.

Email all questions to: info@abcotechnology.edu

Start building search engine optimized websites today!

CompTIA Security + Information

CompTIA’s Security+ is a well-respected, vendor-neutral security certification. Security+ credential holders are recognized as possessing superior technical skills, broad knowledge and expertise in multiple security-related disciplines.

While Security+ is an entry-level certification, successful candidates should possess at least six months of experience working in the areas of network administration and network security. Candidates who want to obtain this certification should consider first obtaining both the A+ and Network+ certification. IT pros who obtain the certificate possess expertise in areas such as threat management, cryptography, identity management, security systems, security risk identification and mitigation, network access control, and security infrastructure. The CompTIA Security+ credential is also approved by the U.S. Department of Defense to meet Directive 8140.-M requirements.

The Security+ credential requires a single exam, currently priced at $311 (discounts may apply to those who work for CompTIA member companies, and to full-time students).

IT professionals who earned the Security+ cert prior to Jan. 1, 2011 remain certified for life. Those who certify after that date must renew the certification every three years to stay current. To renew, candidates are required to pass the most current Security+ exam, pass a higher-level CompTIA exam or complete 50 continuing education units (CEUs) prior to the expiration of the three-year period. CEUs can be obtained by engaging in a variety of activities, such as teaching, blogging, publishing articles or white papers, and participating in professional conferences and similar activities.

Job Outlook for CompTIA Security +

The US Department of Labor states job candidates who have a certification in cyber security, which includes the CompTIA Security + will experience job growth, which is 15% ahead of regular information technology positions in the industry. Organizations large and small are looking for network administration candidates who have a cyber security certification.

The CompTIA Security + certificate informs potential employers that you have the skills to protect their network.
ABCO Technology teaches a comprehensive program for cyber security. One of the courses in this program is the CompTIA Security +. Our next class for CompTIA Security + begins on October 24, 2017.

If you want to obtain a fulfilling career in cyber security, it’s time for you to contact ABCO Technology to receive more information about this cyber security career opportunity. Call our campus between 9 AM and 6 PM Monday through Friday. You can reach us by telephone at: (310) 216-3067.

Email your questions to: info@abcotechnology.edu
Financial aid is available to all students who can successfully qualify for the funding.

ABCO Technology is located at:
11222 South La Cienega Blvd. in STE # 588
Los Angeles, Ca. 90304
Cyber security is a growing field, get trained and certified today!

Cyber Security, your Pizza orders aren’t safe

Pizza Hut’s customers had their online accounts compromised.
Cybercrime is growing at such a rapid rate, even companies selling products as safe as pizza are under cyber-attack. The increase in cybercrime to this level continues to create more cyber security jobs.

Pizza Hut told customers by email on Saturday that some of their personal information may have been compromised. Some of those customers are angry that it took almost two weeks for the fast food chain to notify them.

According to a customer notice emailed from the pizza chain, those who placed an order on its website or mobile app between the morning of Oct. 1 and midday Oct. 2 might have had their information exposed.

The “temporary security intrusion” lasted for about 28 hours, the notice said, and it’s believed that names, billing ZIP codes, delivery addresses, email addresses and payment card information — meaning account number, expiration date and CVV numbers — were compromised. Would you like to be that special person who saved your company from a devastating cyber-attack?

A cyber-attack of this level could only occur if the network administrators didn’t use or have the correct cyber security skills.
The media fails to report that most cyber-attacks occur over time. Before the attacker intruded into Pizza Huts network, a great deal of time was spent in making login attempts, port scanning, analyzing for network weaknesses and stealing passwords. The activity could have been detected if the company had the right tools in place. The fact Pizza Hut was attacked for 28 hours clearly demonstrates someone in cyber security failed to do their job. You could be the network administrator who picks up where those cyber admins left off.

The skills we are talking about in this article involve cyber security. Courses including CompTIA Security +, Certified Ethical Hacker, Linux Fundamentals and Cisco Certified Network Associate will create a library of cyber skills, which will help any network administrator implement cyber security policies.

A thorough understanding of the computer and network servers is also required for this job. The network administrator must think of any network as an electronic eco system. Maintaining such a mindset will go a long way towards preventing the type of cyber-attack, which occurred at Pizza Hut.

If you want to have an exciting career in cyber security, please contact ABCO Technology. Reaching our Los Angeles campus is easy. We are available by telephone from 9 AM to 6 PM Monday through Friday at: (310) 216-3067.

Email all questions to info@abcotechnology.edu
Financial aid is available to all students who can qualify for funding.

ABCO Technology is located at: 11222 South La Cienega Blvd. in STE # 588
Los Angeles, Ca. 90304.

Cyber security is a growing field in information technology. Train for a cyber security position today!

Four Top tips for guest blogging. and

Many people still rely on guest blogging as an ongoing part of their link-building strategy.

If you analyze this for a moment, getting links through guest blogging is much easier than getting links through some other channel.

So it’s no wonder that a lot of bloggers and SEO experts still favor this method. The main question is, are these guest post links still safe and viable?

The answer is yes.

It is very possible to build our link portfolio by contributing on authoritative websites. However, there are certain rules that we need to follow in order to avoid any issues with Google.

Guest blogging 101

One of the beautiful things about guest blogging is that it gives us the opportunity to score some great links from high-tier websites.

To be honest, we probably couldn’t have gotten those links with any other method. This is why guest blogging is always worth bearing in mind as a link-building strategy.

But, we need to be very careful when choosing the websites we guest post for.

Although guest blogging can be carried out on a large scale, you should probably avoid it. This method is optimal in small dosages while cooperating with the biggest domains.

Google trusts authoritative domains. If they notice that your links are coming only from reputable sources, they will not impose a penalty. However…

1) Be Careful not to overdo it!

The biggest problem with guest blogging is that people tend to overdo it.

Your articles should be coming from various sources, with different anchors. If your only source of inbound links is from guest articles, Google will notice this pattern and you will soon get into trouble.

Instead, you should choose your battles carefully. You need to diversify your link profile.

If you already decide to do some guest posting, make sure it counts. Otherwise you’ll waste all that time you spent building up relationships and writing your posts – with only a Google penalty to show for it.

2) Focus on quality

This is where most people go wrong.

Google assesses the articles from which you are getting links. If the article is of high quality, your link will also be regarded as a quality one.

This makes sense, right? After all, why would anyone bother creating a great piece only to place crappy links throughout?

So when you put together a guest post, make sure it’s a good one.

After creating their own article, people try to promote it by writing guest posts. These guest posts will usually be of much lower quality and they will have the same regurgitated content which you published on your own blog.

By doing this, not only are you getting a devalued link, but you are also endangering your original piece. Google will flag up the regurgitated versions of your article as possible duplicate content. And because there are any number of similar, low-quality pieces out there online, it may conclude that your article is low-quality as well.

Everything you create has to be unique and to provide value to the reader. When you write a guest post, ask yourself: would I link to this piece?

If the answer is yes, you are in the clear.

3) Add images, links and formatting

As I mentioned, each guest post you make needs to be distinctive. Even if you are employing this strategy on a larger scale, at least make sure that everything you create is a separate entity.

One of the best ways to differentiate articles is by using varied formatting.

Blogs always have use different fonts and that is something you have no control over. But you have the ability to break up paragraphs and add things like bullet points, subheadings, block quotes and more. These increase the readability of your piece, and also make it easier for search engines to crawl it and interpret the content.

Another way to improve the look and layout of your text is to add images and other media.

Do not be shy and don’t wait for the website editor to insert them for you. Instead, be proactive and use your own images. Add a couple of them if necessary. If they make sense and the text looks better because of it, the editor will be more inclined to ask you for additional guest posts.

You can even go the extra mile and write titles and alt text to optimize the images for SEO – the editor will thank you, as it will save them the effort, and it will improve the overall SEO value of your piece.

Lastly, we come to links.

Now, editors usually allow one link in your bio, or one link within the article. Most of them do not like it when an author writes a piece with numerous links pointing to different websites.

However, if the editor allows it, make sure to add some highly relevant links that will make the article even more authoritative.

4) Vary your anchor text

You are trying to rank for a certain keyword. In an attempt to rank, you try to spam the same anchor text over and over.

This strategy is pretty much obsolete. Instead, just as with everything else that we’ve mentioned so far, make sure to diversify things.

Anchor text should vary.

When people place links with purely editorial value, without trying to cynically rank for a specific keyword, they will rarely link with the exact same phrase every time. This is highly unnatural behavior and can get you in trouble.

Instead, make sure to use different phrases. Place links in different sentences, with different anchors. Focus on writing naturally and place your link accordingly.

Conclusion

Guest blogging is NOT dead. As far as we know, there is no Google system or algorithm that will penalize the creation of such articles.

Nevertheless, it is better to be conservative. Like always, it comes down to whether your link profile looks natural. There should be no indication that you are purposely trying to push a keyword (even if you are).

People usually think about guest blogging in terms of links. However, you should observe it from a different perspective. By using this strategy, not only should you get links, you should also get some good exposure.

Your articles should promote your skills as well as your blog.

By placing emphasis on this, you will be able to accomplish much more with guest posts and as a result, links will start coming from various sources without you forcing them.

ABCO Technology teaches a comprehensive course for web development, guest blogging and search engine marketing. Call our campus between 9 AM and 6 PM Monday through Friday. You can reach us at: (310) 216-3067.
Email your questions to: info@abcotechnology.edu

Financial aid is available to all students who can qualify for the federal funding.
ABCO Technology is located at:
11222 South La Cienega Blvd. in STE # 588
Los Angeles, Ca. 90304
Start building successful websites today!

Cyber security, what CMOs need to know

What do CMOs need to know about cybersecurity?

Cybersecurity is a fundamental consideration for all organizations operating in today’s connected and data-driven world. While all who work across your business – from the IT department, to the PR team and beyond – need to understand the fundamentals of cybersecurity, CMOs have a special responsibility as leaders to ensure they are mitigating risk and are prepared in the event of a possible breach. Here are five things CMOs need to know.

1. Vulnerabilities

In business, CMOs are perhaps some of the best placed when it comes to understanding the global reach of an organization. This is of particular importance when it comes to cybersecurity, as the growing popularity of globally-connected technologies – such as cloud storage and mobile sharing – bring with them increased points of potential vulnerability.

This is a key concern for the CMO, as they are custodians of potentially massive amounts of customer data. Recent security breaches at companies like Yahoo, Deloitte and Equifax have massively damaging implications – both in terms of revenue and brand trust.

CMOs need to be aware of the proliferation of connected technologies across the organization in order to fully understand where possible breaches might happen.

2. Threats

Understanding potential vulnerabilities is one step; acknowledging actual threats is another.

Businesses need to be prepared for increasingly sophisticated and globally organized attackers. Vulnerabilities can give hackers access to confidential business information, as well as lead to theft of personal information of staff and customers.

It is the last threat which is perhaps the most important to be prepared for. The breakdown of trust between organization and customer is the most damaging to business and brand image going forward.

CMOs also need to acknowledge theft of information in the digital realm is not the only threat. Connected IoT devices can also allow hackers to potentially gain access in the physical space such as buildings and vehicles.

3. Prevention

CMOs need to be clear as to how such cybersecurity breaches can be prevented.

They need to collaborate with those across other business departments in ensuring there are clear organization-wide guidelines for security best practice – including keeping apps and software up-to-date, changing passwords regularly and educating team members about phishing scams.

It is essential that CMOs champion these activities within their team, and ensure policies, training and enforcement are up-to-date. Working closely with the local governments is a good way to standardize practices to match those in the wider business community – and to ensure compliance.

For businesses with European connections, GDPR provides a good opportunity to review data best practices.

4. Action

A keen understanding of the above and the most stringent prevention techniques will never make an organization completely immune from cybersecurity breaches.

CMOs can use data and speculation tools to plan action in post-breach scenarios. Again, preparedness for action is key – and collaboration between CMOs and all other business teams are the best way to ensure the correct action takes place if cybersecurity is undermined.

5. Communication

All staff need to understand the importance of cybersecurity – but CMOs can help ensure that knowledge is shared. Collaborations tools help streamline this process by providing channels for any team to communicate.

If a cybersecurity breach has already happened, synergy among C-suite, security, IT and public relations teams is critical. CMOs must have answers to the questions like: What are your best practice communications strategies with customers? Is information about the breach easy to find for worried consumers?

In the event of a cybersecurity breach, businesses need to be clear in their external communications – clarifying exactly what data was exposed and making users aware of worst-case scenarios.

Takeaways

When it comes to cybersecurity, no organization can be 100% protected from breaches. All staff members need to clear on the above five areas, and CMOs have a unique position in being able to lead planning and education within the business to ensure all teams can work quickly and efficiently if the worst happens.

It is the responsibility of the CMO to ensure customers are protected and that they are first to know should such a breach occur. Collaboration and communication is key during such situations – to ensure trust is maintained, information is accessible and order is restored as soon as possible.

ABCO Technology teaches a comprehensive program for cyber security. Call our campus between 9 AM and 6 PM Monday through Friday at: (310) 216-3067.
Email your questions to: info@abcotechnology.edu
Financial aid is available to all students who can qualify for funding.
ABCO Technology is located at:
11222 South La Cienega Blvd. in STE # 588
Los Angeles, Ca. 90304.
Get trained and certified for cyber security today!

Why should you become an Oracle Certified Associate

As an Oracle Certified Associate, you will cultivate industry-supported skills and credentials that you will be able to transfer to future employment opportunities. With your OCA certification, you will be able to demonstrate and promote the fact that you have the necessary skills to do your job effectively and you are certified by Oracle Corporation the world’s leader in Database Management Systems.

What are the Prerequisites & for OCA

Prior to enrolling for OCA courses the applicants have to know how to use the Microsoft Windows operating system. General knowledge of computer programming and databases will be helpful but not necessarily required.

OCA® Topic Requirements:

SQL Fundamentals I

Program with PL/SQL

SQL Fundamentals I
Oracle routinely publishes new versions of exams, and the passing score across versions may differ.

Oracle Developer/Administrator Certified Associate (OCA)

SQL Fundamental I
This course introduces students to the fundamentals of SQL using Oracle Database 12C database technology, which revolves around the cloud. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, students use Oracle SQL Developer and SQL *Plus as the tool.

Course Objectives:

• Retrieve row and column data from tables with the SELECT statement

• Create reports of sorted and restricted data

• Employ SQL functions to generate and retrieve customized data

• Display data from multiple tables using the ANSI SQL 99 JOIN syntax

• Create reports of aggregated data

•Use the SET operators to create subsets of data

•Run data manipulation statements (DML) to update data in the Oracle Database 12C

•Run data definition language (DDL) statements to create and manage schema objects

• Identify the major structural components of the Oracle Database 12C

Course Topics:

Introduction
•Listing the features of Oracle Database 12C
•Discussing the basic design, theoretical and physical aspects of a relational database
•Describing the development environments for SQL
•Describing Oracle SQL Developer, Describing the data set used by the course

Retrieving Data Using the SQL SELECT Statement

• Listing the capabilities of SQL SELECT statements.

• Generating a report of data from the output of a basic SELECT statement

• Using arithmetic expressions and NULL values in the SELECT statement

• Using Column aliases

• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

• Displaying the table structure using the DESCRIBE command

Restricting and Sorting Data
•Writing queries with a WHERE clause to limit the output retrieved Using the comparison operators and logical operators
•Describing the rules of precedence for comparison and logical operators
•Using character string literals in the WHERE clause
• Writing queries with an ORDER BY clause to sort the output
•Sorting output in descending and ascending order
•Using the Substitution Variables

Using Single-Row Functions to Customize Output
•Differentiating between single row and multiple row functions
•Manipulating strings using character functions
•Manipulating numbers with the ROUND, TRUNC and MOD functions
•Performing arithmetic with date data
•Manipulating dates with the date functions

Using Conversion Functions and Conditional Expressions
•Describing implicit and explicit data type conversion
•Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
•Nesting multiple functions
•Applying the NVL, NULLIF, and COALESCE functions to data
•Using conditional IF THEN ELSE logic in a SELECT statement

Reporting Aggregated Data Using the Group Functions
•Using the aggregation functions in SELECT statements to produce meaningful reports
•Using AVG, SUM, MIN, and MAX function
•Handling Null Values in a group function
•Creating queries that divide the data in groups by using the GROUP BY clause
•Creating queries that exclude groups of date by using the HAVING clause

Displaying Data from Multiple Tables
•Writing SELECT statements to access data from more than one table
•Joining Tables Using SQL:1999 Syntax
•Viewing data that does not meet a join condition by using outer joins
•Joining a table by using a self join
•Creating Cross Joins

Using Sub-queries to Solve Queries
•Using a Subquery to Solve a Problem
•Executing Single-Row Sub-queries
•Using Group Functions in a Sub-query
•Using Multiple-Row Subqueries
•Using the ANY and ALL Operator in Multiple-Row Sub-queries

Using the SET Operators
•Describing the SET operators
•Using a SET operator to combine multiple queries into a single query
•Using UNION, UNION ALL, INTERSECT, and MINUS Operator
•Using the ORDER BY Clause in Set Operations

Manipulating Data
•Adding New Rows to a Table Using the INSERT statement
•Changing Data in a Table Using the UPDATE Statement
•Using DELETE and TRUNCATE Statements
•Saving and discarding changes with the COMMIT and ROLLBACK statements
•Implementing Read Consistency
•Using the FOR UPDATE Clause

Using DDL Statements to Create and Manage Tables
•Categorizing Database Objects
•Creating Tables using the CREATE TABLE Statement Describing the data types
•Describing Constraints
•Creating a table using a subquery
•Altering and Dropping a table

Creating Other Schema Objects
•Creating, modifying, and retrieving data from a view
•Performing Data manipulation language (DML) operations on a view
•Dropping a view
•Creating, using, and modifying a sequence
•Creating and dropping indexes
•Creating and dropping synonyms

ABCO Technology offers a comprehensive program for OCA version 12C. Call our campus today between 9 AM and 6 PM Monday through Friday. You can reach us at: (310) 216-3067.
Email your questions to: info@abcotechnology.edu
Financial aid is available to all students who can qualify for funding.

ABCO Technology is located at 11222 South La Cienega Blvd. in STE # 588
Los Angeles, Ca. 90304.
Get certified for Oracle database OCA 12C today!

×