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

3090 Associate courses delivered Online

Windows 10 Modern Desktop Administrator Associate Bootcamp

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Candidates for this exam are IT professionals who perform installation, configuration, general local management and maintenance of Windows 10 core services. The Modern Desktop Administrator deploys, configures, secures, manages, and monitors devices and client applications in an enterprise environment. Overview After completing this course, learners should be able to: Prepare to install Windows 10. Install Windows 10. Configure Updates for Windows. Perform post-installation configuration tasks. Configure devices and drivers for Windows. Configure storage for Windows. Configure network settings in Windows. Configure remote management of Windows. Configure and manage applications in Windows. Configure Internet Explorer. Describe the methods for securing Windows 10. Configure account access and authentication. Configure file and folder permissions. Create security policies. Describe common threats and methods for mitigating against them. Use Windows troubleshooting and monitoring tools. Troubleshoot Windows installations. Troubleshoot application installation issues. Troubleshoot web browser settings. Troubleshoot Windows authentication. Troubleshoot hardware issues related to Windows machines. Develop an Operating System deployment and upgrade strategy. Understand the different methods of deployment. Understand on-premise and cloud-based solutions. Deploy and migrate desktops to Windows 10. Plan and configure Windows Update policies. Describe the benefits and capabilities of Azure AD. Manage users using Azure AD with Active Directory DS. Implement Windows Hello for Business. Configure conditional access rules based on compliance policies. Describe the various tools used to secure devices and data. Implement Windows Defender Advanced Threat Protection. This five day accelerated course will cover topics necessary to prepare attendees with the baseline knowledge to take the MD-100 and MD-101 exams for the Modern Desktop Administrator Associate certification. Installing Windows Introducing Windows 10 Installation Options Requirements for Windows Features Installation Process and Media Upgrading to Windows 10 Updating Windows Windows Servicing Model Updating Windows Applying Applications and Windows Updates Post-Instalation Configuration and Personalization Customize the Windows 10 UI Configure device specific settings such as power plans and mobile device options Use the Windows control panel and setting app to configure settings Describe using Windows PowerShell Configuring Peripherals and Drivers Managing Devices and Drivers Managing Printers Configuring Networking Configure IP Network Connectivity Implement Name Resolution Implement Wireless Network Connectivity Remote Access Overview Remote Management Configuring Storage Overview of storage options Using OneDrive Managing Disks, Partitions, and Volumes Maintaining Disks and Volumes Managing Storage Spaces Managing Apps in Windows 10 Providing Apps to Users Managing Universal Windows Apps The Windows Store Web browsers in Windows 10 Configuring Authorization and Authentication Using Security Settings to Mitigate Threats Configuring User Account Control Implementing Device Registration Authentication Configuring Data Access and Usage Overview of File Systems Configuring and Managing File Access Configuring and Managing Shared Folders Managing Security with Policies Configuring Advanced Management Tools Configuring Tenant Roles Managing Tenant Health and Services Supporting the Windows 10 Environment Troubleshooting Windows Troubleshooting Tools Troubleshooting the Windows OS Troubleshooting Windows Startup Troubleshooting Operating System Service Issues Troubleshooting Sign-In Issues Troubleshooting Files and Applications File Recovery in Windows 10 Application Troubleshooting Troubleshooting Hardware and Drivers Troubleshooting Device Driver Failures Overview of Hardware Troubleshooting Troubleshooting Physical Failures Planning an Operating System Deployment Strategy Overview of Windows as a service Windows 10 Deployment options Considerations for Windows 10 deployment Implementing Windows 10 Implementing Windows 10 by using dynamic deployment Implementing Windows 10 by using Windows Autopilot Upgrading devices to Windows 10 Managing Updates for Windows 10 Implementing Windows 10 by using dynamic deployment Implementing Windows 10 by using Windows Autopilot Upgrading devices to Windows 10 Device Enrollment Device management options Manage Intune device enrollment and inventory Configuring Profiles Configuring device profiles Managing user profiles Monitoring devices Application Management Implement Mobile Application Management (MAM) Deploying and updating applications Administering applications Managing Authentication in Azure Ad MANAGING AUTHENTICATION IN AZURE AD Managing Devices and Device Policies Microsoft Intune Overview Managing devices with Intune Implement device compliance policies Managing Security Implement device data protection Managing Windows Defender ATP Managing Windows Defender in Windows 10 Additional course details: Nexus Humans Windows 10 Modern Desktop Administrator Associate Bootcamp 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 Windows 10 Modern Desktop Administrator Associate Bootcamp 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.

Windows 10 Modern Desktop Administrator Associate Bootcamp
Delivered OnlineFlexible Dates
Price on Enquiry

Microsoft Azure and 365 Bundle with 5 Exams (3 Certifications)

By Hudson

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned

Microsoft Azure and 365 Bundle with 5 Exams (3 Certifications)
Delivered Online On Demand
£1,395

Google Cloud Engineer Associate Certification Bootcamp

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Cloud Solutions Architects  DevOps Engineers  Individuals using Google Cloud Platform who deploy applications, monitor operations, and manage enterprise solutions Overview At course completion, you will have attained knowledge of: Fundamentals of Google Cloud Platform (GCP) Google Cloud Storage Google Compute Engine Google Cloud SQL Load Balancing (LB) Google Cloud Monitoring Auto-Scaling Virtual Private Cloud (VPC) Network Cloud Identity and Access Management (IAM) Cloud CDN and DNS Cloud VPN Google Cloud Deployment Manager Google Container Engine Cloud Run Cloud Bigtable Cloud Datastore Cloud BigQuery Cloud DataFlow Cloud DataProc Cloud Pub/Sub In this course you will attain a deep knowledge of Google Cloud Platform infrastructure and design patterns on developing applications on GCP. This course will prepare you for the Google Cloud Architect Associate Certification Exam. Fundamentals of Google Cloud Platform (GCP) Overview Regions and Zones Review of major GCP services Google Cloud Storage Fundamental APIs Consistency Cloud Storage Namespace Buckets and Objects Bucket and Object Naming Guidelines Encryption Object Versioning Object Lifecycle Management Access Control Access Control Lists Signed URL Multipart upload Resumable upload Understanding Pricing for Cloud Storage Offline Media Import/Export Architecture case study of common Use Cases of Google Cloud Storage Hands-on: Cloud Storage Lab; Creating Buckets, objects, and managing access control Google Compute Engine Compute Engine Architecture VM Instances types Persistence Disks Images Generating Custom Images IP Addresses Static IPs Ephemeral Access Control Options IAM Service Account Monitoring Instances with Google Cloud Monitoring Compute Engine Networks and Firewalls Hands-on: Hosting an Application on Compute Engine Google Cloud SQL Core advantages of Cloud SQL Cloud SQL database instance types Access Control High availability options Failover Read replica Backup options On Demand Automated Understanding Pricing of Cloud SQL Load Balancing (LB) Fundamentals of a Load Balancer Network Load balancing HTTPS Load balancing Cross region Load balancing Content Load balancing Target proxies SSL Load Balancing Internal Load Balancing Network Load Balancing Understanding Pricing for Load Balancer Google Cloud Monitoring Architecture of Cloud Monitoring Supported metrics Stackdriver Monitoring APIs Auto-Scaling Overview of Autoscaling Auto-scaling Fundamentals Instance groups Templates Policies Decisions Hands-on: Deploying a scale application on GCP using Autoscaling, Compute Engine, Cloud SQL, Load Balancers. Virtual Private Cloud (VPC) Network Salient features of Virtual Private Cloud (VPC) Network Infrastructure Virtual Private Cloud (VPC) Networking Fundamentals Subnetworks Firewall Internal DNS Network Routes Hands-on: Hosting Secure Applications in Google Cloud VPC Networks Cloud Identity and Access Management (IAM) Introduction User and Service Accounts IAM Roles Policy Hands-on: Managing Users, Policies and Granting Roles using Service Accounts Cloud CDN and DNS What is CDN Google Cloud CDN Cloud CDN Concepts Some of the Cloud CDN Edge locations Cloud DNS Cloud DNS Terminologies Supported Record Types Hands-on: Moving an Existing Domain Name to Cloud DNS Cloud VPN Cloud VPN overview Types of Cloud VPN Specifications Maintenance and Availability Google Cloud Deployment Manager Deployment Manager Deployment Manager Fundamentals Runtime Configurator Quotas Hands-on: Generating and Creating Cloud Deployment Manager Template Google Container Engine Google Container Engine Overview Docker Overview Kubernetes Terminologies Replication Controller Deployment Price and Quotas Hands-on: Deploying WordPress Cluster using Container Engine Cloud Run Overview of Cloud Run Deploy a Prebuilt Sample container Cloud Bigtable Overview of Cloud Bigtable Access Control Performance Locations Cloud Datastore Overview of Cloud Datastore Limits Storage Size Multitenancy Benefits of Multitenancy Encryption Locations Cloud BigQuery BigQuery Overview Interacting with BigQuery Datasets, Tables, and Views Partitioned Tables Query Plan Explanation Hands-on: Getting Started with BigQuery Cloud DataFlow Overview Programming Model DataFlow SDK 1.x for java Cloud Dataflow SDK 2.x Security and Permissions Advanced Access Control Cloud DataProc Overview Clusters Versioning Cloud Pub/Sub Overview of Cloud Pub/Sub Pub/Sub Concepts and Message Flow Data Model Cleanup of All Services Hands-on: Cloud Pub/Sub Lab with Background Cloud Function Additional course details: Nexus Humans Google Cloud Engineer Associate Certification Bootcamp 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 Google Cloud Engineer Associate Certification Bootcamp 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.

Google Cloud Engineer Associate Certification Bootcamp
Delivered OnlineFlexible Dates
Price on Enquiry

CT08: Clinical Trial Monitoring: Study Monitoring, Documentation and Closure

By Zenosis

The sponsor of a clinical trial must arrange for it to be monitored throughout its duration to ensure that the rights and wellbeing of subjects are protected, the trial data are accurate, complete and verified from source documents, and the conduct of the trial complies with the study protocol, Good Clinical Practice and regulatory requirements. In this module we describe how a Clinical Research Associate (CRA) monitors an ongoing trial to its conclusion.

CT08: Clinical Trial Monitoring: Study Monitoring, Documentation and Closure
Delivered Online On Demand2 hours
£98

Level 5 Associate Diploma in People Management

5.0(3)

By School Of Health Care

CIPD Level 5 Associate Diploma in People Management: People Management Are you willing to experience theoretical knowledge along with real-world application? Then our level 5 associate diploma in Level 5 Associate Diploma in People Management course is perfect for you. In our Level 5 Associate Diploma in People Management course, students will learn about organisational performance, work culture, professional conduct, and respecting others. Also, our Level 5 Associate Diploma in People Management course explains how to build customer relationships, talent management, and workforce planning. You will be recognised for your performance and contributions throughout our Level 5 Associate Diploma in People Management course. In general, the development of management and leadership skills is aided by this Level 5 Associate Diploma in People Management course. Special Offers of this CIPD Level 5 Associate Diploma in People Management Course: This Level 5 Associate Diploma in People Management Course includes a FREE PDF Certificate. Lifetime access to this Level 5 Associate Diploma in People Management Course Instant access to this Level 5 Associate Diploma in People Management Course 24/7 Support Available to this Level 5 Associate Diploma in People Management Course CIPD Level 5 Associate Diploma in People Management: People Management Our Level 5 Associate Diploma in People Management course is designed to empower you with the skills needed to excel in Level 5 Associate Diploma in People Management. In this Level 5 Associate Diploma in People Management course, you'll gain insights into organizational performance, work culture, and professional conduct. Additionally, our Level 5 Associate Diploma in People Management program covers customer relationship building, talent management, and workforce planning. Your achievements in Level 5 Associate Diploma in People Management will be recognized as you progress. This comprehensive Level 5 Associate Diploma in People Management course also focuses on developing strong management and leadership abilities, setting you up for success in any organization. Who is this course for? CIPD Level 5 Associate Diploma in People Management: People Management In order to improve their strategic HR abilities, mid-level HR professionals should pursue this level 5 associate diploma in people management course. Special Note: Our Level 5 Associate Diploma in People Management: People Management Course is Knowledge-based not a regulated course. To get Qualified, you may choose the following options: CIPD CIPD-Intermediate CIPD-Advanced CIPD-hr-practice CIPD Level 3 Foundation Certificate in People Practice CIPD Level 5 Associate Diploma in People Management CIPD Level 5 Associate Diploma in Organisational Learning and Development CIPD Level 7 Advanced Diploma in Strategic Learning and Development Level-3-CIPD Requirements CIPD Level 5 Associate Diploma in People Management: People Management To enrol in this Level 5 Associate Diploma in People Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 5 Associate Diploma in People Management Course. Be energetic and self-motivated to complete our Level 5 Associate Diploma in People Management People Management Course. Basic computer Skill is required to complete our People Management: People Management Course. If you want to enrol in our People Management: People Management Course, you must be at least 15 years old. Career path CIPD Level 5 Associate Diploma in People Management: People Management You can begin a career as an HR manager, HR business partner, head of HR, or HR director after finishing this level 5 associate diploma in people management course.

Level 5 Associate Diploma in People Management
Delivered Online On Demand2 hours
£12

Tableau Desktop - Part 2

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 Lesson 1: Blending Data from Multiple Sources Topic A: Blend Data Topic B: Refine Blends to Visualize Key Information Lesson 2: Joining Data Topic A: Create Joins Topic B: Troubleshoot Joins Topic C: Merge Data with Unions Lesson 3: Accessing Data in PDFs Topic A: Connect to PDFs Topic B: Clean Up and Organize PDF Data Lesson 4: Refining Visualizations with Sets and Parameters Topic A: Create Sets Topic B: Analyze Data with Sets Topic C: Apply Parameters to Refine Visualizations Topic D: Create Advanced Visualizations Lesson 5: Analyzing Data with Calculations Topic A: Create Calculated Fields to Analyze Data Topic B: Manipulate Data with Functions Topic C: Analyze Data with Table Calculations Lesson 6: Visualizing Data with Advanced Calculations Topic A: Create Groups and Bins with Calculations Topic B: Analyze Data with LOD Expressions Lesson 7: Performing Statistical Analysis and Forecasting Topic A: Perform Statistical Analysis Topic B: Forecast Data Trends Lesson 8: Creating Geographic Visualizations Topic A: Create Maps Topic B: Customize Mapped Data Lesson 9: Getting Answers with Ask and Explain Topic A: Ask Data Topic B: Explain Data Additional course details: Nexus Humans Tableau Desktop - Part 2 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 Tableau Desktop - Part 2 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.

Tableau Desktop - Part 2
Delivered OnlineFlexible Dates
£1,400

Level 5 Associate Diploma in People Management

By Wise Campus

Level 5 Associate Diploma in People Management: Level 5 Associate Diploma in People Management Would you like to bring a big change to your company's performance with your Level 5 Associate Diploma in People Management skills? We have a Level 5 Associate Diploma in People Management course to boost your expertise. This level 5 associate diploma in Level 5 Associate Diploma in People Management course covers organisational performance, culture in action, professional attitudes, and appreciating people. Additionally, this level 5 associate diploma in Level 5 Associate Diploma in People Management course teaches students how to perform evidence-based medicine. Furthermore, how to maintain work relationships, workforce planning, and talent management techniques are covered throughout this level 5 associate diploma in Level 5 Associate Diploma in People Management course. Moreover, this level 5 associate diploma in Level 5 Associate Diploma in People Management course will help you recognise your performance, contributions, and the growth of leadership and management. Learning outcomes of Level 5 Associate Diploma in People Management course This Level 5 Associate Diploma in People Management course will explain: Performance of organisations and culture in action. This Level 5 Associate Diploma in People Management course teaches how to practice based on evidence. Professional behaviours and valuing people are also thoughts in our Level 5 Associate Diploma in People Management course. Moreover, this Level 5 Associate Diploma in People Management course explains the management of employment relationships. How to do workforce planning and talent management is described in our Level 5 Associate Diploma in People Management course. Throughout our Level 5 Associate Diploma in People Management course, you will receive acknowledgement of contribution and performance. Overall, this Level 5 Associate Diploma in People Management course is helpful to the development of leadership and management. Special Offers Of this Level 5 Associate Diploma in People Management course This Level 5 Associate Diploma in People Management course includes a FREE PDF Certificate. Lifetime access to this Level 5 Associate Diploma in People Management course Instant access to this Level 5 Associate Diploma in People Management course Get FREE Tutor Support from Monday to Friday in this Level 5 Associate Diploma in People Management course. [ Note: Free Digital certificate as soon as completing the Level 5 Associate Diploma in People Management course] Level 5 Associate Diploma in People Management Our Level 5 Associate Diploma in People Management course offers a deep dive into organizational performance and culture in action. This Level 5 Associate Diploma in People Management course also emphasizes professional attitudes and the value of appreciating people in the workplace. Additionally, our Level 5 Associate Diploma in People Management program equips students with the skills to apply evidence-based practices effectively. By enrolling in this Level 5 Associate Diploma in People Management course, you'll gain the knowledge and tools needed to drive success in any organization. Enhance your expertise in Level 5 Associate Diploma in People Management and take your career to the next level. Who is this course for? Level 5 Associate Diploma in People Management If you're looking to advance in an exciting and encouraging atmosphere in your HR profession, this level 5 associate diploma in Level 5 Associate Diploma in People Management course is for you. Special Note: Our Level 5 Associate Diploma in People Management Course is Knowledge-based not a regulated course. To get Qualified, you may choose the following options: CIPD CIPD-Intermediate CIPD-Advanced CIPD-hr-practice CIPD Level 3 Foundation Certificate in People Practice CIPD Level 5 Associate Diploma in People Management CIPD Level 5 Associate Diploma in Organisational Learning and Development CIPD Level 7 Advanced Diploma in Strategic Learning and Development Level-3-CIPD Requirements Level 5 Associate Diploma in People Management To enrol in this Level 5 Associate Diploma in People Management Course Course, students must fulfil the following requirements. To join in our Level 5 Associate Diploma in People Management Course, you must have a strong command of the English language. To successfully complete our Level 5 Associate Diploma in People Management Course, you must be vivacious and self driven. To complete our Level 5 Associate Diploma in People Management Course, you must have a basic understanding of computers. Career path Level 5 Associate Diploma in People Management Taking this Level 5 Associate Diploma in People Management course will help you land a position as an: HR manager HR director HR business partner Head of HR

Level 5 Associate Diploma in People Management
Delivered Online On Demand2 hours
£12

World of Computer Networking: Your CCNA start

By Packt

This course will help you to prepare for the Cisco Certified Network Associate (CCNA) certification exam. The course covers all the major topics of computer networking and network devices, such as Internet Protocol (IP) addressing, routing, switching, Transmission Control Protocol/Internet Protocol (TCP/IP), Network Address Translation (NAT), Dynamic Host Configuration Protocol (DHCP), and Domain Name System (DNS).

World of Computer Networking: Your CCNA start
Delivered Online On Demand14 hours 38 minutes
£9.99

Designing Effective Teams

By OnlineCoursesLearning.com

Planning Effective Teams Figuring out how to plan compelling groups is significant for anyone hoping to take advantage of their group elements, regardless of whether you're a current or yearning boss, chief or group pioneer. This course gives a far reaching manual for planning powerful groups by setting up unique initiative and picking the correct individuals. From how to associate with and move your group, to setting rules and guaranteeing a good outcome, this course covers all you require to think about each part of planning the best group conceivable. You Will Learn Step by step instructions to guarantee the best authority and constructions The study of picking the correct colleagues for the main jobs Instructions to move, inspire and genuinely associate with your group Defining limits, objectives and rules to guarantee most extreme group achievement Advantages of Taking This Course You will guarantee the accomplishment of your group You will drastically improve the connections inside the group You will accomplish the objectives of the group as a strong unit You will improve your odds of being picked as a group chief

Designing Effective Teams
Delivered Online On Demand
£50

Database fundamentals

5.0(3)

By Systems & Network Training

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.

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