Page 1
Web creation courses
Category overview
Kurzy webových stránok, PHP Script, HTML, CSS, AJAX, Java, jQuery, Joomla, SEO optimalizácia web stránok, grafika pre web stránky
Naučíme Vás vytvárať a upravovať si webové stránky od základov až po náročné moderné technológie. Sledujeme nové trendy a pripravujeme kurzy tvorby web stránok s aktuálnymi novinkami.
Tvorba www stránok základy je vhodný pre úplných začiatočníkov v oblasti tvorby webových stránok. Ponúkame úrovne pre začiatočníkov aj pre pokročilých napr. Tvorba www stránok WordPress - základy, Tvorba www stránok pre pokročilých
Joomla je redakčný systém, ktorý umožňuje vytvárať webové stránky a výkonné on-line aplikácie. Jednoduchosť použitia a rozšíriteľnosť urobila Joomlu najobľúbenejším webovým dostupným softwérom. Joomla je používaný na celom svete na tvorbu webových stránok všetkých tvarov a veľkostí. Napríklad: firemné webové stránky a portály, firemný intranet, on-line časopisy, noviny a publikácie, on-line rezervácie, osobné a rodinné domovské stránky.
Joomla sa školí v úrovniach: základy a pokročilý. Joomla - tvorba www stránok, Joomla pre pokročilých
jQuery je rýchla a presná JavaScript knižnica, ktorá zjednodušuje v HTML dokumente udalosti, manipuláciu a Ajax pre rýchly vývoj webových aplikáciií. jQuery je určený pre zmenu spôsobu, akým píšete JavaScript.
jQuery sa školí v úrovniach: základy a pokročilý jQuery - základy, jQuery – pokročilý
SEO optimalizácia pre vyhľadávače je kurz určený pre majiteľov webových stránok, ktorí sa chcú naučiť optimalizovať web stránky. Optimalizácia pre vyhľadávače zabezpečí vysoké umiestnenie v dôležitých vyhľadávacích portáloch a tým značne zvýši návštevnosť stránok. SEO optimalizácia pre vyhľadávače
Kurz Grafika pre www stránky - webdizajn je určený pre tvorcov webových stránok, ktorí sa chcú naučiť vytvárať profesionálnu grafiku pre webové stránky.
Obľúbené sú akciové balíky kurzov na tvorbu webových stránok Tvorba www stránok a programovanie web aplikácií - Akciový balík, Webová grafika, webdizajnér - Akciový balik!
Osnovy všetkých kurzov sú uvedené pri každom kurze zvlášť, kde sú uvedené aj termíny kurzov.
Pre účastníkov školenia je pripravené občerstvenie, písacie potreby a po absolvovaní školenia dostanú Certifikát!
Neváhajte nás kontaktovať, na tel. č: 0948 884088, 0948 884188 alebo e-mailom [email protected]
Tím spoločnosti Macrosoft sa teší na spoluprácu.
Contents
Active courses: 9
Page 2
Web Application Programmer
Price incl. VAT
934.80 €
Current VAT 23%
Duration
Day: 6 days · Evening: 12 days · Weekend: 6 days
Course overview
The Web Application Programmer course is intended for website creators who want to learn to create websites at a professional level. The package consists of the following courses: Website creation basics and HTML, CSS, PHP, JavaScript basics, My SQL
Minimum input knowledge
Basics of working with a computer.
Output knowledge
Output knowledge is not available yet.
Training syllabus
Introduction to HTML
- Introduction and description of HTML What www and a web server are, what the HTTP protocol and FTP protocol are Principle of operation and options for storing websites on the internet Basics of working with text editors Basics and instructions for working with a WYSIWYG editor (Adobe Dreamweaver, Macromedia Dreamweaver... )
Working with and Description of Individual HTML Tags
- Description of main tags in HTML: html, body and head Description of commands and tags occurring in the header Description of tags and commands located in the body of the page Procedure and correct writing in HTML language
Text and Colors on Websites
- Basic text formatting, paragraph alignment Formatting text using headings in HTML Changing colors of font, background, hypertext
Images on a Website
- Correct image formats for websites Inserting, aligning an image Image size, margin alignment Image in the background of a website
Lists and Hypertext Links
- What a hypertext link and lists on a website are Use of hypertext and lists Ordered and unordered lists Linking pages, links on pages, sending e-mails
Working with Tables and Frames
- Description of tags for creating a table, assigning parameters to tables Merging cells in tables and aligning cells Placing text in tables and distance between cells Basic description of frames and their use for creating a website Use of tables for overall page creation
Forms and Working with Them
- Creating text fields and parameter values Creating a button (Login button...) Creating checkboxes
JavaScript Gallery
- adding a gallery to a website settings for grouping images in the gallery into groups editing the gallery appearance using graphics editing the gallery appearance using xHTML gallery parameters image rules in the gallery (size, dimensions, quality)
JS and PHP Form
- contact form e-shop order form input options for the form sending the form form checking form security
JS Functions
- auxiliary functions for web JavaScript structure use of JavaScript on a website
PHP for Web
- basics of PHP for web creating a template system PHP structure working with functions and variables
JS Rolling Menu
- adding a rolling menu to a website JavaScript structure in a rolling menu graphical editing and customization of the rolling menu XHTML menu editing
Timed Change
- adding a system to the page
JS Image Display
- editing and customizing the size of the display window image rules (size, dimensions, quality)
Introduction to MySQL
- installation of MySQL, minimum HW and SW requirements free programs - Query builder, TOAD user accounts, user and administrator rights environment configuration, starting and stopping the server listing information about processes and database objects setting variables connecting and disconnecting databases database backup and recovery Basics of relational databases getting familiar with the relational database model, basic terms client/server architecture Working with a table new, column types and data types data entry, table editing, inserting and deleting data sorting records, filtering records CREATE TABLE, ALTER, DROP Relationships between tables, indexes relationship settings and properties, types of joins, NULL value, primary and foreign key indexes SQL language commands SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY Aggregate functions MIN, MAX, AVG, SUM, etc. composing a WHERE condition - AND and OR operators, LIKE operator LEFT, RIGHT and INNER JOIN Working with views (Views) creating views, delete, update and append views use of built-in functions, import and export of data transactions and locks Programming in MySQL variables, branching and loops cursors and handlers procedures and functions, input and output parameters triggers (INSERT, UPDATE, DELETE) Reports iReport program report templates, report controls, using sections and page breaks, use of expressions in reports, sorting and grouping...
Page 3
WordPress Web Developer
Price incl. VAT
798.00 €
Current VAT 23%
Duration
Day: 5 days · Evening: 10 days · Weekend: 5 days
Course overview
The WordPress web developer course is intended for all website creators who want to learn to create and edit websites at a professional level. The promotional package consists of the following courses: WordPress - Basics and Advanced. SEO - website optimization. Only the course start is shown in the date; we will inform you about the other dates.
Minimum input knowledge
Basics of working with a computer.
Output knowledge
Mastering the principles and skills of creating and administering websites in the WordPress CMS. Mastering the basics of website optimization for search engines.
Training syllabus
Installing and Launching WordPress
- Obtaining a domain and web hosting for a site Uploading WordPress to web hosting via FTP / installing XAMPP Initial setup, creating an administration account and database setup
Basic Orientation and Settings
- Dashboard (Home page) Administration interface Setting the site title and slogan, environment language, visibility for search engines Switching to site view for visitors User management and roles
Creating Website Content
- Difference between pages and posts Creating new pages and posts, deletion and revisions Setting the final part of the URL, publication time, illustrative image Editing posts and pages with the new Gutenberg editor and the original classic editor (TinyMCE) Working with Gutenberg editor blocks Inserting external content: image, video, link, ... Managing post categories, setting the title and URL, assigning categories to posts Enabling/Disabling comments, comment management Setting the home page and number of displayed posts
Site Appearance
- Adding themes (templates for site appearance and content layout), changing the theme Customizing the theme inserting the site logo Explanation of the site workspace Menu settings Setting and placing widgets on the site
Adding Functionality to WordPress
- Searching for and installing Plugins (Add-ons) Activating and updating Plugins Using selected Plugins for: SEO, site performance optimization, contact form, GDPR notice, security, Google analytics Using shortcodes
Introduction to HTML Language
- Introduction and description of HTML language What www and web server are, what http protocol and ftp protocol are Principle of operation and options for storing www pages on the internet Basics of working with text editors Basics and instructions for working with a WYSIWYG editor Work and description of individual HTML tags Description of main tags in HTML: html, body and head Description of commands and tags occurring in the header Description of tags and commands located in the body of the page Procedure and correct writing in HTML language
Text and Colors on www Pages
- Basic text formatting, paragraph alignment Text formatting using headings in HTML Changing font, background and hyperlink colors
Images on an Internet Page
- Correct image formats for www pages Inserting and aligning an image Image size, aligning margins Image on the background of a www page
Lists and Hypertext Links
- What a hypertext link and lists on an internet page are Use of hypertext and lists Ordered and unordered lists Linking pages, links on pages, sending emails
Working with Tables and Frames
- Description of tags for creating a table, assigning parameters to tables Merging cells in tables and aligning cells Placing text in tables and distance between cells Basic description of frames and their use for creating a www page Using tables for overall page creation
Forms and Working with Them
- Creating text fields and parameter values Creating a button (Login button...) Creating checkboxes Text fields with password Working with a WYSIWYG editor Working with individual HTML tags Text formatting, paragraphs and their editing in HTML code and in the graphical page format Images, lists and hypertext links in HTML code and in the graphical page format Creating tables and forms in HTML code and in the graphical format of a www page Creating the overall final www page Reviewing orientation in the admin environment Dashboard (Home page) Reviewing basic terms Administration interface User management and roles Working with FTP
Editing Site Appearance
- Simple customization of site appearance Editing the site's html code Editing the site using additional CSS code and direct insertion Editing theme code - advantages/disadvantages Using a child theme Creating page/post content Working with the graphical interface and code editor Inserting external content using iframe (Google maps, forms, ...) Comparison of visual editors: Page builder, Elementor, Gutenberg Customization using a visual editor Working with Gutenberg editor blocks Inserting media content (images, videos) and galleries Editing site appearance Simple customization of site appearance Editing the site's html code Editing the site using additional CSS code and direct insertion Editing theme code - advantages/disadvantages Using a child theme Extending the site with widgets
Website, Social Networks and Google Products
- Facebook social buttons Facebook and Instagram feed Facebook messenger as a communication tool of the site Google tag manager (Analytics, Ads), Google AdSense SEO Selection of a suitable plugin Setting and working with the plugin Creating permanent links, meta description (page description for search engines) Creating sitemap.xml Google Search console Importance of a heatmap in website optimization
Website Security
- Benefits of using SSL on a website Changing the login page, creating a strong administrator account Use of security elements Website speed optimization Minimizing plugins Optimizing image size Minification of page code and memory management (cache) using a plugin AMP (Accelerated mobile pages) Website and database backup
Page 4
WordPress Basics
Price incl. VAT
295.20 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
Participants will learn to create a simple site for a blog, presentation or information page. They will gain the knowledge needed for the structure and functioning of their own websites. They will learn to change the appearance using themes and extend the site's functionality using plugins.
Minimum input knowledge
Basics of working with a computer and the internet.
Output knowledge
Participants will be able to create a simple website and will master the basics of working with themes and widgets. They will learn to create suitable content. They will be able to extend functionality using plugins. They will be able to find suitable web hosting and a domain name for their site.
Training syllabus
What Is a CMS and WordPress?
- Basic overview of the most used CMS (Drupal, Joomla, Prestashop, BUXUS, ...) and how a database works Benefits of using WordPress Difference between WordPress.com and WordPress.org Examples of sites created through WordPress
Installing and Launching WordPress
- Obtaining a domain and web hosting for a site Uploading WordPress to web hosting via FTP / installing XAMPP Initial setup, creating an administration account and database setup
Basic Orientation and Settings
- Dashboard (Home page) Administration interface Setting the site title and slogan, environment language, visibility for search engines Switching to site view for visitors User management and roles
Creating Website Content
- Difference between pages and posts Creating new pages and posts, deletion and revisions Setting the final part of the URL, publication time, illustrative image Editing posts and pages with the new Gutenberg editor and the original classic editor (TinyMCE) Working with Gutenberg editor blocks Inserting external content: image, video, link, ... Managing post categories, setting the title and URL, assigning categories to posts Enabling/Disabling comments, comment management Setting the home page and number of displayed posts
Site Appearance
- Adding themes (templates for site appearance and content layout), changing the theme Customizing the theme inserting the site logo Explanation of the site workspace Menu settings Setting and placing widgets on the site
Adding Functionality to WordPress
- Searching for and installing Plugins (Add-ons) Activating and updating Plugins Using selected Plugins for: SEO, site performance optimization, contact form, GDPR notice, security, Google analytics Using shortcodes
Discussion and Further Learning Options After Completing the Training
Page 5
WordPress Advanced
Price incl. VAT
344.40 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
Course participants will deepen and expand their knowledge when creating websites in WordPress. They will try editing site appearance using CSS, HTML and a visual editor. Extending functionality with plugins, widgets and connection with social networks. They will find out how to care for WordPress in the long term, create backups and how to take care of good security of their site.
Minimum input knowledge
Wordpress - basic orientation in administration, creating and editing posts and pages, inserting images, basic theme settings, minimum knowledge of HTML.
Output knowledge
Course participants will be able to create more complex websites and change design using visual editors and CSS editing. Connect the site with social networks and Google products. They will acquire knowledge of how to properly optimize the technical side and website security.
Training syllabus
Review of Orientation in the Admin Environment
- Dashboard (Home page) Review of basic terms Administration interface User management and roles Working with FTP
Editing Site Appearance
- Simple customization of site appearance Editing the site's html code Editing the site using additional CSS code and direct insertion Editing theme code - advantages/disadvantages Using a child theme
Creating Page/Post Content
- Working with the graphical interface and code editor Inserting external content using iframe (Google maps, forms, ...) Comparison of visual editors: Page builder, Elementor, Gutenberg Customization using a visual editor Working with Gutenberg editor blocks Inserting media content (images, videos) and galleries
Editing Site Appearance
- Simple customization of site appearance Editing the site's html code Editing the site using additional CSS code and direct insertion Editing theme code - advantages/disadvantages Using a child theme Extending the site with widgets
Website, Social Networks and Google Products
- Facebook social buttons Facebook and Instagram feed Facebook messenger as a communication tool of the site Google tag manager (Analytics, Ads), Google AdSense
SEO
- Selection of a suitable plugin Setting and working with the plugin Creating permanent links, meta description (page description for search engines) Creating sitemap.xml Google Search console Importance of a heatmap in website optimization
Website Security
- Benefits of using SSL on a website Changing the login page, creating a strong administrator account Use of security elements
Website Speed Optimization
- Minimizing plugins Optimizing image size Minification of page code and memory management (cache) using a plugin AMP (Accelerated mobile pages)
Website and Database Backup
Discussion and Further Learning Options After Completing the Training
Price incl. VAT
282.90 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
The website creation course is suitable for complete beginners in the field of creating web pages.
Minimum input knowledge
Basic work with Microsoft Windows.
Output knowledge
After completing the course, participants will be able to create a www page using visual tools.
Training syllabus
Introduction to HTML
- Introduction and description of HTML.
- What www and a web server are, what the http protocol and ftp protocol are.
- Principle of operation and options for storing www pages on the internet.
- Basics of working with text editors.
- Basics and instructions for working with a WYSIWYG editor.
Working with and Description of Individual HTML Tags
- Description of main tags in HTML: html, body and head.
- Description of commands and tags occurring in the header.
- Description of tags and commands located in the body of the page.
- Procedure and correct writing in the HTML language.
Text and Colors on Web Pages
- Basic text formatting, paragraph alignment.
- Formatting text using headings in HTML.
- Changing font, background and hyperlink colors.
Images on an Internet Page
- Correct image formats for www pages.
- Inserting and aligning an image.
- Image size, aligning margins.
- Image in the background of a www page.
Lists and Hyperlinks
- What a hyperlink and lists on an internet page are.
- Use of hypertext and lists.
- Ordered and unordered lists.
- Linking pages, links on pages, sending emails.
Working with Tables and Frames
- Description of tags for creating a table, assigning parameters to tables.
- Merging cells in tables and aligning cells.
- Placing text in tables and distance between cells.
- Basic description of frames and their use for creating a www page.
- Using tables for overall page creation.
Forms and Working with Them
- Creating text fields and parameter values.
- Creating a button (login button...).
- Creating checkboxes.
- Password text fields.
Working with a WYSIWYG Editor
- Working with individual HTML tags.
- Text formatting, paragraphs and their editing in HTML code and in the graphical page format.
- Images, lists and hyperlinks in HTML code and in the graphical page format.
- Creating tables and forms in HTML code and in the graphical format of a www page.
- Creating the complete final www page.
- Discussion and tips when creating www pages.
- Conclusion.
Price incl. VAT
244.77 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
The CSS, PHP and JavaScript website programming training is intended for more demanding users - programmers who want to learn to program websites using modern technologies.
Minimum input knowledge
Knowledge of website creation at the level of the course: Basics of website creation.
Output knowledge
After completing the course, participants will be able to create static websites with various dynamic elements and will also understand the basics of the HTML and PHP languages.
Training syllabus
JavaScript Gallery
- Adding a gallery to a website, settings for grouping images in the gallery into groups, modifying the appearance of the gallery using graphics, gallery parameters, image rules in the gallery (size, dimensions, quality)
JS and PHP Form
- Contact form, e-shop order form, input options for a form, sending a form, form checking, form security
JS Functions
- Auxiliary functions for the web, JavaScript structure, use of JavaScript on a website
PHP for the Web
- Basics of PHP for the web, creating a template system, PHP structure, working with functions and variables
JS Scrolling Menu
- Adding a scrolling menu to a website, JavaScript structure in the scrolling menu, graphical editing and customization of the scrolling menu
Timed Change
- Adding the system to a page
Displaying Images with JS
- Editing and customizing the size of the display window, image rules (size, dimensions, quality), discussion, conclusion
Price incl. VAT
172.20 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The course is intended for participants who are starting with digital marketing and want to improve in procedures, methods and strategies through which websites become more visible in search engines.
Minimum input knowledge
The participant should know the basics of creating websites, or should have at least basic education focused on marketing and its tools.
Output knowledge
After completing the SEO training, the participant understands terminology, can analyze keywords and independently optimize a website according to marketing requirements. They can correctly evaluate statistical data and, based on it, decide on further marketing activities.
Training syllabus
What SEO Is
- Definition of the term SEO Basic terms What keywords are and their use in SEO
Google - Search Engine Optimization
- Why SEO focuses on Google Working with search results Black-hat practices
On-page Factors
- Which factors to focus on when creating a website Introduction to SEO Creating a basic technical audit of a website Which parts of the website we focus on Explanation of the importance of individual factors Example of an SEO on-page document Case studies on real examples
Off-page Factors
- How to create SEO off-page correctly What link building is What page quality score is
Website and Keyword Analysis
- Creating keyword analysis What link building is What page quality score is
Optimization of a Selected Subpage Under Lecturer Guidance
- Applying keywords when creating SEO Optimization of on-page factors of a subpage
Using Google Analytics in SEO
- Introduction to Google Analytics Tracking website traffic using Google Analytics
Discussion and Questions
Price incl. VAT
356.70 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
The MySQL programming and database work training is intended for all participants who want to become familiar with the database program, know its functional options and create their own database.
Minimum input knowledge
Standard ability to work with a computer.
Output knowledge
Mastering the operation of a MySQL database, acquiring skills in defining and creating one's own database, as well as in evaluating database data.
Training syllabus
Introduction to MySQL
- Installation of MySQL, minimum HW and SW requirements.
- Free programs – Query builder, TOAD.
- User accounts, user and administrator rights.
- Environment configuration, starting and stopping the server.
- Listing information about processes and database objects.
- Setting variables.
- Connecting and disconnecting databases.
- Database backup and restore.
Basics of Relational Databases
- Familiarization with the relational database model, basic terms.
- Client/server architecture.
Working with a Table
- New table, column types and data types.
- Writing data, editing a table, inserting and deleting data.
- Sorting records, filtering records.
- CREATE TABLE, ALTER, DROP.
Relations between Tables, Indexes
- Setting and properties of relations, relationship types, NULL value, primary and foreign key.
- Indexes.
SQL Language Commands
- SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY.
Aggregate Functions
- MIN, MAX, AVG, SUM, etc.
- Combining the WHERE condition – AND and OR operators, LIKE operator.
- LEFT, RIGHT and INNER JOIN.
Working with Views
- Creating views, deleting, modifying and appending views.
- Use of built-in functions, import and export of data.
- Transactions and locks.
Programming in MySQL
- Variables, branching and loops.
- Cursors and handlers.
- Procedures and functions, input and output parameters.
- Triggers (INSERT, UPDATE, DELETE).
Reports
- iReport program.
- Report templates, report controls, using sections and page breaks, using expressions in reports, sorting and grouping, group header and footer.
MySQL Help
- Working with help.
- Discussion.
- Conclusion.
Page 10
PHP Script
Price incl. VAT
356.70 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
The course is suitable for participants who already know the HTML language and want to learn the basics of server programming in PHP and the basics of communication between server and client when operating websites.
Minimum input knowledge
Standard PC operation. Standard knowledge of creating websites, HTML language.
Output knowledge
Basic knowledge of how a web server with PHP support works, ability to create simple scripts in PHP and process HTML forms.
Training syllabus
Introduction to PHP and Apache Server
- How PHP works.
- Making PHP work for Apache server.
- What PHP is, basic functions.
- Difference compared with HTML.
- First application for printing text to the screen.
- ECHO command.
- Difference between server-side and client-side programming.
Variables
- Local and global variables.
- Storing values in variables.
- Custom functions, input and output variables.
- Validity of the variable value.
Built-in Functions
- Meaning and use.
- Numeric functions.
- String functions.
- Date functions.
Loops
- Explanation of loops.
- For, While, Do .. While loop, examples for testing loops.
Conditions
- IF, ELSE IF, ELSE command.
- Operators.
- Combining conditions – AND, OR commands.
Working with Forms
- Form elements in HTML.
- Reading and writing data from a form.
- Checking data on the server side.
- Output to the screen.
- POST and GET directive, their meaning.
- Uploading one or more files to the server.
- Test of correct upload, size and file extension.
- Storing files on the server.
Conclusion
- FTP protocol and file transfer to a webserver.
- Discussion.