2179 Developer courses delivered Online

Welcome to this dual-phase course. In the first segment, we delve into neural networks and deep learning. In the second, ascend to mastering Generative Adversarial Networks (GANs). No programming experience required. Begin with the fundamentals and progress to an advanced level.

Learn user experience fundamentals and master the design process with a user-centered approach. This UX Design Course has been designed to fully equip you with all the tools and methodologies you need to succeed as a UX designer.

NodeJS allows you to build complex and powerful applications quickly and easily, writing JavaScript code. It also allows you to use JavaScript for web applications with flexibility for a wide range of different purposes. Learn about MongoDB as a database and how to build it as well as Express as a framework to build web apps on top of Node.js.

You will learn everything you need to know about JavaScript in this course.

Build powerful web applications with Angular, an incredible frontend JavaScript and TypeScript framework. This Spring & Angular Material

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Overview This comprehensive course on Complete iOS 11 and Swift 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete iOS 11 and Swift 4 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Complete iOS 11 and Swift 4. It is available to all students, of all academic backgrounds. Requirements Our Complete iOS 11 and Swift 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 177 lectures • 19:08:00 total length •iOS 11 Course Overview: 00:11:00 •Install Xcode 9: 00:07:00 •Xcode 9 Beta 4 Update: 00:09:00 •App: Hustle - Your first iOS 11 App: 00:22:00 •Variables, operators, and how computers work: 00:17:00 •Strings in Swift: 00:15:00 •Working with numbers in Swift: 00:20:00 •Swift Functions: 00:23:00 •Booleans: 00:21:00 •Constants: 00:10:00 •Array Data Structure in Swift: 00:13:00 •Swift Loops: 00:19:00 •Dictionary Data Structure in Swift: 00:19:00 •Object Oriented Programming in Swift: 00:12:00 •Inheritance: 00:08:00 •Polymorphism: 00:08:00 •Optionals: 00:21:00 •Enumerations: 00:20:00 •Extensions: Part 1: 00:15:00 •Extensions: Part 2: 00:21:00 •Intro to Protocols, Delegates - Numbers Example: 00:13:00 •Intro to Protocols, Delegates Part 2 - Question Generator: 00:18:00 •Protocols, Delegates - Building Color Magic App UI: 00:17:00 •Protocols, Delegates - Using the Delegate Method in Color Magic App: 00:16:00 •Protocols, Delegates - Using Mutating Functions in Types: 00:18:00 •Git and Version Control - The Fun Way!: 00:12:00 •Terminal Basics - Changing Directories: 00:06:00 •Terminal Basics - Creating Directories and Files: 00:05:00 •Terminal Basics - Copying and Renaming Files: 00:09:00 •Terminal Basics - Deleting Files and Directories: 00:06:00 •Git Basics: 00:17:00 •Setting up Github: 00:05:00 •Working with Local and Remote Repositories: 00:11:00 •Handling Git Merge Conflicts: 00:17:00 •App: Swoosh 01 - Creating the Welcome Screen: 00:25:00 •App: Swoosh 02 - Working with Frames: 00:16:00 •App: Swoosh 03 - Intro to Auto Layout: 00:27:00 •App: Swoosh 04 - Working with Stack Views: 00:27:00 •App: Swoosh 05 - Intro to Segues (Changing Screens): 00:10:00 •App: Swoosh 06 - Refactoring in Xcode 9: 00:10:00 •App: Swoosh 07 - Debugging: setValue forUndefinedKey: 00:04:00 •App: Swoosh 08 - Programmatic Segues: 00:09:00 •App: Swoosh 09 - IBActions (Handling Events) and Data Models: 00:16:00 •App: Swoosh 10 - Passing Data Between View Controllers: 00:12:00 •App: Dev Profile 01 - Auto layout for iPhones: 00:22:00 •App: Dev Profile 02 - Auto layout for iPads (Size Classes): 00:20:00 •App: Window Shopper 01 - Custom Text Fields: 00:18:00 •App: Window Shopper 02 - Input Accessory Views: 00:15:00 •App: Window Shopper 03 - Unit Testing our Data: 00:17:00 •App: Window Shopper 04 - Calculation Algorithm: 00:13:00 •App: Window Shopper 05 - Custom Drawing with drawRect: 00:12:00 •App: Coder Swag 01 - Project creation: 00:23:00 •App: Coder Swag 02 - Tableviews, Delegate, and Data Source: 00:33:00 •App: Coder Swag 03 - Collection Views (Grid Layouts): 00:13:00 •App: Coder Swag 04 - Working with Data Models: 00:14:00 •App: Coder Swag 05 - Displaying Data in Collection View Cells: 00:20:00 •Intro to Chat App: 00:04:00 •App: Smack - Project Setup: 00:26:00 •App: Smack - SWReveal: 00:20:00 •App: Smack - ChannelVC UI: 00:25:00 •App: Smack - LoginVC UI: 00:22:00 •App: Smack - CreateAccountVC UI: 00:19:00 •App: Smack - Web request and API: 00:09:00 •App: Smack - Hosting API: 00:20:00 •App: Smack - Locally Hosting API: 00:18:00 •App: Smack - Creating a web request in Xcode: 00:28:00 •App: Smack - Registering a User: 00:16:00 •App: Smack - Logging in a user: 00:20:00 •App: Smack - Creating a user: 00:26:00 •App: Smack - Avatar Picker Part 1: 00:19:00 •App: Smack - Avatar Picker Part 2: 00:20:00 •App: Smack - Generate a Avatar BG Color: 00:26:00 •App: Smack - LoggedIn Interface: 00:23:00 •App: Smack - Profile View: 00:25:00 •App: Smack - Logging in users: 00:23:00 •App: Smack - Getting channels: 00:19:00 •App: Smack - Channels TableView: 00:14:00 •App: Smack - Add Channel VC: 00:19:00 •App: Smack - Sockets and Channels: 00:26:00 •App: Smack - Refining Login Flow: 00:19:00 •App: Smack - Fetching Messages: 00:20:00 •App: Smack - Sending First Message: 00:17:00 •App: Smack - Displaying Chat Messages: 00:18:00 •App: Smack - Sockets and Messages: 00:19:00 •App: Smack - Typing Users: 00:22:00 •App: Smack - Unread Channels: 00:18:00 •Where to go from here: 00:08:00 •I'm Back: 00:08:00 •Intro to App: Pixel City: 00:02:00 •Creating Xcode Project: Pixel City: 00:04:00 •Installing Alamofire / AlamofireImage Cocoapods: 00:07:00 •Building MapVC UI /Conforming to MKMapViewDelegate /Setting Delegate of mapView: 00:15:00 •Requesting Location Services in iOS 11 / Centering Map On User Location: 00:18:00 •Adding UITapGestureRecognizer to Drop Custom Pins on MapView: 00:15:00 •Setting a Custom Map Annotation Color: 00:05:00 •Animating Photos View / Programmatically adding spinner and label subviews: 00:20:00 •Adding UILabel for Pull Up View / Adding UICollectionView Programmatically: 00:17:00 •Getting API Key from Flickr / Using Flickr API URL Format: 00:14:00 •Using Alamofire to Download URLS: 00:21:00 •Using Alamofire to Download Images / Cancelling All Sessions: 00:16:00 •Setting Up UICollectionView / Adding Images / Reloading UICollectionView: 00:10:00 •Building PopVC / Presentation PopVC When UICollectionViewCell is Tapped: 00:16:00 •Adding 3D Touch Peek: 00:15:00 •Challenge 1: 00:02:00 •Setting up developer: 00:10:00 •Implementing Google AdMob: 00:19:00 •Fetching a list of Products: 00:15:00 •Starting an in-app Purchase: 00:09:00 •Testing in-app Purchases: 00:18:00 •Restoring in-app Purchases after App Deletion: 00:09:00 •Intro to App: GoalPost: 00:03:00 •Creating Xcode Project / Project Folders: 00:04:00 •Building GoalsVC: 00:14:00 •Building GoalCell: 00:14:00 •What is Core Data?: 00:06:00 •Creating Goal Core Data Entity and Attributes: 00:08:00 •Displaying Static GoalCells in UITableView / Creating GoalType Enum: 00:10:00 •Building CreateGoalVC: 00:15:00 •Creating a UIViewController Extension: 00:11:00 •Creating a UIView / UIButton Extension: 00:19:00 •Building FinishGoalVC / Passing Data from CreateGoalVC: 00:19:00 •Saving Goal Data to Persistent Store: 00:13:00 •Fixing Dismissal of FinishGoalVC: 00:07:00 •Fetching Data from Persistent Store / Filling UITableView with Fetched Data: 00:16:00 •Removing Objects from Persistent Store using UITableView Delete Action: 00:11:00 •Setting Goal Progress for UITableViewCell: 00:15:00 •Challenge 2: 00:01:00 •Intro to App: Breakpoint: 00:03:00 •Creating Xcode Project / Setting Up Project Folders: 00:05:00 •Creating Firebase Project: 00:11:00 •Setting Up DataService / Creating Firebase Database Users: 00:11:00 •Building AuthVC and LoginVC in Interface Builder: 00:18:00 •Creating InsetTextField and ShadowView Subclasses: 00:18:00 •Setting up AuthService: 00:13:00 •Building FeedVC and GroupsVC in Interface Builder: 00:16:00 •Presenting LoginVC from AppDelegate / Allowing Login with Email: 00:22:00 •Building MeVC and Adding to UITabBarController: 00:10:00 •Creating CreatePostVC and Uploading Posts to Firebase: 00:20:00 •Creating UIView Extension for Binding Views to Keyboard: 00:15:00 •Building FeedCell: 00:10:00 •Writing the Message Model and Getting All Feed Messages from Firebase: 00:21:00 •Converting UIDs into Emails and Reversing the Order of a TableView: 00:20:00 •Creating CreateGroupVC and Connecting @IBOutlets/Actions: 00:15:00 •Creating UserCell: 00:16:00 •Searching for Email Accounts to Add to Group: 00:19:00 •Adding Users to Group with didSelectRowAt indexPath: 00:21:00 •Creating Groups and pushing them to Firebase: 00:16:00 •Creating GroupCell: 00:15:00 •Creating Group Model and Getting All Groups from Firebase: 00:19:00 •Building GroupFeedVC: 00:18:00 •Initializing Group Data for a Group and Presenting on GroupFeedVC: 00:16:00 •Downloading All Message for a Group and Animating Upon New Message: 00:24:00 •Creating a UIViewController Extension for Presenting GroupFeedVC: 00:07:00 •Challenge 3: 00:02:00 •Intro to app: 00:02:00 •Intro to CoreML: 00:05:00 •What is machine learning?: 00:08:00 •Creating Xcode 9 project: 00:03:00 •Building UI: 00:18:00 •AVFoundation: 00:18:00 •Tap gestures to take snapshot on item: 00:11:00 •Core ML Xcode 9 Beta 4 Update / Fix Preview Photo Crash: 00:03:00 •Downloading CoreML models: 00:21:00 •Adding UI controls for flash control: 00:07:00 •Training your app to speak what it sees: 00:18:00 •App: RampUp - Intro to ARKit App: 00:02:00 •App: RampUp - Resources: 00:04:00 •App: RampUp - Project creation: 00:11:00 •App: RampUp - SceneKit, 3D models: 00:11:00 •App: RampUp - Ramp picker popover: 00:14:00 •App: RampUp - 3D models in SceneKit for popover: 00:18:00 •App: RampUp - 3D models in SceneKit for popover part 2: 00:12:00 •App: RampUp - Detecting taps on 3D objects: 00:17:00 •App: RampUp - Placing ramps in ARKit: 00:24:00 •App: RampUp - Moving objects in 3D space in augmented reality: 00:20:00 •ARKit - where to go next: 00:04:00 •Assignment - Complete iOS 11 and Swift 4: 00:00:00

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

Learn the essentials of software development. And increase your confidence when working with developers. Why take this course? Talk with confidence about web and internet technologies Build better relationships with developers on your team Create smarter designs with a deeper understanding of technical constraints Understand the concepts behind coding without needing to code Who is it for? All UX professionals Format Online, self-paced Duration 6 weeks (recommended) Commitment 3 hours per week What you’ll learn Over 6 weeks, you’ll learn about the key concepts and processes involved in software development. You'll understand how code works, so that you can collaborate more effectively with developers. Module 1 The software landscape Understand the relationship between hardware and software. Module 2 Layers of software Dig into each layer of the tech stack, from the front-end to the back-end. Module 3 Front-end technologies Get up to speed on the roles of HTML, CSS and Javascript. Module 4 Back-end technologies Explore the back-end, APIs and common programming languages. Module 5 How developers work Learn about common development workflows, from waterfall to agile. Module 6 Effective collaboration Get practical guidance on how to work well with development teams.

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