What 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
This course includes:
- 2.5 hours on-demand video
- Assignments
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
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.
How to Get this course FREE?
Get a 100% Discount On Udemy courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Apply this Coupon: FREE5SEP24 is applied (For 100% Discount)
For Latest Udemy Courses Coupon, Join Our Official Free Telegram Group :https://t.me/freecourseforall
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course for 100% Free. After that, you will get this course at a discounted price.
Important Notice and Disclaimer:- CareerBoostZone platform is a free Job Sharing platform for all the Job seekers. We don’t charge any cost and service fee for any job which is posted on our website, neither we have authorized anyone to do the same. Most of the jobs posted over Seekajob are taken from the career pages of the organizations. Jobseekers/Applicants are advised to check all the details when they apply for the job to avoid any inconvenience.
