Name: SQL Querying Fundamentals - Part 1
Price: 495 GBP
Availability: InStock

Packt

Database Programming

SQL Server

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

The Complete Guide for SQL with Microsoft SQL Server

General Admission

Overview
★★ 24 Hour Limited Time Flash Sale ★★
Advanced Diploma in SQL Programming at QLS Level 7
***Key Features of Advanced Diploma in SQL Programming at QLS Level 7***
Free QLS Certificate
Free CPD PDF Certificate + Transcript
Are you eager to master the intricacies of SQL Programming and elevate your database management skills? The Level 7 Advanced Diploma in SQL Programming is meticulously designed to offer an in-depth understanding of SQL Programming. Whether you're a seasoned developer or a novice eager to grasp SQL Programming, this course caters to all proficiency levels. SQL Programming is pivotal in the contemporary data-driven world, and this diploma aims to bridge the gap between foundational knowledge and advanced techniques.
The Level 7 Advanced Diploma in SQL Programming covers a broad spectrum of topics to ensure comprehensive learning. From basic query writing to complex database design and optimisation, every aspect of SQL Programming is addressed in detail. Students will explore various SQL Programming concepts, including indexing, stored procedures, triggers, and performance tuning. By the end of the course, learners will have a robust grasp of SQL Programming, enabling them to handle data challenges efficiently.
This diploma is more than just a certification; it’s a gateway to numerous career opportunities in SQL Programming. The curriculum is structured to provide a solid theoretical foundation, followed by advanced applications in SQL Programming. Graduates will be equipped with the skills needed to excel in roles such as database administrators, data analysts, and SQL developers. Embark on this transformative journey and let SQL Programming become your professional forte.
Learning Outcomes:
Develop advanced skills in SQL Programming to manage and manipulate databases effectively.
Understand and apply indexing techniques within SQL Programming for enhanced query performance.
Master the creation and use of stored procedures in SQL Programming.
Implement triggers in SQL Programming to automate tasks and maintain data integrity.
Optimise database performance through advanced SQL Programming techniques.
Gain expertise in complex query writing within SQL Programming.
Analyse and solve different data problems using SQL Programming.
Learn the principles of database design and architecture in SQL Programming.
Ensure data security and compliance through effective SQL Programming practices.
Stay updated with the latest advancements in SQL Programming.
Certificates
Digital Certificate
This bundle comes with a free CPD Accredited PDF Copy certificate+ Transcript (according to the Learner's Choice). For additional courses, it costs £14.99 per copy.
Level 7 QLS Endorsed Hardcopy Certificate
Hard copy certificate - Included
Certificate delivery is Free for UK residents, whereas it costs £10 for international students as a delivery charge.
Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.
Hard Copy Certificate
Get CPD Accredited Hard Copy certificate for £19.99 per copy. The delivery fee for the Hard Copy certificate, however, is free for UK residents, whereas it costs £10 for international students as delivery charge.
Course Description
The Level 7 Advanced Diploma in SQL Programming is designed for individuals seeking to advance their database management and programming skills. This comprehensive course covers fundamental to advanced topics in SQL Programming, including query writing, database design, indexing, stored procedures, and performance optimisation. Upon completion, students will possess the expertise required to excel in various data-centric roles.
Who is this course for?
Data Analysts looking to enhance their SQL skills
Database Administrators seeking advanced knowledge
IT Professionals aiming to specialise in SQL Programming
Software Developers working with databases
Individuals pursuing a career in data management and analysis
Requirements
Basic understanding of SQL
Prior experience with database management
Commitment to completing coursework and assignments
Career path
SQL Developer: £35,000 - £55,000 per year
Database Administrator: £30,000 - £50,000 per year
Data Analyst: £25,000 - £45,000 per year
Data Engineer: £40,000 - £65,000 per year
Business Intelligence Analyst: £35,000 - £55,000 per year
Database Architect: £50,000 - £80,000 per year

Skill Up

Microsoft SQL

Database Administration

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support


Level 7 Advanced Diploma in SQL Programming - QLS Endorsed


<p>Are you interested in becoming a skilled SQL developer? Look no further than our SQL Developer Training bundle package! This 25-course package includes everything you need to become a master of SQL and set yourself up for a successful career in technology.</p><p>Our courses cover all aspects of SQL programming, from beginner-level courses to advanced topics like NoSQL, Big Data, and Hadoop. You'll learn from expert instructors who have years of experience in the industry, and you'll get hands-on experience with real-world projects and assignments.</p><p>In addition to the SQL-specific courses, you'll also receive five career-guided courses that will help you build a successful career in technology. These courses cover everything from creating a professional LinkedIn profile to acing the job interview.</p><p>The SQL Developer Training bundle is designed for individuals who want to take their career in technology to the next level. Whether you're new to SQL or you're looking to advance your skills, this bundle has everything you need to succeed.</p><p>So what are you waiting for? Enrol in our SQL Developer Training bundle today and take the first step toward becoming a skilled SQL developer!</p><p><strong>This 20-in 1 Ultimate SQL Developer bundle consists of the following Courses:</strong></p><ul><li>Course 01: SQL Programming Masterclass</li><li>Course 02: SQL Server for Beginners</li><li>Course 03: SQL NoSQL Big Data and Hadoop</li><li>Course 04: Microsoft SQL Server Development for Everyone</li><li>Course 05: Javascript Programming for Beginners</li><li>Course 06: Master JavaScript with Data Visualization</li><li>Course 07: jQuery: JavaScript and AJAX Coding Bible</li><li>Course 08: Kotlin Programming : Android Coding</li><li>Course 09: Quick Data Science Approach from Scratch</li><li>Course 10: Secure Programming of Web Applications</li><li>Course 11: A-Frame Web VR Programming</li><li>Course 12: Complete AutoLISP Programming</li><li>Course 13: Building Your Own Computer Course</li><li>Course 14: Neuro-linguistic Programming (NLP) Diploma</li><li>Course 15: Cyber Security Incident Handling and Incident Response</li><li>Course 16: Computer Networks Security</li><li>Course 17: IT Asset Department</li><li>Course 18: C# Programming - Beginner to Advanced</li><li>Course 19: AutoCAD Programming using C# with Windows Forms</li><li>Course 20: AutoCAD Programming using VB.NET with Windows Forms</li></ul><p><strong>Additionally, you will get 5 other career-guided courses in this SQL Developer bundle:</strong></p><ul><li>Course 01: Career Development Plan Fundamentals</li><li>Course 02: CV Writing and Job Searching</li><li>Course 03: Interview Skills: Ace the Interview</li><li>Course 04: Video Job Interview for Job Seekers</li><li>Course 05: Create a Professional LinkedIn Profile</li></ul><p><strong><em>So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this </em></strong><strong>SQL Developer<em> bundle</em>.</strong></p><p><strong>Learning Outcomes of SQL Developer bundle </strong></p><p>This career-oriented bundle will help you to</p><ul><li>Gain the ability to excel in the role of SQL Developer</li><li>Know your responsibilities as SQL Developer and convey your experience to others</li><li>Gain excellent interpersonal and communication skills</li><li>Know the pros and cons of working as SQL Developer</li><li>Adhere to the regulations around this area</li><li>Gain time and risk management skills to ensure efficiency</li><li>Manipulate technological advancement to become more effective</li><li>Maintain moral standards and set an example for your peers</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        250 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 SQL Developer bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This SQL Developer course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this 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>SQL Programming Masterclass</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p><strong>Please Note:</strong> 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

SQL Developer Training

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Learn how to Install and configure NGINX on Ubuntu step-by-step. Includes MySQL, PHP, PhpMyAdmin, WordPress &amp; SSL integration.</span></p><p><span>NGINX is one of the most powerful Web Server technologies in the world. In this course, you will learn how to install NGINX on a DigitalOcean droplet or any virtual server of your choice, with complete step-by-step guidance. It also covers key topics such as the differences between Apache &amp; NGINX, configuring DNS one files, and creating a database for WordPress.</span></p><p><span>This practical training course is a great introduction to NGINX and other open source software, ideal for students interested in web development and web design. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<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>
				<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>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu

<strong>This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.</strong>
        <p>Welcome to this SQL Server course designed to cater to aspiring data professionals and anyone looking to enhance their SQL skills. We will begin with the fundamentals, covering SQL syntax, data types, and essential querying techniques. You will learn how to write powerful SQL queries to retrieve, filter, and sort data, as well as perform calculations, and leverage aggregate functions.

In the second part of the course, we will dive into advanced SQL for data science. Joining tables, using subqueries, and employing window functions are vital skills for complex data retrieval and analysis. You will learn how to combine data from multiple tables, create intricate queries, and extract valuable insights from large datasets.

Lastly, we will focus on database management and optimization. You will gain the skills to efficiently manage SQL Server databases, including database design, indexing, and performance tuning. This knowledge is crucial for ensuring that your databases run smoothly and deliver optimal performance.

By the end of this course, you will have gained the confidence and expertise to utilize SQL for data science tasks, ranging from data exploration and manipulation to advanced analytics and reporting.</p>
        <h2>What You Will Learn</h2><p>Learn DDL commands for creating, altering, and deleting databases<br>Understand various data types and their significance in defining data structures<br>Explore constraints, including NOT NULL, Primary Key, Foreign Key, Check, and Default<br>Work with views to simplify complex queries and improve data security<br>Learn how to use aggregate functions for data summarization and analysis<br>Learn the order of execution in SQL queries and how it affects query performance</p>
        <h2>Audience</h2><p>If you are an aspiring data professional, a Database Administrator (DBA), a developer, or anyone eager to level up your SQL skills, this all-inclusive SQL Server course is tailor-made for you. Whether you are a beginner or looking to advance your SQL expertise, this course will empower you to excel in managing and manipulating data using SQL Server, unlocking new opportunities in the world of data-driven decision-making. Join us and embark on a journey to master SQL and take your career to the next level.</p>
        <h2>Approach</h2><p>This course starts from the basics and gradually dives deep into advanced SQL concepts, ensuring a well-rounded learning experience. With a focus on practical examples and real-world applications, you will not only understand the theory but also gain hands-on experience to solidify your understanding.</p>
        <h2>Key Features</h2><p>Develop a solid understanding of SQL Server fundamentals, data types, querying, and database management * Learn advanced SQL querying techniques such as joins, subqueries, and CTE for complex data retrieval and analysis * Gain hands-on experience in creating and managing essential database objects, such as schemas, tables, and views to organize data</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/The-Complete-SQL-Bootcamp-for-Aspiring-Data-Scientists</p>
        <h2>About the Author</h2><h3>Vivek P.</h3><p>Vivek P. is a Tableau Certified Associate with more than 12 years of IT experience with different technologies. He is enthusiastic about working with technology and strongly believes in hands-on learning. His teaching methodology is also driven by this belief.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. DDL and DML Statements</h4><p></p><br><h4>3. Data Integrity</h4><p></p><br><h4>4. Querying the database</h4><p></p><br><h4>5. Sort, Aggregate, Group and Filter the Data</h4><p></p><br><h4>6. Functions</h4><p></p><br><h4>7. Joins</h4><p></p><br><h4>8. SQL Query Order of Execution</h4><p></p><br><h4>9. CASE, IF ELSE Statement and Set Operators</h4><p></p><br><h4>10. Views</h4><p></p><br><h4>11. Writing Subqueries and Common Table Expressions (CTE)</h4><p></p><br><h4>12. Stored Procedures</h4><p></p><br><h4>13. Window Functions for Advanced Querying</h4><p></p>

This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.

The Complete SQL Bootcamp for Aspiring Data Scientists

<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>

Microsoft SQL Server

Learn SQL with Microsoft SQL Server

<strong>MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications</strong>
        <p>This course will take you on a journey where you'll establish the strongest possible foundation in database development by learning how to use MySQL (the most popular open source database in the world), write queries, create reports, build web applications, and incorporate MySQL as the database layer. Turn your development dreams into a reality by taking this course and putting a check mark next to your growing development skillset.

You will learn to: 
&bull;	Set up MySQL
&bull;	Work with online IDEs
&bull;	Create databases and queries
&bull;	Use logical operators
&bull;	Manipulate tables/rows/data
&bull;	Understand how joins work and use them
&bull;	Create admin features
&bull;	Implement deployment production
&bull;	And a lot more

All the code files are placed at https://github.com/PacktPublishing/The-Complete-MySQL-Developer-Course</p>
        <h2>What You Will Learn</h2><p>Build web applications using MySQL and PHP<br>Establish a solid foundation for databases and SQL <br>Learn how joins work and use them <br>Build web applications with PHP, HTML, and CSS, with MySQL as the database layer <br>Perform CRUD operations and authentication from web applications <br>Create admin features <br>Implement deployment production</p>
        <h2>Audience</h2><p>This course is designed for anyone keen to learn MySQL and database technologies, build web applications, or make a career in the tech industry.</p>
        <h2>Approach</h2><p>This course is a seamless blend of text, videos, and code examples that will help you learn efficiently as you progress through the course. You'll start with the absolute basics (installing and creating databases) and work your way through building web applications with MySQL as the database. By the end of this course, you'll be able to apply what you've learnt and do virtually anything you want with databases.</p>
        <h2>Key Features</h2><p>Learn to build reports and web applications using MySQL and PHP  * Establish a strong foundation for databases and SQL</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/the-complete-mysql-developer-course</p>
        <h2>About the Author</h2><h3>Codestars By Rob Percival</h3><p>Rob Percival is a highly regarded web developer and Udemy instructor with over 1.7 million students. Over 500,000 of them have taken Rob's Complete Web Developer Course 2.0, as well as his Android Developer and iOS Developer courses.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the course and MySQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video introduces the course</p></td></tr><tr><td style='padding: 15px;'><p>2. Development environment overview</p><p style='margin: 0'>This video tells you why to use an online IDE to develop code in this course</p></td></tr><tr><td style='padding: 15px;'><p>3. Sign up for cloud based IDE for development</p><p style='margin: 0'>Learn to use cloud9 to sign up for development environment</p></td></tr></tbody></table><br><h4>2. Creating Databases and Introduction to Queries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Power of Databases</p><p style='margin: 0'>Learn MySQL and understand how wide is it's reach</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Database/Schema</p><p style='margin: 0'>Learn how to create a database/schema</p></td></tr><tr><td style='padding: 15px;'><p>3. Intro to tables and conventions used</p><p style='margin: 0'>This video look at tables, structures for queries and syntax used in the course</p></td></tr><tr><td style='padding: 15px;'><p>4. Working with tables</p><p style='margin: 0'>Learn how to work with tables in databases</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting rows of data</p><p style='margin: 0'>Learn how to insert data into tables</p></td></tr><tr><td style='padding: 15px;'><p>6. Select</p><p style='margin: 0'>Learn about "select" in MySQL</p></td></tr><tr><td style='padding: 15px;'><p>7. Concat and substring</p><p style='margin: 0'>Learn how to work with the concat and substring operators</p></td></tr><tr><td style='padding: 15px;'><p>8. Homework challenge - bowling scores!</p><p style='margin: 0'>This video is about Homework code challenge</p></td></tr><tr><td style='padding: 15px;'><p>9. Solution - bowling score challenge</p><p style='margin: 0'>This video is about Solution - bowling score challenge</p></td></tr><tr><td style='padding: 15px;'><p>10. Alternate method of homework solution - script</p><p style='margin: 0'>This video shows how to use scripts to develop code and running them instead of using the console</p></td></tr><tr><td style='padding: 15px;'><p>11. MySQL, Oracle, SQL Server</p><p style='margin: 0'>This video will have a look at SQL</p></td></tr><tr><td style='padding: 15px;'><p>12. Limit, order by and distinct</p><p style='margin: 0'>Learn how to use additional features like limit, order by and distinct</p></td></tr><tr><td style='padding: 15px;'><p>13. Count, like and group by</p><p style='margin: 0'>Learn how to use count, like and group by features</p></td></tr><tr><td style='padding: 15px;'><p>14. Min and max</p><p style='margin: 0'>Learn how to use min and max</p></td></tr><tr><td style='padding: 15px;'><p>15. Code challenge project - create a new report</p><p style='margin: 0'>This video is about code challenge to create a new report</p></td></tr></tbody></table><br><h4>3. Logical operators and dates</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Data types in MySQL</p><p style='margin: 0'>Learn about different data types and their features</p></td></tr><tr><td style='padding: 15px;'><p>2. Where and not equal</p><p style='margin: 0'>Learn the details about where and how to use it, along with not equal</p></td></tr><tr><td style='padding: 15px;'><p>3. Comparison operators</p><p style='margin: 0'>This video is about working with comparison operators</p></td></tr><tr><td style='padding: 15px;'><p>4. Or</p><p style='margin: 0'>This video describes working with "Or"</p></td></tr><tr><td style='padding: 15px;'><p>5. Null and blanks</p><p style='margin: 0'>This video is about working with null entries and blanks</p></td></tr><tr><td style='padding: 15px;'><p>6. Case statements</p><p style='margin: 0'>This video is about Working with case</p></td></tr><tr><td style='padding: 15px;'><p>7. Dates and times</p><p style='margin: 0'>Learn how to work with date and time formats</p></td></tr><tr><td style='padding: 15px;'><p>8. Date, time and math</p><p style='margin: 0'>This video is about Date, time and math.</p></td></tr><tr><td style='padding: 15px;'><p>9. Section 3 final project - Create a report on birthdays</p><p style='margin: 0'>This video creates a report on birthdays.</p></td></tr></tbody></table><br><h4>4. Update and delete rows</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Update</p><p style='margin: 0'>This video shows how to update rows of data in tables</p></td></tr><tr><td style='padding: 15px;'><p>2. Update based on comparison</p><p style='margin: 0'>This video gives you more info and usage of update</p></td></tr><tr><td style='padding: 15px;'><p>3. Delete</p><p style='margin: 0'>This video shows how to use delete to remove data</p></td></tr></tbody></table><br><h4>5. Multiple tables and JOINS</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Primary keys, foreign keys</p><p style='margin: 0'>Learn about primary and foreign keys</p></td></tr><tr><td style='padding: 15px;'><p>2. Data prep for joins</p><p style='margin: 0'>This video shows to setup tables and data to work with joins</p></td></tr><tr><td style='padding: 15px;'><p>3. Joins and aliases</p><p style='margin: 0'>Learn about joins and using aliases</p></td></tr><tr><td style='padding: 15px;'><p>4. More about joins</p><p style='margin: 0'>Learn about Joins more in-depth</p></td></tr><tr><td style='padding: 15px;'><p>5. Inner, Left, Outer, Right joins</p><p style='margin: 0'>Learn about inner, left, outer and right joins</p></td></tr><tr><td style='padding: 15px;'><p>6. Left outer joins</p><p style='margin: 0'>Learn about left joins</p></td></tr><tr><td style='padding: 15px;'><p>7. Fix a bad join challenge</p><p style='margin: 0'>This video shows how to fix a bad join</p></td></tr><tr><td style='padding: 15px;'><p>8. Subselects</p><p style='margin: 0'>Learn about subselects</p></td></tr><tr><td style='padding: 15px;'><p>9. More subselects</p><p style='margin: 0'>This video is about Subselects more in-depth</p></td></tr><tr><td style='padding: 15px;'><p>10. Section 5 - Final Project Part 1</p><p style='margin: 0'>This video is Part 1 of final project for section 5</p></td></tr><tr><td style='padding: 15px;'><p>11. Section 5 - Final Project Part 2</p><p style='margin: 0'>This video is Part 2 of final project for section 5</p></td></tr></tbody></table><br><h4>6. Web apps - Data collection from a survey</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Web App Development</p><p style='margin: 0'>This video is an Intro to building web applications</p></td></tr><tr><td style='padding: 15px;'><p>2. HTML and CSS</p><p style='margin: 0'>This video is about working with HTML and CSS - web building blocks</p></td></tr><tr><td style='padding: 15px;'><p>3. Start form collector project</p><p style='margin: 0'>This video starts the web app</p></td></tr><tr><td style='padding: 15px;'><p>4. Add styling to form</p><p style='margin: 0'>This video shows how to add styling to the form collector</p></td></tr><tr><td style='padding: 15px;'><p>5. Create table</p><p style='margin: 0'>This video shows how to create a table for the app using sql</p></td></tr><tr><td style='padding: 15px;'><p>6. Config and other php</p><p style='margin: 0'>This video shows to create a config file along with other php</p></td></tr><tr><td style='padding: 15px;'><p>7. Complete receiver</p><p style='margin: 0'>This video contains code for receiver.php</p></td></tr><tr><td style='padding: 15px;'><p>8. Start SQL Functons</p><p style='margin: 0'>This video is about working on SQLFunctions file</p></td></tr><tr><td style='padding: 15px;'><p>9. Preview and understand steps taken for web app</p><p style='margin: 0'>This video is about the steps taken for web app</p></td></tr><tr><td style='padding: 15px;'><p>10. Add browser display</p><p style='margin: 0'>This video shows to add a browser display for the web app</p></td></tr><tr><td style='padding: 15px;'><p>11. Project - Convert to poll!</p><p style='margin: 0'>This video is about the Final project for section 6</p></td></tr></tbody></table><br><h4>7. CRUD and PHP</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. CRUD - Introduction</p><p style='margin: 0'>This video is an introduction to CRUD</p></td></tr><tr><td style='padding: 15px;'><p>2. Create action</p><p style='margin: 0'>This video shows how to build the create action for the To Do app</p></td></tr><tr><td style='padding: 15px;'><p>3. Read</p><p style='margin: 0'>This video shows to Implement Read action for app</p></td></tr><tr><td style='padding: 15px;'><p>4. Update action</p><p style='margin: 0'>This video shows how to Implement update action for the app</p></td></tr><tr><td style='padding: 15px;'><p>5. Delete action</p><p style='margin: 0'>This video Implements the delete action for to-do's</p></td></tr></tbody></table><br><h4>8. Authentication with PHP and MySQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to authentication</p><p style='margin: 0'>This video is an introduction to authentication</p></td></tr><tr><td style='padding: 15px;'><p>2. Complete user sign-up</p><p style='margin: 0'>This video is about complete user sign-up</p></td></tr><tr><td style='padding: 15px;'><p>3. Login users</p><p style='margin: 0'>This video Implements log in and log out functionality</p></td></tr><tr><td style='padding: 15px;'><p>4. Enforce log in for app</p><p style='margin: 0'>This video shows how to add requirements to users to be logged in</p></td></tr><tr><td style='padding: 15px;'><p>5. Sessions</p><p style='margin: 0'>Learn about Sessions.</p></td></tr></tbody></table><br><h4>9. Challenge section - Build a WebAdmin site</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Challenge section intro and get started</p><p style='margin: 0'>This video introduces challenge section</p></td></tr><tr><td style='padding: 15px;'><p>2. Challenge section project day 2</p><p style='margin: 0'>This video contains day 2 items of challenge project</p></td></tr><tr><td style='padding: 15px;'><p>3. Project day 3, 4 and 5</p><p style='margin: 0'>This video contains day 3, 4 and 5 items of challenge project</p></td></tr><tr><td style='padding: 15px;'><p>4. Project day 6, 7 and completion</p><p style='margin: 0'>This video contains items of Project day 6 and 7 leading to completion</p></td></tr></tbody></table><br><h4>10. Deploy to production</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Deploy to production using a hosting service</p><p style='margin: 0'>This video shows how to deploy web apps to production using a hosting service</p></td></tr></tbody></table><br><h4>11. Stored Procedures and Scheduled jobs</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Thank you</p><p style='margin: 0'>This video tells thank you for taking the course.</p></td></tr></tbody></table>

MySQL

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

The Complete MySQL Developer Course

<p>Learn programming structures from scratch and discover various web development areas! Explore the effective methods for creating and deploying data-driven web applications using PHP, MySQL, and Heroku. With this course, you can gain a solid foundation in database design, development, and querying. Data scientists are one of the highest-paid professionals. So, enrol now if you are considering breaking into a new, highly lucrative field in the technology industry.</p><p>This premium QLS endorsed Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku course comes with intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunity and a globally recognised certification all-together. Thus, successful completion of our Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku course will give you limitless opportunities anywhere and everywhere, since the value of QLS endorsed courses are quite high, to say the least!!</p><p>What's more, the quality of our first-class course is uncompromising for both you and us. You will be taught the richest of materials from this exquisite Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku course, enabling you to open up a vast world of opportunities for you to grasp and gain success from. For the price point, this course is actually an absolute steal! It's an investment you absolutely do not want to miss out on!</p><p>So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as, unquestionably, the most skilled one in your workplace!</p><p><strong>Learning Outcomes:</strong><br />By the end of this course, you will:</p><ul><li>Develop intricate web applications using advanced PHP techniques</li><li>Configure development environments for seamless coding experiences</li><li>Employ PHP syntax with precision and craft dynamic functionalities</li><li>Create interactive forms and seamlessly integrate MySQL databases</li><li>Implement robust user authentication systems for enhanced security</li><li>Harness GitHub for collaborative coding and version control</li></ul><p><strong>Why Learn with us: </strong></p><p>We, as one of the leading e-learning service providers across the globe, strive to provide all our learners with the best e-learning experience possible that can make a real difference in their career progression.</p><p><strong>Our Service for the </strong><strong>Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</strong><strong> Includes:</strong></p><ul><li>Intensive Study Notes</li><li>Tutor Support</li><li>Customer Support</li><li>Assignment Help</li><li>QLS Endorsed Certificate</li><li>24/7 Learning Portal Access</li><li>Widely Compatible Study Materials</li></ul><p><strong>Course Curriculum of </strong><strong>Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</strong></p><ul><li><strong>Unit 01:</strong> Introduction</li><li><strong>Unit 02:</strong> Environment Configuration</li><li><strong>Unit 03:</strong> PHP Basics and Syntax</li><li><strong>Unit 04:</strong> PHP Forms and MySQL and User Authentication</li></ul><p><strong>Assessment &amp; Certification</strong></p><p>Learners must submit a comprehensive summarised assignment on all the units that will be assessed by our expert tutor if all the learning outcomes are met as per the standard set by QLS. After the quality check, learner will be provided with the Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku certificate.</p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme.</strong></p><p>An endorsed certificate will be issued to learners at the end of the course as recognition of course completion. Provided that learner completes all the assessment of a course can claim for certificate.</p><p><strong>Endorsement:</strong></p><p>QLS endorsed this certified course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions, including your progression routes into further higher education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        15 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 course is open for everyone. This Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku is ideal for those who aspire to gain in-depth knowledge &amp; efficient skill to embark into the relevant sector as a promising potential.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal requirements needed for this Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku course. So learners do not require any prior qualifications to enrol in this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Through our Level 7 Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku following professionals will be benefited:</p><ol><li>Senior Web Application Developer- £65,000 - £70,000</li><li>PHP Developer - £40,000 - £50,000</li><li>Frontend Developer - £40,000 - £50,000</li><li>Back-end Developer -£45,000 - £55,000</li><li>Full Stack Developer - £45,000 - £55,000</li><li>Database Administrator - £35,000 - £65,000</li></ol>
                        </div>

Kingston Open College

Learning & Development

Online Course Creation

AWS Certified Developer

Trainers Course

Diploma in Professional Studies (DPS)

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

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

<p><strong> Fall into Savings. Enjoy the biggest price fall this Autumn! </strong></p><p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now</strong></p><p>Tired of browsing and searching for a <strong>Database </strong>course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Database bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Database course that will enhance your skills and prepare you for the competitive job market.</p><p>Also, our experts are available for answering your queries on Database and help you along your learning journey. Advanced audio-visual learning modules of these Database courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in Database, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Database Bundle Consists of the following Premium courses: </strong></p><ul><li><strong> </strong><strong>Course 01: </strong>Microsoft SQL Server Development for Everyone</li><li><strong> </strong><strong>Course 02: </strong>SQL Programming Masterclass</li><li><strong> </strong><strong>Course 03: </strong>SQL NoSQL Big Data and Hadoop</li><li><strong> </strong><strong>Course 04: </strong>Python Programming for Everybody</li><li><strong> </strong><strong>Course 05: </strong>Data Science with Python</li><li><strong> </strong><strong>Course 06: </strong>JavaScript Foundations for Everyone</li><li><strong> </strong><strong>Course 07: </strong>C# Programming - Beginner to Advanced</li><li><strong> </strong><strong>Course 08: </strong>R Programming for Data Science</li><li><strong> </strong><strong>Course 09: </strong>Three.js &amp; WebGL 3D Programming Course for Beginners</li><li><strong> </strong><strong>Course 10: </strong>Basic Google Data Studio</li><li><strong> </strong><strong>Course 11: </strong>Data Analytics with Tableau</li><li><strong> </strong><strong>Course 12: </strong>Spatial Data Visualization and Machine Learning in Python Level 4<strong><br /></strong></li><li><strong> </strong><strong>Course 13: </strong>Cyber Security Incident Handling and Incident Response</li><li><strong> </strong><strong>Course 14: </strong>Learn Ethical Hacking From A-Z: Beginner To Expert</li></ul><p>Enrol now in Database to advance your career, and use the premium study materials from Apex Learning.</p><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 Database expertise and essential knowledge, which will assist you in reaching your goal.</p><p><strong>Curriculum of Bundle</strong></p><p><strong> Course 01: Microsoft SQL Server Development for Everyone</strong></p><ul><li>Introduction</li><li>Manipulating Tables and Data</li><li>Relationships Foreign Keys</li><li>Group By and Aggregate Functions</li><li>Advanced SQL Server Objects and Concepts</li></ul><p><strong>The detailed curriculum of the Database bundle is given in the resources section.</strong></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></strong><strong>PDF Certificate: Free (For The Title Course )</strong></li><li><strong></strong><strong>Hard Copy Certificate: Free (For The Title Course )</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        160 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 Database bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our Database course 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 Database 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>P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p> </div>

                        </div>

Complete SQL and Databases Bootcamp: Zero to Mastery

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.</p>Overview<p>Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report.</p><p>In this course, students will compose SQL queries to retrieve desired information from a database.</p></div><div id="course-pills-2"><h3>1 - Executing a Simple Query</h3> <ul> <li>Connect to the SQL Database</li> <li>Query a Database</li> <li>Save a Query</li> <li>Modify a Query</li> <li>Execute a Saved Query</li> </ul> <h3>2 - Performing a Conditional Search</h3> <ul> <li>Search Using a Simple Condition</li> <li>Compare Column Values</li> <li>Search Using Multiple Conditions</li> <li>Search for a Range of Values and Null Values</li> <li>Retrieve Data Based on Patterns</li> </ul> <h3>3 - Working with Functions</h3> <ul> <li>Perform Date Calculations</li> <li>Calculate Data Using Aggregate Functions</li> <li>Manipulate String Values</li> </ul> <h3>4 - Organizing Data</h3> <ul> <li>Sort Data</li> <li>Rank Data</li> <li>Group Data</li> <li>Filter Grouped Data</li> <li>Summarize Grouped Data</li> <li>Use PIVOT and UNPIVOT Operators</li> </ul> <h3>5 - Retrieving Data from Tables</h3> <ul> <li>Combine Results of Two Queries</li> <li>Compare the Results of Two Queries</li> <li>Retrieve Data by Joining Tables</li> <li>Check for Unmatched Records</li> <li>Retrieve Information from a Single Table Using Joins</li> </ul> <h3>6 - Presenting Query Results</h3> <ul> <li>Save the Query Result</li> <li>Generate an XML Report</li> </ul></div>

Nexus Human

Computing Skills

Programming Fundamentals

Data Skills

SQL Querying Fundamentals - Part 1

<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>

55366 Querying Data with Transact-SQL

<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>

AWS Certified Database

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

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

iStudy UK

Database Design & Development

Database Design

Data Architecture

Database Management

Introduction to Database Design

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are experienced in general Windows Server and Windows Client administration. Students should have a foundational knowledge of Windows PowerShell, which they can obtain by taking course 10961C: Automating Administration with Windows PowerShell. In addition, this course provides scripting guidance for Microsoft Azure administrators and developers who support development environments and deployment processes.</p>Overview<p>After completing this course, you will be able to:<br />Create advanced functions.<br />Use Microsoft .NET Framework and REST API in Windows PowerShell.<br />Handle script errors.<br />Use XML, JSON, and custom formatted data.<br />Manage Microsoft Azure resources<br />Analyze and debug scripts<br />Understand Windows PowerShell workflow.</p><p>This course teaches students how to automate administrative tasks using PowerShell. Students will learn crucial scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Candidates will learn how to use PowerShell when working with Microsoft Azure, SQL Server, Active Directory, IIS, Windows PowerShell Workflow, .NET resources, the REST API and XML, CSV &amp; JSON formatted data files.This course replaces retired Microsoft course 10962.</p></div><div id="course-pills-2"><h4>Module 1: Creating advanced functions</h4><ul><li>Lesson 1: Converting a command into an advanced function</li><li>Lesson 2: Creating a script module</li><li>Lesson 3: Defining parameter attributes and input validation</li><li>Lesson 4: Writing functions that accept pipeline input</li><li>Lesson 5: Producing complex pipeline output</li><li>Lesson 6: Using comment-based Help</li><li>Lesson 7: Using Whatif and Confirm parameters</li></ul><h4>Module 2: Using Microsoft .NET Framework and REST API in Windows PowerShell</h4><ul><li>Lesson 1: Using .NET Framework in PowerShell</li><li>Lesson 2: Using REST API in PowerShell</li></ul><h4>Module 3: Writing controller scripts</h4><ul><li>Lesson 1: Understanding controller scripts</li><li>Lesson 2: Writing controller scripts with a user interface</li><li>Lesson 3: Writing controller scripts that create reports</li></ul><h4>Module 4: Handling script errors</h4><ul><li>Lesson 1: Understanding error handling</li><li>Lesson 2: Handling errors in a script</li></ul><h4>Module 5: Using XML, JSON, and custom-formatted data</h4><ul><li>Lesson 1: Working with XML formatted data</li><li>Lesson 2: Working with JSON formatted data</li><li>Lesson 3: Working with custom-formatted data</li></ul><h4>Module 6: Enhancing server management with Desired State Configuration and Just Enough Administration</h4><ul><li>Lesson 1: Implementing Desired State Configuration</li><li>Lesson 2: Implementing Just Enough Administration</li></ul><h4>Module 7: Analyzing and debugging scripts</h4><ul><li>Lesson 1: Debugging in Windows PowerShell</li><li>Lesson 2: Analyzing and debugging an existing script</li></ul><h4>Module 8: Understanding Windows PowerShell Workflow</h4><ul><li>Lesson 1: Understanding Windows PowerShell Workflows</li><li>Lesson 2: Running Windows PowerShell Workflows</li></ul></div>

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-700

55318: Advanced Automated Administration with Windows PowerShell

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Server 101 : Microsoft SQL Server for Absolute Beginners today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Server 101 : Microsoft SQL Server for Absolute Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Server 101 : Microsoft SQL Server for Absolute Beginners will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the SQL Server 101 : Microsoft SQL Server for Absolute Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive Advanced SAS Programming With MacrosSQL has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced SAS Programming With MacrosSQL today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling Advanced SAS Programming With MacrosSQL has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced SAS Programming With MacrosSQL is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The Advanced SAS Programming With MacrosSQL is CPD-accredited, so you can be confident you're completing a quality training course  will boost your CV and enhance your career potential. The Advanced SAS Programming With MacrosSQL is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the Advanced SAS Programming With MacrosSQL, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced SAS Programming With MacrosSQL will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the Advanced SAS Programming With MacrosSQL to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Advanced SAS Programming With MacrosSQL

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Master MySQL by learning all the web development skills for creating complex, high-quality web databases.</span></p><p><span>The <strong>Basic MySQL Online Course</strong> covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field. </span></p><p><span>This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Basic MySQL Online Course </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Basic MySQL Online Course </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Basic MySQL Online Course </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Basic MySQL Online Course </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> Basic MySQL Online Course</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Basic MySQL Online Course </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Basic MySQL Online Course </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<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>
				<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>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Basic MySQL Online Course

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Become a PHP &amp; MySQL pro by learning all the web development features for creating websites.</span></p><p><span>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding</strong> course covers everything you need to know to master PHP programming and gain valuable industry skills. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for complete beginners. </span></p><p><span>Through this in-depth training course, you will familiarise with all the features of MySQL, and learn best practices for cross platform development, taught by an expert in the field. If you are looking to kickstart a career in programming or computer science, then this course will equip you with up-to-date skills that will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> PHP &amp; MySQL Web Development &amp; OOP Coding</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<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>
				<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>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

PHP & MySQL Web Development & OOP Coding

<p><strong>The easy way to store your data and retrieve it when you need it!</strong></p> <p>Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business.</p> <p>This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation.</p> <p>Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need.</p> <p>Along with this Database Course, you will get <strong>11 premium courses, an original hardcopy</strong>, <strong>11 PDF Certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p>So, don't wait up. Enrol now!</p> <p><strong>This Database Bundle Consists of the following Premium courses: </strong> </p> <p><strong>Courses are included in this Database Bundle?</strong></p> <ul> <li><strong> Course 01:</strong> Microsoft SQL Server Development for Everyone</li><li><strong> Course 02:</strong> SQL Programming Masterclass</li><li><strong> Course 03: </strong>SQL NoSQL Big Data and Hadoop</li><li><strong> Course 04: </strong>Python Programming for Everybody</li><li><strong> Course 05: </strong>Data Science with Python</li><li><strong> Course 06:</strong> JavaScript Foundations for Everyone</li><li><strong> Course 07: </strong>C# Programming - Beginner to Advanced</li><li><strong> Course 08: </strong>R Programming for Data Science</li><li><strong> Course 09: </strong>Three.js &amp; WebGL 3D Programming Course for Beginners</li><li><strong> Course 10: </strong>Basic Google Data Studio</li><li><strong> Course 11: </strong>Data Analytics with Tableau</li></ul> <p><strong>Learning Outcomes</strong></p> <ul> <li>Have a fundamental understanding of database design, implementation, and upkeep.</li><li>Be able to query databases and learn the SQL language.</li><li>To preserve data, use security procedures and backup procedures.</li><li>Examine database performance and note any enhancements.</li><li>Be familiar with approaches for database normalisation and optimisation.</li><li>Create web services and database applications.</li><li>Use DBMS software for managing and storing data.</li><li>Identify technologies and trends in databases.</li></ul><p>These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal.</p> <p><strong>Certificate:</strong></p> <ul> <li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li></ul> <ul> <li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        120 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">
                             <ul> <li>Individuals interested in learning programming and data science skills</li><li>Professionals seeking to enhance their knowledge and skill set</li><li>Entrepreneurs or business owners wanting to understand and manage data effectively</li><li>Students or graduates in computer science, data science, or related fields</li><li>Anyone looking to start a career in programming or data science</li><li>Data analysts, data scientists, or data engineers looking to expand their skill set</li></ul> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>People tend to pursue their careers in the following professions in the database sector</p> <ul> <li>Database Administrator</li><li>Database Developer</li><li>Database Architect</li><li>Database Analyst</li><li>Database Designer</li></ul> <p>The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <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>Microsoft SQL Server Development for Everyone</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p> <p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

241 Database Design & Development courses delivered Online

The Complete Guide for SQL with Microsoft SQL Server

By Packt

Level 7 Advanced Diploma in SQL Programming - QLS Endorsed

By Skill Up

SQL Developer Training

By Apex Learning

Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu

By Course Cloud

The Complete SQL Bootcamp for Aspiring Data Scientists

By Packt

Learn SQL with Microsoft SQL Server

By Packt

The Complete MySQL Developer Course

By Packt

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

By Kingston Open College

Complete SQL and Databases Bootcamp: Zero to Mastery

By Apex Learning

SQL Querying Fundamentals - Part 1

By Nexus Human