Exsilio Solutions’ Post

🐛 An interesting SQL problem from Ankit Bansal's youtube channel. 🐛 A person begins their journey from a starting point, let's refer it as the source location, and travels through multiple locations before arriving at the final destination. Our goal is to display the source and destination for each person, omitting the intermediate stops along the way. 🐛 DDL script: CREATE TABLE travel_data ( customer VARCHAR(10), start_loc VARCHAR(50), end_loc VARCHAR(50) ); INSERT INTO travel_data (customer, start_loc, end_loc) VALUES ('c1', 'New York', 'Lima'), ('c1', 'London', 'New York'), ('c1', 'Lima', 'Sao Paulo'), ('c1', 'Sao Paulo', 'New Delhi'), ('c2', 'Mumbai', 'Hyderabad'), ('c2', 'Surat', 'Pune'), ('c2', 'Hyderabad', 'Surat'), ('c3', 'Kochi', 'Kurnool'), ('c3', 'Lucknow', 'Agra'), ('c3', 'Agra', 'Jaipur'), ('c3', 'Jaipur', 'Kochi'); 🦋 Expected output: Customer | Source | Destination c1 | London | New Delhi c2 | Mumbai | Pune c3 | Lucknow | Kurnool #DataAnalyst #QueryWriting #SQL

Connects

Ready to launch your career in Data Science?  Enroll now at IT Preneur Nagpur and secure your future with our comprehensive course and job placement support! 🎓💼 Don't miss this opportunity to gain cutting-edge skills and land your dream job. 🟢100% Job Guaranteed 🟢 Day one offer letter 🟢 Zero % EMI Option 🟢 100% Job Placement on Paper 📌𝐉𝐨𝐢𝐧 𝐮𝐬 𝐚𝐭 𝐭𝐡𝐞 𝐈𝐓𝐩𝐫𝐞𝐧𝐞𝐮𝐫 𝐍𝐚𝐠𝐩𝐮𝐫 - 𝐁𝐞𝐬𝐭 𝐈𝐓 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐈𝐧𝐬𝐭𝐢𝐭𝐮𝐭𝐞. Our Courses : 📌 Salesforce Admin Development Lightning 📌Dot Net Full Stack Development 📌JAVA Full Stack Development 📌Business Analyst 📌Business Intelligence Database 📌 Oracle Database Development (SQL, PLSQL) 📌Android Development 📌 Full Stack Software Testing 📌Angular JS Training 📌Python Full Stack Development 📌UI UX Web Designing 📌MERN Stack and MEAN Stack 🌐 Register Now https://lnkd.in/gVBCZ28g ☎️Reach Us 👇  9371937153  📍Serenity, 2nd Floor, Besides SBI Bank, Chhaoni Rd, Sadar, Nagpur #itpreneurnagpur #itpreneur #nagpur #ngp #itp #placementsuccess #itjobs #careerinit #careergrowth #DataScience #BigData #MachineLearning #ArtificialIntelligence #DataAnalysis #DataMining #AI #DeepLearning #DataAnalytics #Python #Statistics #BusinessIntelligence #Analytics #DataVisualization #Programming #DataEngineering #Tech #Technology #DataDriven #PredictiveAnalytics #Coding

Power up your career in the IT sector!🤗 Join ITpreneur Nagpur and unlock a world of opportunities!☘️ Learn from experts, develop in-demand skills, and become a sought-after professional! Don't just dream about a successful career, build it with us!🌟 🟢100% Job Guaranteed 🟢 Day one offer letter 🟢 Zero % EMI Option 🟢 100% Job Placement on Paper 📌𝐉𝐨𝐢𝐧 𝐮𝐬 𝐚𝐭 𝐭𝐡𝐞 𝐈𝐓𝐩𝐫𝐞𝐧𝐞𝐮𝐫 𝐍𝐚𝐠𝐩𝐮𝐫 - 𝐁𝐞𝐬𝐭 𝐈𝐓 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐈𝐧𝐬𝐭𝐢𝐭𝐮𝐭𝐞. Our Courses : 📌 Salesforce Admin Development Lightning 📌Dot Net Full Stack Development 📌JAVA Full Stack Development 📌Business Analyst 📌Business Intelligence Database 📌 Oracle Database Development (SQL, PLSQL) 📌Android Development 📌 Full Stack Software Testing 📌Angular JS Training 📌Python Full Stack Development 📌UI UX Web Designing 📌MERN Stack and MEAN Stack 🌐 Register Now https://lnkd.in/gVBCZ28g ☎️Reach Us 👇  9371937153  📍Serenity, 2nd Floor, Besides SBI Bank, Chhaoni Rd, Sadar, Nagpur #itpreneurnagpur #itpreneur #nagpur #ngp #itp #placementsuccess #itjobs #careerinit #careergrowth #datascience #bigdata #machinelearning #artificialIntelligence #dataanalysis #datamining #AI #deeplearning #dataanalytics #python #statistics #businessIntelligence #analytics #dataVisualization #programming #dataengineering #technology #datadriven #predictiveanalytics #coding

🔍 WHERE vs. HAVING: SQL Showdown! 🔍 👉 The WHERE clause is like a bouncer at the entrance of a nightclub. It checks individual rows before they even get to the party (a.k.a. aggregation). If they don't meet the dress code (conditions), they're out! 👉 HAVING, on the other hand, is the VIP section. It's applied *after* the party (aggregation) has started. Only the groups that meet certain conditions get the velvet rope treatment. 📊 Example: Suppose we're counting addresses in cities. 🏙️ - WHERE: "Show me customers of the following cities - Nagpur, Pune and Mumbai" - HAVING: "Bring me the cities with more than 5 addresses *after* we've grouped them by city." 🤓 Remember: - WHERE filters rows before aggregation (GROUP BY). - HAVING filters groups after aggregations are done. Next time you write SQL, channel your inner detective! 🕵️♀️💡 #SQL #Database #CodingLife #LearnSQL #TechTalk

Hello Connections !! We Collabera Digital #collaberadigital is hiring as MySQL DBA Experience: 5 years Location: Indore #indore #wfo Mandate Skills: Installation and configuration of databases: Install and set up database software, making sure it is properly configured and integrated with our applications. Database maintenance: Monitoring and improving database performance on a regular basis while resolving storage, access, and data quality concerns. Security management: Enforce security measures to safeguard private information from unauthorised access and make sure that data privacy laws are followed. Data migration: Enable seamless data transfer between databases and systems while preserving data integrity. Troubleshooting: To maintain a stable and dependable database environment, quickly locate and fix database-related problems. Performance tuning: Through query optimisation, index management, and other tuning methods, improve the performance of databases. Looking forward for your response: [email protected] Arjun (AJ) Sharma Manoj Rajput Ronak Patel #indorejobs #indore #indorehiring #indorecity #mysqldba #mysql #clustering #performancetuning #tuning #sqloptimatization #optimization

Hello Applicant , Thanks for showing Interest through Linkedin . I'm reaching out to you that might be interested in the below opportunity. If you are comfortable with JD please help me with the information below to process further. Hi Applicant, Job Title : Azure Dot net Developer Location : Kolkata Exp : 3 to 5 Years Notice Period: Immediate to 30 Days Skill : .Net ,C#, Java, SQL ,Azure ,ADF (Kusto) Job Description: 1.Hands on experience in SQL 2.Hands on experience in C#/.Net/ Java 3.Experience in Azure 4.Experience in ADF, Kusto (Azure Data Explorer) 5.Exposure to Big data platforms and technologies like spark, hive, Hadoop,etc.(Good to have) This role will primarily focus on developing and maintaining required tooling, data pipeline and reporting for C E inventory team Responsibilities includes: •Analyze and fix any issues reported by the partners as email or issues submitted as VSO items. •Respond to partner queries related to data published by C E Inventory Team by email and/or updates to VSO items. •Handle Partner communications for outages and data refresh issues based on agreed guidelines. •Analyze, prioritize and implement requirements from all partners using VSO tool. •Design and build services, tools and applications using C# .Net, Spark, Hadoop, Hive, SQL, Kusto, etc. and Azure technologies pertaining to Azure Fleet Management. •Contribute throughout Software development lifecycle (Planning, Implementation, Testing, Documentation, Deployment and maintenance). All tasks are planned, tracked and KPIs are measured using VSO. •Create test plan for data validation testing . Build data pipeline using tools like ADF and other supporting technologies for processing Inventory related data. •Generate business dashboards and reports using Power BI that compiles data from multiple sources. •Continue to keep the business and executive dashboards up to date, by implementing any corrections or improvements needed. •Monitor health of services, tools, applications, data pipeline, ETL jobs and dashboards/reports. •Investigate, troubleshoot, escalate & resolve ICM incidents created by monitors and customers. •Investigate high severity incidents that resulted in application unavailability •Fix any feature bugs and issues reported by stakeholders. •Develop reports that present incident trend, bug trend. •Contribute to technical design documentations, functional specification documentation, spec reviews, code reviews, design, triage, and other project processes. All tasks are planned, tracked and KPIs are measured using VSO. Documents are stored in SharePoint/Wiki. Code is stored in GIT and code is reviewed using MS-Azure tools. •Participate in team sprint planning and execution as specified in the Governance section. Prepare documentation of design, deployment, user guides, trouble-shooting steps. Skills: AZURE-DOTNET Interested candidate can share your CV to [email protected] or 7981798317.

Please spread the word.

Hello Connections, We are #hiring for #SQLDEVELOPER WITH #POWERSHELL_SCRIPT  Location: #Pune, #Mumbai and #Chennai  Experience level: 5 years Must have Skills:[KK] #SQLDevelopment with Stored Procedures, Functions, #triggers, jobs etc- Should have worked in cursors, conditional logics (if/then, Do/while, case when etc)- Should have knowledge on SQL exception management- Handle /Throw errors, log management etc.- Knowledge of Batch insert and update queries.- Rollbackand record abort management. Detailed JD: A good #sqldeveloper who have 5 - 6 years of SQL experience and has experience on working in #powershellscripts. The person will be provided with requirements to pull data from multiple sources or purge data. This is in reference to the amount being credited because of leave absence. We need this person sooner to utilize the money. Should be able to propose and design DB schema depending upon the requirements- Should have hands on experience in writing Stored Procedures, Functions, triggers, jobs etc- Should have worked in cursors, conditional logics (if/then, Do/while, case when etc)- Should have knowledge on SQL exception management- Handle /Throw errors, log management etc.- Knowledge of Batch insert and update queries.- Rollbackand record abort management. Ensure graceful transaction management - Understand RDBMS concept of Primary key, Foreign key, unique key etc- Should be able to write complex queries, joins between multiple tables (typically parent-child tables), rollup the values at parent level, grouping it by common parameters etcSelf driven, Good communication skills, Work independently, Exposure to work with Customer directly If you are interested please share your updated profile at [email protected]

      WE ARE HIRING NOW  Role : PowerBI Developer  Experience : 5 years  Location : Kolkata  Mail id : [email protected]      #powerbidevelopment #powerpivot #dax #azure #aws #dataanalysis #SQL #Tableau #MicrosoftPowerBI     Key Responsibilities: Develop and Design Power BI Reports and Dashboards: Create visually appealing and interactive reports and dashboards using Power BI to provide business insights. Data Modeling: Design and implement effective data models using DAX (Data Analysis Expressions) to meet business requirements. Data Integration: Integrate data from various sources such as SQL databases, Excel, cloud services, and APIs into Power BI. Performance Optimization: Optimize Power BI reports for performance by using best practices in DAX and data modeling. Power Apps Development: Develop and maintain Power Apps to create user-friendly business applications that integrate with Power BI and other data sources. Requirements Gathering: Collaborate with business stakeholders to gather and understand requirements, translating them into technical specifications. Data Analysis: Perform data analysis to support business decision-making and provide actionable insights. Training and Support: Provide training and support to end-users on Power BI and Power Apps, ensuring they can utilize the tools effectively. Documentation: Maintain documentation for data models, report designs, Power Apps, and development processes. Required Skills and Qualifications: Education: Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field. Experience: Minimum of 3 years of experience in Power BI development, with a strong portfolio of past projects. Experience with Power Apps development is highly desirable. Technical Proficiency: Expertise in Power BI, including Power Query, Power Pivot, and Power BI Service. Advanced knowledge of DAX for data modeling and calculations. Proficiency in SQL for data extraction and manipulation. Familiarity with data warehousing concepts and ETL processes. Experience in developing Power Apps for business applications. Analytical Skills: Strong analytical and problem-solving skills with the ability to translate complex data into meaningful insights. Communication: Excellent verbal and written communication skills to effectively collaborate with business stakeholders and technical teams. Attention to Detail: Keen attention to detail and a commitment to delivering high-quality work. Preferred Qualifications: Experience with other BI tools such as Tableau or QlikView. Knowledge of cloud platforms like Azure or AWS. Experience with programming languages such as Python or R for data analysis. Certification in Microsoft Power BI and/or Power Apps. Follow on social media pages makertron : https://lnkd.in/g6xhGpme fb  : Makertron software solutions web site : Makertron.in