Programming AutoCAD with SQL Server Database Using C#

Programming AutoCAD with SQL Server Database Using C#

Course Overview Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no …

Programming AutoCAD with SQL Server Database Using C#

$32.69

TAKE THIS COURSE

1 Year Access

Intermediate

3 Students

7 hours, 58 minutes

Gift this course

Course Overview

Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you’ve come to the right place!

Our easy-to-follow Programming AutoCAD with SQL Server Database Using C# will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept – from the fundamental to the more advanced aspects of the course.

Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future.

Learning Outcomes

Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge.

Entry Requirement

- This course is available to all learners of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Some basic understanding of the English language and numeracy.

Certification

After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19.

- PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days

Why choose us?

- - Affordable, engaging & high-quality e-learning study materials;
  - Tutorial videos/materials from the industry-leading experts;
  - Study in a user-friendly, advanced online learning platform;
  - Efficient exam systems for the assessment and instant result;
  - The UK & internationally recognised accredited qualification;
  - Access to course content on mobile, tablet or desktop from anywhere, anytime;
  - The benefit of career advancement opportunities;
  - 24/7 student support via email.

Career path

Develop Your Career Plan is a useful qualification to possess and would be beneficial for any related profession or industry.

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 LWPolylines 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 the LWPolylines in SQL Server Database – Overview	00:01:00
	Creating the DBUpdateUtil Class	00:02:00
	Creating the UpdateLines() Method	00:23: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 Lines in SQL Server 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

Course Ratings

N.A

ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Ratings found for this course.

How Do Our Courses Work?

Purchase and payment

Add your chosen course to your basket. Once you’ve added all the courses you need.

Course access

Add your chosen course to your basket. Once you’ve added all the courses you need.

Certificate

Add your chosen course to your basket. Once you’ve added all the courses you need.

Continued support

Add your chosen course to your basket. Once you’ve added all the courses you need.

Programming AutoCAD with SQL Server Database Using C#