Exclusive Autumn Sale: Access to 2000+ Courses for Lifetime for £99 Only
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.
- 1 year
- Intermediate
- Course Certificate
- Number of Units100
- Number of Quizzes0
- 7 hours, 58 minutes Gift this course
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
No Ratings found for this course.
