- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone 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 Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone 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 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00
Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification 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 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00
Overview This comprehensive course on Complete SAP UI5 Development will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete SAP UI5 Development comes with accredited certification, 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 Complete SAP UI5 Development. It is available to all students, of all academic backgrounds. Requirements Our Complete SAP UI5 Development 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 39 lectures • 08:22:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Tools for this Course: 00:03:00 •Module 01: HTML Introduction: 00:16:00 •Module 02: CSS and CSS Selectors: 00:17:00 •Module 03: CSS Box Model: 00:11:00 •Module 04: CSS Layout Flexbox and Grid: 00:18:00 •Module 05: CSS Responsive Design Concept: 00:06:00 •Module 01: Data Types and Operations: 00:34:00 •Module 02: Functions: 00:13:00 •Module 03: Conditions and Loops: 00:19:00 •Module 04: Promise and Async await: 00:16:00 •Module 05: Events: 00:08:00 •Module 01: Load UI5 Libraries: 00:17:00 •Module 02: Views and Controllers: 00:27:00 •Module 03: Component and Descriptor: 00:12:00 •Module 04: JSON Model and Data Binding: 00:14:00 •Module 05: Layout: 00:14:00 •Module 06: Data Format and Icons: 00:14:00 •Module 07: MVC in UI5: 00:05:00 •Module 01: SAP Web IDE and SAP Fiori Launchpad Introduction: 00:11:00 •Module 02: Migrate Project to SAP Web IDE: 00:17:00 •Module 03: Resource Model and Multi-language Support: 00:11:00 •Module 04: Fragments and Dialog: 00:20:00 •Module 05: Routing and Navigation: 00:23:00 •Module 06: Device API: 00:12:00 •Module 01: Use Rest API: 00:07:00 •Module 02: OData Service Introduction: 00:12:00 •Module 03: Use OData Service V2: 00:14:00 •Module 04: Sort and Filter Data: 00:14:00 •Module 05: Create Update Delete Read with OData Service V2: 00:14:00 •Module 06: Use OData Service V4: 00:06:00 •Module 07: Create Update Delete and Auto Data Type Detection with OData Service V4: 00:13:00 •Module 08: Action and Function Binding in OData Service V4: 00:08:00 •Module 09: Troubleshooting: 00:11:00 •Module 01: SAP Fiori Launchpad Core Concept: 00:06:00 •Module 02: Deploy to SAP Cloud Platform: 00:12:00 •Module 03: Deploy to SAP Gateway System: 00:22:00 •Module 04: Deploy to non-SAP Environment: 00:04:00 •Assignment - Complete SAP UI5 Development: 00:00:00
Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00
Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00
Overview This comprehensive course on Learn AutoCAD Programming using VB.NET - Hands On! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn AutoCAD Programming using VB.NET - Hands On! 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 Learn AutoCAD Programming using VB.NET - Hands On!. It is available to all students, of all academic backgrounds. Requirements Our Learn AutoCAD Programming using VB.NET - Hands On! 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 105 lectures • 12:09:00 total length •Module 01: Course Outline: 00:05:00 •Module 02: Introduction: 00:01:00 •Module 03: Who is this Course for?: 00:01:00 •Module 04: What will I learn from this Course?: 00:01:00 •Module 05: What is VB.NET?: 00:01:00 •Module 06: What is AutoCAD .NET API?: 00:01:00 •Module 07: What are the advantages of programming in AutoCAD .NET API?: 00:01:00 •Module 08: Hands-on Projects overview: 00:06:00 •Module 01: AutoCAD .NET API Components Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Understanding AutoCAD Object Hierarchy: 00:03:00 •Module 04: AutoCAD .NET API Application Object: 00:02:00 •Module 05: AutoCAD .NET API Document Object: 00:02:00 •Module 06: AutoCAD .NET API Database Object: 00:04:00 •Module 01: Section Overview: 00:04:00 •Module 02: Installing Visual Studio 2019: 00:05:00 •Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE): 00:04:00 •Module 04: Creating First VB.NET Plugin (Hello AutoCAD): 00:12:00 •Module 05: Different ways to communicate with the User: 00:04:00 •Module 06: Configuring VS2019 Target Processor: 00:10:00 •Module 01: Creating AutoCAD Object using VB.NET Overview: 00:01:00 •Module 02: Creating DrawObjects Project: 00:04:00 •Module 03: Creating a Line Object using VB.NET: 00:15:00 •Module 04: Creating a MText Object using VB.NET: 00:12:00 •Module 05: Creating a Circle Object using VB.NET: 00:09:00 •Module 06: Creating an Arc Object using VB.NET: 00:07:00 •Module 07: Creating a Polyline Object using VB.NET: 00:08:00 •Module 08: Creating Multiple Circles Vertically: 00:09:00 •Module 09: Creating Multiple Circles Horizontally: 00:05:00 •Module 01: Manipulating AutoCAD Objects Overview: 00:01:00 •Module 02: Creating the Project ManipulateObjects: 00:04:00 •Module 03: Creating the SingleCopy Method: 00:13:00 •Module 04: Creating the MultipleCopy Method: 00:11:00 •Module 05: Creating the EraseObject Method: 00:12:00 •Module 06: Creating the MoveObject method: 00:07:00 •Module 07: Creating the MirrorObject method: 00:10:00 •Module 08: Creating the RotateObject method: 00:07:00 •Module 09: Creating the ScaleObject method: 00:05:00 •Module 10: Creating the OffsetObject method: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Overview: 00:02:00 •Module 02: Creating LayersLineTypesAndStyles Project: 00:06:00 •Module 03: Creating the ListLayers Method: 00:11:00 •Module 04: Creating the CreateLayer Method: 00:10:00 •Module 05: Creating the UpdateLayer Method: 00:12:00 •Module 06: Creating the SetLayerOnOff Method: 00:08:00 •Module 07: Creating the SetLayerFrozenOrThaw Method: 00:04:00 •Module 08: Creating the DeleteLayer Method: 00:05:00 •Module 09: Creating the LockUnlockLayer Method: 00:04:00 •Module 10: Creating the SetLayerToObject Method: 00:08:00 •Module 11: Creating the ListLineTypes Method: 00:09:00 •Module 12: Creating the LoadLineType Method: 00:07:00 •Module 13: Creating the SetCurrentLineType Method: 00:05:00 •Module 14: Creating the DeleteLineType Method: 00:09:00 •Module 15: Creating the SetLineTypeToObject Method: 00:05:00 •Module 16: Exploring TextStyles - Overview: 00:01:00 •Module 17: Creating the ListStyles Method: 00:08:00 •Module 18: Creating the UpdateCurrentTextStyleFont Method: 00:12:00 •Module 19: Creating the SetCurrentTextStyle Method: 00:08:00 •Module 20: Creating the SetTextStyleToObject Method: 00:08:00 •Module 01: User Input Functions - Overview: 00:02:00 •Module 02: Creating the UserInteractions Project: 00:03:00 •Module 03: Creating the GetName Method: 00:11:00 •Module 04: Creating the SetLayer Method using the GetString function: 00:12:00 •Module 05: Creating the CreateLineUsingGetpoint Method: 00:11:00 •Module 06: Creating the CalculateDefinedArea Method: 00:17:00 •Module 07: Creating the DrawObjectsUsingGetKeywords Method: 00:14:00 •Module 08: Creating the GetDistanceBetweenTwoPoints Method: 00:05:00 •Module 09: Creating the CountObjects Method: 00:15:00 •Module 01: Selection Sets and Filters - Overview: 00:13:00 •Module 02: Creating the SelectionSets Project: 00:05:00 •Module 03: Creating the SelectAllAndChangeLayer Method: 00:12:00 •Module 04: Creating the SelectObjectOnScreen Method: 00:08:00 •Module 05: Creating the SelectWindowAndChangeColor Method: 00:06:00 •Module 06: Creating the SelectCrossingAndDelete Method: 00:05:00 •Module 07: Creating the SelectFenceAndChangeLayer Method: 00:06:00 •Module 08: Creating the CountPickFirstSelection Method: 00:07:00 •Module 09: Creating the SelectLines Method: 00:13:00 •Module 10: Creating the SelectMTexts Method: 00:05:00 •Module 11: Creating the SelectPlines Method: 00:04:00 •Module 12: Creating the SelectWalls Method: 00:07:00 •Module 13: Creating the SelectStairs Method: 00:03:00 •Module 14: Creating the SelectFrenchDoors Method: 00:04:00 •Module 15: Creating the SelectBifoldDoors Method: 00:03:00 •Module 16: Creating CountReceptacles Method: 00:04:00 •Module 17: Creating the CountLightingFixtures Method: 00:10:00 •Module 01: Developing Projects - Hands on Overview: 00:02:00 •Module 02: BlocksCounter Plugin Demo: 00:03:00 •Module 03: Creating the BlocksCounter Project: 00:04:00 •Module 04: Creating the CountBlocksToTable Method: 00:08:00 •Module 05: Creating the PromptUser Function: 00:08:00 •Module 06: Creating the GatherBlocksAndDrawTable Method: 00:12:00 •Module 07: Continuation of GatherBlocksAndDrawTable Method: 00:17:00 •Module 08: Running and Debugging the BlocksCounter Project - Part 1: 00:15:00 •Module 09: Running and Debugging the BlocksCounter Project - Part 2: 00:11:00 •Module 10: Running and Debugging the BlocksCounter Project - Part 3: 00:01:00 •Module 11: Creating the ObjectExtractor Plugin Project: 00:04:00 •Module 12: Creating the ExtractObjects Method: 00:07:00 •Module 13: Creating the ExtractLine Method: 00:16:00 •Module 14: Running and Debugging the ExtractLine Method: 00:05:00 •Module 15: Creating the ExtractCircle Method: 00:11:00 •Module 16: Creating the ExtractMText Method: 00:13:00 •Module 17: Creating the ExtractPolyline Method: 00:19:00 •Module 18: Creating the ExtractBlock Method: 00:10:00 •Module 01: Congratulations and Thank you very much!: 00:01:00 •Assignment - Learn AutoCAD Programming using VB.NET - Hands On!: 00:00:00
Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00
Overview This comprehensive course on AutoCAD Programming Using C#.NET Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming Using C#.NET Level 7 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 AutoCAD Programming Using C#.NET Level 7. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming Using C#.NET Level 7 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 193 lectures • 16:44:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Who is this course for?: 00:01:00 •Module 03: What Will I Learn from this Course?: 00:01:00 •Module 04: What is CSharp (C#)?: 00:01:00 •Module 05: What is AutoCAD .NET API?: 00:01:00 •Module 06: What are the advantages of programming in AutoCAD .NET API?: 00:02:00 •Module 01: Section Overview: 00:01:00 •Module 02:.NET Framework Architecture Overview: 00:03:00 •Module 03: .NET Framework Class Library, Common Type System, Common Language Runtime: 00:03:00 •Module 04: More about.NET Framework Common Language Runtime (CLR): 00:02:00 •Module 05: Visual Studio 2017 Integrated Development Environment (IDE): 00:03:00 •Module 06: Visual Studio 2017 IDE Demo: 00:07:00 •Module 01: Section Overview: 00:03:00 •Module 02: DataTypes and Variables - Value Types (signed/unsigned integers): 00:04:00 •Module 03: DataTypes and Variables - Signed and Unsigned Integer Demo: 00:06:00 •Module 04: DataTypes and Variables - Floating Point and Decimal: 00:02:00 •Module 05: DataTypes and Variables - Floating Point and Decimal Demo: 00:04:00 •Module 06: DataTypes and Variables - Boolean: 00:03:00 •Module 07: DataTypes and Variables - Reference Types: 00:03:00 •Module 08: DataTypes and Variables - Class Type: 00:03:00 •Module 09: DataTypes and Variables - Class Type - Demo: 00:11:00 •Module 10: DataTypes and Variables - Interface Type: 00:01:00 •Module 11: DataTypes and Variables - Array Type: 00:02:00 •Module 12: DataTypes and Variables - Array Type - Demo (Single Dimension): 00:08:00 •Module 13: DataTypes and Variables - Array Type - Demo (Multi Dimension): 00:10:00 •Module 14: C# Operators Overview: 00:02:00 •Module 15: C# Assignment Operators: 00:03:00 •Module 16: C# Assignment Operators - Demo: 00:06:00 •Module 17: C# Unary Operators: 00:02:00 •Module 18: C# Unary Operators - Demo: 00:02:00 •Module 19: C# Primary Operators: 00:03:00 •Module 20: C# Primary Operators - Demo: 00:07:00 •Module 21: C# Equality Operators: 00:01:00 •Module 22: C# Equality Operators - Demo: 00:02:00 •Module 23: C# Additive Operators: 00:02:00 •Module 24: C# Additive Operators - Demo: 00:01:00 •Module 25: C# Multiplicative Operators: 00:01:00 •Module 26: C# Multiplicative Operators - Demo: 00:01:00 •Module 27: C# - Relational and Type Operators: 00:04:00 •Module 28: C# - Logical, Conditional and Null Operators: 00:04:00 •Module 29: C# - Logical, Conditional and Null Operators - Demo: 00:07:00 •Module 30: C# Keywords (Reserved Words): 00:04:00 •Module 31: C# - Conditionals Overview: 00:01:00 •Module 32: C# Conditionals - If-Then-Else Statement: 00:03:00 •Module 33: C# Conditionals - If-Then-Else Statement - Demo: 00:07:00 •Module 34: C# Conditionals - Switch Statement: 00:03:00 •Module 35: C# Conditionals - Switch Statement - Demo: 00:00:00 •Module 36: C# - Loops Overview: 00:04:00 •Module 37: C# Loops - For Loop: 00:02:00 •Module 38: C# Loops - For Loop - Demo: 00:02:00 •Module 39: C# Loops - Foreach Loop: 00:02:00 •Module 40: C# Loops - Foreach Loop - Demo: 00:05:00 •Module 41: C# Loops - While Loop: 00:02:00 •Module 42: C# Loops - While Loop - Demo: 00:02:00 •Module 43: C# Loops - Do While Loop: 00:02:00 •Module 44: C# Loops - Do While Loop - Demo: 00:03:00 •Module 45: Modifiers Overview: 00:04:00 •Module 46: Debugging Overview: 00:03:00 •Module 47: Debugging - Demo 1: 00:05:00 •Module 48: Debugging - Demo 2: 00:12:00 •Module 49: Debugging - Demo 3: 00:06:00 •Module 50: Error and Exception Handling - Overview: 00:02:00 •Module 51: ExceptionHandling - Demo 1: 00:07:00 •Module 52: ExceptionHandling - Demo 2: 00:07:00 •Module 53: ExceptionHandling - Demo 3: 00:13:00 •Module 54: Introduction to Object Oriented Programming (OOP): 00:04:00 •Module 55: OOP - Encapsulation - Demo (Part 1): 00:11:00 •Module 56: OOP - Encapsulation - Demo (Part 2): 00:12:00 •Module 57: OOP - Inheritance - Demo (Part 1): 00:07:00 •Module 58: OOP - Inheritance - Demo (Part 2): 00:05:00 •Module 59: OOP - Polymorphism - Demo (Part 1): 00:10:00 •Module 60: OOP - Polymorphism - Demo (Part 2): 00:03:00 •Module 01: AutoCAD .NET API - Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Using AutoCAD .NET API in C# - Hello AutoCAD Demo Part 1: 00:12:00 •Module 04: Using AutoCAD .NET API in C# - Hello AutoCAD Demo - Part 2: 00:04:00 •Module 05: AutoCAD .NET API Object Hierarchy: 00:03:00 •Module 06: AutoCAD .NET API - Application Object Overview: 00:03:00 •Module 07: AutoCAD .NET API - Document Object Overview: 00:03:00 •Module 08: AutoCAD .NET API - Database Object Overview: 00:03:00 •Module 01: Creating AutoCAD Objects using AutoCAD .NET API - Overview: 00:01:00 •Module 02: Creating a Line Object - Lab (Part 1): 00:14:00 •Module 03: Creating a Line Object - Lab (Part 2): 00:03:00 •Module 04: Creating a MText Object - Lab: 00:10:00 •Module 05: Creating a Circle Object - Lab: 00:07:00 •Module 06: Creating an Arc Object - Lab: 00:05:00 •Module 07: Creating a LWPolyline Object - Lab: 00:05:00 •Module 01: Manipulate AutoCAD Objects - Overview: 00:01:00 •Module 02: Copy Object using C# - Theory: 00:01:00 •Module 03: Copy Object using C# - Lab (Part 1): 00:11:00 •Module 04: Copy Object using C# - Lab (Part 2): 00:02:00 •Module 05: Copy multiple objects using C# - Lab (Part 1): 00:09:00 •Module 06: Copy multiple objects using C# - Lab (Part 2): 00:01:00 •Module 07: Erase Object using C# - Lab (Part 1): 00:06:00 •Module 08: Erase Object using C# - Lab (Part 2): 00:05:00 •Module 09: Move Object using C# - Lab (Part 1): 00:06:00 •Module 10: Move Object using C# - Lab (Part 2): 00:02:00 •Module 11: Mirror Object using C# - Lab (Part 1): 00:10:00 •Module 12: Mirror Object using C# - Lab (Part 2): 00:02:00 •Module 13: Rotate Object using C# - Lab (Part 1): 00:07:00 •Module 14: Rotate Object using C# - Lab (Part 2): 00:03:00 •Module 15: Scale Object using C# - Lab: 00:05:00 •Module 16: Copy Object Exercise: 00:02:00 •Module 17: Copy Object Solution: 00:06:00 •Module 18: Erase Object Exercise: 00:02:00 •Module 19: Erase Object Solution: 00:07:00 •Module 20: Move Object Exercise: 00:02:00 •Module 21: Move Object Solution: 00:06:00 •Module 22: Mirror Object Exercise: 00:02:00 •Module 23: Mirror Object Solution: 00:06:00 •Module 24: Rotate Object Exercise: 00:02:00 •Module 25: Rotate Object Solution: 00:06:00 •Module 26: Scale Object Exercise: 00:01:00 •Module 27: Scale Object Solution: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Layers Overview: 00:03:00 •Module 02: Listing all the Layers in the drawing using C#: 00:11:00 •Module 03: Creating a Layer in AutoCAD using C#: 00:09:00 •Module 04: Updating a Layer in AutoCAD using C#: 00:09:00 •Module 05: Turning the Layer On/Off in AutoCAD using C#: 00:05:00 •Module 06: Thawing/Freezing Layer in AutoCAD using C#: 00:04:00 •Module 07: Deleting a Layer in AutoCAD using C#: 00:03:00 •Module 08: Locking/UnLocking a Layer in AutoCAD using C#: 00:05:00 •Module 09: Assigning a Layer to an AutoCAD object using C#: 00:03:00 •Module 10: Exploring AutoCAD Dictionaries - LineTypes Overview: 00:01:00 •Module 11: Listing all the LineTypes in the drawing using C#: 00:07:00 •Module 12: Loading a LineType in the drawing using C#: 00:07:00 •Module 13: Setting the Current LineType in AutoCAD using C#: 00:03:00 •Module 14: Deleting a LineType in AutoCAD using C#: 00:03:00 •Module 15: Setting a LineType to an object using C#: 00:04:00 •Module 16: Exploring AutoCAD Dictionaries - TextStyles Overview: 00:01:00 •Module 17: Listing all the TextStyles in the drawing using C#: 00:08:00 •Module 18: Updating current TextStyle Font in AutoCAD using C#: 00:10:00 •Module 19: Setting the Current TextStyle in AutoCAD using C#: 00:08:00 •Module 20: Setting a TextStyle to an object using C#: 00:04:00 •Module 01: User Input Functions Overview: 00:01:00 •Module 02: Using GetString Method - Lab (Part 1): 00:13:00 •Module 03: Using GetString Method - Lab (Part 2): 00:10:00 •Module 04: Using GetPoint Method - Lab: 00:12:00 •Module 05: Using GetDistance Method - Lab: 00:04:00 •Module 06: Using GetKeyWords Method - Lab (Part 1): 00:12:00 •Module 07: Using GetKeyWords Method - Lab (Part 2): 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 03: Using SelectAll Method - Lab (Part 2): 00:02:00 •Module 04: Using SelectOnScreen Method - Lab (Part 1): 00:06:00 •Module 05: Using SelectOnScreen Method - Lab (Part 2): 00:01:00 •Module 06: Using SelectWindow Method - Lab: 00:08:00 •Module 07: Using SelectCrossingWindow Method - Lab: 00:08:00 •Module 08: Using SelectFence Method - Lab: 00:08:00 •Module 09: Using PickFirstSelection Method - Lab: 00:11:00 •Module 10: Using SelectionSet Filters - Overview: 00:01:00 •Module 11: Using SelectionSet Filters - Selecting Lines: 00:09:00 •Module 12: Using SelectionSet Filters - Selecting MTexts Lab: 00:07:00 •Module 13: Using SelectionSet Filters - Selecting Polylines Lab: 00:03:00 •Module 14: Using SelectionSet Filters - Selecting Blocks (FrenchDoors) Lab: 00:07:00 •Module 15: Using SelectionSet Filters - Selecting Blocks (BiFoldDoors) Lab: 00:04:00 •Module 16: Using SelectionSet Filters - Selecting objects in a Layer (Walls) Lab: 00:07:00 •Module 17: Using SelectionSet Filters - Selecting all objects in a Layer (Stairs) Lab: 00:05:00 •Module 18: Using SelectionSets and Filters - Exercises: 00:02:00 •Module 01: TitleBlock Project - Overview: 00:05:00 •Module 02: Creating Project and TBlock Class - Lab: 00:14:00 •Module 03: Creating Classes for each Paper Sizes - Lab: 00:07:00 •Module 04: Creating TitleBlock Class - Lab: 00:14:00 •Module 05: Handling User Selected Paper Size - Lab: 00:05:00 •Module 06: Creating the TitleBlock Border Lines - Lab: 00:06:00 •Module 07: Creating the Horizontal Partition Lines - Lab (Part 1): 00:11:00 •Module 08: Creating the Horizontal Partition Lines - Lab (Part 2): 00:05:00 •Module 09: Creating Vertical Partition Lines - Lab: 00:11:00 •Module 10: Project Check on the Partition Lines - Lab: 00:07:00 •Module 11: Creating the TitleBlock Labels - Lab (Part 1): 00:10:00 •Module 12: Creating the TitleBlock Labels - Lab (Part 2): 00:09:00 •Module 13: Creating the TitleBlock Labels - Lab (Part 3): 00:11:00 •Module 14: Project Check on the Labels: 00:07:00 •Module 15: Creating Drawing Information Texts: 00:08:00 •Module 16: Debugging the TitleBlock Project - Lab: 00:10:00 •Module 17: Completing and Running the TitleBlock Plugin: 00:05:00 •Module 18: Audit Drawing Project - Overview: 00:02:00 •Module 19: Audit Drawing Project - Demo: 00:07:00 •Module 20: Creating the AuditDrawing Project: 00:11:00 •Module 21: Creating the AuditDrawing DisplayOnScreen Method: 00:14:00 •Module 22: Creating the AuditDrawing Write to TXT File Method: 00:08:00 •Module 23: Creating the AuditDrawing Write to CSV File Method: 00:06:00 •Module 24: Creating the AuditDrawing Write to HTML File Method: 00:14:00 •Module 25: AuditDrawing Plugin Demo: 00:04:00 •Module 26: Creating the AuditBlock Method: 00:05:00 •Module 27: Creating the AuditBlock GatherBlocksAndCount Method: 00:16:00 •Module 28: Creating the AuditBlock DisplayOnScreen Method: 00:06:00 •Module 29: Creating the AuditBlock WriteToTXTFile Method: 00:05:00 •Module 30: Creating the AuditBlock WriteToCSVFile Method: 00:05:00 •Module 31: Creating the AuditBlock WriteToHTMLFile Method: 00:07:00 •Module 32: AuditBlock Completed Component - Demo: 00:12:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming Using C#.NET Level 7: 00:00:00
