Database Management
154 Threads
An introduction to SQL: a beginner's guide
SQL: What are DDL, DML, DQL, DCL and TCL? 🧵👇
Be an SQL Expert in 2023: A roadmap for absolute beginners
50+ SQL Interview Questions ❍ Oracle ❍ MySQL ❍ MariaDB ❍ PostgreSQL ❍ SQL Server ⇩
SQL Commands, explained ❯ DDL ❯ DML ❯ DQL ❯ DCL ❯ TCL ⇩
SQL developers, these 15 topics are the most important. Master these and you are ready to ———
Best Courses to learn SQL in 2023 1. The Complete SQL Bootcamp - https://t.co/tFgVhjD9qq 2. Database [ZTM] - https://t.co/r7HDPE1O5i 3. SQL for Data Science - https://t.co/xORWxPeL...
🛣️ Full Stack Web Development Roadmap Front-End → HTML, CSS, JavaScript ↓ Back-End → Java/C#/PHP/Python/JS* ↓ Database → MySQL/MongoDB* ↓ Integr...
Best Places to Learn SQL in 2023 1. Udemy - https://t.co/tFgVhjD9qq 2. Coursera - https://t.co/xORWxPeLAr 3. Educative - https://t.co/s8aaHQEdHO 4. ZTM Academy - https://t.co/r7HDP...
The 2 most popular ways to store data in any modern application are: 1) SQL 2) NoSQL Here's what they mean in the simplest terms:
SQL Indexing is one of the most important ways of improving a query performance Mostly there're 2 types of Indexes: 1) Clustered Index 2) Non-Clustered Index Here's what it mean...
Practicing is the best way to master SQL. Here are 75+ practice questions:
80+ SQL Interview Questions ❍ Oracle ❍ MySQL ❍ MariaDB ❍ PostgreSQL ❍ SQL Server ⇩
/1 How do you decide which type of database to use? There are hundreds or even thousands of databases available today, such as Oracle, MySQL, MariaDB, SQLite, PostgreSQL, Redis, C...
3 Most Popular Keys in SQL are: 1) Primary key 2) Foreign key 3) Unique key Here're what they mean in the simplest term:
/1 𝐓𝐢𝐦𝐞-𝐒𝐞𝐫𝐢𝐞𝐬 𝐃𝐁 (TSDB) in 20 lines. What is 𝐓𝐢𝐦𝐞-𝐒𝐞𝐫𝐢𝐞𝐬 𝐃𝐁 (TSDB)? How is it 𝐝𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 from Relational DB? https://t.co/fz6n47Zy2c
SQL Guide: 1. Normalisation and ER concepts 2. Be good with queries 2.1 Have a good knowledge of JOINS 2.2 Operators (AND, OR...) 2.3 Data types 2.4 Clauses (Group...
SQL Roadmap for the Backend (or Fullstack) Developer:
SQL: Store Procedure vs Functions 🧵👇
Master SQL JOINS:🧵👇
This thread contains details on how to install the Sakila database into your RDBMS, preferably MySQL, so you can have a database to practice on; Common questions to answer to test...
Day 21 of #60daysOfMachineLearning 🔷 Data Management - Delete Records 🔷 Using the "DELETE FROM" statement, you can delete records from an existing table. Delete any record where...
As a data analyst, most of the data you’d be analyzing isn’t in an Excel spreadsheet like in the online courses. Companies data live in a database and you’d require SQL to intera...
Day 18 of #60daysOfMachineLearning 🔷 Data Management - Reading Database Records 🔷 To get results from a table, you will need to use the select keyword. Select all records from th...