37. Lab – Example when using the right distributions for your tables Now, just to drive home the concept when it comes to data shuffles, what I’ll do is create our sales fact table again and then create our dimension product tables a couple of times. And we’ll perform a join query between both tables, […]

27. Lab – Transfer data to our SQL Pool So in the Pride chapters, we had gone ahead and built our fact and dimension tables in the SQL database itself. Now we’ll see how to transfer these hazardous tables onto Azure Synapse in our dedicated SQL pool. If I go on to my SQL pools, […]

17. Lab – Loading data into a table – COPY Command – Parquet Now in this chapter, I want to show how you can load data that’s based on the park-based files. So in the last chapter, we saw how we could load data from the log CC file. You can do the same thing […]

1. 3_1- VLAN and Trunking Applications in Campus Network In this section, we are going to talk about VLAN and tracking applications in Compass Networks. Let’s take a look at the overview of Villain. First, VLAN stands for “virtual local area network,” as you know, and each VLAN is one broadcast domain. And as we […]

1. 2_1- Hierarchical Network Design In this section, we are going to talk about hierarchical network design. But first, let’s take a look at the flat network concept. Flat networks are networks in which all computers, servers, and printers are connected together using just one layer of switching. There is no use of subnet inflate. […]

1. 1_1- Basic Switching Concepts Hello everyone. Welcome to the OKL Cisco CCMP Switch Course. The CCMP certification exam is divided into three parts: switch, route, and T-shirt. And we are going to start with the switch part, and this first section will be about the basic switching concepts. We are starting with the hub. […]

1. 5_1- Specialized Maintenance and Troubleshooting Tools In this section, we are going to focus on specialized maintenance and troubleshooting tools. There are three types of troubleshooting tool categories. The first is information gathering tools. Such tools have the ability to analyses and improve network performance or security. Tools that continuously collect the information mentioned […]

1. 4_1- Basic Troubleshooting Commands In this section, we are going to talk about basic shooting commands, and we are starting with filtering the Show IP route output. If you want to filter the Show IP route, you can use the Show IP route, and for example, if you want to check just a specific […]

1. Welcome Congratulations on completing power automate section and first four sections of the course database data base. Security. Power Apps, which included canvas models and portals, and Power Automate Now we are getting into very interesting topics. We’ll talk about “power virtual agents,” which are basically catboats powered by big data, artificial intelligence, and […]

1. Welcome Congratulations on successfully completing Data Wars security! Power Apps. section of the course. Now we’ll come to the power-sharing section of this book. And this is all about reports, charts, and dashboards. And then we will have only AI and ML left and some innovation lectures. So let’s go ahead and talk about […]