• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3 Database Design & Development courses in Ware

Database design

5.0(3)

By Systems & Network Training

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

Database design
Delivered in Internationally or OnlineFlexible Dates
£2,367

Software development fundamentals

5.0(3)

By Systems & Network Training

Software development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Describe core programming. Explain Object Oriented programming. Describe general software development. Describe Web applications. Describe desktop applications. Explain how databases work. Software development training course details Who will benefit: Anyone looking to learn the fundamentals of software. Prerequisites: None. Duration 3 days Software development training course contents Core programming Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. Handling repetition For loops, While loops, Do...While loops and recursion. Understand error handling Structured exception handling. Object-oriented programming Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. Inheritance Inheriting the functionality of a base class into a derived class. Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. General software development Application life cycle management Phases of application life cycle management, software testing. Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. Web applications Web page development HTML, CSS, JavaScript. ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. Desktop applications Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. Console-based applications Characteristics and capabilities of console- based applications. Windows Services Characteristics and capabilities of Windows Services. Databases Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. Database query methods SQL, creating and accessing stored procedures, updating and selecting data. Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

Software development fundamentals
Delivered in Internationally or OnlineFlexible Dates
£2,367

Microsoft Access Introduction - In-company (now with live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Access Introduction  - In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Online Options

Show all 256

Level 7 Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku - QLS Endorsed

By Kingston Open College

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Level 7 Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku - QLS Endorsed
Delivered Online On Demand12 hours
£105

Introduction to Database Design

By iStudy UK

This Introduction to Database Design course teaches the basis of relational database design and explains how to make a good database design and become an expert on it. Designing a database is quite simple, but you've to understand a few rules before jump onto it. It is essential to know about these rules, otherwise, you will tend to make errors. If you find it hard to deal with database, scripts and all the technical parts, then this comprehensive course is just for you. The course includes the followings: Creating database and database users Introduction of data, different data types, foreign key constraints, and other relevant concepts used to create the best database Importing database tables Explore all types of relationships Designing all types of relationships within a database. Learn three common forms of database normalisation Application of database for the business purpose And much more... What Will I Learn? What is a database Understand different types of databases Understand normalization Assign relationships Eliminate repetition Relate tables with IDs Design rules Requirements Basic Microsoft Windows training or equivalent experience Who is the target audience? Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design Introduction Introduction FREE 00:03:00 Database Basics Overview 00:01:00 What is a Database? 00:03:00 Different Types of Databases 00:12:00 The Process of Database Design 00:08:00 Normalizing Overview - Normalizing 00:01:00 What is Normalization? 00:02:00 Basic Steps to Normalization 00:05:00 A. Brainstorm 00:01:00 B. Organize 00:03:00 C. Eliminate Repetition 00:12:00 D. Assign Relationships 00:01:00 D1. One to One Relationship 00:06:00 D2. One to Many Relationship 00:04:00 D3. Many to Many Relationship 00:06:00 Relating Tables with IDs 00:02:00 Examples of Bad Design 00:15:00 Examples of Good Design 00:06:00 Design Rules 00:05:00 Conclusion Conclusion 00:04:00 Course Certification

Introduction to Database Design
Delivered Online On Demand1 hour 40 minutes
£25

New Db2 13 Functions and Features - CV321G

By Verhoef Training Ltd.

Audience This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. Prerequisites You should have practical experience with Db2 for z/OS Duration 2 days.  Course Objectives Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. Course Content Unit 1: Db2 v12 Function Levels: Selected Highlights Unit 2: Migrating to Db2 13 Unit 3: Availability & Scalability Unit 4: Performance Unit 5: Application Management and SQL Changes Unit 6: SQL Data Insights Unit 7: Security Unit 8: IBM Db2 Utilities Unit 9: Instrumentation and Serviceability

New Db2 13 Functions and Features - CV321G
Delivered OnlineFlexible Dates
£1,200 to £1,800

55366 Querying Data with Transact-SQL

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

55366 Querying Data with Transact-SQL
Delivered OnlineFlexible Dates
£2,976

Oracle SQL Fundamentals, 3 Days

4.6(12)

By PCWorkshops

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Oracle SQL Fundamentals, 3 Days
Delivered OnlineFlexible Dates
£750

Database Online Training

4.9(27)

By Apex Learning

The easy way to store your data and retrieve it when you need it! Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business. This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation. Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need. Along with this Database Course, you will get 11 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. So, don't wait up. Enrol now! This Database Bundle Consists of the following Premium courses: Courses are included in this Database Bundle? Course 01: Microsoft SQL Server Development for Everyone Course 02: SQL Programming Masterclass Course 03: SQL NoSQL Big Data and Hadoop Course 04: Python Programming for Everybody Course 05: Data Science with Python Course 06: JavaScript Foundations for Everyone Course 07: C# Programming - Beginner to Advanced Course 08: R Programming for Data Science Course 09: Three.js & WebGL 3D Programming Course for Beginners Course 10: Basic Google Data Studio Course 11: Data Analytics with Tableau Learning Outcomes Have a fundamental understanding of database design, implementation, and upkeep. Be able to query databases and learn the SQL language. To preserve data, use security procedures and backup procedures. Examine database performance and note any enhancements. Be familiar with approaches for database normalisation and optimisation. Create web services and database applications. Use DBMS software for managing and storing data. Identify technologies and trends in databases. These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in learning programming and data science skills Professionals seeking to enhance their knowledge and skill set Entrepreneurs or business owners wanting to understand and manage data effectively Students or graduates in computer science, data science, or related fields Anyone looking to start a career in programming or data science Data analysts, data scientists, or data engineers looking to expand their skill set Requirements There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path People tend to pursue their careers in the following professions in the database sector Database Administrator Database Developer Database Architect Database Analyst Database Designer The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Microsoft SQL Server Development for Everyone) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Database Online Training
Delivered Online On Demand
£53

MySQL Course Intermediate, 3 DAYS

4.6(12)

By PCWorkshops

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

MySQL Course Intermediate, 3 DAYS
Delivered OnlineFlexible Dates
£600

SQL Intermediate Course, 3 Days

4.6(12)

By PCWorkshops

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

SQL Intermediate Course, 3 Days
Delivered OnlineFlexible Dates
£600

The Complete Guide for SQL with Microsoft SQL Server

By Packt

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.

The Complete Guide for SQL with Microsoft SQL Server
Delivered Online On Demand7 hours 52 minutes
£82.99

SQL Course Advanced, 2 Days

4.6(12)

By PCWorkshops

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

SQL Course Advanced, 2 Days
Delivered OnlineFlexible Dates
£450

Educators matching "Database Design & Development"

Show all 5
Futuretrend

futuretrend

Enfield

Futuretrend has been providing IT, Design, Financial and Business Skills training since December 2000. With a solid reputation for delivering high quality programmes, Futuretrend has become a successful and well established training centre. Year on year hundreds of learners come to this centre to pursue a course of study that will help them fulfill career aspirations, improve their job prospects or to simply learn more about a particular area of interest. In today's competitive business environment the importance of up-to-date skills cannot be overstated. With Futuretrend, you and/or your team will benefit immensely from our results-oriented training. Our instructors are professionals who work full-time in the industry and bring their working knowledge to the classroom to enhance your learning experience. Our courses are centred on learning by doing, ensuring that learning retention rates are high and that delegates are able to confidently apply their new found skills in the workplace or successfully in an exam situation, demonstrating an immediate return on investment. A prerequisite for any Futuretrend trainer is that they must practise the skills they teach. It is essential that they are able to draw from real world experiences to illustrate subject matter, thereby enabling delegates to envisage how best to use software and concepts effectively. This is based on the following ethos: “Tell me and I’ll forget. Teach me and I’ll remember. Involve me and I’ll learn.” We are often asked how we have made a success from a company which was seemingly produced from nothing but which has now become one of the most dynamic organisations within the industry. The answers are simple; Speed - We have built a good reputation around the fact that we do not keep our clients waiting for answers to their requirements. If we tell you we shall call back the same day then we absolutely mean it. It’s more likely that we will get back to you on the spot. Quality - One attribute is nothing without the other. All Futuretrend's staff and associated freelancers have major industry experience and are amongst the best and highest qualified in their sphere of activity in the UK; and why not? Our reputation depends on them. Personal touch - Whilst maintaining the air and professionalism of a larger company you will always know who you are dealing with when you dial through to our offices. We give our individual time to each of our clients and as such you are guaranteed a friendly and personal reception. These are only three of the numerous reasons as to why so many individuals and organisations in and around the UK are choosing to trust their training to Futuretrend. Our success depends entirely on our client's satisfaction and this is mirrored in our everyday approach to your requests. We don't expect to stay at the forefront of our competitors without maintaining sharp minds and a fresh attitude. Another typical question asked is how can we offer our courses at such low prices ? Here is why; Futuretrend has never taken out costly traditional advertising which would lead to unnecessary expenditure and thus forcing prices up. We have built our success mainly on very good "word of mouth" and relatively inexpensive online marketing. As such we are in the lucky position of being able to do away with the myth that business can only be generated through glossy brochures. Additionally, we are not passing on the premiums charged for West End and City training venues. Most of these will still not be as modern or well-equipped as our newly refurbished classrooms. Our premises are within an Elegant Victorian North London building. You could easily be paying double the amount and more attending a similar course elsewhere and probably not even half the quality. We hope our web site will give you a taste of the quality of study available at Futuretrend and make your decision to study with us a little easier. We all learn best when we are happy and valued so let us help advance your skills and enhance your potential.

Oasis Academy Enfield

oasis academy enfield

Enfield

Everything within Oasis Community Learning is framed by our ethos. Our ethos is rooted in what we believe and who we are. Grounded in our story, it is an expression of our character; a set of values that inform and provide the lens on everything we do. A passion to include A desire to treat people equally respecting differences A commitment to healthy, open relationships A deep sense of hope that things can change and be transformed A sense of perseverance to keep going for the long haul It is these ethos values that we want to be known for and to live by. We are committed to a model of inclusion, equality, healthy relationships, hope, and perseverance throughout all the aspects of the life and culture of every Oasis Hub and academy community. We encourage every member of our family, be that staff or student, to align themselves to these ethos values. The values themselves are inspired by the life, message and example of Jesus but we make it clear that we will not impose on anyone, the beliefs that underpin our ethos values. We recognise and celebrate the richness that spiritual and cultural diversity brings to our community, respecting the beliefs and practices of other faiths in the hope that we will provide a welcoming environment for all. The Oasis 9 Habits The Oasis Ethos is aspirational, inspirational and something that we have to constantly work at. It is important to remember that every organisation is made up of its people, and people don’t always get things right. This means that there can sometimes be a dissonance between what we say we are, as stated in our ethos values, and what we actually do and experience. Recognising this is helpful because it reminds us that we each have things to work on; we have space to grow, develop and change to become the best version of ourselves. To help us in this process of personal growth and development we have the Oasis 9 Habits. It is our bespoke and unique approach to character development. We know that by living the way of the Habits, the Oasis Ethos will become second nature to us. We also believe that this process of continually developing our character and being transformed to become the best version of ourselves is really important for every student and staff member alike. Therefore, we actively promote and practice the Oasis 9 Habits which are an invitation to a way of life characterised by being compassionate, patient, humble, joyful, honest, hopeful, considerate, forgiving and self-controlled. We believe that by becoming people who live this way, by becoming the best version of ourselves, whether we are a staff member or students, we are transformed, and we are also able to play our part in bringing transformation locally, nationally and globally.