1665 Database courses

Learn Flutter - Google's mobile development framework - and build Flutter iOS and Android apps using a single codebase

Learn Flask, the simple yet powerful Python web framework. This course is a ridiculously simple way to learn Flask in less than a weekend.

Register on the Microsoft Access today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Microsoft Access is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Access Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Access, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Course Content Microsoft Access Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities Activities - Microsoft Access 2016 Advanced 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 1 Days 6 CPD hours This course is intended for Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. Overview In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will: Share data across applications. Use action, unmatched, and duplicate queries to manage data. Create complex reports and forms. Use macros to improve user interface design. Use VBA to extend database capabilities. Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting. Implement security strategies and distribute a database to multiple users. You've covered many of the basic functions of Microsoft© Access©, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Lesson 2: Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Lesson 3: Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Lesson 4: Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Lesson 5: Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Use VBA with Form Controls Lesson 6: Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Lesson 7: Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Harness the unlimited power of Microsoft Access by creating and maintaining your own basic database system, as well as learning how to develop user-friendly programs. Microsoft Access is a well-known and widely used data-management software application. This Microsoft Access course will teach you how to make the most of this versatile and useful programme, so sign Microsoft Access course up today to quickly gain a valuable new skill that will broaden your portfolio and advance your career. After completing this Microsoft Access course, you will have mastered the most commonly used Access tools and will be able to complete any access task with efficiency and grace. So why wait any longer? Enrol now and become a Microsoft Access guru! Upon completion of this Microsoft Access course, you will be able to: Fully understand tables, queries, reports, and forms Make useful database tables and effective reports Build dynamic user data forms Effectively retrieve data using access queries Automate access database tasks with Macros and VBA And more Why Prefer This Microsoft Access Course? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. *** Course Curriculum *** Here is the curriculum breakdown of the Microsoft Access course: Microsoft Access for Beginners Module 01 Orientation to Microsoft Access Create a Simple Access Database Get Help and Configure Options in Microsoft Access Module 02 Modify Table Data Sort and Filter Records Module 03 Create Basic Queries Sort and Filter Data in a Query Perform Calculations in a Query Module 04 Create Basic Access Forms Work with Data on Access Forms Module 05 Create a Report Add Controls to a Report Enhance the Appearance of a Report Prepare a Report for Print Organize Report Information Format Reports Assessment Process Once you have completed all the modules in the Microsoft Access course, you can assess your skills and knowledge with an optional assignment. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Access Course is for: Users wishing to advance their understanding of Microsoft Access from beginner to advanced Those who have used Access but want to learn some little-known tips, tricks, and shortcuts in order to become more efficient. This Microsoft Access course is also appropriate for students who have prior experience with Access and want to learn more about it. Entrepreneurs, office workers, teachers, and students interested in database work Requirements You will not need any prior background or expertise to enrol in this Microsoft Access Course. Career path Upon completion of this Microsoft Access course, learners will be able to add their new skills to their CV and take the very first step towards the following careers: Database Administrator: £37,000 Data Analyst: £32,000 Office Manager: £28,000 Administrative Assistant: £22,000 Business Analyst: £40,000 Project Coordinator: £27,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

ZigBee training course description A hands on course covering the entire ZigBee protocol stack. ZigBee operation, primitives and frame formats are covered in detail using software tools to test and analyse ZigBee commands and demonstrate how these affect the 802.15.4 MAC. Analysers are used to decode packet formats. What will you learn Describe the ZigBee architecture and applications. Explain the workings of ZigBee protocol stack including the 802.15.4, NWK, APS and ZDO sub layers. Describe in detail the ZigBee primitives and how they are used to pass data; make networks; join networks and repair networks. Secure ZigBee networks. ZigBee training course details Who will benefit: Technical staff requiring grounding in ZigBee including application engineers. Prerequisites: RF fundamentals. Duration 2 days ZigBee training course contents Wireless data overview What is 802.15.4 and ZigBee? WLAN, WPAN, Bluetooth vs. ZigBee. Markets. Applications and architecture. ZigBee demonstration. ZigBee Standards and technology The 7-layer model, IEEE WPAN standards overview, 802.15.4 & ZigBee, ZigBee alliance. ZigBee Protocol stack The ZigBee 5 layer model, The network (NWK) sub layer, Application support sub layer (APS), the ZigBee Device Object (ZDO). 802.15.4 Radio Frequencies, modulation, power, DSSS, BPSK/ O-QPSK, channels, symbols, chips and bit rate. 802.15.4 PHY PHY data transfer primitives. The PHY packet. PHY PIB management. 802.15.4 MAC layer The MAC layer overview, CSMA/CA, addresses, frame types, super frames, MAC layer: Data, Data control, Scan and join, PAN maintenance, MAC PIB. Hands on 802.15.4 frame analysis. ZigBee Topologies Point to point topology, star topology, cluster tree, wired integration. Hands on Building a ZigBee network. ZigBee frame formats General frame format, data frames, command frames. Hands on Analysing ZigBee frames. ZigBee NWK NWK data primitives: Request. Confirm. Indication. NWK management primitives: Network discovery, network formation. Permit joining. Start router. Join. Direct join. Leave. Reset. Sync. NWK database management. Hands on NWK analysis ZigBee APS Address mapping, matching devices, binding devices, binding tables. Hands on APS analysis. ZigBee ZDO Device roles, binding requests, initiating and responding, device discovery, service discovery, network management. ZDO Endpoint 0. ZigBee Security Security issues, security modes, MAC security, NWK security, APS security. Applications Writing ZigBee applications, application profiles, End points, Endpoint addressing, clusters of attributes, broadcasts. Hands on Sample ZigBee application.

Concise Cisco switches course description A hands on course covering the product specifics of Cisco switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. VLANs often take up a large part of the course. The course covers all interfaces but concentrates on using the command line interface. Delegates are, however, free to use the web based interface in all exercises. What will you learn Install Cisco switches. Use the command line interface and the web based interface to manage Cisco switches. Configure and troubleshoot Cisco switches. Perform software upgrades and maintain configurations using TFTP. Concise Cisco switches course details Who will benefit: Anyone working with Cisco switches. Particularly aimed at engineers and technicians supporting Cisco switches. Prerequisites: None. Duration 2 days Concise Cisco switches course content Ethernet review Single segment Ethernet, CSMA/CD, Broadcast domains, collision domains. Hubs, Extending the LAN. Hands on Hub based Ethernet. Cisco switches What are switches, frame forwarding and filtering, the forwarding database. Hands on Switched based Ethernet. Configuring Cisco switches Accessing the switch, installing the switch, The CLI, connecting PCs using the switch. Hands on Configuring Cisco switches. The command line interface User and privilege modes, online help, show, basic troubleshooting. The configuration editor, Global, major and sub commands, enable, secret and other passwords. Hands on Simple troubleshooting using the CLI. Port configuration Speed, duplex, security, trunking. Hands on Port trunking. Spanning Tree Protocol Spanning Tree, Loops, effect, root bridges, bridge port states, STP reconfiguration. RSTP and variants. Hands on STP. VLANS What are VLANs, configuring VLANs, access ports and trunks, 802.1Q, inter VLAN routing. Hands on Access ports, trunks, layer 3 switching. Housekeeping Configuration management, software management, password recovery. Hands on TFTP. Managing interconnection devices SNMP, RMON, RMON II. Troubleshooting LEDs, CDP, logging, Layer 1, layer 2, layer 3. Hands on Fixing things.

Welcome to the exciting world of C# (C-Sharp)! This course is your gateway to mastering one of the most versatile and in-demand programming languages in the world. As technology continues to advance, C# remains at the forefront, offering endless opportunities for those who can harness its power. In this course, we will take you on a journey that begins with the fundamentals and leads you to become a proficient C# developer. In the first section, 'Introduction,' you'll gain insight into the world of C# and understand its significance in the modern software development landscape. We'll guide you through the process of setting up your development environment, ensuring you're ready to dive into coding with confidence. The course progresses to cover essential topics such as C# console programming, Winforms applications, database operations, user management, and source control. By the end, you'll have a deep understanding of C# and the practical skills needed to develop robust software applications. Join us on this exhilarating journey, and let's unlock the incredible potential of web development together. Learning Outcomes of C# (C-Sharp): Develop a solid foundation in C# programming, including mastery of basic control structures and more advanced concepts. Create Windows forms applications and understand the basics of Multi-Document Interface (MDI) for efficient user interface development. Manage databases effectively, covering CRUD (Create, Read, Update, Delete) operations and database changes. Implement user management and login functionality to enhance the security and usability of your applications. Learn the importance of source control and acquire the skills to add your projects to source control repositories. Why buy this C# (C-Sharp) course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the C# (C-Sharp) 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. Who is this C# (C-Sharp) course for? Aspiring software developers looking to build a strong foundation in programming. Computer science students seeking practical knowledge and skills for real-world application development. IT professionals aiming to expand their expertise and career opportunities in software development. Individuals interested in creating Windows applications with user-friendly interfaces. Anyone eager to understand source control and its role in collaborative software development. Career path Junior Developer: £25,000 - £40,000 Per Annum Software Engineer: £40,000 - £60,000 Per Annum Database Developer with C#: £35,000 - £55,000 Per Annum Senior C# Developer: £55,000 - £80,000 Per Annum Software Development Team Lead (C#): £70,000 - £100,000 Per Annum C# Solutions Architect: £90,000 - £130,000 Per Annum Prerequisites This C# (C-Sharp) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This C# (C-Sharp) 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 Introduction Introduction 00:03:00 Development Environment Setup Install Visual Studio 2019 Community Edition 00:04:00 Install .Net Core SDK 00:02:00 Tour Of Visual Studio 00:11:00 C# Console Programming - Basic Control Structures Write a Simple Hello World Program 00:15:00 Input and Output Programs 00:18:00 C# Data Types and Conversion 00:22:00 Operators in C# 00:17:00 Condition Statements 00:32:00 Repetition Statements 00:28:00 Methods and Return Types 00:27:00 C# Console Programming - More Advanced Concepts String Manipulation Functions 00:21:00 Handling Exceptions 00:13:00 Classes and Objects 00:37:00 Arrays, Lists and Other Collections 00:35:00 Winforms Applications - The Basics Create a Simple Winforms Application (Car Rental Application) 00:26:00 Understand Winforms Controls, Properties and Events 00:21:00 Form Validation and Exception Handling 00:34:00 Create Database in SQL Server 00:10:00 Create Database Model with ADO.NET 00:13:00 Select Data from the Database Using LINQ 00:15:00 Submit to Database from Form 00:17:00 Multi Document Interface (MDI) and More Database Operations Creating Additional Forms and Windows 00:14:00 Create an MDI Application 00:17:00 Managing Database Changes and CRUD Operations View Data In A Grid 00:29:00 Managing Database Changes 00:18:00 Create and Edit Records (Using one form) 00:48:00 Vehicle Data Validations and Exception Handling 00:07:00 Manage Car Rental Records 00:45:00 Enhancing Application Flow and User Experience 00:28:00 User Management and Login Functionality Simple Login Form 00:39:00 Control Features Based on User Roles 00:35:00 User Password and Active Status Reset 00:21:00 Add New Users and Password Reset 00:45:00 Add To Source Control Add Project to GitHub 00:19:00 Assignment Assignment - C# (C-Sharp) 00:00:00

Course Overview: The demand for web developers is snowballing. According to the Bureau of Labor Statistics, employment of web developers is projected to grow 22 percent from 2020 to 2030, much faster than the average for all occupations. Are you eager to craft powerful web applications that captivate users and drive business growth? Look no further! This Building Web Applications with Django and PostgreSQL course will equip you with the essential skills to master Django, a versatile web framework, and PostgreSQL, a robust database management system. "Numbers don't lie" - the soaring popularity of Python-based web frameworks like Django is a testament to their relevance and demand in the industry. As you delve into this course, you'll be pleased to know that recent surveys have highlighted Django's dominance in the web development market. Gain a competitive edge as you learn from seasoned professionals, and dive into the world of web development with confidence.  Take advantage of this golden opportunity! Enrol now to embark on an exciting journey of learning and transformation. Key Features of the Course: Unleash your potential with a CPD certificate upon course completion, solidifying your expertise in web application development. Enjoy an uninterrupted learning experience with our 24/7 Learning Assistance, ensuring that you have the support you need whenever you need it. Embrace an interactive and engaging learning journey with captivating materials, real-world projects, and quizzes that inspire you. Who is This Course For? If you aspire to become a web developer, programming virtuoso, or IT enthusiast, this Building Web Applications with Django and PostgreSQL course is tailor-made. Whether you're just starting or an experienced developer looking to enhance your skill set, our course caters to learners of all levels, fostering an inclusive and supportive learning environment. What You Will Learn: Seamlessly set up Python and PyCharm IDE on diverse platforms. Unravel the architectural marvels of Django, and build your first Django app. Embrace the power of PostgreSQL for web applications and configure it flawlessly. Harness the potential of Django's built-in ORM for streamlined database interactions. Implement foolproof user authentication and authorisation mechanisms. Craft dynamic web pages using HTML, templates, and Bootstrap. Design visually stunning product card items to elevate your web applications. Why Enrol in This Course: Your success story begins with us, where you'll gain in-demand skills to create sophisticated web applications that thrive in today's digital landscape. Experience the best as you join our top-reviewed course, regularly updated to stay ahead of industry trends. With hands-on experience and industry-relevant skills, you'll elevate your employability and unlock doors to exciting opportunities. Requirements: A basic understanding of Python A computer with Python installed Career Path: Upon completion, embark on a rewarding career path in web development with diverse options, including: Web Developer - £35,000 to £55,000 per annum Full-Stack Developer - £40,000 to £65,000 per annum Django Developer - £45,000 to £70,000 per annum Python Developer - £40,000 to £65,000 per annum Frontend Developer - £30,000 to £50,000 per annum Backend Developer - £40,000 to £65,000 per annum Database Administrator - £35,000 to £55,000 per annum Certification: The crowning achievement of your learning endeavour awaits as you earn your well-deserved CPD certificate. Recognised and esteemed across industries, this certificate will validate your proficiency in building web applications with Django and PostgreSQL. Take the first step towards excellence and enrol in our course today! Course Curriculum 10 sections • 53 lectures • 04:52:00 total length •Introduction: 00:04:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:02:00 •FAQs: 00:01:00 •Installing Python: 00:07:00 •Installing PyCharm IDE for development: 00:12:00 •Creating the first Python project: 00:09:00 •Write and Run Hello World program: 00:05:00 •Command line basics: 00:06:00 •Installation and access pip command: 00:10:00 •Introduction to web framework and Django: 00:04:00 •Installing Django and setting up a project: 00:07:00 •Understanding Django architecture and structured: 00:08:00 •Creating a simple Django app: 00:06:00 •Introduction to PostgreSQL and its advantages for web applications: 00:04:00 •Installing PostgreSQL and setting up a database: 00:13:00 •pgAdmin Secure login and create database: 00:10:00 •Connection Django to PostgreSQL: 00:09:00 •Creating a Basic HTTP view method request: 00:04:00 •URL pattern on app: 00:05:00 •Include apps to project urls: 00:05:00 •Installing the psycopg2 module for DB connection: 00:05:00 •Defining models and creating database tables: 00:08:00 •Using Djangos built-in ORM to interact with the database: 00:06:00 •Migration to create DB tables: 00:06:00 •Assessment Test: 00:01:00 •Solution for an Assessment Test: 00:04:00 •Creating Superuser as Admin: 00:07:00 •Authentication and Authorization: 00:03:00 •User access permissions: 00:04:00 •Registering user models to the admin Dashboard: 00:04:00 •Creating data using CRUD functionality: 00:06:00 •View data on the PostgreSQL database table: 00:04:00 •Understanding the MVC: 00:05:00 •Creating views and handling HTTP requests and rendering templates: 00:10:00 •Creating a template with HTML page: 00:10:00 •Building dynamic form and handling: 00:10:00 •Creating Bootstrap template: 00:06:00 •Applying Bootstrap to Django form: 00:04:00 •Creating Stunning Product Card items: 00:09:00 •Creating model: 00:04:00 •Creating forms: 00:03:00 •Creating views: 00:07:00 •Applying ORM - migrations: 00:03:00 •Creating my_form template: 00:05:00 •Adding urls: 00:03:00 •Creating success_view template: 00:04:00 •Project urls update and adding Installed apps: 00:02:00 •Run project and submit data to database: 00:06:00 •Creating report_view method: 00:03:00 •Creating report_template: 00:03:00 •Update urls pattern: 00:02:00 •Run project and test reports: 00:03:00

Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone 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 Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone 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 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00