Тёмный
Data Codex
Data Codex
Data Codex
Подписаться
📊 Welcome to Data Codex - Your Gateway to Data!

Unlock the power of data with Data Codex! 🚀 Dive into basics of data engineering, analysis, and science. From foundational knowledge to advanced insights, join our structured learning journey. Real-world applications, community engagement, and practical examples make us unique.

📈 Topics: Data Engineering, Data Analytics, Data Science, Databases and Warehouses.

🔔 Subscribe for the latest! Let's explore the possibilities of data together!

Subscribe now, and let the data-driven journey begin!

Follow me on:

LinkedIn - www.linkedin.com/company/data-codex/

Instagram - instagram.com/datacodex07?igsh=ZnB0dGtmbnExMjds

Git Hub - github.com/Data-Codex
Комментарии
@MahmutAyabakan
@MahmutAyabakan 2 дня назад
Lewis Laura Garcia Elizabeth Lee Charles
@saravanapothi574
@saravanapothi574 14 дней назад
Thank you dude
@thakshinnnss2943
@thakshinnnss2943 18 дней назад
add timestamps bro
@DataCodex-07
@DataCodex-07 18 дней назад
Will update this soon, Thanks for the support. Happy Learning!
@infobursttamil1606
@infobursttamil1606 21 день назад
Bro getting error bro
@DataCodex-07
@DataCodex-07 20 дней назад
Could you please provide more details about the error message you are encountering? Please find the below possibilities of the error Column Mismatch: The columns in the CSV file may not match the columns in the table, either in number or data type. Data Type Incompatibility: The data in the CSV file may not be compatible with the data types expected by the table columns. Constraint Violations: The data may violate table constraints such as primary keys, foreign keys, or unique constraints. Format Issues: The CSV file may have formatting issues, such as incorrect delimiters or inconsistent quoting. Null Values: The CSV file may contain null values or empty fields that are not allowed by the table schema. File Encoding: The encoding of the CSV file may not match the expected encoding, leading to data misinterpretation. File Path and Permissions: Issues with the file path or file access permissions can prevent the bulk insert operation from reading the CSV file. It would be helpful if you could provide more detailed information about the error you are encountering.
@infobursttamil1606
@infobursttamil1606 23 дня назад
Bro CSV or Excel files eppadi add panrathu nu video podu bro .
@DataCodex-07
@DataCodex-07 23 дня назад
I did already please refer to this Shorts to load CSV data into tables ru-vid.comIZGzDNvhwHU?feature=share Also you are able to load the data from Excel into tables with the help of this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d-0OovGu5c0.html Watch further videos in SQL Server playlist to Master your SQL skills Thanks for the support! Happy Learning
@dineshkrishnamoorthy1358
@dineshkrishnamoorthy1358 24 дня назад
1 2 3 4
@mohammedvahid5099
@mohammedvahid5099 Месяц назад
If u combines series playlist with snowflake and ADF it will very highligjt and its very powerful stuff for data enthusiast bro Any how good video 🎉
@DataCodex-07
@DataCodex-07 29 дней назад
Thank you for your kind words and support regarding the ADF video. I appreciate your suggestion about integrating ADF with Snowflake. I will definitely consider creating content on this topic in the future. Happy learning 🎉!
@LuckyAzher
@LuckyAzher 2 месяца назад
unable to create connection error allow sqldb firewall to acess how to solve please help
@DataCodex-07
@DataCodex-07 2 месяца назад
What are you connecting to: an Azure SQL Database or a SQL Server Database? 1. If it is an Azure SQL Database, please verify that your IP address is permitted in the firewall rules. You can check this by connecting via SSMS or reviewing the firewall rules in the Azure Portal. 2. If you are connecting to a SQL Server Database, ensure that the Self-hosted Integration Runtime (IR) is correctly configured and running, and also verify the authentication type. Please let me know if you have any further questions.
@rajnarayananm7455
@rajnarayananm7455 2 месяца назад
Usefull bro😊
@DataCodex-07
@DataCodex-07 2 месяца назад
Happy learning 🎉
@professor_DJ_010
@professor_DJ_010 2 месяца назад
bhai 97 videos ka playlist tha aapka .. kahan gaya
@TomHolland-wi8vj
@TomHolland-wi8vj 2 месяца назад
I have completed the SQL Server playlist.Thanks for this Scenario based questions, please upload more videos on this.
@DataCodex-07
@DataCodex-07 2 месяца назад
Sure, Thanks for the support! Happy learning
@pradeepvadlakonda007
@pradeepvadlakonda007 3 месяца назад
where can i find script for this question
@DataCodex-07
@DataCodex-07 3 месяца назад
Given the simplicity of these questions, I have refrained from providing the code on GitHub. However, should you find access to the source code beneficial, I am more than willing to accommodate. I can diligently work on compiling the necessary source codes, along with the requisite table creation scripts, and promptly make them available on GitHub. Rest assured, I will include the GitHub link in the description for your convenience. Thank you sincerely for your support! Wishing you a fulfilling journey of learning ahead.
@cs151_subramanianm4
@cs151_subramanianm4 3 месяца назад
Thanks 🎉
@DataCodex-07
@DataCodex-07 3 месяца назад
Happy Learning 🎊
@professor_DJ_010
@professor_DJ_010 4 месяца назад
Plz don't add music..remove music plsssss
@DataCodex-07
@DataCodex-07 4 месяца назад
Dear Professor DJ, as you previously requested, I have significantly reduced the background music in my new videos. However, this particular video is a compilation of older clips, so I am unable to edit the background music in this instance. I will ensure future videos have better audio balance. Thank you for your support and happy learning!
@professor_DJ_010
@professor_DJ_010 4 месяца назад
Please don't add music..it's irritating
@DataCodex-07
@DataCodex-07 4 месяца назад
I apologize for any inconvenience caused by the background music. Thank you for bringing this to my attention-it's helpful to receive your feedback. I will make adjustments to minimize the background music significantly or consider removing it entirely. I appreciate your understanding and wish you a pleasant and productive learning experience!
@Kalai2420
@Kalai2420 4 месяца назад
one doubt,may i know why you aggregate with Name fields? why cant we use ID fields for aggregation?
@DataCodex-07
@DataCodex-07 4 месяца назад
Indeed, it is possible to perform aggregation based on the id column by including it in the select list. You can try several ways!
@Vasiya-yt9ws
@Vasiya-yt9ws 4 месяца назад
Nice thank u pls make more videos on scenario based interview questions and answers on SQL
@Vasiya-yt9ws
@Vasiya-yt9ws 4 месяца назад
Nice approach ples make more on interview scenario based questions thnk u sir
@DataCodex-07
@DataCodex-07 4 месяца назад
Thank you for your interest in the scenario-based questions playlist! I appreciate your support and encouragement. Please feel free to watch the video for detailed explanations and refer to the GitHub repository for the table creation scripts, insert queries, and solutions. I've also included the PowerPoint presentation. Happy learning, and let me know if you have any questions or feedback along the way!
@Vasiya-yt9ws
@Vasiya-yt9ws 4 месяца назад
Thnk u
@shivamdheeman1363
@shivamdheeman1363 4 месяца назад
Brother kya ye sql learning roadmap complete hoga??
@DataCodex-07
@DataCodex-07 4 месяца назад
I have organized playlists on this channel covering topics like data engineering, data analytics, data science, and databases. The first playlist focuses on SQL Server, where I've covered a comprehensive range of SQL-related topics. Moving forward, I plan to delve into data integration and subsequently explore data analysis. I encourage you to complete the SQL Server playlist and practice the questions I've posted on GitHub for each session. Additionally, I'm curating a concise playlist of SQL Server commands. Your continued support and engagement are greatly appreciated as we continue to learn together. Thank you for your ongoing support!
@punithreddy7398
@punithreddy7398 4 месяца назад
What's the best way to master SQL as I am following ur videos regularly but unable to master on hands on any suggestions for mastering this sql
@DataCodex-07
@DataCodex-07 4 месяца назад
It's wonderful to hear that you're an active subscriber who watches all the videos. In addition to watching each video, I kindly encourage you to also attempt the queries provided on GitHub for each day. You can find the GitHub link in the description of each video. By tackling these queries regularly, you'll enhance your mastery of SQL. Moreover, I'm considering creating a separate playlist for scenario-based question-solving sessions. Remember, the journey of learning is continuous, so keep exploring and practicing.
@kavi3424
@kavi3424 5 месяцев назад
Please make the shorts in English
@DataCodex-07
@DataCodex-07 5 месяцев назад
Certainly, I aim to create short videos in Tamil to explain each feature in detail, while I continue to post full-length videos in English.
@Dil.E.Bekhabar
@Dil.E.Bekhabar 5 месяцев назад
Can't look properly your screen is not clear. In this situation people can't enjoy your lacture.
@DataCodex-07
@DataCodex-07 5 месяцев назад
Certainly, I will endeavor to enhance the clarity and ensure the video has a high resolution. Your continued support is greatly appreciated. Thank you.
@ananthsri3164
@ananthsri3164 5 месяцев назад
Total count will be 8 if greater than or equal to condition met
@DataCodex-07
@DataCodex-07 5 месяцев назад
Good effort, but using '>= ALL' returns 5 rows, whereas using '>= ANY' would yield 8 rows. Let's explore this difference further.