Booking options
£10.99
Course Images
Programming AutoCAD with SQL Server Database Using C#
By Studyhub UK
(3)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
8 hours 2 minutes
All levels
Description
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 |
About The Provider
Studyhub UK
London, England
(3)Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...
Reviews
There are no reviews for Programming AutoCAD with SQL Server Database Using C# yet.Why not be the first one to review this course?