At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.
Learn to design using Adobe XD and create a real-world iPhone app with the Adobe XD Design Diploma course. Adobe XD is the all-in-one UX/UI solution for designing websites, mobile apps, and many more. In this course, you will learn the necessary tools of Adobe XD and learn how to apply Paper Prototyping techniques. The course guides you to create Interactive Prototype using the software and teaches you how to open sketch, Photoshop and Illustrator files with Adobe XD. Instead of these, you will master the techniques of collaborating with other developers using Zeplin & Avocode in the course. Upon completion, you will be able to design a fantastic iPhone (IOS) real world App in Adobe XD following iOS Design guidelines. What Will I Learn? Get grip on all the basic tools and techniques of Adobe XD Learn to apply Paper Prototyping techniques Design a stunning iPhone (IOS) real world App in Adobe XD Create Interactive Prototype using Adobe XD Export Assets and Design Specification for Developers Use Zeppelin and Avocode to Handoff your designs to developers Design with IOS Design guidelines Batch Export all assets in 1x 2x and 3x resolutions Requirements Install Adobe XD (at least trial version) MAC or Windows 10 at least Enterprise Edition Update Pencil, Black Pointer and Highlighter for Paper Prototyping Module: 01 What Is Adobe XD 00:07:00 Download And Install Adobe Xd 00:03:00 Why Adobe XD Is So Awesome - Talkinghead FREE 00:04:00 Updates And Upcoming Features Xd 00:03:00 Adobe XD Interface Welcome Screen FREE 00:03:00 Adobe Xd Top Nav Bar 00:02:00 Adoe Xd Interface Toolbar 00:02:00 Properties Panel Adoe Xd Interface 00:03:00 Xd Mac And Win Differences 00:05:00 First Assignment Simple One 00:07:00 Module: 02 Artboards and grids 00:08:00 Tools in xd 00:05:00 Rectangle tool to create buttons 00:06:00 Background and object blur 00:03:00 Ellipse tool 00:02:00 Basics of pen tool 00:03:00 Pen tool to creat Icons 00:06:00 Line tool 00:01:00 Text-tool 00:03:00 Colors Palettes 00:04:00 Color Gradients in Xd 00:06:00 Coolors.io 00:04:00 Masks in xd 00:06:00 Character styles in Xd 00:05:00 Creating and reusing symbols 00:07:00 Repeat grid 00:09:00 Common Shortcuts 00:06:00 Shortcut keys part2 00:08:00 Nested symbols in xd 00:06:00 Module: 03 S03L01 block-level design 00:12:00 S0302 Sketching First Design Idea-block Level Paper 00:08:00 S0303 First Paper Prototype- Adding Details 00:04:00 S0304 Vertical Horizontal Prototypes T Proto 00:09:00 S0305 Level Of Fidelity and prototypes 00:04:00 S0306 adding details to your block design 00:08:00 S0307 using ui design patterns 00:06:00 S0308 creating signup ios screen EXERCISE 00:14:00 Module: 04 S0401 Design preparations 00:05:00 S0402 Color scheme and insprations 00:05:00 S0403 Solving UX problems of old app 00:04:00 S0404 Welcome Screen design 00:10:00 S0405 designing the login screen 00:14:00 S0406 login-activated 00:12:00 S0407 Signup Screen 00:07:00 S0408 dashboard design part 1 00:12:00 S0409 dashboard design part 2 00:11:00 S0410 Sidebar Navigation 00:09:00 S0411 actitivies screen 00:11:00 S0412 sync screen 00:08:00 S0413 sync status update 00:04:00 S0414 using grids to improve designs further 00:05:00 S0415 refining style guides 00:08:00 S0416 IOS Design guidelines 00:09:00 Module: 05 S0501 fixing tap targets 00:06:00 S0502 prototype login and signup screens 00:10:00 S0503 prototyping dashboards and other screens 00:11:00 S0504 sharing prototype with others 00:04:00 S0505 recording prototype on mac 00:02:00 S0506 design Inspect beta 00:04:00 Module: 06 S0601 why to export in 1x 2x 3x 00:09:00 S0602 Perfect example of 1x 2x 3x 00:03:00 S0603 export artboards to create mockups 00:08:00 S0604 batch export 00:06:00 Module: 07 S0701 Live Preview Your App On Iphone 00:02:00 S0702 Developer handoff with Zeplin 00:13:00 S0703 Developer Handoff using Avocode 00:14:00 S0704 open sketch-psd-illustrato import 00:08:00 Module: 08 XD updtaes april may 2018 00:04:00 1st Exercise Asssignment-1 00:03:00 Second Assignment-1 00:03:00 Third Last Assinment - Google Drive 00:03:00 Resources Resources - Adobe XD Design Diploma 00:00:00
Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas
From downloading and installing to creating beautiful dashboards, this course takes you through all the essential concepts of the MicroStrategy Desktop application. You will learn to import data from Excel and transform this data into appealing charts, filters, and graphs that are easy to understand.
The course will cover special procedures and the benefits of using IP and OP in your compliance.
Overview This comprehensive course on Programming AutoCAD to Excel using VB.NET will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Programming AutoCAD to Excel using VB.NET comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Programming AutoCAD to Excel using VB.NET. It is available to all students, of all academic backgrounds. Requirements Our Programming AutoCAD to Excel using VB.NET is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 102 lectures • 09:34:00 total length •Introduction: 00:04:00 •Who is this course for?: 00:02:00 •What will you learn from this course?: 00:05:00 •Tools needed: 00:01:00 •Course Prerequisites: 00:04:00 •Section Overview - Export AutoCAD Objects to Excel: 00:02:00 •Exporting Lines to Excel - Overview: 00:02:00 •Creating the VB.NET-Excel Project: 00:06:00 •Design of User Interface to Export Lines: 00:10:00 •Creating the Common Utility Class: 00:19:00 •Creating the ExportLines Method: 00:12:00 •Running and Testing ExportLines Method: 00:06:00 •Exporting MTexts to Excel - Overview: 00:02:00 •Creating the ExportMTexts Method: 00:11:00 •Export Polylines to Excel - Overview: 00:01:00 •Creating the ExportPolylines Method: 00:12:00 •Running and Testing ExportPoylines Method: 00:12:00 •Export Blocks (Without Attributes) to Excel - Overview: 00:01:00 •Creating the ExportBlocks Method: 00:12:00 •Creating Export Blocks UI and Running the Code: 00:06:00 •Exporting Blocks (With Attributes) to Excel - Overview: 00:02:00 •Creating the User Interface for exporting Blocks to Excel: 00:05:00 •Creation of BlocksForm UI: 00:04:00 •Coding the BlocksForm Load Event: 00:08:00 •Testing the BlocksForm UI: 00:03:00 •Coding the BlocksForm to populate the Listboxes: 00:15:00 •Coding the BlocksForm Export Button: 00:04:00 •Coding the ExportBlocksWithAttributes Method: 00:21:00 •Running and Testing ExportBlocksWithAttributes Method: 00:02:00 •Section Overview - Import Excel File into AutoCAD: 00:01:00 •Importing Lines from Excel File into AutoCAD - Overview: 00:01:00 •Creating ImportExcelUtil Class: 00:02:00 •Creating the ImportLines Method: 00:19:00 •Creating the UI for the ImportLines Method: 00:02:00 •Coding the ImportLines UI code behind.: 00:07:00 •Running and Testing ImportLines Method: 00:08:00 •Importing MTexts into AutoCAD - Overview: 00:01:00 •Creating the ImportMTexts Method: 00:11:00 •Creating ImportMTexts User Interface: 00:02:00 •Running and Testing ImportMTexts Method: 00:02:00 •Importing Polylines from Excel File into AutoCAD - Overview: 00:01:00 •Creating the ImportPolylines Method: 00:14:00 •Creating ImportPolylines User Interface: 00:02:00 •Running and Testing ImportPolylines Method: 00:03:00 •Running and Testing ImportPolylines (from a File) Method: 00:02:00 •Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview: 00:01:00 •Creating the ImportBlocks Method: 00:09:00 •Creating the ImportBlocks User Interface: 00:02:00 •Running and Testing ImportBlocks Method: 00:03:00 •Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocksWithAttributes Method: 00:25:00 •Creating the UI for ImportBlocksWithAttributes Method: 00:04:00 •Running and Testing ImportBlocksWithAttributes Method: 00:03:00 •Exporting Lines to a File - Overview: 00:02:00 •Creating the ExportToFile Utility Class: 00:04:00 •Creating ExportLinesToFile Method: 00:14:00 •Creating the UI for ExportLinesToFile Method: 00:08:00 •Running and Testing ExportLinesToFile Method: 00:02:00 •Exporting MTexts to File - Overview: 00:01:00 •Creating the MTextToFile Method: 00:06:00 •Creating the UI for the ExportMTextToFile Method: 00:01:00 •Running and Testing ExportMTextToFile Method.: 00:08:00 •Exporting Polylines to File - Overview: 00:02:00 •Creating ExportPolylinesToFile Method: 00:11:00 •Exporting Polylines to File - User Interface: 00:01:00 •Running and Testing ExportPolylinesToFile Method: 00:02:00 •Exporting Blocks (without Attributes) to File - Overview: 00:02:00 •Creating the ExportBlocksToFile Method: 00:10:00 •Creating ExportBlocksToFile User Interface: 00:02:00 •Running and Testing ExportBlocksToFile Method: 00:02:00 •Exporting Blocks (With Attributes) to a File - Overview: 00:02:00 •Creating the EXportBlocksWithAttributesToFile Method: 00:19:00 •Creating the UI for ExportBlocksWithAttributesToFile Method: 00:06:00 •Coding the BlocksForm for ExportBlocksWithAttributeToFile Method: 00:04:00 •Running and Testing ExportBlocksWithAttributesToFile Method: 00:03:00 •Importing Text File into AutoCAD - Overview: 00:01:00 •Importing Lines from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportFileUtil Class: 00:01:00 •Creating the ImportLinesMethod: 00:17:00 •Creation of ImportLines User Interface: 00:03:00 •Coding the ImportLines UI button: 00:05:00 •Running and Testing the ImportLines Method: 00:04:00 •Importing MTexts from Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportMTexts Method: 00:09:00 •Creating the TextStyle Manipulation Code: 00:02:00 •Creating the UI for the ImportMTexts Method: 00:01:00 •Running and Testing the ImportMTexts Method: 00:04:00 •Importing Polylines from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportPolylines Method: 00:18:00 •Creating the ImportPolylines UI: 00:02:00 •Running and Testing ImportPolylines (from a File) Method: 00:02:00 •Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocks (without Attributes) Method: 00:15:00 •Creating the ImportBlocks UI: 00:05:00 •Running and Testing ImportBlocks (without Attributes) Method: 00:04:00 •Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocksWithAttributes from a File Method: 00:24:00 •Creating the ImportBlocksWithAttributes (from a File) UI (Part 1): 00:06:00 •Creating the ImportBlocksWithAttributes (from a File) UI (Part 2): 00:04:00 •Running and Testing ImportBlocksWithAttributes (from a File) Method: 00:03:00 •Conclusion: 00:01:00 •Assignment - Programming AutoCAD to Excel using VB.NET: 00:00:00
HGV (Heavy Goods Vehicle) HGV Mechanic Training Overview Do you want to learn what it takes to be an HGV Mechanic? With approximately 100k vacancies UK-wide and earning potential of up to £70k a year, there has never been a better time to be an HGV Mechanic in the UK. Rev up your engines and accelerate your career with our exclusive HGV Mechanic Training Bundle! This comprehensive collection of 14 CPD-certified HGV Mechanic courses will give you the theoretical knowledge to excel in the world of transport, logistics, and vehicle maintenance. Get ready to transform your life and career by unlocking the secrets of this exciting and in-demand field. From mastering the ins and outs of Heavy Goods Vehicle (HGV Mechanic) to learning how to manage and optimize transport operations, this bundle covers it all. Discover the essentials of delivery driving, freight consulting, logistics management, and so much more. Our HGV Mechanic course will equip you with the information you need to understand complex processes like import/export and warehouse management. In addition, you'll learn crucial safety practices, spill management, and emergency first aid to ensure a safe and efficient work environment. This HGV Mechanic Bundle Consists of the following Premium courses: Course 01: Large Goods Vehicle (LGV) Course 02: Delivery Driver Training Course 03: Transport Management Diploma Course 04: Freight Consultant Training Course 05: Logistic Management Course 06: Import/Export Processing Course 07: Car Mechanic and Repair Training Course 08: MET Technician Course 09: Driver Safety Awareness Certificate - CPD Certified Course 10: Engine Lubricant System Training - Level 4 Course 11: Warehouse Course 12: Manual Handling Level 2 Course 13: Spill Management Training Course 14: Emergency First Aid and Incident Management at Work Learning Outcomes of Heavy Goods Vehicle (HGV Mechanic): Gain comprehensive theoretical knowledge in transport, logistics, and vehicle maintenance. Understand the intricacies of Large Goods Vehicles (LGV) operations and management. Acquire essential skills in delivery driving and transport management. Learn about freight consultancy and logistics management best practices. Master import/export processing and warehouse management techniques. Develop a solid foundation in vehicle mechanics and repair. Enhance your awareness of driver safety and manual handling practices. Gain expertise in spill management, emergency first aid, and incident management at work. Benefits you'll get from choosing Apex Learning for this HGV Mechanic: Pay once and get lifetime access to 14 CPD courses in this HGV Mechanic Training Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the HGV Mechanic course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of HGV Mechanic designed by expert instructors Learn about HGV Mechanic at your ease - anytime, from anywhere Study from your computer, tablet or mobile device How will I get my HGV Mechanic Certificate? After successfully completing the HGV Mechanic course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) So, enroll HGV Mechanic now to advance your career! CPD 140 CPD hours / points Accredited by CPD Quality Standards Certificates Certificate of Completion (PDF) Digital certificate - Included Certificate of Completion (Hard Copy) Hard copy certificate - Included You will get the Hard Copy certificate for the title course Large Goods Vehicle (LGV) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Description The course curriculum of HGV Mechanic Bundle : Course 01: Heavy Goods Vehicle Module 01: Knowing Your LGV Module 02: Characteristics of Vehicle Module 03: Vehicle Limit Module 04: Loads and Load Restraint Module 05: Drivers' Hours and Records Module 06: Vehicles and Driving Module 07: Health and Conduct Module 08: Your LGV Module 09: Qualified LGV Driver Module 10: Provisional LGV Licence Module 11: CPC Test Part 01 and 02 Module 12: CPC Test Part 03 and 04 Module 13: After Getting Qualification =========>>>>> And 13 More HGV Mechanic Courses <<<<<========= Enroll now in HGV Mechanic Training to advance your career, and use the premium study materials from Apex Learning. Who is this course for? Anyone from any background can enrol in this HGV Mechanic bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this HGV Mechanic course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our HGV Mechanic is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This HGV Mechanic course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. Career path HGV Mechanic Having this various HGV Mechanic expertise will increase the value of your CV and open you up to multiple job sectors. LGV Mechanic Transport Manager Logistics Coordinator Freight Forwarder Warehouse Manager Delivery Driver HGV Driver Trainee HGV Driver HGV Class 2 Driver LGV Mechanic Heavy Vehicle Mechanic Fitter
Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!
Linux training course description A Linux foundation appropriate for all flavours of Linux, focussed on getting network engineers up and running with Linux. The command line is used throughout. The course progresses from the basics of Linux commands onto useful tools such as grep, then shell features such as piping and then onto shell scripting. Administration aspects covered are the tasks network engineers are most likely to encounter such as software installation. Hands on exercises concentrate on network related tasks such as installing net-snmp and using shell scripts to provide network automation. What will you learn Use Linux commands to perform a variety of tasks from manipulating files to handling processes. Create and edit files with vi. Work with permissions. Write simple shell scripts. Install software packages. Configure base networking. Linux training course details Who will benefit: Network engineers. Prerequisites: TCP/IP Foundation Duration 5 days Linux training course contents What is Linux? Linux distributions, open source software. Getting started Logging in, changing passwords, logging out. Hands on Basics and root access. Linux basics Command structure. The Linux manuals, basic commands (who, date, tty, uname, echo, banner...). Hands on Using the CLI. Connecting to a network IP configuration, DHCP, static addressing, routing, ifconfig, ping, netstat, traceroute, dig. Hands on Network configuration and testing. Managing Software Package Concepts, Comparison of package formats, RPM, rpm Commands, Yum, Debian Packages, dpkg, apt-cache, apt-get, dselect, aptitude, Converting Between Package Formats, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management Hands on Installing network packages such as nmap and net-snmp. Processes and log files ps, kill, background processes, at, exec, priorities. Managing Linux log files. Syslogd. Setting the time. Cron and cronjobs. Managing Processes, the Kernel: The First Process. Hands on Controlling daemons and services. Setting up a TFTP server. Filesystem commands Home directories, manipulating files and directories, Filesystem layout, Pathnames, hard and symbolic links. Viewing files. Hands on Exploring the filesystem, working with network device configuration files. The Linux editors ed, vi, shell escapes, .exrc. Hands on Editing network device configuration files. Extracting data from files grep, find, cut, sort and paste⦠Hands on Working with syslog files. Permissions Theory, chmod, chown, newgrp. Hands on Handling permission problems. The shell Metacharacters, piping and redirection. Hands on Running SNMP commands and working with their output. Basic shell scripting What are shell scripts? Simple scripts, control structures. Variable. Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. Positional parameters: $0 to $9, $#, $* and others. shift parameter substitution. Control statements: The test command, if , while loops, for loops, the case statement. Hands on Automating network tasks. Customising your environment Environmental variables, stty, .profile and other startup files. Hands on Customising Linux. Introduction to administration The root user, su. Managing users and groups. Hands on The power of root. Archiving files Backups, tar, cpio, dd, gzip. Hands on Working with tar files. Booting Linux and Editing Files Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system. Hands on Installing network services on Linux.
Get hands-on with a working knowledge of the basics needed to operate Unreal Engine 4