QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost
24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Ignite your career in the construction industry and open the gates to success with our exclusive Building Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle. This power-packed trio of courses is your ticket to unlocking a world of opportunities. With three QLS-endorsed certifications at your fingertips and hardcopy certificates to showcase your expertise, you'll be on the fast track to professional advancement. Learn how surveying measurements are done and budgets are estimated and start your career as a quantity surveyor in the UK building industry. From tendering important contracts to pricing and bill preparation, master all the tricks of the profession with the help of our experts from this industry. Is this Premium Quantity Surveying course really worth £350? Take a look at the goodies you will be offered- Get 3 FREE QLS Certificate & CPDQS accredited certificate worth of (£129+£10)x3 = £417 This course is also offering a 'Job Seeker' bundle consisting of 10 courses worth £200 to increase your employability Get Nominated for a Live webinar; 1 out of every 10 students would get this chance by a Rafflel Draw worth £299 Full tutor support is available Get 24/7 help or advice from our email and live online community Profile-building consultation for job sites and resume support Unlimited retake exams Free entry to job seekers forum Find a report of current job openings for the relevant course Learn at your ease - anytime, from anywhere Job Seeker's Special Bundle Worth £200 Our Special Course is also offering an exclusive bundle to enhance your potential in the job market. This bundle includes important and effective courses such as: Course 01: Job Search Skills Course 02: CV Writing and Job Searching Course 03: Proofreading & Copy Editing Course (Level 4 Diploma) Course 04: Effective Methods of Public Speaking and Presentation Skill Course 05: Recovering from a Job Loss in Technology Course Course 06: Workplace Professionalism Course 07: Microsoft Office Course 08: Confidence Building & Assertiveness Course 09: Critical Thinking in The Workplace Course 10: Time Management Skills You Will Gain: By the end of this Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle, you will be able to - Quantity surveying principles, techniques, and measurement methods Be able to perform and record accurate measurements Understand how to execute efficient cost management Learn how to accurately estimate project costs Factors influencing cost estimation and effective cost management Get skilled in the acts of procurement and bill charging Master the ability to assess potential risks and act accordingly Construction Industry Scheme (CIS) coverage, registration, verification, and record-keeping The Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle is QLS-endorsed and CPD accredited. You can take the at your own pace - anytime, from anywhere. Enroll in the Building Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle today and unleash your potential. Gain the expertise, recognition, and hardcopy certificates that will take your career to soaring heights. Your future in the construction industry starts here. By the time you complete this Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle, you'll have sharpened the skills and As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have crafted this training to empower you to learn all at once with accuracy. QLS Course 1- Quantity Surveying: An introduction to quantity surveying principles Development of the quantity surveying profession Quantity surveying measurement techniques Cost management strategies Pricing and operational estimation Contract management and tendering processes Procurement and bill preparation Predicting potential risks and implementing management strategies Regulation and control in quantity surveying Report writing skills development QLS Course 2- Building Quantity Surveying: Building law principles Building procurement and contract administration Building technology insights Cost estimation techniques Factors influencing cost estimation Effective cost management strategies Management of materials for construction Building pathology understanding Building adaptation considerations Report writing skills development Legal aspects of building surveying QLS Course 3- Construction Industry Scheme (CIS): Overview of the Construction Industry Scheme (CIS) Coverage and scope of the scheme Contractor registration process for CIS Verification procedures within the scheme CIS returns and reporting requirements Record-keeping and CIS certificate management Penalties associated with CIS non-compliance Miscellaneous information related to the CIS Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. Show off Your New Skills with a Certification of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After completing the Quantity Surveying course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, completely free of charge in this package. CPD 450 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to enhance their skills and knowledge in quantity surveying and construction industry schemes. Individuals interested in pursuing a career as a quantity surveyor or building surveyor within the construction sector. Students or graduates looking to specialise in quantity surveying or gain a comprehensive understanding of the construction industry. Construction professionals aiming to expand their expertise and stay updated with the latest regulations and practices. Requirements Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle has no formal entry criteria, and everyone is welcome to enrol! Career path Career Path of Quantity Surveying & Construction Industry Scheme (CIS) - QLS Endorsed Bundle: Quantity Surveyor: £30,000 - £60,000 per year Building Surveyor: £25,000 - £50,000 per year Construction Estimator: £25,000 - £45,000 per year Contract Administrator: £25,000 - £40,000 per year Procurement Manager: £30,000 - £60,000 per year Construction Compliance Officer: £25,000 - £45,000 per year Certificates Certificate Accredited by CPDQS Digital certificate - Included
24 Hour Flash Deal **25-in-1 Level 2 Certificate in Understanding the Care and Management of Diabetes Mega Bundle** Level 2 Certificate in Understanding the Care and Management of Diabetes Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Level 2 Certificate in Understanding the Care and Management of Diabetes package online with Studyhub through our online learning platform. The Level 2 Certificate in Understanding the Care and Management of Diabetes bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Level 2 Certificate in Understanding the Care and Management of Diabetes course provides complete 360-degree training on Level 2 Certificate in Understanding the Care and Management of Diabetes. You'll get not one, not two, not three, but twenty-five Level 2 Certificate in Understanding the Care and Management of Diabetes courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Level 2 Certificate in Understanding the Care and Management of Diabetes courses are yours for as long as you want them once you enrol in this course This Level 2 Certificate in Understanding the Care and Management of Diabetes Bundle consists the following career oriented courses: Course 01: Diabetes Awareness Training Course 02: Diabetes Management & Balanced Diet Course 03: Nutrition Training - Advanced Diet & Meal Planning Course 04: Medication Administration and Preservation Course 05: Foot Disorders & Treatment Course 06: Oral Health Care: Strategies for Dental Wellness Course 07: Wound Care and Tissue Viability Course 08: Stress Management Training Course 09: Holistic Exercise Physiology Training Course 10: Health and Weight Coaching Certificate Course 11: Understanding the Immune System Course 12: Pharmacology Diploma Course 13: Complete Training on Holistic Health and Nutrition Course 14: Ketogenic Diet Mastery: Achieving Health Goals with Keto Course 15: Diet and Nutrition Diploma Course 16: Mental Health Awareness Course Online Course 17: Diploma in Safeguarding Vulnerable Adults Course 18: Domiciliary Care Training Course 19: Personal Hygiene Course 20: Phlebotomy Course 21: Diploma in Infection Prevention Course 22: Observation Skills for Carers Course 23: Anatomy and Physiology of Human Body Course 24: Public Health Course 25: Health and Social Care Management The Level 2 Certificate in Understanding the Care and Management of Diabetes course has been prepared by focusing largely on Level 2 Certificate in Understanding the Care and Management of Diabetes career readiness. It has been designed by our Level 2 Certificate in Understanding the Care and Management of Diabetes specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Level 2 Certificate in Understanding the Care and Management of Diabetes Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Level 2 Certificate in Understanding the Care and Management of Diabetes bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Level 2 Certificate in Understanding the Care and Management of Diabetes Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Level 2 Certificate in Understanding the Care and Management of Diabetes Elementary modules, allowing our students to grasp each lesson quickly. The Level 2 Certificate in Understanding the Care and Management of Diabetes course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Level 2 Certificate in Understanding the Care and Management of Diabetes bundle, you really hit the jackpot. Here's what you get: Step by step Level 2 Certificate in Understanding the Care and Management of Diabetes lessons One to one assistance from Level 2 Certificate in Understanding the Care and Management of Diabetesprofessionals if you need it Innovative exams to test your knowledge after the Level 2 Certificate in Understanding the Care and Management of Diabetescourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Level 2 Certificate in Understanding the Care and Management of Diabetes courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Level 2 Certificate in Understanding the Care and Management of Diabetes certificate and transcript on the next working day Easily learn the Level 2 Certificate in Understanding the Care and Management of Diabetes skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Level 2 Certificate in Understanding the Care and Management of Diabetes training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Level 2 Certificate in Understanding the Care and Management of Diabetes Requirements To participate in this Level 2 Certificate in Understanding the Care and Management of Diabetes course, all you need is - A smart device A secure internet connection And a keen interest in Level 2 Certificate in Understanding the Care and Management of Diabetes Our Course is not a regulated course. If You want to get qualified, you can consider following options: Level 2 Certificate in Understanding the Care and Management of Diabetes (RQF) NCFE CACHE Level 3 Certificate in Understanding the Care and Management of Diabetes Career path You will be able to kickstart your Level 2 Certificate in Understanding the Care and Management of Diabetes career because this course includes various courses as a bonus. This bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Level 2 Certificate in Understanding the Care and Management of Diabetes career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free
Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is as follows: Administrator IT support personnel Helpdesk support staff The secondary audience for this course is as follows: Network Engineering Staff Overview Upon completing this course, the learner can meet these overall objectives: Demonstrate an overall understanding of the Cisco Unified Communications Manager (CUCM) system and its environment Configure CUCM to support IP Phones Configure Cisco Unified Communications Manager and IM&Presence to support Cisco Jabber soft client. Configure CUCM to route calls to internal and PSTN destinations Configure User accounts and multi-level administration Demonstrate the use of Self Care Portal functionality Configure user features, including Hunt Groups, Call Pickup, and Call Park. Define the capabilities of and demonstrate the Bulk Administration Tool Define the SMART Licensing model for Cisco Unified Communications Demonstrate the use of the Unified Reporting tool Demonstrate the use of the Dialed Number Analyzer Explain the function of Cisco Unity Connection and the various interfaces that are used to access the system Describe the components that are required for user call processing by Cisco Unity Connection Implement the various features and options that are available to users in Cisco Unity Connection Explore Cisco Unity Connection version features and functions Use the various applications, tools, and reports that are available in Cisco Unity Connection Administering Collaboration Environments (CLACE) is an instructor-led course presented by Skyline-ATS to system administrators and customers involved with the Cisco Unified Communications Manager and Cisco Unity Connection product's day-to-day operation. The CLACE course is the replacement for the CMA / UCA courses. CLACE is a lab-intensive course. The primary focus is learning by performing the configuration tasks. The amount of theory is limited to allow more time for discovery exercises. This course introduces you to the CUCM system, the necessary procedures for administering IP Phones and Users, understanding the Dial Plan, and implementing Features. The course also covers Jabber administration and Cisco Unity Connection administration features, options, and configuration settings. In addition to instructor-led lectures and discussions, you will configure CUCM and Cisco IP Phones in the lab, either in a live classroom or WebEx remote classroom environment. While the CUCM and CUC software used in the class is version 12.5.1, the course material applies to versions 8.x, 9.x, 10.x, 11.x, or 12.x of the applications. The concepts and the lab tasks are the same for most of the software versions. Define Collaboration Technology and Benefits Define Collaboration Benefits Describe On-Premise, Cloud, and Hybrid Deployments Describe On-Premise Collaboration Deployments Describe Cisco's Collaboration Endpoints Describe Cisco Collaboration On-Premise Edge Solutions Describe Cisco's Collaboration On-Premise Conferencing Solutions Describe Cisco Cloud Services Administering Initial Parameters for Cisco Unified Communications Manager Understand the On-Premise Collaboration Deployment Models Describe The Cisco Unified CM Cluster Services Define Network requirements for Collaboration Define Network Services for Collaboration Navigate Cisco Unified CM Discovery 1: Configure Cisco Unified Communications Manager Initial Parameters Explore Cisco Unified CM Groups Discovery 2: Configure the Cisco UCM Core Systems Settings Exploring Endpoints and the Registration Process Identify Cisco Endpoint Solutions Explore the Boot up Process of an Endpoint Describe Power Over Ethernet Discovery 3: Configure an Access Switch for an Endpoint Describe IP Network Settings Discovery 4: Deploy an IP Phone Through Auto and Manual Registration Discovery 5: Administer Endpoints in Cisco Unified Communications Manager Managing Users in Cisco Unified Communications Manager Analyze Cisco UCM Users Types and Settings Describe Methods for Authenticating Cisco UCM Users Discovery 6: Create Local User Accounts Discovery 7: Adding Users in Cisco Unified Communications Manager Describing a Basic Dial Plan Describe the Concepts of a Dial Plan and Call Routing Describe Elements of Call Routing Explore Digit Manipulation and Translation Patterns Discovery 8: Create a Basic Dial Plan Describing Class of Service Explore the Concepts of Class of Control Discovery 9: Explore Partitions and Calling Search Spaces Discovery 10: Explore Private Line Automatic Ringdown (PLAR) Enabling Endpoints and Features Configure a Cisco Jabber Endpoint in Cisco UCM Discovery 11: Implementing Common Endpoint Features (Configuring Hunt Groups and Call Coverage) Explore Mobility Discovery 12: Implement Mobility Implementing Media Resources in Cisco Unified Communications Manager Media Resource Overview Media Resource Selection and Access Control Audio and Video Conference Bridge Devices Audio and Video Conference Bridge Integration Options Discovery 13: Configuring Media Resources Reporting and Maintenance Explore the Troubleshooting Process Describe Reporting and Maintenance Tools Describe the Cisco Real-Time Monitoring Tool Discovery 14: Use Reporting and maintenance Tools Describing Cisco Instant Messaging and Presence Describe Cisco IM and Presence Features and Architecture Clustering Describe Cisco IM and Presence Components and Communication Flows Enabling Jabber Cisco Jabber Deployment Modes Discovery 15: Deploy an On-Premise Cisco Jabber Client for Windows Configure Unity Connection Integration Overview of Cisco Unity Connection Integration SIP Integration Typical Integration Mistakes Integration Considerations Discovery 16: Configure the integration between Cisco Unity Connection and Cisco UCM Discovery 17: Configure Voicemail Users Configuring Cisco Unity Connection Call Handlers Call handler Overview System Call Handler Caller Input Operator Call Handler Goodbye Call Handler Directory Handler Interview Handler Troubleshooting Cisco Unity Connection Overview of Cisco Unity Connection Troubleshooting Options Integration Troubleshooting Tools Cisco Real-Time Monitoring Tool Discovery 18: Troubleshoot Cisco Unity Connection Additional course details: Nexus Humans Cisco Administering Collaboration Environments (CLACE) 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 Cisco Administering Collaboration Environments (CLACE) 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.
Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.
Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.
Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.
MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.
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.