‼️Caution
For accepted students:

Please check your emails and join the groups you have been assigned to. You will find the group link in your acceptance email. The organizing team and the teachers need to proceed with the next steps, so it is very important that all accepted students check their emails and join their assigned groups as quickly as possible. If you do not respond, the organizing team will pick students from the waitlist to join, and the group link will expire.

Please share this information and remind your friends and everyone you know to check their emails.

@GDSCAAU

🚀 Join Top Rated Plus Upwork Freelancer Bethlehem Dagnachew as she guides you through navigating remote work opportunities from Ethiopia! 🚀

Learn firsthand how Bethlehem built a successful freelancing career online.

Join us for an empowering workshop series designed to help you excel in the gig economy. Learn directly from a top-rated plus freelancer and gain the skills to thrive on Upwork. Master remote work and gain practical guidance on accessing different freelance Platforms 🌟

Over 8 exciting weeks, we'll cover everything from getting started on Upwork and optimizing your profile to landing high-value clients, writing winning proposals, and mastering interview techniques. You'll also learn about contracts, payments, building long-term client relationships, and enhancing both technical and soft skills. Plus, we'll help you avoid common freelancing mistakes!

Don't miss out on this opportunity to transform your career! 8 Consecutive Weeks of In-Depth Learning

📅 Date: Sunday, July 14th (ሐምሌ 7)
🕒 Time: 2:00 PM - 4:00 PM (ከ8፡00 - 10፡00 ሰአት)
📍 Location: Capstone ALX Tech Hub, Lideta

📩 RSVP at: https://bit.ly/3y1hG8p

“An opportunity to elevate your graphics design skill”

Join the world of digital design with our intensive bootcamp. This comprehensive training program is tailored for anyone aspiring to be a graphic designer. The boot camp will dive into the powerful tools of illustrator and Adobe Photoshop.

Keep in mind you will get a certification from Addis Ababa University if you pass all the evaluations with 100% attendance

Registration deadline: July 27, 11:00 AM GMT +3

Registration steps:-
1. Pay 2500 birr to CBE account 1000003783344 - (AAU  SPECIAL FUNDACCOUNT).
Add reason of payment as “4K Labs training”
2. Save screenshot of the payment slip
3. Register Here: https://shorturl.at/2gCp4
4. Don't lose your payment slip for future reference


#Graphics_design #3D_modelling #3D_Printing #4K_Labs #AAU #Addis_Ababa_University #CNCS #Computer_Science
#AI hashtag#Robotics
#Things#SoftwareDevelopment #TinyML #Digital_Skills_Opportunity #Innovation #Ethopian_Tech #EthiopianCoders #Coding hashtag#Tech #Bootcamp

Complete 14-day roadmap to learn SQL learning:

Day 1: Introduction to Databases
- Understand the concept of databases and their importance.
- Learn about relational databases and SQL.
- Explore the basic structure of SQL queries.

Day 2: Basic SQL Syntax
- Learn SQL syntax: statements, clauses, and keywords.
- Understand the SELECT statement for retrieving data.
- Practice writing basic SELECT queries with conditions and filters.

Day 3: Retrieving Data from Multiple Tables
- Learn about joins: INNER JOIN, LEFT JOIN, RIGHT JOIN.
- Understand how to retrieve data from multiple tables using joins.
- Practice writing queries involving multiple tables.

Day 4: Aggregate Functions
- Learn about aggregate functions: COUNT, SUM, AVG, MIN, MAX.
- Understand how to use aggregate functions to perform calculations on data.
- Practice writing queries with aggregate functions.

Day 5: Subqueries
- Learn about subqueries and their role in SQL.
- Understand how to use subqueries in SELECT, WHERE, and FROM clauses.
- Practice writing queries with subqueries.

Day 6: Data Manipulation Language (DML)
- Learn about DML commands: INSERT, UPDATE, DELETE.
- Understand how to add, modify, and delete data in a database.
- Practice writing DML statements.

Day 7: Data Definition Language (DDL)
- Learn about DDL commands: CREATE TABLE, ALTER TABLE, DROP TABLE.
- Understand constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL.
- Practice designing database schemas and creating tables.

Day 8: Data Control Language (DCL)
- Learn about DCL commands: GRANT, REVOKE for managing user permissions.
- Understand how to control access to database objects.
- Practice granting and revoking permissions.

Day 9: Transactions
- Understand the concept of transactions in SQL.
- Learn about transaction control commands: COMMIT, ROLLBACK.
- Practice managing transactions.

Day 10: Views
- Learn about views and their benefits.
- Understand how to create, modify, and drop views.
- Practice creating views.

Day 11: Indexes
- Learn about indexes and their role in database optimization.
- Understand different types of indexes (e.g., B-tree, hash).
- Practice creating and managing indexes.

Day 12: Optimization Techniques
- Explore optimization techniques such as query tuning and normalization.
- Understand the importance of database design for optimization.
- Practice optimizing SQL queries.

Day 13: Review and Practice
- Review all concepts covered in the previous days.
- Work on sample projects or exercises to reinforce learning.
- Take practice quizzes or tests.

Day 14: Final Review and Projects
- Review all concepts learned throughout the 14 days.
- Work on a final project to apply SQL knowledge.
- Seek out additional resources or tutorials if needed.


Here are some practical SQL syntax examples for each day of your learning journey:

Day 1: Introduction to Databases
- Syntax to select all columns from a table:
   SELECT * FROM table_name;
 
Day 2: Basic SQL Syntax
- Syntax to select specific columns from a table:
   SELECT column1, column2 FROM table_name;
 
Day 3: Retrieving Data from Multiple Tables
- Syntax for INNER JOIN to retrieve data from two tables:
   SELECT orders.order_id, customers.customer_name
  FROM orders
  INNER JOIN customers ON orders.customer_id = customers.customer_id;
 
Day 4: Aggregate Functions
- Syntax for COUNT to count the number of rows in a table:
   SELECT COUNT(*) FROM table_name;
 
Day 5: Subqueries
- Syntax for using a subquery in the WHERE clause:
   SELECT column1, column2
  FROM table_name
  WHERE column1 IN (SELECT column1 FROM another_table WHERE condition);
 
Day 6: Data Manipulation Language (DML)
- Syntax for INSERT to add data into a table:
   INSERT INTO table_name (column1, column2) VALUES (value1, value2);




@code_it_now

Flutter UI Bootcamp | Build Beautiful Apps using Flutter

*Apply Link:*
https://careerboostzone.com/flutter-ui-bootcamp-build-beautiful-apps-using-flutter/

@code_it_now

What people need to do survive in the age of AI? one of the gay activitst(just joke😁😁) sam altman Answer ✅

1 day left!! 🏆🏆

Register now for our Free online game development course using Unity and C# programming.

Spend your summer learning how to make games!

Register below for the orientation on Saturday, July 13!

Make sure to join our community where we collaborate and create together! For more info check out our telegram channel  @infinitycodestudios or DM @ICSaadmin

https://docs.google.com/forms/d/e/1FAIpQLSchOCxzJ_vD7hxHv1LUP578tEBEnzMyXMLl2mUpmHnsP0in1Q/viewform?usp=sf_link



@code_it_now

The day u stp learning is the day u start dying !!!
Always be student in life🙏🙏!!


@code_it_now

Introducing the first-ever ALX Pulse event, brought to you by your very own ALX TEBIBAN! 👏🏾👏🏾👏🏾

We're kicking things off by welcoming the first VA batch of the year and AiCE Batch 5 with a bang! 🎉✨

OPEN INVITE FOR ALL TO MAKE NEW FRIENDS! But ALSO this hangout is the perfect chance for C4 Foundations learners to form their groups for next month's CAPSTON project. What better way to make new friends and team up than at a relaxed Saturday morning hangout? 🌟👥

Register at: https://docs.google.com/forms/d/1BIcI9-4qdMkjwaofonIHyA9npFueuxcwZvJikDJtxTw/edit

Join us for a fun-filled morning of connections, laughter, and collaboration! See you there!
#ALXPulse #Tebiban #Community #Collaboration

Some of you were asking me for this pdf especially on tiktok. Here it is the one and only cracking the coding interview.

መዝሙር 19
¯¯¯¯¯¯¯¯¯¯
⁷ የእግዚአብሔር ሕግ ፍጹም ነው፤ ነፍስን ይመልሳል፤ የእግዚአብሔር ምስክር የታመነ ነው፤ ሕፃናትን ጠቢባን ያደርጋል።
⁸ የእግዚአብሔር ሥርዓት ቅን ነው፥ ልብንም ደስ ያሰኛል፤ የእግዚአብሔር ትእዛዝ ብሩህ ነው፥ ዓይንንም ያበራል።
⁹ የእግዚአብሔር ፍርሃት ንጹሕ ነው፤ ለዘላለም ይኖራል፤ የእግዚአብሔር ፍርድ እውነትና ቅንነት በአንድነት ነው።


አሜን 🙏

“አቤቱ፥ ረድኤቴ መድኃኒቴም፥ የአፌ ቃልና የልቤ አሳብ በፊትህ ያማረ ይሁን።”
— መዝሙር 19፥14

Information is useless without implementation what is the point of consuming all this information to your head and not to do anything with it not taking action not taking a risk it doesn't make sense!!!u will get more result and success if u start taking action NOW



@code_it_now

Here is a google map location for the ALX Capstone Hub

https://maps.app.goo.gl/hoDJL9MiKrKr8SMc8

See you there!