9669 Office courses in Cardiff delivered Online

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Business Strategy Planning Masterclass bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Business Strategy Planning Masterclass related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Business Strategy Planning Masterclass bundle will help you build a solid foundation to become a proficient worker in the sector. This Business Strategy Planning Masterclass Bundle consists of the following 25 CPD Accredited Premium courses - Course 01 :Business Strategy Planning Masterclass Course 02 :Business Performance Management Course 03 :Diploma in Lean Process and Six Sigma Course 04 :Rapid Business Improvement Course 05 :Branding Fundamentals for New Business Course 06 :Raise Money and Valuation for Business Course 07 :Business Intelligence Analyst Course Course 08 :Business Strategy for Managers Course 09 :Research Methods in Business Course 10 :Capital Budgeting & Investment Decision Rules Course 11 :Retail Strategy Course 12 :Basic Business Finance Course 13 :Business Funding Course 14 :Financial Modelling for Decision Making and Business plan Course 15 :Financial Risk Management Course 16 :Lead Generation with Attraction Marketing for Business Course 17 :Digital Product Management Course 18 :Digital Marketing Business Tips Course 19 :Digital Marketing - Growth Hacking Techniques Course 20 :A Profitable Online Business Masterclass Course 21 :Petroleum Products : Specifications Properties Market Demand Course 22 :Candle Making Business Course 23 :Setting Up Your Dog Grooming Business Course 24 :14 Authority Sites For Learning Amazon Affiliate Marketing Course 25 :Start A T-Shirt Business | Merch By Amazon, Teespring & More 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Learning Outcome This tailor-made Business Strategy Planning Masterclass bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Business Strategy Planning Masterclass Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course for free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Business Strategy Planning Masterclass bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Business Strategy Planning Masterclass Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified HVAC Technologies Masterclass course bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The HVAC Technologies Masterclass course related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive HVAC Technologies Masterclass course bundle will help you build a solid foundation to become a proficient worker in the sector. This HVAC Technologies Masterclass course Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 2: Heat Exchanger Course 3: PAT Level 4 Course 4: Smart Meter Installer Training Course 5: Domestic Appliance Repairing Course Course 6: Electronic & Electrical Devices Maintenance Course 7: Electrician Course 8: Digital Electric Circuits & Intelligent Electrical Devices Course 9: Electric Power Metering for Single and Three Phase Systems Course 10: Light Current Systems for Electrical Engineering Course 11: Basic AC Circuit Analysis Course 12: Electrical 3 Phase Power Transformers Fundamentals Course 13: Electrical Power System and High Voltage Engineering Course 14: Electrical Engineering for Electrical Substations Course 15: Essential Hydro Electric Power Plant Training Course 16: Energy Saving in Electric Motors Course 17: MATLAB Simulink for Electrical Power Engineering Course 18: MATLAB/Simulink for Power Electronics Simulations Course 19: Solar Energy Course 20: Protection and Control of High Voltage Power Circuits Course 21: Distribution Station & Feeder Protection Course 22: Electrical and Fire Safety Training - Level 2 Course 23: Advanced Electrical Safety Course 24: Workplace Safety Course Course 25: First Aid at Work 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made HVAC Technologies Masterclass course bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This HVAC Technologies Masterclass course Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete HVAC Technologies Masterclass course training materials, you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the HVAC Technologies Masterclass course bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in HVAC Technologies Masterclass course Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

The process of building and maintaining a good and healthy employee and supervisory relationship is an ongoing process. Along with building relationships, performance coaching is a great way to develop new skills and talents. Our Performance Coaching bundle can help you take your career to the next level. Performance coaching can be a great asset in developing a healthy competitive workplace environment. At the same time, it can be used to develop and hone the various necessary skills that are essential in order to give the required push to your career. So, whether to just hone your skills or to get ready for the upcoming promotion you are aiming for, developing the essential skills is always a good idea. Our Performance Coaching course bundle can guide and train you in all the necessary skills you might need to get ahead of the curve in your workplace. All the courses in this Performance Coaching bundle are well-researched and thoroughly detailed. This comprehensive course bundle can be just the thing to reach your next professional milestone. Along with this Performance Coaching course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Performance Coaching Bundle Consists of the following Premium courses: Course 01: Performance Coaching Course 02: Performance Management Course 03: Coaching & Mentoring Course 04: Leadership & Management Diploma Course 05: Workplace Confidentiality Course 06: People Management Skills Level 3 Course 07: Emotional Intelligence and Human Behaviour Course 08: Sales: Psychology of Customers Course 09: Time Management Course 10: Effective Communication Skills Course 11: Motivation Skills Key features of this Performance Coaching course: This Performance Coaching bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Performance Coaching is entirely online 24/7 Learner support The Performance Coaching bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Performance Coaching expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Performance Coaching from any place in your own time without travelling for classes. Enrol now in Performance Coaching to advance your career, and use the premium study materials from Apex Learning. This Performance Coaching bundle entails 11 essential courses that can accelerate your career forward. Learning these skills will not only be beneficial for now, but they will also help you in every professional move you might make in the future. This Performance Coaching bundle consists of the following courses: Course 01: Performance Coaching Module 01: Introduction Module 02: The Coach/Client Relationship Module 03: Coaching and Mentoring Models Module 04: Ethical Aspects of Coaching and Mentoring Module 05: Effective Communication Skill Module 06: Personal Skills Module 07: Management Skills Module 08: Organisational Skills Module 09: Motivation and Mindset Module 10: Key Themes of NLP Module 11: The Relationship Between Stress and Performance: The Inverted-U Theory Module 12: Leadership Under Pressure Module 13: Setting Up as a Coach Course 02: Performance Management Section 01: Introduction Section 02: Performance Section 03: Key Performance Indicators Section 04: Reporting Section 05: Rewarding Section 06: Conclusion Course 03: Coaching & Mentoring Module 1: Introduction Module 2: Coaching and Mentoring: Objectives & Processes Module 3: Ethical Aspects of Coaching and Mentoring Module 4: Coaching and Mentoring Models Module 5: Effective Communication Skills Module 6: Personal Skills Module 7: Management Skills Module 8: Functional Skills Course 04: Leadership & Management Diploma Understanding Management and Leadership Leadership Theories Motivating Employees Organisational Skills Talent Management Succession Planning Business Process Management Communication Skills Negotiation Techniques Managing Meetings and Giving Feedback Managing Change Time Management Stress Management Emotional Intelligence in Leadership Managing Conflict Dealing with Office Politics Risk Management Corporate Responsibility and Ethics And Much More... Course 05: Workplace Confidentiality Module 01: Introduction to workplace confidentiality Module 02: Business Etiquettes and Types of Confidentiality Module 03: The Importance of Confidentiality Module 04: Confidentiality with Co-workers Module 05: Preventing Confidentiality Breach Module 06: How Employers Can Protect Confidential Information Course 06: People Management Skills Level 3 Course 07: Emotional Intelligence and Human Behaviour Course 08: Sales: Psychology of Customers Course 09: Time Management Course 10: Effective Communication Skills Course 11: Motivation Skills CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? You don't need any previous training or training materials to finish the Performance Coaching course bundle. This Performance Coaching course is designed for: Students Academics of all background Office workers Corporate Job Holders Requirements Our Performance Coaching bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Career path Completing the Performance Coaching Course bundle can open up various exciting career opportunities in sectors, such as: Business & Management Admin Accountancy & Finance Secretarial & PA Teaching & Mentoring The average salary for a Management Accountant can be £22,000- £55,000 per annum for anyone residing in the United Kingdom. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Performance Coaching) 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.

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.

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.

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

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.

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.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

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.