--- Insert into Account---
INSERT INTO Account (id, customer_id, card_id, balance) VALUES (1, 1, 1, '1000');
INSERT INTO Account (id, customer_id, card_id, balance) VALUES (2, 2, 2, '100');
INSERT INTO Account (id, customer_id, card_id, balance) VALUES (3, 3, 3, '200');
INSERT INTO Account (id, customer_id, card_id, balance) VALUES (4, 5, 4, '50000');
INSERT INTO Account (id, customer_id, card_id, balance) VALUES (5, 5, 5, '1000000');

select * from Account

---Insert record for Loan table---

INSERT INTO Loan (id, account_id, loan_type_id, amount_paid, start_date, due_date) VALUES (1, 1, 3, '0', '2020-05-18', '2023-05-18');
INSERT INTO Loan (id, account_id, loan_type_id, amount_paid, start_date, due_date) VALUES (2, 5, 1, '0', '2019-08-12', '2021-05-25');
INSERT INTO Loan (id, account_id, loan_type_id, amount_paid, start_date, due_date) VALUES (3, 4, 2, '100', '2019-05-13', '2024-05-14');
INSERT INTO Loan (id, account_id, loan_type_id, amount_paid, start_date, due_date) VALUES (4, 2, 5, '1000', '2018-05-25', '2021-05-21');
INSERT INTO Loan (id, account_id, loan_type_id, amount_paid, start_date, due_date) VALUES (5, 1, 4, '5000', '2020-05-20', '2023-05-07');
select * from Loan

---Insert record for Transaction table----

INSERT INTO [Transaction] (id, account_id, description, amount, date) VALUES (1, 1, 'description 100', 1000.90, '2020-05-18');
INSERT INTO [Transaction] (id, account_id, description, amount, date) VALUES (2, 2, 'description 200', 500.80, '2019-12-07');
INSERT INTO [Transaction] (id, account_id, description, amount, date) VALUES (3, 5, 'description 300', 100.90, '2018-06-30');
INSERT INTO [Transaction] (id, account_id, description, amount, date) VALUES (4, 5, 'description 400', 5060.7, '2020-01-24');
INSERT INTO [Transaction] (id, account_id, description, amount, date) VALUES (5, 5, 'description 500', 500.67, '2018-01-24');

select * from [Transaction]


-----------The End-----------

📊 Exciting news for aspiring Data Scientists! 🚀

Embark on your journey into the realm of data analysis with our latest guide: "SQL For Data Scientists: A Beginner's Guide for Building Datasets for Analysis." 📈💻

In this comprehensive beginner's guide, you'll delve into the fundamentals of SQL, mastering the skills needed to build robust datasets for analysis. Whether you're a seasoned professional looking to enhance your skill set or a newcomer eager to explore the world of data science, this guide is tailored just for you! 🎓✨

Ready to take your first steps towards becoming a data analysis expert? Join us on this exciting adventure! Access the guide now and unlock the secrets of SQL for data scientists. 💡

🔗 Join our Telegram community @coder_baba for more insights, resources, and discussions on data science and programming. Let's learn and grow together! 🌱💬

#DataScience #SQL #BeginnersGuide #DataAnalysis #LearnToCode #DataScienceCommunity #JoinUs #TelegramGroup #CoderBaba #LinkedInLearning

list of essential programming terms without the plugariasum, adorned with emojis:

Array: A data structure that stores a collection of elements of the same type in contiguous memory locations. 📚
Boolean: A data type that represents true or false values. 🔵🔴
Conditional Statement: A statement that executes different code based on a condition. ⚖️
Debugging: The process of identifying and fixing errors or bugs in a program. 🔍🐛
Exception: An event that occurs during the execution of a program that disrupts the normal flow of instructions. ⚠️
Function: A block of code that performs a specific task and can be called multiple times in a program. 🛠
GUI (Graphical User Interface): A visual way for users to interact with a computer program using graphical elements like windows, buttons, and menus. 💻
HTML (Hypertext Markup Language): The standard markup language used to create web pages. 🌐
Integer: A data type that represents whole numbers without any fractional part. 123
JSON (JavaScript Object Notation): A lightweight data interchange format commonly used for transmitting data between a server and a web application. 📝
Loop: A programming construct that allows repeating a block of code multiple times. 🔁
Method: A function that is associated with an object in object-oriented programming. 🎛
Null: A special value that represents the absence of a value. ⚪️
Object-Oriented Programming (OOP): A programming paradigm based on the concept of "objects" that encapsulate data and behavior. 🧱
Pointer: A variable that stores the memory address of another variable. 📌
Queue: A data structure that follows the First-In-First-Out (FIFO) principle. 🚶‍♂️🚶‍♀️
Recursion: A programming technique where a function calls itself to solve a problem. 🔄
String: A data type that represents a sequence of characters. 📝
Tuple: An ordered collection of elements, similar to an array but immutable. 📦
Variable: A named storage location in memory that holds a value. 📦
While Loop: A loop that repeatedly executes a block of code as long as a specified condition is true. 🔁
follow me for more @coder_baba

Learn Apps Development
https://youtu.be/pIUmldMrRqs

If you love this project do comments

Exam AZ-900 Microsoft Azure Fundamentals

Pi is a new digital currency developed by Stanford PhDs, with over 55 million members worldwide. To claim your Pi, follow this link https://minepi.com/coderbaba and use my username (coderbaba) as your invitation code.

Join CoderBaba whatsapp channel for DSA study materials
Data Structures video tutorials
Data Structures and Algorithms: 📊
NCSU - CSC 316 - Data Structures: 🔗
Introduction to Computer Science: 💻
Linear Algebra: 🧮
Introduction to Probability Theory: 🎲
Maths for Big Data and Machine Learning: 📈
Essence of Calculus: 📐
Machine Learning by Andrew Ng: 🤖
Machine Learning by Sentdex: 📊
Machine Learning: 🧠
Machine Learning on Tabular Data: 📊
Natural Language Processing (NLP): 📝
Computer Vision: 👁
Neural Networks for Machine Learning: 🧠
Applied Machine Learning: 🚀
TensorFlow 2.0: 🧠
Data Structures Easy to Advanced Course - Full Tutorial from a Google Engineer: 💼
https://whatsapp.com/channel/0029Va9Vfn29Bb5pXUTn6i30/219

AJAX Control in ASP .Net PDF Notes

🚀 Are you curious about the basics of .NET Technology? Check out this insightful video! 🎥

Whether you're a seasoned developer or just starting your journey in tech, understanding .NET is essential. This video covers fundamental topics such as the .NET Framework, JIT compiler, and more.

Watch the video here: https://youtu.be/aLsDDTpxGSo?si=zCXdFi7DLm1KKJwG

Topics covered include:
⏰ 00:01 Introduction
🔍 00:48 Full Stack Developer
📝 01:53 Course Detailed
💡 03:45 Introduction to .NET Framework
💻 07:55 What .NET Represents
🛠 09:12 What is Framework
🔧 10:30 JIT Compiler
🚫 11:42 What is Not .NET
🔍 12:35 What is DOTNET in ASP.NET
📚 20:48 DotNet Framework

Don't miss out on this opportunity to enhance your .NET skills! Hit like 👍, subscribe to the channel, and share with your friends. Let's learn and grow together! 💪
@coder_baba #coderbaba #coder_baba #dotnet #technology #learning #development #softwareengineering

👉Shopping Website:
https://youtu.be/FuyRWWVx9Ig

Build your own Desktop application using Csharp DotNet with SQL Server
https://youtu.be/pIUmldMrRqs

🎉 Exciting news! 🎉I'm thrilled to announce that I am now live on Topmate! 💻 As a mentor and leader in my field, I'm passionate about giving back to the community and helping others reach their goals. 🙌🏼 Whether you're looking for career advice or expert guidance in your industry, I am here to support you through my Topmate page.
https://topmate.io/coderbaba/
💡 Let's connect and achieve greatness together! #Mentorship #