Name: Apache Kafka - Real-time Stream Processing (Master Class)
Price: 33.99 GBP
Availability: InStock

<strong>Big data certification for non-programmers, business analysts, testers, and SQL developers</strong>
        <p>This course will help you understand Hive, along with preparing you to achieve CCA159 (Cloudera Big Data Analyst) certification. 

You will start by delving into Hadoop and its distributed file system. Next, you'll become well-versed with the most common Hadoop commands you'll need to work with Hadoop file systems. Later, you'll explore the Apache Hive, starting with an introduction to it, before moving on to understanding external and managed tables. The next few sections will take you through insert and multi-insert. As you progress, the course will provide insights into different functions such as collection, conditional, Hive string functions, Hive date functions, and mathematical functions. In addition to this, you'll learn to work with different file formats and compressions.  

By the end of this course, you'll have comprehensive knowledge of Hive and Sqoop and gained the skills you need to pass the CCA Data Analyst Exam. 

All code and supporting files are available at - https://github.com/PacktPublishing/CCA-159-Expert-in-Big-Data-Analytics---Advance-Hive-Sqoop</p>
        <h2>What You Will Learn</h2><p>Delve into Hive analysis <br>Get to grips with the ALTER TABLE command <br>Explore joins, multi-joins and Map joins <br>Work with different files such as Parquet and Avro <br>Understand partitioning and bucketing <br>Focus on views <br>Get up to speed with lateral views/explode <br>Delve into window functions - Rank/Dense Rank/Lead/Lag/Min/Max <br>Explore the window specification</p>
        <h2>Audience</h2><p>This course is for anyone who wants to achieve CCA159 Cloudera Big Data Analyst certification or simply learn Hive and Sqoop.</p>
        <h2>Approach</h2><p>This course systematically takes you through Hadoop and Hadoop distributed file systems, while also preparing you for the CCA Data Analyst Exam. You'll even get access to code and supporting files that will help you learn effectively.</p>
        <h2>Key Features</h2><p>Get to grips with Hive and Sqoop for big data analytics and ingestion  * Become well-versed with the essential topics and concepts and achieve CCA159 (Cloudera Big Data Analyst) certification  * Get to grips with data types and complex data types</p>
        
        <h2>About the Author</h2><h3>Navdeep Kaur</h3><p>Navdeep Kaur - Technical Trainer
Navdeep Kaur is a big data professionals with 11 years of industry experience in different technologies and domains. She has a keen interest in providing training in new technologies. She has received CCA175 Hadoop and Spark developer certification and AWS solution architect certification. She loves guiding people and helping them achieves new goals.</p>
        <h2>Course Outline</h2><h4>1. Hadoop Introduction</h4><p></p><br><h4>2. Hive</h4><p></p><br><h4>3. Hive Data Types</h4><p></p><br><h4>4. Hive Functions</h4><p></p><br><h4>5. Hive Join</h4><p></p><br><h4>6. Working with Different File Formats & Compressions</h4><p></p><br><h4>7. Advance Hive</h4><p></p><br><h4>8. Hive Windows Function</h4><p></p><br><h4>9. Sqoop Import</h4><p></p><br><h4>10. Sqoop Import</h4><p></p>

Packt

Database Administration

Big data certification for non-programmers, business analysts, testers, and SQL developers

CCA 159: Expert in Big Data Analytics - Advance Hive and Sqoop

General Admission

Java

Programming

Learn how to build real-world applications using Spring Framework 5 and Spring Boot 2

Getting Started with Spring Boot 2

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

Xpert Learning

PostgreSQL

Build Web Applications with Django and PostgreSQL

<strong>Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.</strong>
        <p>SQL is the language that you can use to interact with one major database type (SQL databases), one that is very widespread in today's world.

Knowing SQL will give you a nice ability and understanding of how to handle data and databases and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.

In this course, you will be learning SQL. We will start by going through some fundamental knowledge such as learning about the relational model, as well as what schemas are, the different data types available, and how database tables are organized. Then we will go ahead and set up our own local Postgres database and populate it with data so that we have data to run queries against. Once our setup is done, we are then ready to jump directly into writing SQL code.

We will start with the basics such as creating databases and tables, inserting, and selecting data, and performing filtering and result order. This way, we can ensure we are comfortable with how the data is laid out and that we feel good performing the basic operations that usually make up all queries. Then we will jump deeper into SQL by learning about aggregations, subqueries, joins, unions, and window functions.

By the end of this course, you should be ready to successfully apply your SQL knowledge in technical interviews and on the job.

All the resources for this course are available at: https://github.com/PacktPublishing/Job-Ready-SQL-in-an-Afternoon</p>
        <h2>What You Will Learn</h2><p>Understand SQL databases<br>Understand the relational model<br>Learn to insert data into SQL databases<br>Extract data from SQL databases<br>Learn about aggregations, subqueries, joins, and unions<br>Learn about different window functions</p>
        <h2>Audience</h2><p>Anyone who wishes to learn about databases, integrate databases into their programs, or learn about SQL databases should take this course. One should be familiar with Python's fundamentals.</p>
        <h2>Approach</h2><p>In this practical, hands-on course, we will start with the fundamentals, such as building databases and tables, adding and choosing data, and performing filtering and result ordering. Then, by studying aggregations, subqueries, joins, unions, and window functions, we will dive even further into the world of SQL.</p>
        <h2>Key Features</h2><p>Write complex queries to perform tasks as required in technical interviews or on the job * A hands-on course, designed for complete beginners * Cover different self-learning exercises to improve your query-writing skills</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Job-Ready-SQL-in-an-Afternoon</p>
        <h2>About the Author</h2><h3>Maximilian Schallwig</h3><p>Maximilian Schallwig is a data engineer and a proficient Python programmer. He holds a bachelor's degree in physics and a master's degree in astrophysics. He has been working on data for over five years, first as a data scientist and then as a data engineer. He can talk endlessly about big data pipelines, data infrastructure, and his unwavering devotion to Python.

Even after two unsuccessful attempts in high school, he still decided to learn Python at the University. He cautiously stepped into the realm of data, beginning with a simple Google search for 'what does a data scientist do'.

He was determined to pursue a career in data science to become a data engineer by learning about big data tools and infrastructure design to build scalable systems and pipelines. He enjoys sharing his programming skills with the rest of the world.</p>
        <h2>Course Outline</h2><h4>1. Fundamentals and Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro to Relational Databases</p><p style='margin: 0'>In this video, we will have a quick introduction to Relational databases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Data Types and Schemas</p><p style='margin: 0'>In this video, you will learn about data types and schemas.</p></td></tr><tr><td style='padding: 15px;'><p>3. [Mac] Setting Up a Local PostgreSQL Server</p><p style='margin: 0'>In this video, we will work on setting up a local PostgreSQL server for Mac systems.</p></td></tr><tr><td style='padding: 15px;'><p>4. [Windows] Setting Up a Local PostgreSQL Server</p><p style='margin: 0'>In this video, we will work on setting up a local PostgreSQL server for Windows systems.</p></td></tr><tr><td style='padding: 15px;'><p>5. [Mac] SQL Editor Postico</p><p style='margin: 0'>In this video, we will cover SQL Editor Postico for Mac.</p></td></tr><tr><td style='padding: 15px;'><p>6. SQL Editor DataGrip</p><p style='margin: 0'>In this video, we will explore SQL Editor DataGrip.</p></td></tr><tr><td style='padding: 15px;'><p>7. SQL Editor CLI (Command Line Interface)</p><p style='margin: 0'>In this video, we will explore SQL Editor CLI (Command Line Interface).</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating and Removing a Database</p><p style='margin: 0'>In this video, you will learn how to create and remove a database.</p></td></tr></tbody></table><br><h4>2. Databases, Tables, and Basic Queries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating Schemas</p><p style='margin: 0'>In this video, you will learn how to create schemas.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating Tables</p><p style='margin: 0'>In this video, you will learn how to create tables.</p></td></tr><tr><td style='padding: 15px;'><p>3. Altering Tables</p><p style='margin: 0'>In this video, you will learn how to alter tables.</p></td></tr><tr><td style='padding: 15px;'><p>4. Enumerated Types</p><p style='margin: 0'>In this video, you will learn about Enumerated types.</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting Values</p><p style='margin: 0'>In this video, you will learn how to insert values.</p></td></tr><tr><td style='padding: 15px;'><p>6. Running an SQL Script</p><p style='margin: 0'>In this video, you will learn how to run an SQL script.</p></td></tr><tr><td style='padding: 15px;'><p>7. Reading Data</p><p style='margin: 0'>In this video, you will learn how to read data.</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating Tables Using Query Results</p><p style='margin: 0'>In this video, you will learn how to create tables using query results.</p></td></tr><tr><td style='padding: 15px;'><p>9. Aliases and Ordering</p><p style='margin: 0'>In this video, you will learn about aliases and ordering.</p></td></tr></tbody></table><br><h4>3. Conditionals and Arithmetic</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Conditional Filtering Direct Comparisons</p><p style='margin: 0'>In this video, we will cover conditional filtering direct comparisons.</p></td></tr><tr><td style='padding: 15px;'><p>2. Conditional Filtering Grouped Comparisons</p><p style='margin: 0'>In this video, we will cover conditional filtering grouped comparisons.</p></td></tr><tr><td style='padding: 15px;'><p>3. Joining Conditionals</p><p style='margin: 0'>In this video, we will cover joining conditionals.</p></td></tr><tr><td style='padding: 15px;'><p>4. Negating Conditionals</p><p style='margin: 0'>In this video, we will cover negating conditionals.</p></td></tr><tr><td style='padding: 15px;'><p>5. Filtering Null Values</p><p style='margin: 0'>In this video, we will cover filtering null values.</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating New Columns and Arithmetic</p><p style='margin: 0'>In this video, you will learn how to create new columns and arithmetic.</p></td></tr><tr><td style='padding: 15px;'><p>7. Datatype Conversions</p><p style='margin: 0'>In this video, we will cover datatype conversions.</p></td></tr><tr><td style='padding: 15px;'><p>8. Logic Statements</p><p style='margin: 0'>In this video, we will cover the logic statements.</p></td></tr></tbody></table><br><h4>4. Dates, Times, and Manipulating Data</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Manipulating Strings</p><p style='margin: 0'>In this video, we will cover manipulating strings.</p></td></tr><tr><td style='padding: 15px;'><p>2. String Positional Information</p><p style='margin: 0'>In this video, we will cover string positional information.</p></td></tr><tr><td style='padding: 15px;'><p>3. String Subsets and Concatenations</p><p style='margin: 0'>In this video, we will cover string subsets and concatenations.</p></td></tr><tr><td style='padding: 15px;'><p>4. String Replacements</p><p style='margin: 0'>In this video, we will cover string replacements.</p></td></tr><tr><td style='padding: 15px;'><p>5. Date and Time</p><p style='margin: 0'>In this video, we will cover date and time.</p></td></tr><tr><td style='padding: 15px;'><p>6. Date and Time Intervals</p><p style='margin: 0'>In this video, we will cover date and time intervals.</p></td></tr><tr><td style='padding: 15px;'><p>7. Comments</p><p style='margin: 0'>In this video, we will cover comments.</p></td></tr><tr><td style='padding: 15px;'><p>8. Aggregation Functions</p><p style='margin: 0'>In this video, we will cover aggregation functions.</p></td></tr><tr><td style='padding: 15px;'><p>9. Grouping and Filtering Aggregations</p><p style='margin: 0'>In this video, you will learn how to group and filter aggregations.</p></td></tr></tbody></table><br><h4>5. Joins, Unions, and Subqueries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Inner Joins</p><p style='margin: 0'>In this video, we will cover inner joins.</p></td></tr><tr><td style='padding: 15px;'><p>2. Left, Right, and Outer Joins</p><p style='margin: 0'>In this video, we will cover left, right, and outer joins.</p></td></tr><tr><td style='padding: 15px;'><p>3. Self Joins</p><p style='margin: 0'>In this video, we will cover self joins.</p></td></tr><tr><td style='padding: 15px;'><p>4. Unions</p><p style='margin: 0'>In this video, we will cover unions.</p></td></tr><tr><td style='padding: 15px;'><p>5. Subqueries</p><p style='margin: 0'>In this video, we will cover subqueries.</p></td></tr><tr><td style='padding: 15px;'><p>6. CTEs</p><p style='margin: 0'>In this video, we will cover CTEs (Common Table Expressions).</p></td></tr></tbody></table><br><h4>6. Window Functions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Window Functions and Aliases</p><p style='margin: 0'>In this video, we will cover Window functions and aliases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Row Numbers and Ranks</p><p style='margin: 0'>In this video, we will cover row numbers and ranks.</p></td></tr><tr><td style='padding: 15px;'><p>3. Using Other Rows with Window Functions</p><p style='margin: 0'>In this video, you will learn how to use other rows with Window functions.</p></td></tr><tr><td style='padding: 15px;'><p>4. NTiles</p><p style='margin: 0'>In this video, we will cover NTiles.</p></td></tr><tr><td style='padding: 15px;'><p>5. Understanding Query Performance</p><p style='margin: 0'>In this video, we will understand query performance.</p></td></tr></tbody></table><br><h4>7. Exercises</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Exercise 1</p><p style='margin: 0'>In this exercise video, we will practice understanding a new database, as we may not always be the creator of the database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Exercise 2</p><p style='margin: 0'>In this exercise video, we will work on data filtering for easier analysis.</p></td></tr><tr><td style='padding: 15px;'><p>3. Exercise 3</p><p style='margin: 0'>In this exercise video, we will work on data preparation so that we have clean data to work with.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 4</p><p style='margin: 0'>In this exercise video, we will find out if there are any customers who purchased a track more than once.</p></td></tr><tr><td style='padding: 15px;'><p>5. Exercise 5</p><p style='margin: 0'>In this exercise video, we will find out how much people from each country spent on tracks in total.</p></td></tr></tbody></table>

Database Programming

Database

Python

Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.

Job-Ready SQL in an Afternoon

<strong>Explore the Apache Kafka ecosystem and architecture, and learn client API programming in Java</strong>
        <p>This course is designed to get you up and running with the fundamentals and the working of Apache Kafka with the help of practical examples. You will also delve into client API programming in Java.  As you progress, you will not only cover the Apache Kafka stack, but also the architecture of Kafka components and Kafka client APIs (Producers and Consumers). The course will even guide you on how to apply the knowledge you've gained through the course to create efficient Kafka programs in Java.
This course is based on Apache Kafka 2.x. All the source code and examples used in this course on Apache Kafka 2.3 open-source distribution have been tested. Several examples in this course also make use of the Confluent Community Version of Kafka. The course will focus on the Confluent Community Version to explain and demonstrate functionalities that are only available in the Confluent Platform, such as Schema Registry and Avro Serdes.
This course will be making extensive use of IntelliJ IDEA as the preferred development IDE. However, based on your prior experience, you should be able to work with any other IDE designed for Java application development.
Although the course will be using Apache Maven as the preferred build tool, based on your prior experience, you should be able to use any other build tool designed for Java applications.
In addition to this, the course will use Log4j2 to teach you industry-standard log implementation in your applications.
This course is fully example-driven and several examples will be created in the class.
By the end of this course, you will have gained the skills you need to confidently build Kafka programs in Java.

All the codes and supporting files are available at-
https://github.com/PacktPublishing/Apache-Kafka-for-absolute-beginners</p>
        <h2>What You Will Learn</h2><p>Delve into the multi-node Confluent Community of Kafka<br>Discover the Kafka Storage architecture<br>Gain insights into the Kafka Cluster architecture<br>Understand Kafka Consumer API programming in Java<br>Get up to speed with JSON and AVRO Serialization</p>
        <h2>Audience</h2><p>This course is designed for software engineers, solution architects, and managers looking to implement Kafka and solve real-time stream processing problems. Architects who are not directly involved in Kafka implementation or anyone who is looking to implement Kafka Streams will also find this course helpful. This course is designed for both beginner and intermediate-level Apache Kafka users.</p>
        <h2>Approach</h2><p>This course features several working examples that will help you effectively apply the knowledge you gain through the course.</p>
        <h2>Key Features</h2><p>Get to grips with the Apache Kafka ecosystem and components * Delve into Kafka Producer API programming in Java</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/apache-kafka-for-absolute-beginners</p>
        <h2>About the Author</h2><h3>Prashant Kumar Pandey</h3><p>Prashant Kumar Pandey is passionate about helping people learn and grow in their careers by bridging the gap between their existing and required skills. In his journey to fulfill this mission, he is authoring books, publishing technical articles, and creating training videos to help IT professionals and students succeed in the industry. He is also the founder, lead author, and chief editor of the Learning Journal portal that has been providing various skill development courses, training sessions, and technical articles since 2018.</p>
        <h2>Course Outline</h2><h4>1. Kafka Ecosystem - The Big Picture</h4><p></p><br><h4>2. Apache Kafka - Getting Started</h4><p></p><br><h4>3. Apache Kafka - Storage Architecture</h4><p></p><br><h4>4. Apache Kafka - Cluster Architecture</h4><p></p><br><h4>5. Kafka Producer Internals</h4><p></p><br><h4>6. Advanced Kafka Producers</h4><p></p><br><h4>7. Types and Serialization</h4><p></p><br><h4>8. Micro Project - Summing Up the Producer</h4><p></p><br><h4>9. Kafka Consumers</h4><p></p><br><h4>10. Where to go Next</h4><p></p>

Apache Kafka

Big Data

Kafka

Explore the Apache Kafka ecosystem and architecture, and learn client API programming in Java

Apache Kafka for Absolute Beginners

Through this course, you will learn how to arrange Kafka a producer and consumer and Kafka Streams and Connectors accurately. You will also gain the skills needed to coordinate Kafka with existing application stages and to pass the Apache Kafka certification exam.

Apache Kafka A-Z with Hands-On Learning

<strong>This advanced course created by data analysts who use Alteryx daily while working with their clients teaches data cleansing and manipulation, working in databases, apps, and macros, and breaks down Alteryx's latest product, Alteryx Intelligence Suite, which includes ML tools that introduce individuals to the world of AI</strong>
        <p>Alteryx provides a platform for data preparation, blending, and advanced analytics. The Alteryx platform allows users to access, cleanse, and integrate data from various sources, and perform statistical analysis, predictive modeling, and geospatial analysis. Alteryx offers a range of tools and integrations with other software platforms, including Tableau, Snowflake, and Microsoft Azure for users to easily share data and insights across different teams and applications.

The course begins with an introduction to Alteryx and its features and capabilities. You will also learn about its tools and uses. We will then advance to learning about using multiple files and Calgary, sampling data, and using wild matches and data cleansing, manipulation, binning, and grouping. We will explore how to use RegEx (regular expressions) and parse XML. We will work with In-Database and blend, select, and summarize data. You will learn about macros and using iterative and batch macros and customizing apps and macros. Finally, we will explore machine learning and the Alteryx Intelligence Suite.

Upon completion of the course, you will be able to independently handle data cleansing and manipulation, working in databases, apps, and macros, and acquire skills needed to pass Alteryx's certification as well as on-job skills needed to become data analytic experts.</p>
        <h2>What You Will Learn</h2><p>Learn data cleansing, manipulation, binning, and grouping<br>Understand how to use RegEx (regular expressions) and parse XML<br>Work with In-Database and blend, select, and summarize data<br>Learn about apps and macros, understand app errors and conditions<br>Customize apps and macros and use iterative and batch macros<br>Learn about machine learning and the Alteryx Intelligence Suite</p>
        <h2>Audience</h2><p>This advanced course is designed for individuals with beginner- to intermediate-level knowledge of Alteryx who are looking to build upon those skills. The prerequisites for the course would include an intermediate to advanced understanding of Excel, which would be useful while learning the concepts of the course.</p>
        <h2>Approach</h2><p>This course is designed to be delivered over video-led, high-definition training with concepts being delivered over a classroom-style tutorial and drawing-board experience. The course includes multiple quizzes and exercises to help learn the topics and concepts comprehensively.</p>
        <h2>Key Features</h2><p>Learn about Alteryx on data cleansing, manipulation, working in databases, apps, and macros * Acquire skills needed to pass Alteryx's certification or to become data analytics experts * Explore Alteryx's Intelligence Suite, with ML tools that introduce you to the world of AI</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Alteryx-Advanced</p>
        <h2>About the Author</h2><h3>Simon Sez IT</h3><p>Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.</p>
        <h2>Course Outline</h2><h4>1. Data Cleansing & Manipulation</h4><p></p><br><h4>2. Working in Database</h4><p></p><br><h4>3. Apps and Macros</h4><p></p><br><h4>4. Intelligence Suite</h4><p></p><br><h4>5. Exercises and Course Close</h4><p></p>

Data Visualization

This advanced course created by data analysts who use Alteryx daily while working with their clients teaches data cleansing and manipulation, working in databases, apps, and macros, and breaks down Alteryx's latest product, Alteryx Intelligence Suite, which includes ML tools that introduce individuals to the world of AI

Alteryx Advanced

<div>
	<h3><b>Course Overview</b></h3>
<p><span>The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this</span><b> Microsoft SQL Server Development </b><span>course and boost the quality of your software.</span></p>
<p><span>This</span><b> Microsoft SQL Server Development </b><span>course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management.</span></p>
<h3><b>Learning Outcomes</b></h3>
<ul>
<li><span>Learn how to use Microsoft SQL management studio </span></li>
<li><span>Familiarize with basic database design </span></li>
<li><span>Learn how you can use select statements </span></li>
<li><span>Be able to insert delete or update data into data tables</span></li>
<li><span>Learn about the best practices for database development </span></li>
<li><span>Create relationships among multiple tables </span></li>
<li><span>Learn how you can use foreign keys </span></li>
<li><span>Be able to create Complex database objects</span></li>
<li><span>Understand how to backup and restore database</span></li>
</ul>
<h3><b>Who is this course for?</b></h3>
<p><span>This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your <strong>Microsoft SQL server development</strong>.</span></p>
<h3><b>Entry Requirement</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Certification</b></h3>
<ul>
<li><span>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry-leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path</b></h3>
<p><strong>Microsoft SQL Server Development</strong><span> is a useful qualification to possess and would be beneficial for any related profession or industry such as:</span></p>
<ul>
<li><span>Software Engineer </span></li>
<li><span>Web Developers </span></li>
<li><span>Data Security Officers </span></li>
<li><span>Database Administrators </span></li>
<li><span>Database Developers</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to SQL Server and Databases</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Install SQL Server Express</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Manipulating Tables and Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connect to Database Instance and Create a Database</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop or Remove Database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database Table?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create an SQL Database Table</td>
					<td> </td>
					<td><span><i></i> 00:32:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with Management Studio</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Select Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Advanced Select Queries Part 1</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Relationships and Foreign Keys</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Relationships, Foreign Keys and Normalization</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Relationship in SQL Server</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Records in Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Run Queries on Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left, Right and Full Joins</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Group By and Aggregate Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Grouping Data using SQL GROUP BY Clause</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL AVG Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL COUNT Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL MAX and MIN Aggregate Functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL SUM Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced SQL Server Objects and Concepts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Manage Views</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Scalar Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inline Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multi Statement Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored Procedures</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Table Triggers</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Scripting, Backup and Restore</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Database Design & Development

Microsoft Certification

Microsoft SQL Server

Microsoft SQL

SQL Server

Microsoft AZ-303

Microsoft SQL Server Development

<strong>This course will enable you to master Docker fundamentals that are required for Spring Boot developers. You'll learn the essential concepts needed to create Dockerfiles for your projects using Docker, Docker Compose, Volumes and various Docker commands. You will launch multiple Docker containers for your microservices that will communicate with each other.</strong>
        <p>Docker is an open-source tool to package your applications and everything they need as containers. You can then use these containers on your laptop, in testing, stage, and all the way to production, which could be on the cloud or servers within your organization.

This course starts with the basics of AWS EC2, which we will use to launch Linux instances to install and use Docker. You will master all the fundamentals of Docker such as Docker layers, networking, volumes, and bind mounts. You will learn how to launch different types of containers and master various Docker commands in the process. You will create a Docker hub account and learn how to push your images to the Docker hub as well.

You will create two Spring Boot microservice restful applications that will use each other. You will create Docker files for these two projects using Visual Studio Code IDE. You will launch a MySQL container that will be used by your microservice containers. You will learn how to access the applications running in the containers from your local machines. You will then use Docker Compose to launch multiple containers in one shot. You will also master what Docker Swarm is and how to use it.

Add the resources for this course are available at https://github.com/PacktPublishing/Docker-for-Java-and-Spring-Boot-Developers</p>
        <h2>What You Will Learn</h2><p>Use various Docker commands to pull images and launch containers<br>Learn how Docker networking works<br>Use Docker volumes and bind mounts and know the differences<br>Dockerize your Spring Boot microservice applications<br>Use Docker Compose to launch multiple containers in one shot<br>Learn the fundamentals of Docker Swarm </p>
        <h2>Audience</h2><p>Experienced Java developers who want to learn Docker and use it on their projects. Spring Boot developers who want to understand how Docker works and want to create Docker files and Docker Compose files to Dockerize their projects.</p>
        <h2>Approach</h2><p>With the help of simple narration, real-time examples, and interesting activities, this course helps you master the fundamentals of Docker that are needed to create and Dockerize Spring Boot microservice applications.</p>
        <h2>Key Features</h2><p>Master the fundamentals of Containerization and Docker * Use Docker networks, volumes, and various Docker commands * Create Dockerfiles and Docker Compose files to Dockerize your Spring Boot projects</p>
        
        <h2>About the Author</h2><h3>Bharath Thippireddy</h3><p>Bharath Thippireddy is an entrepreneur, software architect, and public speaker who has trained over 350,000 students across the globe. He is an Oracle certified developer, web component developer, business component developer, and web services developer who loves learning new things in technology and personal development, and sharing them on his website and YouTube channel.

He has mentored students in classroom training as well as in the corporate world in India and USA and has spoken on technical topics at several Agile conferences. While in India, he volunteers to teach interviews and soft skills at Vivekananda Kendra.</p>
        <h2>Course Outline</h2><h4>1. Introduction and AWS Basics</h4><p></p><br><h4>2. Software Setup For Micro Services</h4><p></p><br><h4>3. Create Micoservices</h4><p></p><br><h4>4. Docker</h4><p></p><br><h4>5. Dockerize Micro Services</h4><p></p><br><h4>6. Docker Compose</h4><p></p><br><h4>7. Docker Swarm</h4><p></p>

Web Development

MySQL

This course will enable you to master Docker fundamentals that are required for Spring Boot developers. You'll learn the essential concepts needed to create Dockerfiles for your projects using Docker, Docker Compose, Volumes and various Docker commands. You will launch multiple Docker containers for your microservices that will communicate with each other.

Docker for Java and Spring Boot Developers

<strong>A beginner's guide to mastering real-time stream processing using Apache Kafka and Kafka Streams API</strong>
        <p>If you want to understand the concept of stream processing, this course is for you. Using Kafka, the course will help you get to grips with real-time stream processing and enable you to apply that knowledge to learn Kafka programming techniques.
This course uses the Kafka Streams library available in Apache Kafka 2.x. All the source code and examples on Apache Kafka 2.3 open-source distribution have been tested. You'll understand and explore Confluent Platform functionalities such as Schema Registry and Avro Serdes using the Confluent Community Version. This course makes extensive use of IntelliJ IDEA and Apache Maven as the preferred development IDE. You'll leverage Log4J2 and JUnit5 for industry-standard log implementation in your application and implementing unit test cases, respectively.

The code bundle is available at https://github.com/PacktPublishing/Apache-Kafka---Real-time-Stream-Processing-Master-Class
</p>
        <h2>What You Will Learn</h2><p>Learn Apache Kafka fundamentals and Kafka Architecture<br>Understand how to create streams using the Kafka Producer APIs<br>Design, develop, and test real-time stream processing applications using the Kafka Streams library<br>Get well-versed with the Kafka Streams architecture, Streams DSL, and the Processor API<br>Support microservice architecture and implement interactive queries in Kafka Streams<br>Explore serializing and deserializing and work on JSON and AVRO messages</p>
        <h2>Audience</h2><p>The Kafka Streams - Real-time Stream Processing course is for software engineers looking to develop a stream processing application using the Kafka Streams library. This course will also help Java programmers who want to learn everything necessary to start implementing real-time streaming applications using Apache Kafka. Data architects and data engineers responsible for designing and building the organization's data-centric infrastructure will benefit from this course.</p>
        <h2>Approach</h2><p>The course uses a progressive approach to teach a complex subject. It contains some fully example-driven sections to help you grasp key concepts easily.</p>
        <h2>Key Features</h2><p>Design, develop, and test real-time stream processing applications using Kafka Streams * Explore the Kafka Streams architecture, Streams DSL, and exactly-once processing in Apache Kafka * Autogenerate Java Objects from JSON and AVRO Schema definition</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Apache-Kafka---Real-time-Stream-Processing-Master-Class</p>
        <h2>About the Author</h2><h3>Prashant Kumar Pandey</h3><p>Prashant Kumar Pandey is passionate about helping people learn and grow in their careers by bridging the gap between their existing and required skills. In his journey to fulfill this mission, he is authoring books, publishing technical articles, and creating training videos to help IT professionals and students succeed in the industry. He is also the founder, lead author, and chief editor of the Learning Journal portal that has been providing various skill development courses, training sessions, and technical articles since 2018.</p>
        <h2>Course Outline</h2><h4>1. Before you Start</h4><p></p><br><h4>2. Introduction to Real-time Streams</h4><p></p><br><h4>3. Enter the world of Apache Kafka</h4><p></p><br><h4>4. Creating Real-time Streams</h4><p></p><br><h4>5. Enter the Stream Processing</h4><p></p><br><h4>6. Foundation for Real Life Implementations</h4><p></p><br><h4>7. States and Stores</h4><p></p><br><h4>8. KTable - An Update Stream</h4><p></p><br><h4>9. Real-time Aggregates</h4><p></p><br><h4>10. Timestamps and Windows</h4><p></p><br><h4>11. Joining Streams and Tables</h4><p></p><br><h4>12. Testing Streams Application</h4><p></p><br><h4>13. Interactive Query and Micro-Service Responses</h4><p></p><br><h4>14. Appendix</h4><p></p>

A beginner's guide to mastering real-time stream processing using Apache Kafka and Kafka Streams API

Apache Kafka - Real-time Stream Processing (Master Class)

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

Nexus Human

Computing Skills

Data Skills

Trainers Course

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

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

Course Cloud

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

CCA 159: Expert in Big Data Analytics - Advance Hive and Sqoop

By Packt

Getting Started with Spring Boot 2

By Packt

Build Web Applications with Django and PostgreSQL

By Xpert Learning

Job-Ready SQL in an Afternoon

By Packt

Apache Kafka for Absolute Beginners

By Packt

Apache Kafka A-Z with Hands-On Learning

By Packt

Alteryx Advanced

By Packt

Microsoft SQL Server Development

By John Academy

Docker for Java and Spring Boot Developers

By Packt

Apache Kafka - Real-time Stream Processing (Master Class)

By Packt