Learning Management System
Absorb is an AI-powered strategic learning system designed for all internal and external learning needs.
Explore our LMS featuresThis course provides a comprehensive introduction to relational database development and SQL, making it ideal for anyone looking to build a strong foundation in database management. Whether you are new to databases or seeking to solidify your understanding of SQL, this course will guide you through the fundamental concepts and practical techniques necessary to work with relational databases effectively.The course begins with an overview of relational database basics, including a brief history of SQL and the principles underlying relational databases. You will learn about the core components of a relational database, such as tables, rows, columns, and relationships, as well as essential concepts like data types, primary keys, and foreign keys. This section also covers popular commercial and open-source databases, giving you a broad perspective on the database landscape.As you progress, you will delve into the basics of SQL, starting with simple SELECT statements. You will learn how to retrieve data from a database, sort records, and filter results using the WHERE clause. The course also covers logical operators and introduces the concept of checking for NULL values. Practical exercises are included throughout, allowing you to apply these concepts in real-world scenarios.Moving into more advanced topics, the course explores calculated fields, aggregate functions, and grouping data. You will learn how to create complex queries that manipulate data, perform calculations, and group results. The course also introduces built-in data manipulation functions, which are essential for performing operations on strings, numbers, and dates.The course further extends your SQL skills with lessons on subqueries, joins, and unions. You will learn how to combine data from multiple tables, perform outer joins, and use unions to merge results from different queries. This section is crucial for understanding how to work with complex data sets and relational data structures.Conditional processing using the CASE statement is also covered, enabling you to add logic to your SQL queries. This feature is particularly useful for creating dynamic reports and handling various data conditions.If time allows, the course concludes with an introduction to inserting, updating, and deleting records, giving you a full spectrum of SQL capabilities needed for managing data in a relational database.By the end of this course, you will have a solid understanding of relational databases and SQL, empowering you to build, query, and manage databases effectively. This knowledge will provide a strong foundation for further studies in database development or for applying SQL in real-world applications.
Our Advanced Microsoft PowerPoint 2016 Training course is perfect for those looking to master the intricacies of PowerPoint. This course is geared toward companies seeking to enhance their team's presentation skills as well as individuals aiming to elevate their PowerPoint expertise. By the end of this course, you will possess advanced skills that can be applied to create captivating and professional presentations. The journey begins with Customizing Presentations, where you'll explore the process of applying and customizing themes. You’ll learn to preview and select themes and how to make a theme your default. You'll also dive into applying and modifying background styles, and you’ll even get hands-on with adding footers and managing sections to make your presentations unique and organized. Next, the Presentation Masters lesson will guide you through working with slide masters and layouts. You’ll learn how to format slide masters, add watermarks, and insert new slide masters. Additionally, you'll get proficient in modifying the notes and handout masters to ensure consistency and professionalism throughout your presentation materials. In the lesson on Working with Special Effects, you’ll unlock the potential of animating text and objects within your slides. You’ll understand how to set animation timing and use the Animation Painter effectively. Plus, you’ll practice animating charts to make your data presentations more dynamic and engaging. Using SmartArt;covers;inserting, modifying, and formatting SmartArt graphics. You'll learn to resize and reposition SmartArt objects, insert text, and add shapes to your graphics. This lesson also covers ungrouping SmartArt objects, providing you with flexibility and control over visual elements. The course will then cover the use of Multimedia in presentations. You’ll discover how to create photo albums, add captions, and apply themes to your albums. You’ll also get practical experience inserting and editing sounds and videos, including integrating YouTube videos, to create highly engaging multimedia presentations. Setting up the Slide Show explores how to configure custom shows and set slide show resolution. You’ll also learn to create hyperlinks, add action buttons, and navigate within a slide show. The exercises will guide you in preparing a presenter-independent slide show and setting it to repeat automatically for seamless presentations. The Outlines and Slides lesson teaches you how to export notes and handouts to Word, save presentations as outlines or graphics, and set handout print options. These skills are invaluable for creating comprehensive documentation to accompany your presentations. In Managing Multiple Presentations, you’ll discover techniques for merging presentations, reusing slides, and viewing multiple presentations simultaneously. Learn to track changes, manage comments, and effectively review alterations in PowerPoint through guided exercises. The course's lesson on Sharing and Securing a Presentation will cover how to share presentations with remote audiences, embed fonts, and package presentations for CD. You’ll also learn to inspect presentations, encrypt them, add digital signatures, and manage permissions, ensuring your presentations are secure and accessible. Lastly, the course reviews the Microsoft PowerPoint Features that Were New in 2013 and Features New in 2016. You’ll become familiar with new functionalities like using comments, motion path changes, merging shapes, and creating custom colors with the eyedropper. Notably, you will practice these new features to stay updated with the latest in PowerPoint capabilities. By completing this Advanced Microsoft PowerPoint 2016 Training, you and your team will be equipped to craft impressive, innovative, and professional presentations. Be ready to leverage these advanced tools and techniques to communicate your ideas more effectively.
Learn moreGet started with Microsoft Excel 2016. This comprehensive beginner-level training covers everything you need to know to create professional-looking worksheets to organize, manipulate, and analyze data with ease. To begin, the course familiarizes you with the user interface and outlines the basics of setting up a new worksheet. You’ll learn how to enter your data, implement basic formulas, apply custom formatting, and insert objects and graphics. You'll also learn how to proof your work, print and export Excel files, work within different views, and so much more. This course is the first part in a 3-part series on Excel 2016. To take your skills to the next level, watch the next courses in the series, Excel 2016 Intermediate and Excel 2016 Advanced. This course aligns with the CAP Body of Knowledge and should be approved for 3.75 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Learn moreExpand your basic Excel 2016 skillset by learning about intermediate features and functions that will help you work more efficiently, and effectively, with your data. In this course, you will learn how to work with text, logical and lookup functions, in addition to learning how to use range names to simplify and improve the readability of your formulas. You'll learn how to create tables and charts, as well as more advanced PivotTables and PivotCharts, to organize and analyze your data. Navigate through your worksheets and workbooks more effectively by creating links, using conditional formatting and outlining subtotals and groups. The course also covers how to work with Flash Fill and date and time functions to save time and effort. This course is the second part in a 3-part series on Excel 2016. To take your skills to the next level, watch the next course in the series, Excel 2016 Advanced. This course aligns with the CAP Body of Knowledge and should be approved for 4 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Learn more