1635 Database courses delivered Online

GCP provides infrastructure as a service (IaaS), platform as a service (PaaS), and serverless computing environments to help businesses build, deploy, and scale applications and services.

This course will take you from the basic structure of ASP.Net Core 5 to building and enhancing a functional website. You will deep dive into the concepts by creating a product catalog, connecting your application to a database, sending emails from your application, integrating a secure payment system into your application, and a lot more.

Complete Python training course description Python is an agile, robust, expressive, fully objectoriented, extensible, and scalable programming language. It combines the power of compiled languages with the simplicity and rapid development of scripting languages. This course covers Python from the very basics of 'hello world!' through to object oriented programming and advanced topics such as multi threading. Hands on follows all the major sections in order to reinforce the theory. What will you learn Read Python programs. Write Python programs. Debug Python programs. Use Python's objects and memory model as well as its OOP features. Complete Python programming training course details Who will benefit: Anyone wishing to learn Python. Prerequisites: None. Duration 5 days Complete Python programming training course contents Welcome to Python: What is Python? Origins, features. Downloading and installing Python, Python manuals, comparing Python, other implementations. Getting started: Program output, the print statement, "hello world!", Program input, raw_input(), comments, operators, variables and assignment, numbers, strings, lists and tuples, dictionaries, indentation, if statement, while Loop, for loop. range(), list comprehensions. Files, open() and file() built-in functions. Errors and exceptions. Functions, Classes, Modules, useful functions. Python basics: Statements and syntax, variable assignment, identifiers, basic style guidelines, memory management, First Python programs, Related modules/developer tools. Python Objects: Other built-in types, Internal Types, Standard type operators, Standard type built-in functions, Categorizing standard types, Unsupported types. Numbers: Integers, Double precision floating point numbers, Complex numbers, Operators, Built-in and factory functions, Other numeric types. Sequences: strings, lists, and tuples: Sequences, Strings, Strings and operators, String-only operators, Built-in functions, String built-in methods, Special features of strings, Unicode, Summary of string highlights, Lists, Operators, Built-in functions, List type built-in methods, Special features of lists, Tuples, Tuple operators and built-in functions, Tuples special features, Copying Python objects and shallow and deep copies. Mapping and set types: Mapping Type: dictionaries and operators, Mapping type built-in and factory functions, Mapping type built-in methods, Dictionary keys, Set types, Set type operators, Built-in functions, Set type built-in methods. Conditionals and loops: If, else and elif statements, Conditional expressions, while, for, break, continue and pass statements, else statement . . . take two, Iterators and iter(), List comprehensions, Generator expressions. Files and input/output: File objects, File built-in functions [open() and file()], File built-in methods and attributes, Standard files, Command-line arguments, File system, File execution, Persistent storage modules. Errors and exceptions: What are exceptions? Detecting and handling exceptions, Context management, Exceptions as strings, Raising exceptions, Assertions, Standard exceptions, Creating Exceptions, Why exceptions, Exceptions and the sys module. Functions: Calling, creating and passing functions, formal arguments, variable-length arguments, functional programming, Variable scope, recursion, generators. Modules: Modules and files, Namespaces, Importing modules, Module import features, Module built-in functions, Packages, Other features of modules. Object-Oriented Programming (OOP): Classes, Class attributes, Instances, Instance attributes, Binding and method invocation, Static methods and class methods, Composition, Sub-classing and derivation, Inheritance, Built-in functions for classes, and other objects, Customizing classes with special methods, Privacy, Delegation, Advanced features of new-style classes (Python 2.2+), Related modules and documentation. Execution environment: Callable and code Objects, Executable object statements and built-in functions, Executing other programs. 'Restricted' and 'Terminating' execution, operating system interface. Regular expressions: Special symbols and characters, REs and Python, Regular expressions example. Network programming: Sockets: communication endpoints, Network programming in Python, SocketServer module, Twisted framework introduction. Internet client programming: What are internet clients? Transferring files, Network news, E-mail. Multithreaded Programming: Threads and processes Python, threads, and the global interpreter lock, The thread and threading Modules. GUI programming: Tkinter and Python programming, Tkinter Examples, Brief tour of other GUIs. Web programming: Web surfing with Python: creating simple web clients, Advanced Web clients, CGI: helping web servers process client data, Building CGI applications, Using Unicode with CGI, Advanced CGI, Web (HTTP) Servers. Database programming: Python database application programmer's interface (DB-API), ORMs. Miscellaneous Extending Python by writing extensions, Web Services, programming MS Office with Win32 COM, Python and Java programming with Jython.

Microsoft Exchange training course description A hands on course focusing on the day to day running of Microsoft Exchange. The course is designed for those with a sound understanding of how Exchange forwards emails and concentrates on important issues such as monitoring, backups and restores. This course can be delivered on any version of Microsoft exchange and tailored as required. What will you learn Install MS Exchange Create, configure and manage user mailboxes. Configure and administer MS Exchange. Backup and restore MS Exchange. Microsoft Exchange training course details Who will benefit: Anyone working with MS Exchange. Prerequisites: Total SMTP and email for engineers Duration 3 days Microsoft Exchange training course contents Review of mail basics Basic routing & Client/Server, Mail flow & protocols, Mail server technology. Exchange features MAPI, Database, The Exchange organisation, Active Directory consideration. Installing Understanding server roles, Planning for Exchange, Preparing Active Directory, Preparing the host server, Installing Exchange. Introduction to Exchange management tools Exchange Management shell, Exchange Management console. Administration Configuring SMTP domains, Send connectors, Receive connectors, Setting up & managing user mailboxes, Setting up resource mailboxes, Mail enabled groups, Address lists. Troubleshooting Security & troubleshooting wizards, Windows platform tools, External/Internet tools.

Description: Microsoft Access is the most popular database for Windows. It enables you to collect, organize, and report on data via a graphical interface. Templates provide pre-defined forms, reports and database designs - and Macros enable you to automate regular tasks. By this Microsoft Access 2016 Advanced explore the advanced Access features. Whether you are using Access for the first time, , or have been using it for years, this course will help you make the most of Access 2016's features and tools. So, if you are thinking to improve your knowledge in Microsoft Access 2016, you can join this course now. Learning Outcomes: Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Access 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Access 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Implementing Advanced Form Design 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 Using Data Validation Field Validation 00:30:00 Form and Record Validation 00:30:00 Using Macros to Improve User Interface Design 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 Using Advanced Database Management 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 Distributing and Securing a Database 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 Managing Switchboards 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 Mock Exam Mock Exam- Microsoft Access 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Access 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Take your REST APIs to a whole new level with this advanced Flask and Python course!

Learning Objectives Introduction , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup , Configuring Access for Multiple Users , Automating Processes with VBA , Using Table Events , Conclusion   Pre-Requisites Access Beginner and Intermediate courses or equivalent experience.   Description Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Access 2019 Advanced Module 1: Introduction to the course 00:01:00 Module 2: Using the table Analyzer Wizard 00:07:00 Module 3: Append Querying to Normalize a Table 00:06:00 Module 4: Creating a Junction Table 00:05:00 Module 5: Backing up a Database 00:02:00 Module 6: Using the Compact and Repair Database Tool 00:03:00 Module 7: Using the Object Dependencies Tool 00:02:00 Module 8: Using the Database Documenter Tool 00:02:00 Module 9: Using the Analyze Performance Tool 00:02:00 Module 10: Creating a Navigation Form 00:03:00 Module 11: Modifying a Navigation Form 00:03:00 Module 12: Setting the Startup Options 00:02:00 Module 13: Using the Database Splitter 00:03:00 Module 14: Configuring Trusted Locations 00:03:00 Module 15: Password Protecting a Database 00:03:00 Module 16: Password Protecting Modules 00:02:00 Module 17: Converting a Database to an ACCDE File 00:02:00 Module 18: Understanding VBA Basics 00:03:00 Module 19: Exploring Variables and Control Flow Statements 00:07:00 Module 20: Exploring a Table or Query with VBA 00:10:00 Module 21: Converting a Macro to VBA 00:03:00 Module 22: Understanding Table Events 00:02:00 Module 23: Using the Before Change Event Command 00:05:00 Module 24: Using the After Update Event Command 00:03:00 Module 25: Recap 00:01:00 Resource Resource - Access 2019 Advanced 00:00:00 Final Exam Final Exam - Access 2019 Advanced 00:20:00

This course gets you started with the testing of web services and REST APIs using SoapUI features and tools. You will start with the basics and advance towards designing test frameworks for performing manual and automation testing on web services and APIs with the help of real-time projects.

This comprehensive course will show you how to use SQL Server, ASP.NET Core, Angular 14, and Bootstrap to build a blog from scratch.

Duration 1.5 Days 9 CPD hours This course is intended for This course is intended for DBAs and IT Professionals who want to enhance their Postgres administration skill to the next level. Overview This exam is the definitive standard for PostgreSQL professionals. This certification assesses and certifies a database professional?s ability to work in demanding, large-scale, real-world production environments. This course covers enterprise class tools for Postgres administration and prepares the learners to handle real time, production environments. Upon course completion, you will be prepared to manage large, highly available Postgres databases with confidence. PostgreSQL IntroductionSQL TuningPerformance TuningPerformance and BenchmarkingWAL ArchivingStreaming ReplicationConnection PoolingTable PartitioningExtensionsForeign Data WrappersMonitoringDatabase SecurityUpgrading Best Practices Additional course details: Nexus Humans Advanced PostgreSQL Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced PostgreSQL Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.