Intro to SQL [Module no. 4]

 What is SQL?

Have you ever heard of SQL? If not, then allow me to clarify.

SQL or "Structured Query Language", is a standardized programming language that is used to manage relational databases and perform various operations on the data in them, it is honestly an easy language to learn. If you understand programming and already know some other languages, you can learn SQL in a few weeks. If you're a beginner, completely new to programming, it can take longer.

Now for a bonus question, should you use SQL? Well it is a better fit for heavy duty or complex transactions because it's more stable and ensure data integrity. You need to ensure ACID compliance. (Atomicity, Consistency, Isolation, Durability) or defining exactly how transactions interact with a database. You don't anticipate a lot of changes or growth, compared to python,
the significant difference between SQL and Python is that SQL is used to access and extract data from a database. At the same time, Python is used to analyze and manipulate data by using regression tests, time-series tests, and other computations. So in the end it really boils down on what type of database you are looking for, so yeah you can choose to us SQL.


Comments

Post a Comment

Popular posts from this blog

INTRODUCTION TO JSON

Image
XML      What is XML? The Extensible Markup Language (XML) is  a simple text-based format for representing structured information: documents, data, configuration, books, transactions, invoices, and much more . It was derived from an older standard format called SGML (ISO 8879), in order to be more suitable for Web use JSON     Moving on to JSON , it is a text-based data format following JavaScript object syntax, which was popularized by Douglas Crockford  Even though it closely resembles JavaScript object literal syntax, it can be used independently from JavaScript, and many programming environments feature the ability to read (parse) and generate JSON.     I s a string whose format very much resembles JavaScript object literal format. You can include the same basic data types inside JSON as you can in a standard JavaScript object  strings, numbers, arrays, booleans, and other object literals. This allows you to construct a data hierarchy. AJAX   AJAX or " Asynchronous JavaScript
Read more

Introduction to Computing Blog

Image
TECHNOLOGY           You can't deny the existence of technology and the fact that it truly improved the way of lifestyle for everyone, despite the downsides and negative effects it holds on the younger generation like gaming addictions.           Looking at the brighter side of the spectrum technology has helped humanity progress in a fast rate, new devices are being produced and sold to the public, advance computers, electrical cars, sophisticated gadgets and so much more helps entertain and assist us in our tasks almost everyday. MUSIC & ENTERTAINMENT           Music and overall entertainment had a huge effect on the lives of people, it keeps us motivated, happy and stable, without it people and society would look and feel a lot different in a more sad and monotone way, devoid of emotion and filled with negativity.            It really is a medium that we as individuals seek to help ease the everyday frustration and sadness we face, in a life of hardship and pain, that is wh
Read more

Activity Quiz (BLOGPOST#3)

Image
a.) If you will become a computer parts/gadgets or any ICT tools, what will you be and why? -  If I were to become an ICT tool, I prefer to be a digital camera, so I see beautiful and amazing sceneries and help users capture and store them, I can be useful in many aspects, taking photos for artistic and business purposes, I'll also be available and easy to use by everyone for their entertainment and hobbies, I can also help preserve memorable moments that are important to the users, so they can always remember the good old days and look forward to more memories to capture in the future. b.) What is the use of computer in your day to day activity? - I use my laptop mostly for my own entertainment, I either play online/offline games, and watch different types of videos varying in content on youtube, or browse the chrome for a website where I can watch anime and read mangas for a whole day. I also use my laptop for other reasons, such as research and educational purposes, not only th
Read more