Docs و Sheets و Slides | احتراف أدوات جوجل للعمل والدراسة

SQL is the standard language used to interact with databases.In this course i will show you how to build SQL scripts from scratch step by step that you will use during the course to execute insert and update bulk tasks. The skills you will learn on this course will help you confidently approach any bulk SQL request task you in a live production environment.SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsMicrosoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of softwareAs a database developer and administrator you will create queries frequently. Sometimes you also need to generate bulk SQL queries to insert or update multiple records; Microsoft Excel can be used to generate bulk queries that you can execute on a database server.

This course includes downloadable course instructor files and exercise files to work with and follow along.In this Microsoft PowerPoint Slides and Layouts course you'll master essential skills for crafting engaging presentations. Learn to design captivating slides using various layouts and themes to convey your message effectively. You'll discover how to seamlessly add, arrange, and duplicate slides to streamline your workflow. Moreover, you'll explore techniques for reusing slides from existing presentations and creating slides from outlines for enhanced productivity. Customize slide backgrounds and apply cohesive themes to ensure a consistent, professional appearance throughout your presentation. Reinforce your learning with practical examples and exercises throughout the course, ensuring a hands-on understanding of the material. By completing this course, you'll be equipped with the knowledge to create polished presentations efficiently, improving your communication skills and professional impact. Whether you're building a presentation from scratch or enhancing an existing one, these tools will help you present your ideas with clarity and confidence.In this course, you'll learn how to:Create visually appealing slides using diverse layouts.Efficiently add, arrange, and duplicate presentation slides.Incorporate slides from external presentations for seamless integration.Develop slides from outlines for streamlined content creation.This course includes:39 minutes of video tutorials8 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Do you want to help your organization take care of the environment, follow up on the actions implemented and meet environmental objectives on an annual basis? Then this course is perfect for you! Nowadays, companies are increasingly focused on environmental care and seek to implement effective environmental management systems. It is essential to monitor and evaluate the actions implemented, and for this purpose, environmental indicators are the best tool.In our course you will learn everything you need to know about environmental indicators, from scratch. We will show you how to design and establish indicators step by step, so you can apply them in your organization and obtain tangible results. In addition, we will give you examples of both input and output indicators with formulas that you can use in your organization. Our eight classes will teach you everything you need to know: introduction, advantages of environmental indicators, types of indicators, principles for designing indicators, indicators according to ISO 14031, environmental performance indicators, environmental management indicators and environmental status indicators.Using environmental indicators will allow you to identify deviations, weak points in production processes, make comparisons with other sectors, monitor, analyze and evaluate actions to protect the environment, which will allow you to make better decisions.Don't think twice and join our course! Sign up now and become an expert in environmental

In this course, students will learn to automate Microsoft Word through the use of building blocks and Quick Parts for inserting pre-formatted blocks of text and graphics, fields to insert meta data, and recorded Macros to automate repetitive processes. Students will also learn to utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through creating a table of contents, marking and building indexes, and inserting captions. Students will also work with the Outline View and master documents to quickly organize documents, create Mail Merges, and build forms.This course aligns with the CAP Body of Knowledge and should be approved for 2.5 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.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

From the earliest beginner to the mid-skilled Microsoft Excel user, this course is for all those:who want to impress their bosswho aspire to grow in their careerwho desire to create a side hustle with Microsoft Excelwho see the power in knowing a software used globallywho want to create visual trackers to help them improve their livesUnderstanding how to use Microsoft Excel well is a skill that keeps giving. Becoming the person in your office who can create the visually stunning dashboards, the efficient processes, and the transparent reports gives you exposure at your company.Knowing Microsoft Excel creates an opportunity to make additional side income as well, creating business cases for start-ups, doing consulting work, and selling your own templates.Creating personal finance and other goal-related Microsoft Excel templates gives you the ability to see where you are and monitor your progress, resulting in further inspiration to hit your targets.In this course, you'll receive 40 lectures, 30+ associated data sets and templates with those lectures, 40+ formulas, and 30+ shortcuts.All videos and files are downloadable and yours to keep forever.As a student, you'll receive all future updates for free.With over two decades of experience using Microsoft Excel, this course is packed with every valuable tool I've learnt. All lectures allow you to follow along with the given file in the Resources section, or you have the option to build these files from scratch for a more thorough learning experience.Enjoy!

Excel is one of the most essential tools for data management, analysis and decision making in today’s business and academic world. Whether you’re a beginner looking to learn the basics or a professional aiming to master advanced techniques, this course will take you step by step from novice to Excel expert.In Microsoft Excel Masterclass: From Beginner to Advanced, you’ll learn how to organize, analyze and visualize data efficiently. You’ll work with real-world examples, hands-on exercises, and practical projects that make Excel skills immediately applicable.What you’ll learnExcel basics: navigation, formatting, and essential functionsAdvanced formulas and functions for data analysisCreating PivotTables and PivotCharts for summarizing dataDesigning professional reports and dashboardsTips and shortcuts to improve speed and efficiencyReal-world applications for business, finance and personal projectsWhy take this course?Step by step guidance from beginner to advancedHands-on, practical exercises for real-world scenariosLearn at your own pace with lifetime accessBuild job ready Excel skills that boost career growthBy the end of this course, you’ll be able to analyze data, create reports and build dashboards like a pro, unlocking the full potential of Excel for business, study or personal use. Enroll now and start from today.