3825 Courses in Cardiff delivered Live Online

Web development training course description This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. What will you learn Program Web applications. Work with data and services. Troubleshoot and debug Web applications. Work with client side scripting. Configure and deploy web applications. Web development training course details Who will benefit: Anyone looking for an introduction to web development. Prerequisites: None. Duration 3 days Web development training course contents Programming web applications Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. Working with data and services Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. Troubleshooting and debugging web applications Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. Handle web application errors HTTP error codes. Working with client-side scripting Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. Configuring and deploying web applications Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. Understand application pools Purpose of application pools; effect of application pools on web applications.

Managing Complex Projects: Virtual In-House Training As knowledge and technology expand exponentially, organizations are finding that the tools, processes, and methods used to select, plan, and manage their projects are insufficient for the challenges posed by them. The goal of this course is to provide participants with a working knowledge of project complexities and a framework for managing the ambiguities involved in today's fast-changing, competitive, and technology-based environment As knowledge and technology expand exponentially, organizations are finding that the tools, processes, and methods used to select, plan, and manage their projects are insufficient for the challenges posed by them. Complex projects don't necessarily follow the rules of traditional projects - in many instances the projects' end-products, and the methods by which they will be produced, are not easily defined. Stakeholder diversity and geographical dispersion contribute to the difficulties project managers face in their efforts to gain acceptance of project goals, objectives, and changes. Additionally, hierarchic leadership styles, traditional lifecycle approaches, and traditional project manager competencies may no longer maximize the efficiencies that need to be realized on complex projects. The goal of this course is to provide participants with a working knowledge of project complexities and a framework for managing the ambiguities involved in today's fast-changing, competitive, and technology-based environments. What you Will Learn The learning objectives of this workshop are to enable participants to: Appreciate complexity and its impact on the management of projects Describe the differences among traditional, complicated, and complex projects Explain the effects of complexity on the PMBOK® Guide's process groups Apply a high-level model in the management of real- world projects Complexity and Projects Some characteristics of complex systems Important models/characteristics of complex projects Major players in project complexity Landscapes and project typologies A supplemental framework for complex projects Framing Framing overview Potential pitfalls in framing complex projects Possible solutions Inception Centrality of risk management PM competencies, selection Stakeholder identification, analysis Blueprint Collaborative planning Stakeholder engagements Alternative methodologies/life cycles Collaborative scheduling Procurement management Oversight, Navigation, and Adjustment Leadership and the project team Stakeholder management Networks Close and Continuous Improvement Transition/support Post-project evaluations Rewards/Recognition

Virtual Agile Teams: Virtual In-House Training Agile teams are a must in this world of intense competition, marketing demands, and changing expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed, with suppliers and clients actively engaged in joint projects. Agile Teams now work across geographical, organizational, and cultural boundaries to deliver solutions and services to global users. Distance and differences may amplify the effect of issues and factors that are relatively straightforward for co-located Agile teams. This workshop delivers practical concepts and techniques that participants will start using immediately with their virtual Agile teams. The goal of the course is to enable you to successfully execute your preferred Agile or Scrum methods in a virtual project team environment. What you will Learn At the end of this program, you will be able to: Explain the characteristics of a virtual team and how they differ from a co-located team Build an effective virtual Agile team using a Team Charter approach Develop Release Plans, including prioritizing user stories, with a virtual Agile Team Construct a Sprint plan, including effective user story estimates, virtually Execute a Sprint, including essential Agile or Scrum ceremonies, virtually Conduct effective virtual meetings in an environment supportive of Agile and Scrum methods Foundation Concepts Agile Mindset and Values Agile Benefits and Methods Scrum Overview Co-located vs. Virtual Teams Forming Virtual Agile Teams Exploring Virtual Leadership Focusing on Virtual Agile Leaders Developing a Virtual Agile Team Charter Meeting Team Challenges in a Virtual Environment Planning Releases with a Virtual Agile Team Planning releases overview Estimating user stories Prioritizing user stories Setting release parameters Getting consensus on the release plan Planning a Sprint for a Virtual Project Sprint Planning Overview Confirming Sprint Scope with Virtual Agile Teams Developing a Sprint Delivery Plan for Virtual Agile Teams Running a Sprint in a Virtual Environment Self-organizing a Sprint for a Virtual Agile Team Using Scrum tools in a Virtual Environment Conducting End of Sprint Meetings in a Virtual Environment Iterating as a Virtual Agile Team Creating an Environment for Success Piloting a virtual Agile team Creating an Agile-friendly virtual environment

Why Learn Vectorworks Basics to Essentials Training Course? Our Vectorworks training is meticulously crafted to educate and inspire designers of all levels. Whether you're a beginner or an experienced designer, our courses will equip you with new skills, refine your workflows, and teach Plans, sections and elevations. Course Link Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm. Vectorworks Basics to Essentials Training Course Discover and Enhance Your Design Skills Our Vectorworks training is meticulously crafted to educate and inspire designers of all levels. Whether you're a beginner or an experienced designer, our courses will equip you with new skills, refine your workflows, and unlock the full potential of your Vectorworks software. Online Training Options Customized Online Sessions: Tailored training sessions for your specific needs and expertise level. Virtual Classroom: Join interactive virtual classes from the comfort of your office. Getting Started Guides: Comprehensive guides to help you navigate the fundamentals of Vectorworks. In-Person Training Opportunities Customized On-Site Sessions: Hands-on training delivered directly to your office or regional event. One to One: Engage in interactive learning at our training locations. Get Vectorworks https://www.vectorworks.net › downloads › ServicePack Vectorworks, Inc. 2D 3D CAD BIM software for Mac or Windows allows designers to transform the world. Project sharing makes it easy. Download or try today. Module 1: Grasping CAD and Vectorworks Understanding the Role of CAD in Design Getting Acquainted with Vectorworks Software Module 2: Configuring Your Workspace Customizing Your Workspace Essential Options and Preferences Module 3: Mastering Foundational Drawing Skills Techniques for Drawing Object Selection Methods Module 4: Advanced Object Manipulation Merging Shapes Reflecting Objects Rotating Objects Grouping Elements Module 5: Precision Drawing and Scaling Techniques Working with Scale Setting Preferences for Accuracy Creating and Saving Templates Module 6: Achieving Accurate Object Placement Ensuring Drawing Precision Precise Object Movement Module 7: Advanced Editing Methods Utilizing Fillet Tool Applying Offset Function Module 8: Understanding Object Attributes and Groups Basic Attribute Management Editing Object Groups Module 9: Object Duplication Techniques Linear Duplicates Rectangular Duplicates Circular Duplicates Module 10: Crafting Room Plans Designing Walls Incorporating Windows and Doors Module 11: Development of Room Plans Methods for Room Plan Drawing Module 12: Exploring Additional Attributes Hatch Patterns Gradients Image Fills Module 13: Creating Elevation Drawings Elevation Drawing Techniques Effective Approaches Module 14: Importing Images for Graphic Use Graphic Illustration Integrating Images Module 15: Symbols and Resource Handling Symbol Creation Introduction to Resource Browser Module 16: Organizing Drawings Using Design Layers Optimizing Design Layer Utilization Module 17: Labeling Drawings and Title Blocks Drawing Labels Title Block Text Placement Module 18: Plotting and Printing Methods User Interface Navigation and Terminology Printing Approaches Module 19: Generating Drawing Sheets A1, A2, and A3 Sheet Formats Module 20: Utilizing Viewports Effectively Managing Multiple Views Module 21: Professional Model Presentation Techniques Paper Space Presentation Conversion to PDF Formats Module 22: File and Project Management Module 23: Object Display and Terminology Module 24: Objects and Data Management Module 25: Precise Object Placement Object Snapping Quick Selection Module 26: Dividing and Measuring Objects Module 27: Dimensioning and Annotations Module 28: Working with Text Elements Module 29: Customizing Tool Palettes Module 30: Organizing Tool Palettes Module 31: Efficient Tool Palette Usage Module 32: Standard Views and Drawing Techniques Module 33: Drawing Curved Shapes Arcs, Donuts, and Ellipses Drawing Module 34: Real-World Units and Measurements Module 35: Object Manipulation Adjusting Object Angles Module 36: File Handling and Management Saving, Exiting, and Opening Projects Module 37: Creating Mirrored Images Module 38: Introduction to 3D Modeling Creating Extrusions Basic 3D Concepts Understanding For a free 30-day trial of Vectorworks, request an evaluation serial number at the provided link. https://www.vectorworks.net/trial Learning Outcomes of the Vectorworks Basics to Essentials Training Course: Proficiency in Vectorworks software, mastering its basic and essential features. Enhanced design skills and efficient workflows for architectural, landscape, and entertainment projects. Customized training based on individual needs and expertise levels. Flexibility with online and on-site options for convenient learning. Access to Vectorworks University with a wealth of resources for continuous learning. Interactive virtual classrooms and immersive hands-on training for practical experience.

Developing the Business Case: Virtual In-House Training Business analysts must be able to create business case documents that highlight project benefits, costs, and risks. The business case is based on the real business need to be solved. These become parts of proposals, feasibility studies, and other decision support documents. This course teaches the purpose, structure, and content of a business case. It presents the basic techniques for determining financial ROI, non-tangible benefits, and the probability of meeting expectations. What you will Learn At the end of this program, you will be able to: Perform feasibility studies Justify the business investment to solve the business problem Prepare an effective business case document Plan and implement a business case approval process Foundation Concepts The role of the BA An introduction to the BABOK® Guide The business analyst and the product / project life cycle (PLC) The business case deliverable Introducing the Business Case Process The BA and strategy analysis The BA and the business case process (BCP) The BA during the business case process (BCP) The BA after the business case process (BCP) Importance of defining solution performance metrics Defining the Business Need Overview of defining the business need Business needs: problem / opportunity statement Product vision Objectives and constraints Exploring Business Case Solutions Overview of exploring solutions Solution identification for feasibility Solution definition for analysis Assessing project risks Justifying the Business Case Overview of justifying the business case Qualitative justification Quantitative justification Approving the Business Case Overview of business case approval Developing recommendations Preparing the decision package - documents Preparing the decision package - presentations

Advanced DNS training course description This two-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course follows on from our Definitive DNS for engineers course starting with best practices. The majority of the course is spent on securing DNS and in particular DNSSEC. Some parts are specific to BIND. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Implement DNS best practices. Harden DNS servers. Install, configure, maintain and troubleshoot DNSSEC. Advanced DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel. System administrators. Prerequisites: Total DNS for engineers Duration 2 days Advanced DNS training course contents Best practices MX and PTR records, lame delegations, disallowing recursion, TTLs, online testing. Hands on Review of your DNS servers. Split DNS Partitioning internal and external DNS, views. Hands on Implementing split DNS. Hardening DNS ACLs, recursion, queries, trusted sources, chroot jail, secure BIND template. Hands on Securing the DNS server. DNSSEC What is DNSSEC? DNSSEC benefits, DNSSEC RRs. DNSKEY, RRSIG, NSEC, DS. Hands on Creating DNSSEC keys. Securing zone transfers TSIG, shared secret. Securing DDNS. Hands on Secure file transfers. Zone integrity Trusted anchors, Chains of trust, Zone status, Zone signing, Keys. ZSK, KSK, adding keys to a zone file. Secure delegations. Hands on Zone signing Maintaining Signed zones Key rollover, pre publish, double signing, rollover cache.

Voice over LTE training course description This course provides a basic understanding of the 3G LTE Air Interface, SAE, as well as Voice over LTE options and LTE Advanced features. Investigating the standards for the EPS , formulated by the 3GPP standards body, the course will set out to examine and explain the 4G environment from user equipment to border gateway and beyond. This course will ensure the delegate has a grasp of all aspects of the current global deployments, the next steps in upgrades and the promise of things to come. What will you learn Describe the complete EPC architecture. Explain the use of QoS within the air interface & core network. Explore the features of LTE advanced. Describe the various methods of supporting voice services with 3G LTE. Describe IMS structure and control entities. Explain an IMS session. Voice over LTE training course details Who will benefit: Any engineers who are assisting in the deployment of voice services within their LTE networks. Prerequisites: Intro to Data comms & networking Telecommunications Introduction Duration 3 days Voice over LTE training course contents 3GPP standards body Release 8 - Release 12, Supported and expected features. The EPC revisited EPC revisited 3G LTE & EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers. VoLTE deployment strategies Common networks everywhere, GSM/WCDMA view, CDMA view. VoLTE system architecture LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities & functions, EPS mobility management, MS entities, Home subscriber server, Policy & charging rules function. VoLTE functionality Radio functionality, Bearers & schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users. EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public & private identity, identification of users device, identification of network entities, identification of services, identification without ISIM. IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action. VoLTE end-to-end & signalling VoLTE subscription & device configuration. EPS attach for CSFB/IMS VoIP & default bearer. IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration & re-authentication, De-registration, Related standards. IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation & policy control, Charging, Session release. Voice continuity, PS - PS intersystem handover, Single radio voice call continuity. IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session. CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry & forwarding. VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service. Unstructured supplementary services data simulation in IMS. IMS services VoLTE radio performance Coverage, Latency, Capacity. LTE advanced features Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC & eICIC, Relay node deployment & donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.

Dreamweaver training course description Dreamweaver is a web authoring program that allows you to build professional quality websites. This course starts with a tour of Dreamweaver and customising your workspaces, moving onto HTML and CSS basics. Page layouts, templates and interactive pages are also covered. The final session covers how to use Dreamweaver as a HTML editor. Hands on session follow all the major theory chapters. What will you learn Use Dreamweaver to create websites. Customise Dreamweaver. Use templates. Add interactivity to web pages. Use Dreamweaver to edit HTML code. Dreamweaver training course details Who will benefit: Anyone wishing to create or edit websites. Prerequisites: None. Duration 3 days Dreamweaver training course contents Getting started Installing the programme, Updating to the latest version,, Online content, On first launch, Choosing the program colour theme, Setting up the workspace, Defining a Dreamweaver site, Checking for updates, Additional resources. Customizing your workspace Touring the workspace, Using the start screen, Exploring new feature guides, Setting interface preferences, Switching and splitting views, Selecting a workspace layout, Personalising Dreamweaver, Working with extract, Creating custom keyboard shortcuts, Using the Property inspector, Using the Related Files interface, Using tag selectors, Using the CSS Designer, Using the Visual Media Query (VMQ) interface, Using the DOM viewer, Using Element dialogs, displays and inspectors, Setting up version control in Dreamweaver, Exploring experimenting and learning. HTML Basics What is HTML? Where did HTML begin? Frequently used HTML elements, What's new in HTML5. CSS Basics What is CSS? HTML vs. CSS formatting, HTML defaults, CSS box model, Applying CSS styling, Multiples, classes and ids. Web design basics Developing a new website, Scenario, Working with thumbnails and wireframes, Creating a page layout Evaluating page design options, Working with predefined layouts, Styling an existing layout, Styling elements using the Extract panel, Extracting text from a Photoshop mockup, Troubleshooting CSS styling, Extracting text styling from a Photoshop mockup, Creating a gradient background using Extract, Extracting image assets from a mockup, Adding CSS background effects in code, Finishing up the layout. Working with templates Creating a template from an existing layout, Inserting editable regions, Inserting editable regions, Inserting HTML entities, Inserting metadata, Validating HTML code, Producing child pages, Moving CSS styles to linked file, Updating a template. Working with text, lists and tables Previewing the completed file, Creating and styling text, Creating lists, Creating and styling tables, Spell-checking webpages, Finding and replacing text. Working with images Web image basics, Previewing completed files, Inserting an image, Controlling image positions with CSS classes, Working with the Insert panel, Using the Insert menu, Inserting non-web file types, Working with Photoshop Smart Objects, Copying and pasting images from Photoshop, Inserting images by drag and drop, Optimizing images with the Property inspector. Working with navigation Hyperlinks, previewing the completed file, creating internal and external hyperlinks, setting up email links, Creating image-based links, Targeting page elements, Locking an element on the screen, Styling a navigation menu, Checking your page, Adding destination links. Adding interactivity Dreamweaver behaviours, Previewing the completed file, Working with Dreamweaver behaviours, Working with jQuery Accordion widgets, Inserting a jQuery Accordion widget, Styling a jQuery Accordion. Publishing to the web Defining a remote site, Cloaking folders and files, Wrapping things up, Putting your site online, Synchronizing local and remote sites. Working with code Creating HTML code, multicursor support, commenting your code, Working with CSS preprocessors, Selecting code, Collapsing code, Expanding code, Accessing Split code view, Previewing assets in Code View.

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Why choose Vectorworks Evening Training Course? Course Link. This course led by certified expert, this course offers flexibility for evening learning. Choose in-person or live online sessions to master Vectorworks in architecture, interior design, and landscaping. Enroll now even after business hours! Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. The Vectorworks course provides comprehensive training in computer-aided design (CAD) and Building Information Modeling (BIM) using the powerful Vectorworks software. This hands-on, instructor-led course covers 2D drafting, technical drawing, and 3D modeling, enabling participants to apply Vectorworks effectively in real-world projects. Key Features: Hands-on, instructor-led classroom training. Practical Vectorworks CAD projects for real-world application. Part-time evening or weekend options available. 1-2-1 Private learning experience. Module 1: Grasping CAD and Vectorworks Understanding the Role of CAD in Design Getting Acquainted with Vectorworks Software Module 2: Configuring Your Workspace Customizing Your Workspace Essential Options and Preferences Module 3: Mastering Foundational Drawing Skills Techniques for Drawing Object Selection Methods Module 4: Advanced Object Manipulation Merging Shapes Reflecting Objects Rotating Objects Grouping Elements Module 5: Precision Drawing and Scaling Techniques Working with Scale Setting Preferences for Accuracy Creating and Saving Templates Module 6: Achieving Accurate Object Placement Ensuring Drawing Precision Precise Object Movement Module 7: Advanced Editing Methods Utilizing Fillet Tool Applying Offset Function Module 8: Understanding Object Attributes and Groups Basic Attribute Management Editing Object Groups Module 9: Object Duplication Techniques Linear Duplicates Rectangular Duplicates Circular Duplicates Module 10: Crafting Room Plans Designing Walls Incorporating Windows and Doors Module 11: Development of Room Plans Methods for Room Plan Drawing Module 12: Exploring Additional Attributes Hatch Patterns Gradients Image Fills Module 13: Creating Elevation Drawings Elevation Drawing Techniques Effective Approaches Module 14: Importing Images for Graphic Use Graphic Illustration Integrating Images Module 15: Symbols and Resource Handling Symbol Creation Introduction to Resource Browser Module 16: Organizing Drawings Using Design Layers Optimizing Design Layer Utilization Module 17: Labeling Drawings and Title Blocks Drawing Labels Title Block Text Placement Module 18: Plotting and Printing Methods User Interface Navigation and Terminology Printing Approaches Module 19: Generating Drawing Sheets A1, A2, and A3 Sheet Formats Module 20: Utilizing Viewports Effectively Managing Multiple Views Module 21: Professional Model Presentation Techniques Paper Space Presentation Conversion to PDF Formats Module 22: File and Project Management Module 23: Object Display and Terminology Module 24: Objects and Data Management Module 25: Precise Object Placement Object Snapping Quick Selection Module 26: Dividing and Measuring Objects Module 27: Dimensioning and Annotations Module 28: Working with Text Elements Module 29: Customizing Tool Palettes Module 30: Organizing Tool Palettes Module 31: Efficient Tool Palette Usage Module 32: Standard Views and Drawing Techniques Module 33: Drawing Curved Shapes Arcs, Donuts, and Ellipses Drawing Module 34: Real-World Units and Measurements Module 35: Object Manipulation Adjusting Object Angles Module 36: File Handling and Management Saving, Exiting, and Opening Projects Module 37: Creating Mirrored Images Module 38: Introduction to 3D Modeling By the end of the Vectorworks Evening Training Course, participants will: Demonstrate proficiency in using the Vectorworks interface, tools, and navigation. Create and edit 2D drawings, including walls, doors, windows, floors, ceilings, stairs, and railings. Effectively manage layers, classes, and views for organized and controlled object placement. Create and edit dimensions and annotations for accurate measurements and documentation. Develop skills in creating, modifying, and utilizing symbols for increased efficiency. Generate and edit 3D geometry, apply textures, and create sections and elevations from 3D models. Create polished presentation drawings using viewports, annotations, and text for clarity. Summarize course content and confidently apply learned skills in Vectorworks projects. Utilize available resources for further learning and professional development.