Database Development and Design Week 7: Lab 6 Walkthrough

Lab 6 instructions: (Copy and paste in your SQL Server)

use G0022211111;

–1 run the follow query. How many records are in the table?

Select *
from Cust_Orders;

–2 run this query below. It will enter 3 new records into your table

insert into Cust_Orders
values (1500, 908132, 665, ‘Cash’, ‘2018-03-08 00:00:00’, ‘Electronics’),
(1501, 876661, 128, ‘Credit Card’, ‘2016-05-18 00:00:00’, ‘Toys’),
(1502, 732027, 785, ‘Check’, ‘2018-03-08 00:00:00’, ‘Furniture’)

–3 run the follow query. How many records are in the table this time?

Select *
from Cust_Orders;

–4 Run the following queries. What happened to Order_ID 1502
begin transaction;

delete from Cust_Orders
where Order_ID = ‘1502’;

select *
from Cust_Orders;

–5 Run the following queries. Now what happened to Order_ID 1502
Rollback;

Select *
from Cust_Orders;

–6 Run question 4 again, this time add a commit statement.
–What happens to Order_ID 1502 now

–7 Try using Rollback. Can you undo the delete statement?

–8 Using question 2 as a guide, insert a new record, order_id =1600
— Run a Select * query to see if the record is in your table

–9 Adding a Begin Transaction statement, insert another row
— This time Order_ID 1601. Run Select * to confirm

–10 Try either a commit or rollback command – What happened?

–11 — Turn the query below into a View
Select s.Stud_NM as [Student Name], s.Start_dt as [Start Date], T.Subject,
t1.name as [Tutor Name]
from Student as s
join Tutoring as t
on s.Stud_ID = t.Student_ID
join tutor as t1
on t.Tutor_ID = t1.Tutor_ID

–12 — Run a query from the view you just created where
——-Subject does not start with the letter G

–Bonus Question—-
–13 — Run a query from the view you just created where
——-tutor name does not end with the letter b

Here are the Excel files needed to create the tables:

Cust-OrdersDownload

Link to lesson with video for uploading Excel files into SQL Server:

What is MLOps (Machine Learning Operations)?

Machine learning has revolutionized the way businesses operate by enabling them to make data-driven decisions. However, building, deploying, and maintaining machine learning models can be a complex and time-consuming process. This is where MLOps comes in – it streamlines the entire machine learning lifecycle and enables organizations to manage their models at scale.

MLOps, short for Machine Learning Operations, is a set of practices, processes, and tools that automate the end-to-end process of building and deploying machine learning models. The goal of MLOps is to bridge the gap between data science and IT operations, enabling teams to collaborate effectively and efficiently.

In this article, we’ll explore the key components of MLOps and how they work together to make machine learning more manageable and scalable.

Photo by Mahdis Mousavi on Unsplash

Data Management

Data is the backbone of any machine learning model, and it’s essential to ensure that it’s clean, properly labeled, and easily accessible. MLOps teams must ensure that data is managed effectively throughout the machine learning lifecycle, from collecting and preprocessing data to selecting appropriate features and training the model.

Model Development

Model development involves building and testing machine learning models using appropriate algorithms and techniques. This process involves selecting the right architecture, training and testing the model, and tuning it to improve accuracy and performance. MLOps teams need to ensure that the models are transparent, interpretable, and easily maintainable.

Deployment and Monitoring

Deploying a machine learning model in a production environment requires a different set of skills and tools than building it. MLOps teams need to ensure that models are deployed in a consistent and repeatable manner, using containerization or virtualization technologies. They must also monitor the performance of the models continuously, detecting and addressing any issues that arise.

Model Management and Maintenance

Once a machine learning model is deployed, it needs to be maintained and updated to ensure that it remains accurate and relevant. MLOps teams must manage the model’s lifecycle, version control, and document changes made to the model. They must also ensure that the models continue to function correctly as new data is introduced or the production environment changes.

Benefits of MLOps

MLOps brings several benefits to organizations that rely on machine learning models, including:

  1. Scalability: MLOps enables organizations to manage machine learning models at scale, making it easier to deploy and manage multiple models across different business units.
  2. Reliability: By ensuring that machine learning models are tested, monitored, and maintained, MLOps helps to improve their reliability, reducing the risk of errors and data breaches.
  3. Efficiency: MLOps automates many of the tasks involved in building and deploying machine learning models, freeing up data scientists and IT teams to focus on more strategic tasks.
  4. Agility: MLOps enables organizations to respond quickly to changing business needs, making it easier to build and deploy new machine learning models as needed.

Conclusion

MLOps is an essential practice for organizations that rely on machine learning to make critical business decisions. By streamlining the machine learning lifecycle and automating many of the tasks involved in building and deploying models, MLOps makes it easier to manage machine learning at scale. With MLOps, organizations can improve the reliability, scalability, and efficiency of their machine learning models, leading to better business outcomes and increased customer satisfaction.