Programming AutoCAD with SQL Server Database Using C#

Home
Course
IT & Software
Programming AutoCAD with SQL Server Database Using C#

Programming AutoCAD with SQL Server Database Using C#

Level: Intermediate
Modules: 100 Modules
Duration: 8 hours, 2 minutes
Students: 0

Embark on a transformative journey into the realm of precision and efficiency with our course, “Programming AutoCAD with SQL Server Database Using C#.” Delve into the intricacies of marrying AutoCAD functionality with the power of SQL Server databases through the lens of C#. In this immersive learning experience, you’ll progress seamlessly from laying the groundwork in Sections 1 and 2, exploring tools and SQL queries, to the advanced stages of Section 7, mastering the art of deleting data in SQL Server databases directly from AutoCAD. This course is more than a mere exploration of coding; it’s a creative odyssey where you sculpt the future of design and data integration, unlocking a realm of possibilities with every line of code.

Learning Outcomes

Tool Proficiency and SQL Mastery: Gain expertise in the tools essential for AutoCAD programming and unravel the complexities of SQL queries, setting the foundation for database manipulation.
Database Creation and Table Design: Learn to create databases and design tables, ensuring a structured and efficient storage system for your AutoCAD projects.
Data Loading Techniques: Master the techniques of loading data into SQL Server databases, streamlining the process of transferring AutoCAD information to the database seamlessly.
Efficient Data Retrieval: Acquire the skills to retrieve data from databases, enhancing your ability to access and utilize information stored within the SQL Server infrastructure.
Data Manipulation Mastery: Explore the intricacies of updating and deleting data in SQL Server databases directly from AutoCAD, revolutionizing your approach to data management within the AutoCAD environment.

Why choose this Programming AutoCAD with SQL Server Database Using C# course?

Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Unlock career resources for CV improvement, interview readiness, and job success.

Who is this Programming AutoCAD with SQL Server Database Using C# course for?

Aspiring programmers eager to elevate their skills in AutoCAD and SQL Server integration.
Design professionals seeking to streamline their workflow through efficient database utilization.
Students and enthusiasts interested in the intersection of design and database management.
Engineers and architects aiming to enhance their AutoCAD capabilities with dynamic data manipulation.
Individuals keen on mastering C# for advanced applications in the AutoCAD environment.

Career path

CAD Programmer: £30,000 – £45,000
Database Integration Specialist: £35,000 – £50,000
Software Engineer (AutoCAD): £40,000 – £55,000
Database Administrator: £35,000 – £50,000
Architectural Technologist: £30,000 – £45,000
Engineering Software Developer: £45,000 – £60,000

Prerequisites

This Programming AutoCAD with SQL Server Database Using C# does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Programming AutoCAD with SQL Server Database Using C# was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Certification

After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.

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
	Running the LoadPlines() Method	00:03: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 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