Programming AutoCAD with SQL Server Database Using C#
Category: IT & Software
Course Info
Overview
Develop a Programming AutoCAD with SQL Server Database Using C# arsenal of skills including critical strategic, managerial, and leadership abilities with our expertly developed Programming AutoCAD with SQL Server Database Using C#.
To stay ahead of the curve, companies are now embracing eLearning in the most inventive methods to develop an excellent workforce and produce optimal outcomes to get the most out of their investments. To align with your goals and your workplace objectives, Learning Paths has been working on creating the most effective and dynamic courses.
Through an immersive online experience, Learning Paths offers market-driven courses that empower you or any working professional with the competence required for the workplace of the future. We assess future skill demands using a data-driven methodology and ensure that all of our courses satisfy this need. This Programming AutoCAD with SQL Server Database Using C# course is no exception.
This platform provides you with exclusive resources to help you along your professional path, as well as the tools you’ll need to further your career.
To enhance your learning outcomes, this career-focused Programming AutoCAD with SQL Server Database Using C# curriculum employs a variety of interactive modules to provide you with abilities that are relevant to your career. This Programming AutoCAD with SQL Server Database Using C# course was also created with professionals in mind and is tailored to fit with your busy schedule.
Sign up for the Programming AutoCAD with SQL Server Database Using C# course today and build core Programming AutoCAD with SQL Server Database Using C# skills for tackling any complex challenges.
Description
This Programming AutoCAD with SQL Server Database Using C# course will teach you how to think critically and strategically about Programming AutoCAD with SQL Server Database Using C#, as well as how to build and implement strategy. You’ll also discover fundamental Programming AutoCAD with SQL Server Database Using C# ideas that will help you build the foundation you need to flourish in the workplace.This Learning Paths online Programming AutoCAD with SQL Server Database Using C# course is for working people who want to improve their abilities and advance in their careers. The Programming AutoCAD with SQL Server Database Using C# course is provided in an interactive virtual learning environment where you can study at your own comfort and convenience.
Who is this course for?
This certificate Programming AutoCAD with SQL Server Database Using C# course is curated for individuals who want to improve their hard and soft skills. The interactive, guided approach to learning and the potential to build their worldwide network online will help you thrive. Moreover, working professionals in managerial and leadership roles in a variety of industries will benefit from the emphasis on the dynamics of leadership, influence, and strategy, as well as Programming AutoCAD with SQL Server Database Using C# abilities. Those pursuing career advancement in the future will benefit from the skill to apply Programming AutoCAD with SQL Server Database Using C#-derived abilities to current and future employment.
Requirements
This Learning Paths Programming AutoCAD with SQL Server Database Using C# course will prepare you to make data-driven decisions that will give you a competitive edge. There are no formal requirements for this course. However smart gadgets and stable internet connection is required for a smooth learning journey.
Career Path
Earn a certificate of competence from the Learning Paths platform by learning all about Programming AutoCAD with SQL Server Database Using C#. This Programming AutoCAD with SQL Server Database Using C# course curriculum will benefit you at all stages of your career.
Certification
After successfully completing the Programming AutoCAD with SQL Server Database Using C# course, you will get your PDF certificate for FREE! The hardcopy certificate will cost only £11.99 with free shipping inside the UK. For delivery outside the UK an additional shipping charge will be applied.
Course Curriculum
| Section 01: Introduction | |||
| Course Topics | 00:02:00 | ||
| Introduction | 00:02:00 | ||
| Section 2 - Tools And SQL Queries | |||
| Section Overview | 00:01:00 | ||
| Downloading Visual Studio 2019 | 00:01:00 | ||
| Downloading SQL Server Express | 00:02:00 | ||
| Downloading SQL Server Management Studio (SSMS) | 00:01:00 | ||
| SQL Queries – Overview | 00:03:00 | ||
| INSERT SQL Statement – Demo | 00:13:00 | ||
| SELECT SQL Statement – Demo | 00:08:00 | ||
| UPDATE SQL Statement – Demo | 00:08:00 | ||
| DELETE SQL Statement – Demo | 00:11:00 | ||
| Section 3 - Create Database And Tables | |||
| Section Overview | 00:01:00 | ||
| Creating the CADDB Database | 00:03:00 | ||
| Creating the Lines Table | 00:07:00 | ||
| Creating the MTexts Table | 00:04:00 | ||
| Creating the Plines Table | 00:04:00 | ||
| Creating the Blocks No Attribute Table | 00:04:00 | ||
| Creating the Blocks With Attributes Table | 00:04:00 | ||
| Section 4 - Loading Into SQL Server Database | |||
| Section Overview | 00:02:00 | ||
| Loading Lines into SQL Server Database | 00:01:00 | ||
| Creating the CADDB Project | 00:04:00 | ||
| Creating the Settings File | 00:04:00 | ||
| Creating the Get Connection Method | 00:03:00 | ||
| Creating the LoadLines() Method | 00:22:00 | ||
| Creating the User Interface for the LoadLines() method | 00:07:00 | ||
| Running the LoadLines() Method | 00:05:00 | ||
| Loading MTexts into SQL Server Database – Overview | 00:01:00 | ||
| Creating the LoadMTexts() Method | 00:10:00 | ||
| Running the LoadMTexts() Method | 00:06:00 | ||
| Loading LWPolylines into SQL Server Database – Overview | 00:01:00 | ||
| Creating the LoadPolylines() Method | 00:13:00 | ||
| Running the LoadPlines() Method | 00:03:00 | ||
| Loading Blocks (No Attribute) into SQL Server Database – Overview | 00:01:00 | ||
| Creating the LoadBlocksNoAttribute() Method | 00:11:00 | ||
| Running the LoadBlocksNoAttribute() Method | 00:03:00 | ||
| Loading Blocks (with Attributes) into SQL Server Database – Overview | 00:01:00 | ||
| Creating the LoadBlocksWithAttributes() Method | 00:07:00 | ||
| Running the BlocksWithAttributes() Method | 00:02:00 | ||
| Section 5 - Retrieving Data From Database | |||
| Section Overview | 00:02:00 | ||
| Retrieving Lines from SQL Server Database – Overview | 00:01:00 | ||
| Creating the DBRetrieveUtil Class | 00:03:00 | ||
| Creating the RetrieveAndDrawLines() Method (Part 1) | 00:17:00 | ||
| Creating the GetColorIndex() Method | 00:05:00 | ||
| Creating the RetrieveAndDrawLines() Method (Part 2) | 00:11:00 | ||
| Running and Testing the RetrieveAndDrawLines() Method | 00:09:00 | ||
| Retrieving MTexts from SQL Server Database – Overview | 00:01:00 | ||
| Creating the RetrieveAndDrawMTexts() Method | 00:11:00 | ||
| Running and Testing the CreateAndDrawMTexts() Method | 00:05:00 | ||
| Retrieving LWPolylines from SQL Server Database – Overview | 00:01:00 | ||
| Creating the RetrieveAndDrawPlines() Method | 00:12:00 | ||
| Running and Testing the RetrieveAndDrawPlines() Method | 00:05:00 | ||
| Retrieving Blocks (No Attribute) from SQL Server Database – Overview | 00:01:00 | ||
| Creating the RetrieveAndDrawBlocksNoAttribute() Method | 00:11:00 | ||
| Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method | 00:05:00 | ||
| Retrieving Blocks (with Attributes) from SQL Server Database – Overview | 00:01:00 | ||
| Creating the RetrieveAndDrawBlocksWithAttributes() Method | 00:21:00 | ||
| Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method | 00:10:00 | ||
| Section 6 - Updating Data In SQL Server Database - Overview | |||
| Section Overview | 00:01:00 | ||
| Updating Lines in SQL Server Database – Overview | 00:01:00 | ||
| Creating the DBUpdateUtil Class | 00:02:00 | ||
| Creating the UpdateLines() Method | 00:25:00 | ||
| Creating the User Interface for UpdateLines() Method | 00:02:00 | ||
| Running and Testing the UpdateLines() Method | 00:08:00 | ||
| Updating MTexts in SQL Server Database – Overview | 00:01:00 | ||
| Creating the UpdateMTexts() Method | 00:09:00 | ||
| Creating the User Interface for UpdateMTexts() | 00:01:00 | ||
| Running and Testing the UpdateMTexts() Method | 00:07:00 | ||
| Updating the LWPolylines in SQL Server Database – Overview | 00:01:00 | ||
| Creating the UpdateLWPolylines() Method | 00:09:00 | ||
| Running and Testing the UpdateLWPolylines() Method | 00:07:00 | ||
| Updating Blocks (No Attributes) in SQL Server Database – Overview | 00:01:00 | ||
| Creating the UpdateBlocksNoAttributes() Method | 00:10:00 | ||
| Creating the User Interface for UpdateBlocksNoAttributes() Method | 00:01:00 | ||
| Running and Testing the UpdateBlocksNoAttributes() Method | 00:04:00 | ||
| Updating Blocks With Attributes in SQL Server Database – Overview | 00:01:00 | ||
| Creating the UpdateBlocksWithAttributes() Method | 00:08:00 | ||
| Creating the User Interface for UpdateBlocksNoAttributes() Method | 00:01:00 | ||
| Running and Testing the UpdateBlocksWithAttributes() Method | 00:09:00 | ||
| Section 7 - Deleting Data In SQL Server Database From AutoCAD - Overview | |||
| Section Overview | 00:02:00 | ||
| Deleting LWPolylines in SQL Server Database from AutoCAD – Overview | 00:01:00 | ||
| Creating the DBDeleteUtil Class | 00:01:00 | ||
| Creating the DeleteLines() Method | 00:13:00 | ||
| Creating the User Interface for the DeleteLines() Method | 00:02:00 | ||
| Running and Testing the DeleteLines() Method | 00:04:00 | ||
| Deleting MTexts in SQL Server Database from AutoCAD – Overview | 00:01:00 | ||
| Creating the DeleteMTexts() Method | 00:04:00 | ||
| Creating the User Interface for DeleteMTexts() Method | 00:01:00 | ||
| Running and Testing the DeleteMTexts() Method | 00:03:00 | ||
| Deleting LWPolylines in SQL Server Database from AutoCAD – Overview | 00:01:00 | ||
| Creating the DeletePlines() Method | 00:04:00 | ||
| Creating the User Interface for the DeletePlines() Method | 00:01:00 | ||
| Running and Testing the DeletePlines() Method | 00:02:00 | ||
| Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD – Overview | 00:01:00 | ||
| Creating the DeleteBlocksNoAttribute() Method | 00:03:00 | ||
| Creating the User Interface for DeleteBlocksNoAttribute() Method | 00:01:00 | ||
| Running and Testing DeleteBlocksNoAttribute() Method | 00:02:00 | ||
| Deleting Blocks (With Attributes) in SQL Server Database from AutoCAD – Overview | 00:01:00 | ||
| Creating the DeleteBlocksWithAttributes() Method | 00:02:00 | ||
| Creating the User Interface for DeleteBlocksWithAttributes() Method | 00:01:00 | ||
| Running and Testing the DeleteBlocksWithAttributes() Method | 00:02:00 | ||