Computer Science Exit Exam Material

Harvard University 100+ Free Online Courses for world wide students. Golden Chance. No IELTS - Everyone Can Apply - No Agent - Direct Apply Apply Link: https://carraadesk.com/harvard-university-free-online-courses-2023/ Huawei Free Online Courses  with Certificate https://carraadesk.com/huawei-free-online-courses-2023-24-with-certificate/ Google Free Course and Certification https://carraadesk.com/google-free-course-and-certification/ Microsoft Free AI Training Course With Professional Certificate Visit - https://carraadesk.com/microsoft-free-ai-training-course-with-professional-certificate/ Free Online Courses with Free Certificates                       https://carraadesk.com/free-online-courses-with-free-certificates/ Cisco Certified Certifications Introduction to cyber security. Introduction to the Internet of Things. Courses: https://carraadesk.com/cisco-online-free-courses/ WHO Free Online Courses With Free Certificates All Fields 2023 Click Here For More Detail: https://carraadesk.com/who-organization-free-courses-with-a-certificate/ 3 millons watched LinkedIn Learning Courses | LinkedIn Courses with Certificates | LinkedIn Learning Visit - https://carraadesk.com/free-courses-from-the-linkedin-platform-and-free-certification/ UNICEF FREE ONLINE COURSES WITH FREE CERTIFICATES ALL FIELDS https://carraadesk.com/unicef-free-courses-with-certificate/ Google and LinkedIn have launched new professional certificates on the Coursera platform https://carraadesk.com/google-free-online-courses/ https://t.me/OlibarAdvertisement

Vacancy at World Bank Group 📚World Bank Group wants to recruit employees in the following vacant positions: 1:  Junior Professional Associate-Digital Development 2: Junior Professional Associate- Social Protection 3: Senior IT Assistant, Client Services(For Fresh Graduate) 4: IT Analyst, Client Services 📌ሰለ ሰራው ሙሉ መረጃ ለማየት ይህንን ሊንክ ይጠቀሙ👇👇 👉Apply Online:- https://harmeejobs.com/company/world-bank-group https://t.me/OlibarAdvertisement

[ Fresh Graduates ] Job by Premier Switch Solutions Premier Switch Solutions S.C. (PSS) is a leading Electronic Payment Processing Company, established by major private banks of Ethiopia. Qualification: Bachelor’s Degree in ICT, Computer Science, Information Systems, Computer Engineering, or a related field Work Experience: This is an entry level position; no experience is required. How to Apply online https://carraadesk.com/junior-it-officer-at-premier-switch-solutions/ Deadline: July 28th 2024 https://t.me/OlibarAdvertisement

https://t.me/ComputerScienceExitExam Join for new vacancy posting daily

#Today New Vacancy at Zemen Bank(For Fresh Graduate) 📚Position:- Graduate Trainee Program – IT ✅ Experience: 0 year/Fresh Graduate ✅ Qualification: BSc. Degree in Computer Engineering, Computer Science, Information Technology or any other related field. 📌ሰለ ሰራው ሙሉ መረጃ ለማየት ይህንን ሊንክ ይጠቀሙ👇👇 👉Apply Online:- https://harmeejobs.com/job/young-graduate-trainee-program-it-ygtp-it/ ♻️For other Zemen Bank Jobs : https://harmeejobs.com/job-category/banking-and-insurance/ 🔰ከተለያዩ  ድርጅት የሥራ ማስታወቂያዎች በዚህ ሊንክ  ይመልከቱት👇👇 =>See Detail:-  www.harmeejobs.com https://t.me/OlibarAdvertisement

Job Title: Architect/ Graphic design Job Type: On-site - Permanent (Full-time) Job Sector: #Creative_art_and_design Work Location: Addis Ababa, Ethiopia Education Qualification: Bachelor's Degree Experience Level: Junior Vacancies: 5 Applicants Needed: Female Salary/Compensation: Monthly Deadline: July 31st, 2024 Description: We are looking for an Architect Graphic Designer to join our team and create stunning designs for our CNC cutting projects. You will be responsible for designing and producing graphics for various media, such as websites, brochures, flyers, logos, signage, and packaging. You will also collaborate with our architects and engineers to ensure that the designs are aligned with the project specifications and requirements.     To be eligible as an Architect Graphic Designer at our company, you should have a strong background in architecture and graphic design, as well as proficiency in relevant software tools like Autocad, Illustrator, Corel Draw, Revit and other software. You should also have a keen eye for aesthetics and details, and the ability to work under pressure and meet deadlines. You should be creative, innovative, and passionate about your work. Responsibilities: -Meet with clients and managers to discuss the design objectives and requirements for each project. -Create sketches, drawings, models, and layouts by hand or using computer-aided design (CAD) software. -Use various graphic design software and technologies (such as Photoshop, Illustrator, InDesign, etc.) to create and edit graphics, images, and text. -Incorporate architectural elements, such as shapes, forms, structures, and materials, into the graphic designs. -Ensure that the graphic designs are consistent with the project theme, style, and branding. -Test and review the graphic designs across various media and platforms, and make adjustments as needed. -Present the graphic designs to clients and managers for feedback and approval. -Coordinate with the CNC cutting team to ensure that the designs are compatible with the cutting machines and processes. -Keep up to date with the latest trends and developments in architecture and graphic design. Requirements and Skills: -A minimum of 2 Years Experience -Bachelor’s degree in architecture, graphic design, or related field. -Portfolio of previous work in architecture and graphic design. -Experience in CNC cutting or similar industry is a plus. -Knowledge of architectural principles, concepts, and techniques. -Knowledge of graphic design principles, concepts, and techniques. -Proficiency in CAD software, such as AutoCAD, SketchUp, Revit, etc. -Proficiency in graphic design software, such as Photoshop and Corel draw is a must etc. -Ability to work independently and as part of a team. -Ability to communicate effectively with clients and managers. -Ability to manage multiple projects and prioritize tasks. -Ability to work under pressure and meet deadlines. -Creativity, innovation, and passion for design. ______ Teketay Creative Works PLC [Verified Company ✅] 4 Jobs Posted From: @freelance_ethio | @freelanceethbot For our Amharic Channel, Join @afriworkamharic

▪️For Fresh 🎴Zemen Bank SC🎴 ▪️Position 1 - Young Graduate Trainee Program – IT (YGTP- IT) ▪️Education: Degree in Computer Engineering, Computer Science, Information Technology or any other related field ▪️Deadline: August 16/25 Job Position 2 - Young Graduate Trainee Program – Business (YGTPB) ▪️Education: Degree in Banking and Finance, Accounting, Management, Economics or related Business fields. ▪️Deadline: July 25/24 ▪️Find More Details here           💧💧💧💧💧 https://elelanajobs.com/job/zemen-bank-sc-july-16-24/

[ New  ]  Jobs by International Cargo and Aviation Service Diploma in Computer science, IT, or similar field  10th /12th grade complete  How to Apply https://carraadesk.com/jobs-by-international-cargo-and-aviation-service/ Deadline: July 24th 2024 https://t.me/OlibarAdvertisement

★[በ0 አመት እና በልምድ] የአለም ባንክ አዲስ የስራ ማስታወቂያ - World Bank Vacancy ♦Closing Date: 7/26/2024 World Bank invites interested applicants for the following job position. ✔ Position 1: IT Assistant, Client Services ❇️ Selection Criteria: Bachelor’s degree with no experience required or equivalent combination of education and relevant experience. ✔ Position 2: IT Analyst, Client Services ❇️ Selection Criteria: Bachelor’s or Master’s degree with 2 years relevant experience OR equivalent combination of education and experience 🌀How to Apply Online?? 👇👇👇👇👇 https://dailyjobsethiopia.com/2024/07/16/world-bank-job-vacancy-2024-3/ Share to your friends https://t.me/OlibarAdvertisement

[ Fresh Graduates ] Job by Ethio telecom July 16 2024 Job Title Vacancy National ID Registration Agent BSc Degree In IT, Computer Science, and related field How to Apply https://carraadesk.com/job-by-ethio-telecom-july-16-2024/ Opening date: 16-Jul-24 Closing Date: 20-Jul-24 https://t.me/ComputerScienceExitExam

Today, let's go through complete tutorial on SQL aggregate functions. https://t.me/ComputerScienceExitExam Aggregate functions are used to perform calculations on multiple rows of a table's column and return a single value. Here are the most commonly used aggregate functions: 1. COUNT(): Counts the number of rows in a table. 2. SUM(): Calculates the sum of a set of values. 3. AVG(): Calculates the average value of a set of values. 4. MIN(): Finds the minimum value in a set of values. 5. MAX(): Finds the maximum value in a set of values. ### 1. COUNT() The COUNT() function returns the number of rows that match a specified criterion. Syntax:

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

Example: Count the number of customers in the Customers table.

SELECT COUNT(CustomerID) AS NumberOfCustomers
FROM Customers;

### 2. SUM() The SUM() function returns the total sum of a numeric column. Syntax:

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Example: Calculate the total sales in the Orders table.

SELECT SUM(Sales) AS TotalSales
FROM Orders;

### 3. AVG() The AVG() function returns the average value of a numeric column. Syntax:

SELECT AVG(column_name)
FROM table_name
WHERE condition;

Example: Find the average order amount in the Orders table.

SELECT AVG(OrderAmount) AS AverageOrder
FROM Orders;

### 4. MIN() The MIN() function returns the smallest value of the selected column. Syntax:

SELECT MIN(column_name)
FROM table_name
WHERE condition;

Example: Find the lowest price in the Products table.

SELECT MIN(Price) AS LowestPrice
FROM Products;

### 5. MAX() The MAX() function returns the largest value of the selected column. Syntax:

SELECT MAX(column_name)
FROM table_name
WHERE condition;

Example: Find the highest price in the Products table.

SELECT MAX(Price) AS HighestPrice
FROM Products;

### Using Aggregate Functions with GROUP BY Aggregate functions are often used with the GROUP BY clause to group rows that have the same values in specified columns into summary rows. Syntax:

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE condition
GROUP BY column_name;

Example: Get the total sales for each product.

SELECT ProductID, SUM(Sales) AS TotalSales
FROM Orders
GROUP BY ProductID;

### Using Aggregate Functions with HAVING The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. HAVING allows us to filter records that work on summarized GROUP BY results. Syntax:

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE condition
GROUP BY column_name
HAVING aggregate_function(column_name) condition;

Example: Get the total sales for each product where total sales exceed $1000.

SELECT ProductID, SUM(Sales) AS TotalSales
FROM Orders
GROUP BY ProductID
HAVING SUM(Sales) > 1000;

### Combining Aggregate Functions You can use multiple aggregate functions in the same query. Example: Get the total number of orders, average order amount, minimum order amount, and maximum order amount.

SELECT COUNT(OrderID) AS NumberOfOrders,
       AVG(OrderAmount) AS AverageOrder,
       MIN(OrderAmount) AS MinOrder,
       MAX(OrderAmount) AS MaxOrder
FROM Orders;

- COUNT(): Counts rows. - SUM(): Sums up values. - AVG(): Averages values. - MIN(): Finds the minimum value. - MAX(): Finds the maximum value. - GROUP BY: Groups rows that have the same values. - HAVING: Filters groups based on aggregate functions. https://t.me/ComputerScienceExitExam Hope it helps :) https://t.me/ComputerScienceExitExam

Top 18 Websites to Land Remote Jobs and Earn in USD $ in 2024! 1.  RemoteHunt : Simplify your search with advanced filters and a user-friendly interface. (https://remotejobhunt.com/) 2. Wellfound: Connect with purpose-driven companies offering remote work aligned with your values. (https://wellfound.com/) 3. WeWork Remotely: Explore remote jobs from companies of all sizes and industries. 4. Working Nomads Nomads: Tailored remote work opportunities to match your skills and preferences. 5. RemoteBliss: Find remote jobs with a focus on work-life balance and flexibility. (https://remotebliss.com/) 6. Remotees: Browse remote job listings from around the world. (https://remotees.com/) 7. RemoteHub: Connect with remote job opportunities in tech, design, and marketing. (https://remotehub.io/) 8. RemoteCo: Curated listings from companies embracing remote work culture. (https://remoteco.com/) 9. JustRemote: Navigate through tech, marketing, and more to find your perfect remote job. (https://justremote.co/) 10. JSRemotely: Tailored opportunities for JavaScript developers. (https://jsremotely.com/) 11. FlexJobs: A curated marketplace for remote, freelance, and flexible work. (https://www.flexjobs.com/) 12. Toptal: Elevate your remote career with top-tier freelance opportunities. (https://toptal.com/) 13.Guru: Dive into freelance gigs spanning writing, design, marketing, and more. (https://www.guru.com/) 14. RemoteOK: Explore remote job opportunities across various industries. (https://remoteok.com/) 15.RemoteHire: Discover remote jobs with a focus on tech and digital roles. (https://remotehire.io/) 16. RemoteLeads: Receive curated remote job leads directly to your inbox. (https://remoteleads.io/) 17. remote4me: Customize your remote job search based on location, salary, and more. (https://remote4me.com/) 18. RemoteCircle: Network with remote professionals and discover job opportunities. (https://remotecircle.com/) Join our telegram channel @ComputerScienceExitExam @OlibarAdvertisement

@ComputerScienceExitExam Level up your coding skills for free: 🌐 HTML - w3schools.com 💅 CSS - web.dev/learn/css 🔥 JavaScript - javascript.info 🐙 Git and Github - git-scm.com 📚 API - rapidapi.com/learn 🐍 Python - learnpython.org ⚛️ React - react-tutorial.app 🎡 Laravel - laracasts.com 🌟 VueJS - learnvue.co 🔍 SQL - SQLbolt.com 🌈 Tailwind CSS - tailwindcss.com 🚀 Go - gobyexample.com 🐳 Docker - docker-curriculum.com 🦋 Flutter - flutter.dev/learn 🦀 Rust - rust-lang.org/learn @ComputerScienceExitExam @OlibarAdvertisement

🎴Ethio Telecom🎴 Ethio-Telecom has prepared various gifts for 500 thousand people regarding the successful completion of the fiscal year. ▪️ 250 thousand Birr for 5 people ▪️ iphone 15 pro max for 5 people ▪️ Zte A34 phone for 400 people ▪️1 GB for 299,000 ▪️ 50 Birr for 200 thousand people You can get this by topping up Telebirr airtime every day from Hamle 5-9, buying packages, shopping and transferring money, and if you get the spin. Try your luck. 🏴Ethio-Telecom has prepared various gifts for 500 thousand people regarding the successful completion of the fiscal year. ▪️ 250 thousand birr for 5 people ▪️ iphone 15 pro max for 5 people ▪️ Zte A34 phone for 400 people ▪️1 GB for 299,000 ▪️ 50 Birr for 200 thousand people You can get this by topping up Telebirr airtime every day from July 5-9, buying packages, shopping and transferring money, and if you get spin. Try your luck. @ComputerScienceExitExam @ComputerScienceExitExam

✅ If there are universities that offer completely free education scholarships, here are their addresses! ‼️There are many people who want it, so please share it ⤴️ 📌1. Simon Fraser University Scholarships In Canada https://lnkd.in/dkNEy39J 2. Orange Knowledge Program In The Netherlands https://lnkd.in/dvvN5pAE 3. Boston University Scholarships In USA https://lnkd.in/dx4Xn7Z 4. British Council STEM Scholarships In UK https://lnkd.in/dn77K7dm 📌5. Deakin University Scholarship in Australia https://lnkd.in/dUrKBJbe 6. LOCALINTER National Summer Paid Internship in Turkey https://lnkd.in/dPBySrM8 7. 300 University of South Australia Scholarships https://lnkd.in/dRKFAtQ8 8. University of Miami Stamps Scholarship In USA https://lnkd.in/dZQ_sKnR 9. DAAD Helmut Schmidt Germany Scholarship https://lnkd.in/dbw36D8n 📌 10. Hokkaido University MEXT Japan Government Scholarship https://lnkd.in/d6MNJz7i 📌11. University of Manitoba Scholarship In Canada https://lnkd.in/dEkcYbA 📌12. Aalto University Scholarship In Finland https://lnkd.in/d4WtQ6AN 📌13. Australian Government Research Training Program https://lnkd.in/dS2qtT_S 📌14. University of Dundee Scholarships In UK https://lnkd.in/dg3b3UrC 📌 15. Luiss University ENI Scholarship In Italy https://lnkd.in/ddwAAatP ▬▬ ▬▬ ▬▬ ▬▬ ▬ ▬▬ ▬ SHARE WITH UR FRIENDS ⤴️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬    ✅ For more Join us 👇👇👇 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬          ⬇️ Join and Share ⤴️👇       ╔═══════════╗       ❇️      @ComputerScienceExitExam     ❇️       ❇️      @ComputerScienceExitExam      ❇️       ╚═══════════╝