Name: Oracle WebLogic 12c for Administrators
Price: 113.99 GBP
Availability: InStock

<p><strong> 11 in 1 "IT Security &amp; Cyber Security" Bundle only at £53 </strong></p> <p><strong>Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>Give a compliment to your career and take it to the next level. This<strong> IT Security &amp; Cyber Security </strong>bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this IT Security &amp; Cyber Security bundle will help you stay ahead of the pack.</p> <p>Throughout the IT Security &amp; Cyber Security programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector.</p> <p>Along with this IT Security &amp; Cyber Security course, you will get <strong>10 premium courses, an original</strong><strong>hardcopy</strong>, <strong>11 PDF certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p><strong>This IT Security &amp; Cyber Security Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong> Course 01:</strong> Computer Networks Security</li><li><strong> Course 02:</strong> Cyber Security Incident Handling and Incident Response</li><li><strong> Course 03:</strong> CyberSecurity Law Online Course</li><li><strong> Course 04:</strong> Crash Course on Ecommerce Security</li><li><strong> Course 05:</strong> Linux Security and Hardening</li><li><strong> Course 06:</strong> Secure Programming of Web Applications</li><li><strong> Course 07:</strong> Complete Web Application Penetration Testing &amp; Security</li><li><strong> Course 08:</strong> Data Protection and Data Security Level 2</li><li><strong> Course 09:</strong> Information Management</li><li><strong> Course 10:</strong> Security Management Advanced Diploma</li><li><strong> Course 11:</strong> Internet of Things Hacking</li></ul> <p>Enrol now in IT Security &amp; Cyber Security to advance your career, and use the premium study materials from Apex Learning.</p> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your IT Security &amp; Cyber Security expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p> <p><strong>Curriculum of Bundle</strong></p> <p><strong> Course 01: Computer Networks Security</strong></p> <ul> <li>Introduction</li><li>Section 01: An Introduction to Computer Networks</li><li>Section 02: ISO/OSI Model</li><li>Section 03: TCP/IP Protocols</li><li>Section 04: Wireless Networks</li><li>Section 05: Network Security</li><li>Section 06: Firewalls and Honeypots</li><li>Section 07: Intrusion Detection and Prevention System</li><li>Section 08: Wireless Network Security</li><li>Section 09: Physical Security and Incident Handling</li><li>Section 10: Network Security: Conclusion</li></ul> <p><strong> Course 02: Cyber Security Incident Handling and Incident Response</strong></p> <ul> <li>Cyber Security Incident Handling and Incident Response</li><li>Section 01: An Introduction to Incident Handling</li><li>Section 02: Preparation for an Incident</li><li>Section 03: Identification</li><li>Section 04: Containment</li><li>Section 05: Eradication</li><li>Section 06: Recovery Phase</li><li>Section 07: Final Thoughts</li></ul> <p><strong> Course 03: CyberSecurity Law Online Course</strong></p> <ul> <li>Module 01: Introduction to Cyber Law</li><li>Module 02: Cyber Law, Cyber Ethics and Online Gambling</li><li>Module 03: Cyber Crime, Cyber Security and Trust in Cyberspace</li><li>Module 04: Threat Factors: Computer as a Target</li><li>Module 05: Threats to Cyber Security by Criminals and Organised Crimes</li><li>Module 06: Threats to Cybersecurity by Hacktivists and Nation-States</li><li>Module 07: Cyberterrorism</li><li>Module 08: An Evolving Threat: The Deep Web</li><li>Module 9: Fraud</li><li>Module 10: Jurisdiction</li></ul> <p><strong> Course 04: Crash Course on Ecommerce Security</strong></p> <ul> <li>Unit 01: Introduction and Types of Ecommerce</li><li>Unit 02: Ecommerce SEO</li><li>Unit 03: Ecommerce Demo</li><li>Unit 04: Ecommerce Website Vulnerability and Security Risk Scanning</li><li>Unit 05: Basic Terms of Ecommerce</li><li>Unit 06: Ecommerce Fraud</li><li>Unit 07: Ecommerce Fraud Prevention</li></ul> <p><strong> Course 05: Linux Security and Hardening</strong></p> <ul> <li>Unit 01: Course Overview and Downloads</li><li>Unit 02: General Security</li><li>Unit 03: Physical Security</li><li>Unit 04: Account Security</li><li>Unit 05: Network Security</li><li>Unit 06: File System Security</li><li>Unit 07: Additional Resources</li></ul> <p><strong> Course 06: Secure Programming of Web Applications</strong></p> <ul> <li>Section 01: Introduction</li><li>Section 02: Well-known Vulnerabilities and Secure Programming</li><li>Section 03: Conclusion and Summary</li></ul> <p><strong> Course 07: Complete Web Application Penetration Testing &amp; Security</strong></p> <ul> <li>Unit 01: Introduction</li><li>Unit 02: BE PREPARED</li><li>Unit 03: WEB APPLICATION TECHNOLOGIES</li><li>Unit 04: INFORMATION GATHERING - MAPPING THE APPLICATIONS</li><li>Unit 05: CROSS-SITE SCRIPTING ATTACKS - XSS</li><li>Unit 06: SQL INJECTION ATTACKS - EXPLOITATIONS</li><li>Unit 07: CROSS SITE REQUEST FORGERY - XSRF</li><li>Unit 08: AUTHENTICATION &amp; AUTHORIZATION ATTACKS</li><li>Unit 09: CLIENT SIDE SECURITY TESTING</li><li>Unit 10: FILE RELATED VULNERABILITIES</li><li>Unit 11: XML EXTERNAL ENTITY ATTACKS - XXE</li></ul> <p><strong> Course 08: Data Protection and Data Security Level 2</strong></p> <ul> <li>GDPR Basics</li><li>GDPR Explained</li><li>Lawful Basis for Preparation</li><li>Rights and Breaches</li><li>Responsibilities and Obligations</li></ul> <p><strong> Course 09: Information Management</strong></p> <ul> <li>Module 01: Introduction to Information Management</li><li>Module 02: Information Management Strategy</li><li>Module 03: Databases and Information Management</li><li>Module 04: Management Information Systems (MIS)</li><li>Module 05: Auditing Information Systems</li><li>Module 06: Ethical and Social Issues and Data Protection</li></ul> <p><strong> Course 10: Security Management Advanced Diploma</strong></p> <ul> <li>Module 01: Introduction to Security Management</li><li>Module 02: Organisational Security Management</li><li>Module 03: Security Risk Analysis and Risk Reduction</li><li>Module 04: Physical and Information Security Protection</li><li>Module 05: Business Resilience and Crisis Management</li><li>Module 06: Cyber Security and Fraud Prevention</li><li>Module 07: Security Investigations and Threat Awareness</li><li>Module 08: Laws and Regulations</li></ul> <p><strong> Course 11: Internet of Things Hacking</strong></p> <ul> <li>Module 01: IoT Part 1</li><li>Module 02: IoT Part 2</li><li>Module 03: IoT Hacking Tools and Technique</li><li>Module 04: IoT Hacking Tools and Technique Part 2</li><li>Module 05: IoT Scenario Part 1</li><li>Module 06: IoT Scenario Part 2</li><li>Module 07: Smart Devices</li><li>Module 08: AWS Basics</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        115 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this IT Security &amp; Cyber Security bundle.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our IT Security &amp; Cyber Security is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this IT Security &amp; Cyber Security expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>IT: IT Security &amp; Cyber Security</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p> <p>Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Apex Learning

IT Security & Cyber Security

General Admission

<p><strong>Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>Give a compliment to your career and take it to the next level. This <strong>Tech Coding </strong>will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this <strong>Tech Coding </strong>will help you keep ahead of the pack.</p> <p>The <strong>Tech Coding</strong> incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this <strong>Tech Coding</strong> will add extra value to your resume to stand out to potential employers.</p> <p>Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the <strong>Tech Coding,</strong> you can equip yourself with the essentials to keep you afloat in the competition.</p> <p>Along with this Tech Coding course, you will get <strong>10 premium courses, an original </strong><strong>Hardcopy</strong>, <strong>11 PDF Certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p><strong>This Tech Coding Bundle Consists of the following Premium courses: </strong> </p> <ul> <li><strong>Course 01: </strong>Computer Science With Python<strong><br /></strong></li><li><strong>Course 02: </strong>Coding with HTML, CSS, &amp; Javascript</li><li><strong>Course 03: </strong>Python Programming for Everybody</li><li><strong>Course 04: </strong>Ultimate PHP &amp; MySQL Web Development Course &amp; OOP Coding<strong><br /></strong></li><li><strong>Course 05: </strong>HTML and CSS Coding: Beginner to Advanced</li><li><strong>Course 06: </strong>Complete Web Application Penetration Testing &amp; Security</li><li><strong>Course 07: </strong>Diploma in PHP Web Development</li><li><strong>Course 08: </strong>Basic C# Coding</li><li><strong>Course 09: </strong>Intermediate Python Coding</li><li><strong>Course 10: </strong>CSS Coding</li><li><strong>Course 11: </strong>Master JavaScript with Data Visualization<strong><br /></strong></li></ul> <p>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 designed the <strong>Tech Coding</strong> to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere.</p> <p>So, enrol now to advance your career!</p> <p><strong>Benefits you'll get choosing Apex Learning for this Tech Coding:</strong></p> <ul> <li>Pay once and get lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><p><strong>Tech Coding Bundle</strong></p> <p>This Tech Coding's curriculum has been designed by Tech Coding experts with years of Tech Coding experience behind them. The Tech Coding course is extremely dynamic and well-paced to help you understand Tech Coding with ease. You'll discover how to master the Tech Coding skill while exploring relevant and essential topics like:</p> <ul> <li>Diploma in Computer Programming</li><li>Coding with HTML, CSS, &amp; Javascript</li><li>Python Programming for Everybody</li><li>Create Your First Responsive Website</li><li>Ethical Hacking</li><li>Complete Web Application Penetration Testing &amp; Security</li><li>Diploma in PHP Web Development</li><li>Front End Web Development Diploma</li><li>SQL Server for Beginners</li><li>Level 3 Cyber Security</li><li>Game Design and Development Diploma</li></ul> <p><strong>Curriculum of Tech Coding Bundle</strong></p> <p><strong>***Computer Science With Python***</strong></p> <ul> <li>Module 01: Introduction</li><li>Module 02: Getting Started</li><li>Module 03: Procedures and Loops</li><li>Module 04: How to Manage Data</li></ul> <p><strong>***Coding with HTML, CSS, &amp; Javascript***</strong></p> <ul> <li>Welcome</li><li>HTML 5</li><li>CSS 3</li><li>Bootstrap</li><li>Project 1 - Design a Landing Page</li><li>Project 2 - Business Website</li><li>Project 3 - Portfolio</li></ul> <p><strong>***Python Programming for Everybody***</strong></p> <p><strong>Module 01</strong></p> <ul> <li>A Installing Python</li><li>Documentation</li><li>Command Line</li><li>Variables</li><li>Simple Python Syntax</li><li>Keywords</li><li>Import Module</li></ul> <p><strong>Module 02</strong></p> <ul> <li>Additional Topics</li><li>If Elif Else</li><li>Iterable</li><li>For</li><li>Loops</li><li>Execute</li><li>Exceptions</li></ul> <p><strong>Module 03</strong></p> <ul> <li>Data Types</li><li>Number Types</li><li>More Number Types</li><li>Strings</li><li>More Strings</li><li>Files</li><li>Lists</li><li>Dictionaries</li><li>Tuples</li><li>Sets</li></ul> <p><strong>Module 04</strong></p> <ul> <li>Comprehensions</li><li>Definitions</li><li>Functions</li><li>Default Arguments</li><li>Doc Strings</li><li>Variadic Functions</li><li>Factorial</li></ul> <p><strong>Module 05</strong></p> <ul> <li>Function Objects</li><li>Lambda</li><li>Generators</li><li>Closures</li><li>Classes</li><li>Object Initialization</li><li>Class Static Members</li><li>Classic Inheritance</li><li>Data Hiding</li></ul> <p><strong>Create Your First Responsive Website</strong></p> <ul> <li>Introduction</li><li>Project Files</li><li>Project Setup</li><li>Website Structure Part-1</li><li>Website Structure Part-2</li><li>Chrome Dev Tools</li><li>Top Menu</li><li>Image Area</li><li>Service</li><li>Responsive Page</li><li>Conclusion</li></ul> <p><strong>Level 3 Cyber Security</strong></p> <ul> <li>FUNDAMENTALS OF NETWORKING</li><li>GETTING STARTED WITH CYBER SECURITY</li><li>LET'S BEGIN - THE FUNDAMENTALS OF CYBER SECURITY</li><li>DIVING DEEP INTO CYBER SECURITY</li><li>TYPES OF ACTORS, ATTACKS, MALWARE AND RESOURCES</li><li>FIREWALLS AND ANTIVIRUS</li><li>KEY SECURITY CONCEPTS</li></ul> <p><strong>HTML5 Game Development</strong></p> <ul> <li>Unit 01: Introduction</li><li>Unit 02: Getting started with the HTML5 Canvas</li><li>Unit 03: Animating your sprites</li><li>Unit 04: Let's make a noise</li><li>Unit 05: Creating a collapse game</li><li>Unit 06: Physics is fun</li><li>Unit 07: Using Spritoon</li><li>Unit 08: OK - we know enough, let's make a real game</li><li>Unit 09: Platformers</li><li>Unit 10: Games where the computer is the opponent</li><li>Unit 11: Card games</li><li>Unit 12: Save and Load</li><li>Unit 13: Particle effects</li><li>Unit 14: Multi-player games</li><li>Unit 15: Professional tools</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        130 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Our Tech Coding course is a great place to start if you're looking to start a new career in Tech Coding and acquire relevant competencies.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our Tech Coding course is your path that might lead to a rewarding career.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this various expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Computer Science With Python</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p> <p>Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Tech Coding Diploma - CPD Certified

<div>
	<h3><strong>Description:</strong></h3>
<p><span>To learn on how to use lists, libraries, view, account information, etc. within the software SharePoint Foundation, this SharePoint Foundation Basics - Video Training Course is perfect for you. You will also gain knowledge on using communication services via discussion boards, surveys, and blog posts. </span></p>
<p><span>SharePoint Foundation can be used to organize, manage, and share information. It stores all the data in an SQL server and it can be accessed by multiple users. You can also create and edit lists which will include information about several events, links, tasks, contacts, etc. Libraries can also be created which will include document, picture, Wikipedia pages, and asset and form libraries. Team communication and account information and notifications can also be managed using the same platform. These techniques are all taught lucidly which will cover all the basic training for this program.  </span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>SharePoint Foundation Basics - Video Training Course </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> SharePoint Foundation Basics - Video Training Course</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Getting started</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SharePoint Foundation Sites</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Lists</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Announcements</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Events</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Link Lists</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Task Lists</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Contacts</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Deleting List Items</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Libraries</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Document Libraries</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Picture Libraries</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wiki Pages</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Asset Libraries</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Form Libraries</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Team Communication</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Discussion Boards</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Surveys</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Blog Pages</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Views</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Page Views</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Personal Views</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Account Information and Notifications</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Personal and Regional Settings</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Alerts</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RSS Feeds</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- SharePoint Foundation Basics - Video Training Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- SharePoint Foundation Basics - Video Training Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Microsoft Certification

Online Course Creation

Microsoft Sharepoint

Microsoft AZ-104

SharePoint

Microsoft AZ-303

SharePoint Foundation Basics - Video Training Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>MS Access Tables and Queries for Beginner </strong>will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This MS Access Tables and Queries for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this MS Access Tables and Queries for Beginner. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our MS Access Tables and Queries for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>2 sections • 20 lectures • 03:32:00 total length</p></div><div><div><div><div><div><div><div><p>•Module 01: Tour of the screen: 00:11:00</p></div><div><div><p>•Module 02: Using Design view to create and edit tables: 00:45:00</p></div><div><div><p>•Module 03: Using the lookup wizard: 00:09:00</p></div><div><div><p>•Module 04: Importing data from Other Data Sources into Access: 00:18:00</p></div><div><div><p>•Module 05: Linking Tables from Other Data Sources into Access: 00:10:00</p></div><div><div><p>•Module 06: Exporting data from Access to other data types: 00:03:00</p></div><div><div><p>•Module 07: Creating and Managing Table Relationships: 00:10:00</p></div><div><div><p>•Module 08: Database Tools: 00:05:00</p></div><div><div><p>•Module 09: Sort and Filter a Table: 00:06:00</p></div><div><div><p>•Module 10: Basic Queries: 00:22:00</p></div><div><div><p>•Module 11: Prompting the user for the criteria: 00:05:00</p></div><div><div><p>•Module 12: Creating Calculated Fields in a Query: 00:10:00</p></div><div><div><p>•Module 13: Creating Totals Queries: 00:08:00</p></div><div><div><p>•Module 14: Multiple table Queries: 00:12:00</p></div><div><div><p>•Module 15: Viewing the SQL code for an Access Query: 00:06:00</p></div><div><div><p>•Module 16: Using the Query Wizards: 00:09:00</p></div><div><div><p>•Module 17: Creating Subqueries: 00:03:00</p></div><div><div><p>•Module 18: Creating Make Table, Append, Update and Delete Queries: 00:19:00</p></div><div><div><p>•Module 19: Displaying a certain number of records: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - MS Access Tables and Queries for Beginner: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Computer Skills

Microsoft Access

Trainers Course

MS Access Tables and Queries for Beginner

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Microsoft Access Tables and Queries </strong></span><span>will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Access Tables and Queries</strong></span><b> </b><span>comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.   </span></p><p><span>So enrol in this course today to fast-track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Access Tables and Queries</strong></span><span>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Microsoft Access Tables and Queries</strong></span><span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li><span>Open doors of opportunities</span></li><li><span>Increase your adaptability</span></li><li><span>Keep you relevant</span></li><li><span>Boost confidence</span></li></ul><p><span>And much more!</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>2 sections • 20 lectures • 03:32:00 total length</p></div><div><div><div><div><div><div><div><p>•Tour of the screen: 00:11:00</p></div><div><div><p>•Using Design view to create and edit tables: 00:45:00</p></div><div><div><p>•Using the lookup wizard: 00:09:00</p></div><div><div><p>•Importing data from Other Data Sources into Access: 00:18:00</p></div><div><div><p>•Linking Tables from Other data Sources into Access: 00:10:00</p></div><div><div><p>•Exporting data from Access to other data types: 00:03:00</p></div><div><div><p>•Creating and Managing Table Relationships: 00:10:00</p></div><div><div><p>•Database Tools: 00:05:00</p></div><div><div><p>•Sort and Filter a Table: 00:06:00</p></div><div><div><p>•Basic Queries: 00:22:00</p></div><div><div><p>•Prompting the user for the criteria: 00:05:00</p></div><div><div><p>•Creating Calculated Fields in a Query: 00:10:00</p></div><div><div><p>•Creating Totals Queries: 00:08:00</p></div><div><div><p>•Multiple table Queries: 00:12:00</p></div><div><div><p>•Viewing the SQL code for an Access Query: 00:06:00</p></div><div><div><p>•Using the Query Wizards: 00:09:00</p></div><div><div><p>•Creating Subqueries: 00:03:00</p></div><div><div><p>•Creating Make Table, Append, Update and Delete Queries: 00:19:00</p></div><div><div><p>•Displaying a certain number of records: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Microsoft Access Tables and Queries: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Certified Trainer (MCT)

Microsoft Access Tables and Queries

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Individuals planning to deploy applications and create application environments on Google Cloud.<br />Developers, systems operations professionals, and solution architects getting started with Google Cloud.<br />Executives and business decision makers evaluating the potential of Google Cloud to address their business needs.</p>Overview<p>Identify the purpose and value of Google Cloud products and services. Interact with Google Cloud services.<br />Describe ways in which customers have used Google Cloud.<br />Choose among and use application deployment environments on Google Cloud: App Engine, Google Kubernetes Engine, and Compute Engine.<br />Choose among and use Google Cloud storage options: Cloud Storage, Cloud SQL, Cloud Bigtable, and Firestore.<br />Make basic use of BigQuery, Google's managed data warehouse for analytics.</p><p>This course uses lectures, demos, and hands-on labs to give you an overview of Google Cloud products and services so that you can learn the value of Google Cloud and how to incorporate cloud-based solutions into your business strategies.</p></div><div id="course-pills-2"><h4>Introducing Google Cloud Platform</h4><ul><li>Explain the advantages of Google Cloud Platform.</li><li>Define the components of Google's network infrastructure, including: Points of presence, data centers, regions, and zones.</li><li>Understand the difference between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS).</li></ul><h4>Getting Started with Google Cloud Platform</h4><ul><li>Identify the purpose of projects on Google Cloud Platform.</li><li>Understand the purpose of and use cases for Identity and Access Management.</li><li>List the methods of interacting with Google Cloud Platform.</li><li>Lab: Getting Started with Google Cloud Platform.</li></ul><h4>Google Compute Engine and Networking</h4><ul><li>Identify the purpose of and use cases for Google Compute Engine.</li><li>Understand the basics of networking in Google Cloud Platform.</li><li>Lab: Deploying Applications Using Google Compute Engine.</li></ul><h4>Google Cloud Platform Storage Options</h4><ul><li>Understand the purpose of and use cases for: Google Cloud Storage, Google Cloud SQL, and Google Cloud Bigtable.</li><li>Learn how to choose between the various storage options on Google Cloud Platform.</li><li>Lab: Integrating Applications with Google Cloud Storage.</li></ul><h4>Google Container Engine</h4><ul><li>Define the concept of a container and identify uses for containers.</li><li>Identify the purpose of and use cases for Google Container Engine and Kubernetes.</li><li>Introduction to Hybrid and Multi-Cloud computing (Anthos).</li><li>Lab: Deploying Applications Using Google Container Engine.</li></ul><h4>Google App Engine and Google Cloud Datastore</h4><ul><li>Understand the purpose of and use cases for Google App Engine and Google Cloud Datastore.</li><li>Contrast the App Engine Standard environment with the App Engine Flexible environment.</li><li>Understand the purpose of and use cases for Google Cloud Endpoints.</li><li>Lab: Deploying Applications Using App Engine and Cloud Datastore.</li></ul><h4>Deployment and Monitoring</h4><ul><li>Understand the purpose of template-based creation and management of resources.</li><li>Understand the purpose of integrated monitoring, alerting, and debugging.</li><li>Lab: Getting Started with Stackdriver and Deployment Manager.</li></ul><h4>Big Data and Machine Learning</h4><ul><li>Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms.</li><li>Lab: Getting Started with BigQuery.</li></ul><h4>Summary and Review</h4><ul><li>Summary and Review.</li><li>What's Next?.</li></ul></div>

Nexus Human

Cloud Computing

AWS Certified Cloud Practitioner

Google Suite

Google Cloud

Google Workspace

Google Digital Marketing

Google Cloud Fundamentals - Core Infrastructure

<div><h2> About Course</h2><div><p><strong>Building Web Applications with Django and PostgreSQL: Master the Complete Stack</strong></p><p><strong>Learn to build modern and robust web applications with one of the most popular and powerful tech stacks: Django and PostgreSQL.</strong></p><p><strong>In this comprehensive course, you will learn:</strong></p><ul><li>The fundamentals of Django, including setting up a development environment, creating models, views, and templates, and handling user authentication and authorization.</li><li>How to work with Django's built-in admin interface and form files.</li><li>Advanced topics, such as working with Django's ORM (Object-Relational Mapping) to interact with the PostgreSQL database, handling form submissions, and integrating third-party libraries.</li><li>Best practices for structuring Django projects, handling user sessions, and securing your web applications against common web vulnerabilities.</li></ul><p><strong>You will also gain hands-on experience in using PostgreSQL as your database backend, including:</strong></p><ul><li>Designing database schemas</li><li>Performing CRUD (Create, Read, Update, Delete) operations</li><li>Optimizing database performance</li></ul><p><strong>Throughout the course, you will work on practical projects that will allow you to apply the concepts you've learned and build real-world web applications.</strong></p><p><strong>By the end of this course, you will be able to:</strong></p><ul><li>Create dynamic and interactive web applications with Django and PostgreSQL.</li><li>Build secure, scalable, and maintainable web applications.</li><li>Become a skilled and proficient web developer.</li></ul><p><strong>This course is perfect for:</strong></p><ul><li>Beginners who want to learn how to build web applications from scratch.</li><li>Experienced web developers who want to learn how to use Django and PostgreSQL.</li><li>Anyone who wants to learn how to build modern and robust web applications.</li></ul><p><strong>Enroll today and start your journey to becoming a Django and PostgreSQL expert!</strong></p><p><strong>Bonus:</strong></p><ul><li>Get access to the instructor's personal collection of Django and PostgreSQL resources.</li></ul><p><strong>Why learn Django and PostgreSQL?</strong></p><p>Django and PostgreSQL are two of the most popular and powerful technologies for building web applications. Django is a popular web framework written in Python that allows developers to build robust and scalable web applications quickly and efficiently. PostgreSQL is a powerful open-source relational database management system known for its reliability and performance.</p><p>Learning Django and PostgreSQL will give you a significant advantage in the job market and allow you to build more complex and sophisticated web applications.</p><p>Here are some of the benefits of learning Django and PostgreSQL:</p><ul><li>Django is a popular web framework with a large and active community. This means that there is a wealth of resources available to help you learn Django and get help when you need it.</li><li>Django is a powerful and versatile web framework that can be used to build a wide variety of web applications, from simple websites to complex e-commerce platforms.</li><li>PostgreSQL is a powerful and reliable database management system that is known for its performance and scalability.</li><li>PostgreSQL is also an open-source database, which means that it is free to use and distribute.</li></ul><p>So what are you waiting for? Enroll in this course today and start your journey to becoming a Django and PostgreSQL expert!</p></div></div> <div><h3> What Will You Learn?</h3><ul><li> <span></span> <span>Comprehensive coverage of Django web framework and PostgreSQL database</span></li><li> <span></span> <span>Practical projects to apply concepts learned</span></li><li> <span></span> <span>Hands-on experience with PostgreSQL as a database backend</span></li><li> <span></span> <span>Best practices for structuring Django projects and securing web applications</span></li><li> <span></span> <span>In-depth understanding of Django's ORM for database interactions</span></li><li> <span></span> <span>Integration of third-party libraries and Import</span></li><li> <span></span> <span>Real-world examples and use cases</span></li></ul></div><div><h3> Course Content</h3><div><div><h4> Getting Started</h4><div><div><ul><li><div> <span></span><h5> Introduction</h5></div><div> </div></li><li><div> <span></span><h5> Getting started on Windows, MacOS, and Linux</h5></div><div> </div></li><li><div> <span></span><h5> How to Ask Great Questions</h5></div><div> </div></li><li><div> <span></span><h5> FAQs</h5></div><div> </div></li></ul></div></div></div><div><h4> Setting Up a Python Development</h4><div><div><ul><li><div> <span></span><h5> Installing Python</h5></div><div> </div></li><li><div> <span></span><h5> Installing PyCharm IDE for Development</h5></div><div> </div></li><li><div> <span></span><h5> Creating the first Python Project</h5></div><div> </div></li><li><div> <span></span><h5> Write and Run Hello World Program</h5></div><div> </div></li><li><div> <span></span><h5> Command Line Basics</h5></div><div> </div></li><li><div> <span></span><h5> Installation and Access Pip Command</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Setting Up the Project</h4><div><div><ul><li><div> <span></span><h5> Introduction to Web Framework and Django</h5></div><div> </div></li><li><div> <span></span><h5> Installing Django and Setting Up a Project</h5></div><div> </div></li><li><div> <span></span><h5> Understanding Django Architecture and Structured</h5></div><div> </div></li><li><div> <span></span><h5> Creating a Simple Django App</h5></div><div> </div></li></ul></div></div></div><div><h4> Building a Django App with PostgreSQL</h4><div><div><ul><li><div> <span></span><h5> Introduction to PostgreSQL and its Advantages for Web Applications</h5></div><div> </div></li><li><div> <span></span><h5> Installing PostgreSQL and Setting Up a Database</h5></div><div> </div></li><li><div> <span></span><h5> pgAdmin Secure Login and Create Database</h5></div><div> </div></li><li><div> <span></span><h5> Connection Django to PostgreSQL</h5></div><div> </div></li><li><div> <span></span><h5> Creating a Basic HTTP View Method Request</h5></div><div> </div></li><li><div> <span></span><h5> URL Pattern on App</h5></div><div> </div></li><li><div> <span></span><h5> Include Apps to Project URLs</h5></div><div> </div></li><li><div> <span></span><h5> Installing the Psycopg2 Module for DB Connection</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Models and ORM (Object Relational Mapping)</h4><div><div><ul><li><div> <span></span><h5> Defining Models and Creating Database Tables</h5></div><div> </div></li><li><div> <span></span><h5> Using Djangos Built-in ORM to Interact with the Database</h5></div><div> </div></li><li><div> <span></span><h5> Migration to Create DB Tables</h5></div><div> </div></li><li><div> <span></span><h5> Assessment Test</h5></div><div> </div></li><li><div> <span></span><h5> Solution for an Assessment Test</h5></div><div> </div></li></ul></div></div></div><div><h4> Working with Admin Module</h4><div><div><ul><li><div> <span></span><h5> Creating Superuser as Admin</h5></div><div> </div></li><li><div> <span></span><h5> Authentication and Authorization</h5></div><div> </div></li><li><div> <span></span><h5> User Access Permissions</h5></div><div> </div></li><li><div> <span></span><h5> Registering User Models to the Admin Dashboard</h5></div><div> </div></li><li><div> <span></span><h5> Creating Data Using CRUD Functionality</h5></div><div> </div></li><li><div> <span></span><h5> View Data on the PostgreSQL Database Table</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Views and Templates</h4><div><div><ul><li><div> <span></span><h5> Understanding the MVC - MVT</h5></div><div> </div></li><li><div> <span></span><h5> Creating Views and Handling HTTP Requests and Rendering Templates</h5></div><div> </div></li><li><div> <span></span><h5> Creating a Template with HTML Page</h5></div><div> </div></li><li><div> <span></span><h5> Building Dynamic Form and Handling</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Form Design</h4><div><div><ul><li><div> <span></span><h5> Creating Bootstrap Template</h5></div><div> </div></li><li><div> <span></span><h5> Applying Bootstrap to Django Form</h5></div><div> </div></li><li><div> <span></span><h5> Creating Stunning Product Card items</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Project: Registration form - Real world</h4><div><div><ul><li><div> <span></span><h5> Creating Model</h5></div><div> </div></li><li><div> <span></span><h5> Creating Forms</h5></div><div> </div></li><li><div> <span></span><h5> Creating Views</h5></div><div> </div></li><li><div> <span></span><h5> Applying ORM - Migrations</h5></div><div> </div></li><li><div> <span></span><h5> Creating My Form Template</h5></div><div> </div></li><li><div> <span></span><h5> Adding URLs</h5></div><div> </div></li><li><div> <span></span><h5> Creating Success_View Template</h5></div><div> </div></li><li><div> <span></span><h5> Project URLs Update and Adding Installed Apps</h5></div><div> </div></li><li><div> <span></span><h5> Run Project and Submit Data to Database</h5></div><div> </div></li></ul></div></div></div><div><h4> Django Reports</h4><div><div><ul><li><div> <span></span><h5> Creating Report_View Method</h5></div><div> </div></li><li><div> <span></span><h5> Creating Report_Template</h5></div><div> </div></li><li><div> <span></span><h5> Update URLs Pattern</h5></div><div> </div></li><li><div> <span></span><h5> Run Project and Test Reports</h5></div><div> </div></li></ul></div></div></div><div><h4> Course Resources</h4><div><div><ul><li><div> <span></span><h5> Course Resources</h5></div><div> <span> </span> <span></span></div></li></ul></div></div></div></div></div>A course by  Sekhar Metla  IT Industry Expert Material Includes  Download Resources and Reference Project Source Code  Django to PostgreSQL database connection Project Settings file RequirementsBasic knowledge of Python programmingUnderstanding of relational databases and SQL - optionalFamiliarity with web development concepts (HTML, CSS, and JavaScript) - optional Audience  Beginners Python Django developers curious about web application development  Web developers who want to learn how to build web applications using Django and PostgreSQL  Python developers who want to expand their skillset to web development  Students or professionals looking to enhance their web development skills with Django and PostgreSQL.<h3> Requirements</h3><ul><li><span></span><span>Basic knowledge of Python programming</span></li><li><span></span><span>Understanding of relational databases and SQL - optional</span></li><li><span></span><span>Familiarity with web development concepts (HTML, CSS, and JavaScript) - optional</span></li></ul>

Xpert Learning

PostgreSQL

Build Web Applications with Django and PostgreSQL

<p>The IT For Recruiters is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about the IT For Recruiters and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Introduction</strong></p><ul><li>Introduction</li></ul><p><strong>IT Fundamentals</strong></p><ul><li>What is hardware and software</li><li>Server</li><li>Project Life cycle</li><li>Software Development Life Cycle</li></ul><p><strong>IT Terms Basics</strong></p><ul><li>Methodologies</li><li>CMS</li><li>API</li><li>CI/CD</li><li>Stacks</li><li>Native and Hybrid Native Apps</li></ul><p><strong>IT Positions</strong></p><ul><li>CTO</li><li>IT Architect</li><li>Product Owner</li><li>Project Manager</li><li>Product Manager</li><li>PO vs PM vs Product Manager</li><li>PO vs Product Manager</li><li>Business Analyst</li><li>Business Intelligence Specialist</li><li>Data Engineer</li><li>Data Scientist</li><li>Data Engineer vs Data Scientist</li><li>Agile Coach</li><li>Scrum Master</li><li>Agile Coach vs Scrum Master</li><li>Frontend Developer</li><li>Backend Developer</li><li>Fullstack Developer</li><li>Frontend vs Backend vs Fullstack Developer</li><li>iOS Developer</li><li>Android Developer</li><li>UX Designer</li><li>UI Designer</li><li>UX vs UI Designer</li><li>QA Engineer_Tester</li><li>SysAdmin</li><li>DevOps</li><li>SEO</li></ul><p><strong>IT Technologies. Programming Languages and Frameworks</strong></p><ul><li>Programming languages and frameworks. Intro</li><li>Programming languages and frameworks</li><li>Java</li><li>JavaScript</li><li>Python</li><li>C</li><li>C++</li><li>C#</li><li>HTML</li><li>PHP</li><li>SWIFT</li><li>Objective-C</li><li>Ruby</li><li>SQL</li><li>Go (Golang)</li></ul><p><strong>Databases</strong></p><ul><li>Database</li><li>Types of Databases</li></ul><p><strong>From Recruiter to Recruiter</strong></p><ul><li>The day of an IT Recruiter</li><li>Key principles</li><li>Sourcing Tipps</li></ul><p><strong>Good Bye Video</strong></p><ul><li>Good Bye Video</li></ul><p><strong>Exam and Assessment</strong></p><ul><li>MCQ based test</li><li>60% Marks to pass</li><li>Instant Assessment and Feedback</li></ul><p><strong>Certification</strong></p><ul><li>CPD Certified PDF and Hardcopy Certificate</li><li>Level 5 QLS Endorsed Hardcopy Certificate for<strong> Diploma in IT For Recruiters at QLS Level 5</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This IT For Recruiters course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This IT For Recruiters course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the IT For Recruiters Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            £9
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            £109
        </p>
            <div> <p><strong>QLS Endorsed Certificate</strong></p><p>Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying -</p><ul><li>Within the UK: £109</li><li>International: £109 + £10 (postal charge) = £119 </li></ul><p><strong>CPD Certification Service Accredited Certification</strong></p><ul><li>Hardcopy Certificate (within the UK): £15</li><li>Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</li></ul> </div>

                        </div>

One Education

IT Training For Recruiters Course

<strong>Learn how to deploy, manage, and secure Oracle WebLogic in an enterprise environment.</strong>
        <p>Oracle WebLogic 12c for Administrators is designed to teach systems administrators and developers how to deploy, configure and manage the leading enterprise application server in an enterprise environment. This course takes a pragmatic step-by-step approach and uses a combination of video lectures and hands-on labs to easily break down complex and confusing topics into an easy-to-understand format. Oracle WebLogic 12c for Administrators will teach you how to deploy and manage an Oracle WebLogic 12c environment by introducing you to a variety of topics from architectural concepts and best practices, to domain configuration, runtime management, and (of course) how to secure WebLogic. 

By the end of this course, you will have gained the skills you need to securely deploy WebLogic in an enterprise environment. 

If you have been hesitant to check out WebLogic or if you want to learn more about WebLogic features and best practices, then this course is for you. It supplies easy-to-understand lectures and hands-on lab work.

All the codes and supporting files for this course are available at - https://github.com/PacktPublishing/Oracle-WebLogic-12c-for-Administrators</p>
        <h2>What You Will Learn</h2><p>Satisfy system prerequisites for deploying Oracle WebLogic 12c<br>Install Oracle WebLogic<br>Create WebLogic domains <br>Configure WebLogic JDBC and JMS resources<br>Secure a WebLogic domain using best practices<br>Script common WebLogic management tasks using WLST</p>
        <h2>Audience</h2><p>This course has been designed for systems administrators and DevOps engineers who need to support Oracle WebLogic in an enterprise environment; however, anyone who is interested in learning about WebLogic and its features will find this course greatly beneficial.</p>
        <h2>Approach</h2><p>Oracle WebLogic 12c for Administrators is broken up into a series of topics that cover each core aspect of WebLogic. Each topic comprises a video lecture that clearly explains and illustrates one aspect of WebLogic and is followed by a hands-on lab exercise.</p>
        <h2>Key Features</h2><p>Install and configure WebLogic resources (JMS and JDBC) and deploy applications in a production environment * Covers all major areas of Oracle WebLogic 12c, from design to deployment to security * A practical course designed to help you understand architectural and technical concepts.</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/oracle-weblogic-12c-for-administrators</p>
        <h2>About the Author</h2><h3>Chris Parent</h3><p>Chris Parent has nearly 20 years of software development, architecture and IT management experience in defence and commercial industries with a focus on enterprise and cloud architectures. He has consulted as an architect and consultant with companies such as Lockheed Martin, Northrop Grumman, Raytheon, and Oracle on the implementation and use of Oracle Fusion Middleware products including Oracle WebLogic Server, SOA Suite, and Identity and Access Management. He received his undergraduate and graduate degrees in Computer Science and Systems Engineering from Rensselaer Polytechnic University in Troy, NY and Penn State University respectively. Chris resides with his family in Denver, Colorado USA.</p>
        <h2>Course Outline</h2><h4>1. Welcome to the Course!</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video includes overview of the course, topics, audience, and any prerequisites or requirements.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab Guide Overview - here you will find the Lab Guide and files you need</p><p style='margin: 0'>In this video author introduces the Lab Guide and how the labs are organized and put together for this course.</p></td></tr></tbody></table><br><h4>2. WebLogic Domain</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Installing WebLogic</p><p style='margin: 0'>This video introduces the first step to learning WebLogic and that is installing the product.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #1 Installing WebLogic</p><p style='margin: 0'>In this lab you will download and install JDK7 and WLS 12.1.3.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating a Domain</p><p style='margin: 0'>This video will briefly discuss the various options for creating WebLogic domains, specifically Configuration Wizard, Template Builder, and WLST.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #2 Creating a Domain</p><p style='margin: 0'>In this lab you will use the Configuration Wizard, Template Builder and WLST to create domains. Refer to the Lab Guide found under Lecture 1 Introduction.</p></td></tr></tbody></table><br><h4>3. WebLogic Servers</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Admin Server and Admin Console</p><p style='margin: 0'>Learn the function and purpose of the WebLogic admin server and the key role it plays within a WebLogic domain.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #3 Admin Server</p><p style='margin: 0'>In this lab you will learn how to start the admin server and how to access the admin console. Refer to the Lab Guide found under Lecture 1 Introduction.</p></td></tr><tr><td style='padding: 15px;'><p>3. Managed Servers</p><p style='margin: 0'>In this video you will learn what a WebLogic managed server and its role within a domain.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #4 Managed Servers Part 1</p><p style='margin: 0'>In this lab you will create a managed server using the admin console. You'll then start this managed server and monitor it via the admin console.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #4 Managed Servers Part 2</p><p style='margin: 0'>Part 2 concludes with basic server monitoring using the admin console.</p></td></tr></tbody></table><br><h4>4. JDBC Data Sources</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Data Sources</p><p style='margin: 0'>This lecture introduces WebLogic data sources and discusses Generic, GridLink, and Multi-datasources and XA versus non-XA JDBC drivers</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #5 Data Sources Part 1</p><p style='margin: 0'>In this lab you will learn how to create, configure, and monitor a WebLogic data source using the admin console. The lab is broken up into 2 parts. Part 1 covers the configuration of Derby database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #5 Data Sources Part 2</p><p style='margin: 0'>In Part 2 of this lab you will learn how to create and connect a data source to an instance of Derby created in Part 1</p></td></tr></tbody></table><br><h4>5. JMS</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. JMS</p><p style='margin: 0'>Learn basic WebLogic JMS concepts such as Publish/subscribe versus Point-to-Point, JMS architecture, JMS servers and JMS system and application modules</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #6 JMS Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to create and configure file-based persistent storage and a JMS server.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #6 JMS Part 2</p><p style='margin: 0'>In Part 2 of this lab you will create JMS system models containing a connection factory and a JMS destination. You will then test the destination by generating a JMS message using the admin console.</p></td></tr></tbody></table><br><h4>6. Application Deployment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Application Deployment</p><p style='margin: 0'>Understand the concepts and tools behind deploying applications to WebLogic. This lecture introduces the student to using the admin console and command line tools for deployment.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #7 Application Deployment Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to use the admin console to deploy an enterprise application.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #7 Application Deployment Part 2</p><p style='margin: 0'>In Part 2 of this lab teaches the student how to use command-line tools for deploying applications to WebLogic.</p></td></tr><tr><td style='padding: 15px;'><p>4. Production Application Deployment</p><p style='margin: 0'>In this lecture you will learn about various techniques and strategies for deploying applications in a production environment, specifically Deployment plans, Application installation directories and In-place and Zero-downtime upgrades</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #8 Production Application Deployment Part 1</p><p style='margin: 0'>In this lab you will learn how to deploy an application using deployment plans and an application installation directory.</p></td></tr><tr><td style='padding: 15px;'><p>6. Lab #8 Production Application Deployment Part 2</p><p style='margin: 0'>Part 2 of this lab covers versioning and upgrading applications for deployment using weblogic.Deployer</p></td></tr></tbody></table><br><h4>7. Security</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. WebLogic Security Part 1</p><p style='margin: 0'>In Part 1 you will be introduced to WebLogic-related security concepts and general security guidelines such as Secure installation of WebLogic, Domain creation, Securing a WebLogic domain, Domain-wide administration port and SSL</p></td></tr><tr><td style='padding: 15px;'><p>2. WebLogic Security Part 2</p><p style='margin: 0'>In Part 2 of this lecture we will discuss Security realms, Users, groups, roles, and security policies, Security providers and Security provider database</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #9 WebLogic Security Part 1</p><p style='margin: 0'>In this lab you will learn how to protect a weblogic domain by configuring the administration port.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #9 WebLogic Security Part 2</p><p style='margin: 0'>In Part 2 of this lab you will create a SQL Authentication Provider using Derby DB.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #9 WebLogic Security Part 3</p><p style='margin: 0'>In Part 3 of this lab you will learn how to configure Password complexity, User lockout and Auditing provider</p></td></tr><tr><td style='padding: 15px;'><p>6. Lab #9 WebLogic Security Part 4</p><p style='margin: 0'>In this lab you will learn how to protect an application using groups, roles, and a security policy.</p></td></tr></tbody></table><br><h4>8. High Availability and Failover</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. WebLogic Clusters Part 1</p><p style='margin: 0'>Part 1 of this lecture will cover Benefits and capabilities, Cluster communications and Basic cluster architectures</p></td></tr><tr><td style='padding: 15px;'><p>2. WebLogic Clusters Part 2</p><p style='margin: 0'>Part 2 of this lecture will cover Load balancing, Failover and Server and Service Migration</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #10 Clusters Part 1</p><p style='margin: 0'>In Part 1 of this lab you will learn how to create and configure a cluster. You'll also deploy some resources to the cluster, including a data source and an application.</p></td></tr><tr><td style='padding: 15px;'><p>4. Lab #10 Clusters Part 2</p><p style='margin: 0'>In Part 2 of this lab you will cluster an application by deploying it to a cluster.</p></td></tr><tr><td style='padding: 15px;'><p>5. Lab #10 Clusters Part 3</p><p style='margin: 0'>In Part 3 of this lab you will configure and deploy a proxy service using the HttpClusterServlet. Be sure to download the Lab Files.zip from Lecture 2. The zip file contains the proxy web application you will need for the lab.</p></td></tr></tbody></table><br><h4>9. Node Manager</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Node Manager</p><p style='margin: 0'>In this lecture you will learn about WebLogic's Node Manager utility for controlling server lifecycle. The lecture will cover key terms and concepts, architecture, data flows, and basic configuration.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #11 Node Manager Part 1</p><p style='margin: 0'>In this lab you will Configure Node Manager to run securely, Create WebLogic Machines and Connect WLST using SSL</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #11 Node Manager Part 2</p><p style='margin: 0'>In Part 2 of this lab you will Generate Node Manager startup and boot properties for the Admin Server, Start the Admin Server using WLST, Start Managed Servers using the Admin Console and Simulate a restart of a failed server</p></td></tr></tbody></table><br><h4>10. Distributed Deployment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Distributed Deployment</p><p style='margin: 0'>Understand how to scale out WebLogic deployments using managed server templates and Node Manager.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab #12 Distributed Deployment Part 1</p><p style='margin: 0'>In Part 1 of this lab, you will learn about distributed deployment.</p></td></tr><tr><td style='padding: 15px;'><p>3. Lab #12 Distributed Deployment Part 2</p><p style='margin: 0'>In Part 2 of this lab, you will learn about distributed deployment.</p></td></tr></tbody></table><br><h4>11. WebLogic Scripting Tool</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro to WLST</p><p style='margin: 0'>This video introduces you to WLST.</p></td></tr><tr><td style='padding: 15px;'><p>2. WLST Command Types</p><p style='margin: 0'>This video is about WLST Command types</p></td></tr><tr><td style='padding: 15px;'><p>3. Online versus Offline Modes</p><p style='margin: 0'>This video is about Online versus Offline modes.</p></td></tr><tr><td style='padding: 15px;'><p>4. MBeans Part 1</p><p style='margin: 0'>Learn about MBeans here.</p></td></tr><tr><td style='padding: 15px;'><p>5. MBeans Part 2</p><p style='margin: 0'>This video is about MBeans.</p></td></tr><tr><td style='padding: 15px;'><p>6. Interactive Mode</p><p style='margin: 0'>This video is about Interactive Mode.</p></td></tr><tr><td style='padding: 15px;'><p>7. WLS Example</p><p style='margin: 0'>This video is WLS Example</p></td></tr><tr><td style='padding: 15px;'><p>8. Lab 13.1 - Launching WLST</p><p style='margin: 0'>Learn how to launch WLST interactively.</p></td></tr><tr><td style='padding: 15px;'><p>9. Lab 13.2 - Creating a Domain using WLST</p><p style='margin: 0'>Create a domain using WLST and a domain template.</p></td></tr><tr><td style='padding: 15px;'><p>10. Lab 13.3 - Using Online Mode</p><p style='margin: 0'>This video is about connect the admin server using online mode</p></td></tr><tr><td style='padding: 15px;'><p>11. Lab 13.4 - Creating a Managed Server, Deploying a Web application and Monitoring Application Deployment Status</p><p style='margin: 0'>This video shows to create a managed server using WLST, how to deploy a web application to Weblogic using WLST and shows monitoring a domain using WLST.</p></td></tr><tr><td style='padding: 15px;'><p>12. Lab 13.7 - Recording WLST Scripts</p><p style='margin: 0'>Learn how to generate WLST scripts by recording your interactions within the WebLogic administration console.</p></td></tr><tr><td style='padding: 15px;'><p>13. Lab 13.8 - WLST Security</p><p style='margin: 0'>Learn how to connect to the admin server using a private key. In this lab you will create a symmetric key that will be used to authenticate against WebLogic. This is a safer alternative than using named credentials when executing connect () statements.</p></td></tr></tbody></table>

Packt

AWS Certified Developer

Linux Administration

LPIC-1:Linux Administrator

AWS Certified Database

Oracle 1Z0-819

Learn how to deploy, manage, and secure Oracle WebLogic in an enterprise environment.

Oracle WebLogic 12c for Administrators

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

Computing Skills

Microsoft SQL

Data Skills

SQL Server

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager 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.  <p></p>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.<p></p></div>

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

55348 Administering Microsoft Endpoint Configuration Manager

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Microsoft SQL Server

Database Administration

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-300T00: Administering Microsoft Azure SQL Solutions 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.  <p></p>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.<p></p></div>

Azure SQL Database

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<p>The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Microsoft SQL Server Bootcamp 2022</strong></p><ul><li>Section 01: Getting Started</li><li>Section 02: SQL Server setting up</li><li>Section 03: SQL Database basic</li><li>Section 04: SQL DML (Data Manipulation Language)</li><li>Section 05: SQL DDL (Data Definition Language)</li><li>Section 06: SQL DCL (Data Control Language)</li><li>Section 07: SQL Statement Basic</li><li>Section 08: Filtering Data rows</li><li>Section 09: Aggregate functions</li><li>Section 10: SQL Query statements</li><li>Section 11: SQL Group by statement</li><li>Section 12: JOINS</li><li>Section 13: SQL Constraints</li><li>Section 14: Views</li><li>Section 15: Advanced SQL commands</li><li>Section 16: SQL Stored procedures</li><li>Section 17: Import &amp; Export data</li><li>Section 18: Backup and Restore Database</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.
Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!
Expert Support
Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.
Key Benefits
Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.
Get 24/7 access to all content for a full year.
Each of our students gets full tutor support on weekdays (Monday to Friday)
Course Curriculum:
Microsoft SQL Server Bootcamp 2022
Section 01: Getting Started
Section 02: SQL Server setting up
Section 03: SQL Database basic
Section 04: SQL DML (Data Manipulation Language)
Section 05: SQL DDL (Data Definition Language)
Section 06: SQL DCL (Data Control Language)
Section 07: SQL Statement Basic
Section 08: Filtering Data rows
Section 09: Aggregate functions
Section 10: SQL Query statements
Section 11: SQL Group by statement
Section 12: JOINS
Section 13: SQL Constraints
Section 14: Views
Section 15: Advanced SQL commands
Section 16: SQL Stored procedures
Section 17: Import & Export data
Section 18: Backup and Restore Database
Course Assessment 
To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.
When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.
Certification
Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.
Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
 Who is this course for? 
This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.
 Requirements 
This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.
 Career path 
Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<strong>Understanding databases and SQL</strong>
        <p>Databases are incredibly important in the modern world, and may seem quite complex to most people. But they're easy to use if you know the right techniques and concepts. With this course, you'll get up to speed with the Structured Query Language (SQL) in an interactive, quick, and easy way. You'll be able to download and use the free trial version of Microsoft SQL Server and understand how to use it confidently. 

You'll start by learning fundamental database concepts, gradually understanding what databases, tables, rows and columns, and data types are. Next, you'll explore how to set up and use Microsoft SQL Server. The course will then delve into SQL, focusing on basic concepts such as SELECT statements; Where, And, or Not; and How to Order and Group By. As you progress, you'll gain insights into comprehensive topics such as Having and Top Clauses; Select Distinct; Union; and Functions. Finally, you'll focus on advanced concepts including Insert and Update Statements; Deleting and Altering Tables; Joining Tables; Primary Keys; and Indexing.

By the end of this course, you'll have the skills you need to effectively use databases with SQL.</p>
        <h2>What You Will Learn</h2><p>Discover the fundamentals of Microsoft SQL Server<br>Explore conditions<br>Understand how to experiment with tables<br>Work with functions</p>
        <h2>Audience</h2><p>This course is for beginners who want to learn SQL, or anyone who wants to understand how to build databases using Microsoft SQL Server.</p>
        <h2>Approach</h2><p>This course will demonstrate how to build databases with Microsoft SQL Server from scratch. You'll cover the theory and implementation through real-world examples.</p>
        <h2>Key Features</h2><p>Install and use Microsoft SQL Server * Gain a basic understanding of databases and their use * Explore SQL and use it with databases</p>
        
        <h2>About the Author</h2><h3>John Elder</h3><p>John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Introduction: Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Database Concepts</p><p style='margin: 0'>Introduction: Database Concepts</p></td></tr><tr><td style='padding: 15px;'><p>3. Data Types</p><p style='margin: 0'>Introduction: Data Types</p></td></tr></tbody></table><br><h4>2. Installation and Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Download and Install SQL Server</p><p style='margin: 0'>Installation and Setup: Download and Install SQL Server</p></td></tr><tr><td style='padding: 15px;'><p>2. Download and Install SSMS</p><p style='margin: 0'>Installation and Setup: Download and Install SSMS</p></td></tr><tr><td style='padding: 15px;'><p>3. Connect To Server</p><p style='margin: 0'>Installation and Setup: Connect To Server</p></td></tr><tr><td style='padding: 15px;'><p>4. System Databases</p><p style='margin: 0'>Installation and Setup: System Databases</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating a Database and Table</p><p style='margin: 0'>Installation and Setup: Creating a Database and Table</p></td></tr><tr><td style='padding: 15px;'><p>6. Adding Data To A Table</p><p style='margin: 0'>Installation and Setup: Adding Data To A Table</p></td></tr></tbody></table><br><h4>3. Structured Query Language - SQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro To SQL</p><p style='margin: 0'>Structured Query Language - SQL: Intro To SQL</p></td></tr><tr><td style='padding: 15px;'><p>2. Select Statements</p><p style='margin: 0'>Structured Query Language - SQL: Select Statements</p></td></tr><tr><td style='padding: 15px;'><p>3. Where Clause</p><p style='margin: 0'>Structured Query Language - SQL: Where Clause</p></td></tr><tr><td style='padding: 15px;'><p>4. And or Not</p><p style='margin: 0'>Structured Query Language - SQL: And or Not</p></td></tr><tr><td style='padding: 15px;'><p>5. Order By</p><p style='margin: 0'>Structured Query Language - SQL: Order By</p></td></tr><tr><td style='padding: 15px;'><p>6. Group By</p><p style='margin: 0'>Structured Query Language - SQL: Group By</p></td></tr><tr><td style='padding: 15px;'><p>7. The Having Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Having Clause</p></td></tr><tr><td style='padding: 15px;'><p>8. The Top Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Top Clause</p></td></tr><tr><td style='padding: 15px;'><p>9. Select Distinct</p><p style='margin: 0'>Structured Query Language - SQL: Select Distinct</p></td></tr><tr><td style='padding: 15px;'><p>10. Union</p><p style='margin: 0'>Structured Query Language - SQL: Union</p></td></tr><tr><td style='padding: 15px;'><p>11. Functions</p><p style='margin: 0'>Structured Query Language - SQL: Functions</p></td></tr><tr><td style='padding: 15px;'><p>12. Insert Statement</p><p style='margin: 0'>Structured Query Language - SQL: Insert Statement</p></td></tr><tr><td style='padding: 15px;'><p>13. Update Statement</p><p style='margin: 0'>Structured Query Language - SQL: Update Statement</p></td></tr><tr><td style='padding: 15px;'><p>14. Delete Statement</p><p style='margin: 0'>Structured Query Language - SQL: Delete Statement</p></td></tr><tr><td style='padding: 15px;'><p>15. Alter Table</p><p style='margin: 0'>Structured Query Language - SQL: Alter Table</p></td></tr><tr><td style='padding: 15px;'><p>16. Null</p><p style='margin: 0'>Structured Query Language - SQL: Null</p></td></tr><tr><td style='padding: 15px;'><p>17. Creating A Table</p><p style='margin: 0'>Structured Query Language - SQL: Creating A Table</p></td></tr><tr><td style='padding: 15px;'><p>18. Drop Table</p><p style='margin: 0'>Structured Query Language - SQL: Drop Table</p></td></tr><tr><td style='padding: 15px;'><p>19. Primary Key</p><p style='margin: 0'>Structured Query Language - SQL: Primary Key</p></td></tr><tr><td style='padding: 15px;'><p>20. Intro To Joining Tables</p><p style='margin: 0'>Structured Query Language - SQL: Intro To Joining Tables</p></td></tr><tr><td style='padding: 15px;'><p>21. Inner Join</p><p style='margin: 0'>Structured Query Language - SQL: Inner Join</p></td></tr><tr><td style='padding: 15px;'><p>22. Left, Right, and Outer Join</p><p style='margin: 0'>Structured Query Language - SQL: Left, Right, and Outer Join</p></td></tr><tr><td style='padding: 15px;'><p>23. Indexing</p><p style='margin: 0'>Structured Query Language - SQL: Indexing</p></td></tr></tbody></table>

Learn SQL with Microsoft SQL Server

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL 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.  <p></p>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.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Database Programming

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

750 Courses delivered Online

IT Security & Cyber Security

By Apex Learning

Tech Coding Diploma - CPD Certified

By Apex Learning

SharePoint Foundation Basics - Video Training Course

By John Academy

MS Access Tables and Queries for Beginner

By Apex Learning

Microsoft Access Tables and Queries

By Apex Learning

Google Cloud Fundamentals - Core Infrastructure

By Nexus Human

Build Web Applications with Django and PostgreSQL

By Xpert Learning

IT Training For Recruiters Course

By One Education

IT Training For Recruiters Course

By One Education

Oracle WebLogic 12c for Administrators

By Packt