Welcome to Data Coaching, your go-to destination for all things data analytics and data science!
📊🔍 Dive into the world of numbers with our engaging tutorials, where we break down complex concepts into digestible bites. Whether you're a beginner or an experienced professional, our content is tailored to enhance your skills and keep you updated on the latest trends in the industry. Stay ahead of the curve with insightful interviews from experts, providing valuable insights and tips for acing your data-related interviews. Subscribe now for a data-driven journey that will transform your career! 🚀💻 #DataAnalytics #DataScience #CareerAdvancement
Пікірлер
Excellent
Mam waiting for next video Plzz mam course fulla complete paniirunga
Thank u mam.engala Mari house wife Mala.pay Pani course join pandrathu difficult mam... Thanks a lot mam...your videos so useful for me.i
35:15 H22 CELL 99 tha mam varuthu athuvum select aairuku neenga intha method pannathu konjam propera select aagala mam table la
Great effort in Tamil thanks for the effort
Akka fulla complete panniruvingala
Hello mam.. Thank you so much. am watching your videos from UK. it is very useful. 🤝👏
Thanks mam.❤.. Kindly explain with some example mam.. When we use these concept as a data analyst (ex-real time work )
😊easy to understand 😊
Hai mam,i m 2020 passout after kojam break agiduchu ,enakum vellai keidaikuma
7:33 go to : reference kekuthu ka
Mam..❤❤thanks can understand easy... One more request..as a data analyst ah , intha functions ah epadi,ethuku use pandranga..nu DA..example oda solli thaaanga mam... Please...❤❤❤
Sister Data Analysis job ku ML knowledge theva illaya and maths knowledge like Algebra,Probality
Libreoff calc use panlama sis ?
Very usefull mam😊
mam, thankyou very much
Thanks a lot
Tq mam
Mam enaku hard code panropa matum error varuthu
Can we use Tree, Pareto, etc in the interactive Dashboard and can these charts be linked by reports connection?
CREATE TABLE customer(accno number(10) primary key, custname varchar2(20), address varchar2(30), acctype varchar2(8), balanceamt number(12)); If I run this it shows an error only in this postgrees software ? If I run this in run SQL command line it creates table. Please reply mam
The SQL code you provided for creating a table has a few issues, particularly with the data types. Specifically, varchar2 and number data types are not correctly used in the syntax for most SQL databases. the correct code is: CREATE TABLE customer ( accno NUMBER(10) PRIMARY KEY, custname VARCHAR2(20), address VARCHAR2(30), acctype VARCHAR2(8), balanceamt NUMBER(12) ); Try this
Now also error mam It came Number does not exist
@@mrplant6712 CREATE TABLE customer ( accno INT(10) PRIMARY KEY, custname VARCHAR(20), address VARCHAR(30), acctype VARCHAR(8), balanceamt DECIMAL(12, 2) ); Try this sir, This error is likely because the SQL dialect you're using does not support the NUMBER type as expected.
Am also waiting for the same.
Will continue
Really superb Explanation & strong technical skills . Great Explanation in Tamil Thank you for your valuable support to make more Data Analytics Engineer.
Thanks and welcome sir
Mam can u create a whatsapp group...bcz that can help for our students ..if we have some doubts how can i clear?
Soon will have one community sir, as of now ask in comment in am replying all comments then ask me in instagram sir
Mam data analysis job ku diploma student eligible la mam
Ya sir text me on instagram I will give more information, link of instagram is given in description
Intha excel 365 ithu 2007 version laptop la accept aguma mam
In data analyst role coding is main ?
dataset for practice is not relevant
I will check on that mam, or else mail me at [email protected] with name of data set I will share you
Or else you can check in day 6 or 7 ie before or after class may be u will get
Super mam 80 video vaiyum vedama mattum potruga...romba use full ahh iruku
Sure sir
Hi.mam..trigger error show aguthu mam...am using sql...not postgre...what to do??
Are u using mysql
Sister regular 80 days videos update pannunga
Okay sir
Dashboard la charts insert panum bodhu, thani thaniyaa format pandrathuku bathila formal painter pannalaana madam? Athu work aagumaa?
Ya sir it will work, of course that's the easy way
Hello ma'am I tried to import data into SQL it's coming as failed what to do maam
If you're encountering a failure when importing data into SQL, here are a few quick steps to troubleshoot: Check File Format: Ensure the file format (CSV, Excel, etc.) is compatible with your SQL database. Review Error Message: Look at the error message for clues about what's going wrong. Verify Data Types: Make sure the data types in your file match the SQL table schema. Inspect Data for Issues: Look for any inconsistencies or errors in your data (e.g., missing values, incorrect formats). If you provide more details, I can give more specific advice!
I don't have that version in my laptop mam what can I do mam but still I learned much information from ur channel tq so much mam🎉❤
welcome
Mam ithula 3 or 4 columns la blank cells iruku athu Delete sheet rows kudukanuma ila vera epdi handle panrathu
f you have 3 or 4 columns with blank cells in Excel, here are two ways to handle them before importing the data into SQL: Delete Rows with Blank Cells: Select the entire dataset. Go to Home > Find & Select > Go To Special. Choose Blanks and click OK. Right-click on any of the selected blank cells and choose Delete. Choose Entire Row and click OK. Fill Blank Cells: If you prefer not to delete rows, you can fill blank cells with a placeholder (e.g., "N/A"): Select the entire dataset. Press Ctrl+H to open the Find and Replace dialog. Leave the Find what field empty and enter your placeholder in the Replace with field. Click Replace All.
@@DataCoaching Thanks for your explaination mam
maam I need excel course only so it is possible to get the Excel course
No mam as of now we don't have that option, we provide full course
Thanks mam❤
Most welcome sir
Run sql command line software use pannalama ? For your class? Please reply
Yes, you can use SQL command line software to run SQL commands.
Mam i have one what is different between Data science and data analytics
Data science involves using algorithms, machine learning, and statistical methods to extract insights from data. It's about building models and making predictions. Data analytics focuses on examining data sets to find trends, patterns, and insights. It's more about interpreting existing data to make informed decisions. In summary: Data Science: Creating models and predictions. Data Analytics: Analyzing data to find insights and inform decisions.
Thank u mam❤.kindly say... in view topic , what is file detail...?? Pls say clearly
I didn't get your question explain me clearly mam, In SQL, a "view" is a virtual table based on the result-set of a SQL query. Views contain rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database
Nandrigal pala🥰♥️👌🏻🙏🏻👍🏻
Thank You sir
👍🏻❤
Screenshot epadi mam eduthinha ?
Press window plus print screen
sql practice excel dataset mam?
Will upload soon
Can you say which companies are hiring data analyst freshers ( like product based company)
Here are a few product-based companies that often hire data analyst freshers: Google Microsoft Amazon Apple Facebook (Meta) IBM Intel Adobe Oracle Salesforce These companies frequently have entry-level positions in data analysis and related fields. Checking their careers pages or job boards like LinkedIn and Indeed can provide current openings.
Thank you so much, and further videos eppo upload pannuvinga
Indha ella courses um support panna entha laptop mam vaanganum any guidance for laptop enkita laptop illa so inime tha vanga pore ellame support aagura maathiri oru laptop venum pls reply
Text me on instagram mam
Hi mam , many time try panniten but error showing aguthu.
What's the error
@@DataCoaching syntex error I've many tried mam
code : create table school information (stu_name VARCHAR(20),Roll_num INT)
The error in your SQL code for creating a table in PostgreSQL is the missing underscore in the INFORMATION word. Table names in SQL should be a single identifier without spaces. CREATE TABLE school_information ( stu_name VARCHAR(20), roll_num INT ); Try this if you face any problem command me sir
@@DataCoaching thankyou mam
Great video! Thanks for the awesome content ❤
Welcome sir
How to join ur Master class akka
Hello Aspiring Data Analyst Thank you for your interest in our Data Analytics Masterclass! Our comprehensive program is designed to equip you with the essential skills and knowledge in data analysis, covering topics such as 1) Statistics, 2) MS-Excel , 3) PowerBI, 4) SQL, 5) Tableau, 6) Python, 7) JIRA Tool, 😎 Qlik Sense, 9) Alteryx 10) Usage Of Chat GPT In Data Analysis 11) GitHub Projects We Will Also Train You To Improve Your Profile Online Creditability, Resume Building & Portfolio Website. We Train You For The Interview Preparation & Job Applications Learning Format: Online For more information and to enroll , please visit our website at www.datacoaching.in Best Wishes From Data Coaching
@@DataCoaching thanks