Course ID: 1

Query:
SELECT c.*, s.school_name 
     FROM course c
     LEFT JOIN school s ON c.school_id = s.id
     WHERE c.course_id = 1

Result:
stdClass Object
(
    [course_id] => 1
    [course_type] => 1
    [course_code] => B. Tech. CSE
    [course_name] => Bachelor of Technology in Computer Science and Engineering – B. Tech. CSE
    [course_slug] => b-tech-in-computer-science-engineering
    [course_duration] => 4 Years
    [mode_of_study] => Full Time Course
    [course_commencement] => January 2020 and July 2020
    [course_seat] => 60
    [course_image] => 36324
    [department_id] => 2
    [school_id] => 3
    [admission_contact_number1] => +91 96060 48544, 96200 09825, 080 4619 9049
    [admission_contact_number2] => 
    [admission_contact_email] => btech@alliance.edu.in
    [apply_now_link] => https://apply.alliance.edu.in/undergraduate-application-form-2026
    [admission_line_left] => Building
    [admission_line_big] => Strong Foundations
    [admission_line_right] => in Computer Science
    [display_order] => 9
    [color_code] => 
    [course_page_title] => B Tech in Computer Science & Engineering - Alliance University Bangalore
    [objectives_data] => {"image":"","heading":"Foster strategic thinking","explore_label":"Explore Our B. Tech. in Computer Science & Engineering","explore_link":"","objectives":[{"title":"PEO (Program Educational Objectives)","items":[{"title":"","desc":"PEO1:<\/strong> Apply computing knowledge and modern tools to design efficient, scalable, and sustainable software and system solutions in professional practice.\r\nPEO2:<\/strong> Innovate and solve complex computing problems using critical thinking, data-driven approaches, and emerging technologies such as AI, cloud, and cybersecurity.\r\nPEO3:<\/strong> Lead ethical and responsible computing practices while engaging in lifelong learning and contributing to societal and technological advancement."}]},{"title":"PSO (Program Specific Outcomes)","items":[{"title":"","desc":"PSO1:<\/strong> Design and develop efficient, scalable, and secure software systems using modern computing technologies to address real-world and societal needs.\r\nPSO2:<\/strong> Integrate advanced technologies such as Cloud Computing, Full Stack Development, Cyber Security, Internet of Things (IoT), DevOps, and Blockchain to build innovative and industry-relevant solutions.\r\nPSO3:<\/strong> Create and lead technology-driven ventures by applying entrepreneurial skills to develop impactful digital products and services."}]},{"title":"PO (Program Outcomes)","items":[{"title":"","desc":"PO1 Engineering Knowledge:<\/strong>\r\n\r\nApply knowledge of mathematics, natural science, computing, engineering fundamentals and an engineering specialization as specified in WK1 to WK4 respectively to develop to the solution of complex engineering problems.\r\n\r\nPO2 Problem Analysis:<\/strong>\r\n\r\nIdentify, formulate, review research literature and analyze complex engineering problems reaching substantiated conclusions with consideration for sustainable development. (WK1 to WK4)\r\n\r\nPO3 Design\/Development of Solutions:<\/strong>\r\n\r\nDesign creative solutions for complex engineering problems and design\/develop systems\/components\/processes to meet identified needs with consideration for the public health and safety, whole-life cost, net zero carbon, culture, society and environment as required. (WK5)\r\n\r\nPO4 Conduct Investigations of Complex Problems:<\/strong>\r\n\r\nConduct investigations of complex engineering problems using research-based knowledge including design of experiments, modelling, analysis & interpretation of data to provide valid conclusions. (WK8).\r\n\r\nPO5 Engineering Tool Usage:<\/strong>\r\n\r\nCreate, select and apply appropriate techniques, resources and modern engineering & IT tools, including prediction and modelling recognizing their limitations to solve complex engineering problems. (WK2 and WK6)\r\n\r\nPO6 The Engineer and The World:<\/strong>\r\n\r\nAnalyze and evaluate societal and environmental aspects while solving complex engineering problems for its impact on sustainability with reference to economy, health, safety, legal framework, culture and environment. (WK1, WK5, and WK7)\r\n\r\nPO7 Ethics:<\/strong>\r\n\r\nApply ethical principles and commit to professional ethics, human values, diversity and inclusion; adhere to national & international laws. (WK9)\r\n\r\nPO8 Individual and Collaborative Team work:<\/strong>\r\n\r\nFunction effectively as an individual, and as a member or leader in diverse\/multi-disciplinary teams.\r\n\r\nPO9 Communication:<\/strong>\r\n\r\nCommunicate effectively and inclusively within the engineering community and society at large, such as being able to comprehend and write effective reports and design documentation, make effective presentations considering cultural, language, and learning differences\r\n\r\nPO10 Project Management and Finance:<\/strong>\r\n\r\nApply knowledge and understanding of engineering management principles and economic decision-making and apply these to one\u2019s own work, as a member and leader in a team, and to manage projects and in multidisciplinary environments.\r\n\r\nPO11 Life-Long Learning:<\/strong>\r\n\r\nRecognize the need for, and have the preparation and ability for i) independent and life-long learning ii) adaptability to new and emerging technologies and iii) critical thinking in the broadest context of technological change. (WK8)"}]}]}
    [major_image] => 
    [major_courses] => []
    [major_type] => 
    [minor_type] => 
    [open_type] => 
    [minor_image] => 
    [minor_courses] => [{"area_title":"Minors","tab_custom_title":"Minors","courses":["The Minor Pathways in the B.Tech Computer Science and Engineering curriculum are designed to provide students with focused specialization beyond their core discipline, enabling them to build domain depth in emerging and high-demand technology areas. Introduced as a structured academic pathway from the second year onwards, minors allow learners to align their academic journey with career aspirations, industry trends, and interdisciplinary interests .\r\n\r\nA key highlight of this framework is the flexibility offered to students to choose any minor track based on their interests and career goals, empowering them to personalize their learning journey and explore interdisciplinary domains without constraints.\r\n\r\nThe Minors framework emphasizes:<\/strong>\r\n\r\na) Specialized skill development in cutting-edge domains\r\n\r\nb) Hands-on learning through labs, projects, and industry-aligned tools\r\n\r\nc) Integration of certifications and real-world applications\r\n\r\nd) Enhanced employability through domain-focused expertise\r\n\r\nBy complementing the Program Core with targeted specialization, the Minor Pathways empower students to graduate with multi-dimensional competencies, making them adaptable, future-ready professionals capable of thriving in dynamic and technology-driven environments.\r\n\r\nMinors List:<\/strong>\r\n