![learn-sql-from-scratch-in-arabic-–-for-beginners-free-course-coupon-[100%-off]](https://i0.wp.com/diypriceless.com/courses/wp-content/uploads/2024/09/19251-learn-sql-from-scratch-in-arabic-for-beginners-free-course-coupon-100-off.jpg?resize=750%2C422&ssl=1 "Learn SQL from scratch in Arabic – for beginners Free Course Coupon [100% Off] 1")
What
You’ll Learn
You’ll Learn
- Microsoft SQL server 2019
- Create and drop database
- Master database files
- Log database files
- Secondary database files
- SQL server transaction
- Create and drop database table
- Alter database table (Add
- drop & alter column)
- SQL constraints
- Data manipulation language (dealing with records)
- SELECT and SELECT DISTINCT
- WHERE clause
- AND
- OR and NOT
- ORDER BY
- Aliases
- SQL subqueries
- SQL Joins
- Aggregation functions (MIN
- MAX
- AVG
- SUM
- COUNT)
- GROUP BY
- HAVING
- LIKE
Requirements
- There are no perquisites to start this course
- only have a PC / laptop.
Description
In this course, you will learn SQL basics from A to Z in Arabic!
The content of the course as in sections and videos;
01:
1- What is flat file?
2- Flat file VS relational database.
3- Flat file advantages.
4- Flat file disadvantages.
5- Database.
6- RDBMS.
7- What is SQL?
8- SQL commands in brief.
02:
Download and install MS SQL server 2019 and SSMS
03:
1- CREATE database.
2- DROP database.
3- USE keyword.
4- MDF VS LDF files.
5- SQL server transaction.
6- NDF files.
04:
1- CREATE database table.
2- DROP database table.
3- ALTER database table.
ADD column.
DROP COLOMN.
ALTER COLUMN.
05:
1- SQL constraints
1.1- NOT NULL
1.2- UNIQUE
1.3- PRIMARY KEY
1.4- FOREIGN KEY
1.5- CHECK
1.6- DEFAULT
2- AUTO INCREMENT.
3- constraint naming.
4- Practicing on using constraints in both create table time and alter table.
06:
Data manipulation language
1. insert a record.
2. update a record.
3. delete a record.
4. delete all records.
5. truncate table.
6. SELECT statement.
7. SELECT DISTINCT statement.
8. WHERE clause.
9. AND, OR and NOT.
10. Combining AND, OR and NOT.
11. ORDER BY.
12. Aliases.
07:
SQL subqueries
1. What is subquery in SQL.
2. Subquery in SELECT statement.
3. Subquery in INSERT statement.
4. Subquery in UPDATE statement.
5. Subquery in DELETE statement.
6. Advantages & disadvantages of subqueries.
08:
SQL Joins:
1. What is SQL join?
2. Inner join.
3. Left join.
4. Full join
09:
Aggregation functions:
1. MIN()
2. MAX()
3. COUNT()
4. AVG()
5. SUM()
10:
1. GROUP BY
2. HAVING
3. LIKE
With exercises.
Who this course is for:
- Computer science students.
- Those who are totally beginners in programming field.
🔝
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
Infos:
Are you thinking about upgrading your home security systems?
It's a wise investment, especially in today's world. With crime rates on the rise, ensuring the safety of your loved ones and property is paramount. But where do you start? Well, let's break it down.
Firstly, consider consulting with a reputable personal injury lawyer. Accidents happen, and having legal protection in place can provide peace of mind. Whether it's a slip and fall incident or a car accident, having a legal expert on your side can make all the difference.
Once you've addressed your legal concerns, it's time to focus on your financial security. Exploring options like mortgage rates and personal loans can help you achieve your goals. Maybe you're considering a home renovation project or even looking into real estate investment opportunities. Whatever your financial aspirations, having the right information at your fingertips is crucial.
Now, let's talk technology. Cloud computing services are revolutionizing the way businesses operate. Whether you're a small startup or a multinational corporation, leveraging the power of the cloud can streamline your operations and enhance productivity. And don't forget about cybersecurity. With the increasing prevalence of cyber threats, investing in antivirus software is non-negotiable.
Of course, amidst all the hustle and bustle, it's essential to take care of your health. Health supplements can bolster your immune system and keep you feeling your best. And if you're considering cosmetic surgery, be sure to do your research and consult with a reputable provider.
Finally, let's not forget about relaxation and recreation. Planning a luxury vacation or a cruise getaway? Don't overlook the importance of travel insurance. It's a small investment that can save you a lot of hassle in the long run.
In conclusion, whether you're prioritizing your safety, financial security, technological advancement, health, or leisure, there are plenty of options available to you. By making informed decisions and seeking expert advice when needed, you can navigate life's challenges with confidence and ease Continue reading...: Click Here
