Ultimate SQL and DataBase Concepts | Jazeb Akram | Skillshare

# Ultimate SQL and DataBase Concepts

#### Jazeb Akram, Freelancer, Web Developer

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
25 Lessons (2h 15m)
• 1. Promo

2:56
• 2. Introduction

3:57
• 3. Lecture 1 Why SQL

2:15
• 4. Lecture 2 Select

7:52
• 5. Lecture 3 Arithmmatic Expressions

6:14
• 6. Lecture 4 Building Blocks

8:22
• 7. Lecture 5 Writing Comparison Operators In SQL

8:10
• 8. Lecture 6 Logical Operators

5:04
• 9. Lecture 7 Operator Precedence

2:45
• 10. Lecture 8 ORDER BY Clause

4:50
• 11. Lecture 9 Character Functions

11:44
• 12. Lecture 10 Numbers

3:36
• 13. Lecture 11 Dates

6:28
• 14. Lecture 12 Conversion

3:39
• 15. Lecture 13 General

4:11
• 16. Lecture 14 Nesting Function

1:33
• 17. Lecture 15 Multiple Row Functions on Table

4:21
• 18. Lecture 16 Multiple Row Functions on Different Table sets of Data

9:52
• 19. Lecture 17 Primary Key and Foreign Key

9:11
• 20. Lecture 18 Joins

3:41
• 21. Lecture 19 Cartesian Product

3:05
• 22. Lecture 20 Equie Join Simple Join Self Join

10:06
• 23. Lecture 21 Non Equie Join

2:32
• 24. Lecture 22 Outer Join

3:23
• 25. Lecture 23 Self Join

5:32

SQL developers are earning higher salary in IT industry, but, its not about writing queries its about understanding and applying the right query at right time and this course will let you understand complex SQL Statements in an easy way .

Moreover, This Course will teach you how to extract Data from Database and write complex queries to a database This course will focus on a wider scale by Covering Structure Query Language SQL concepts as a whole, whether Students work with MySQL, Microsoft SQL Server, Oracle Server, etc.

This course have 5 Chapters in which you will learn

• Chapter 1  Fundamentals
1. Fundamentals
2. Building Blocks
3. Selecting Records from DB
4. Working with Arithmetic Expressions
• Chapter 2 Conditioning Sorting and Operators
1. Logical Operators
2. Comparison Operators
3. Operator Precedence
4. Sorting Results
• Chapter 3 Functions
1. Character Functions
2. Number Functions
3. Date Functions
4. Conversions
5. General Purpose Functions
6. Nesting Functions
• Chapter 4 Grouping
1. Multiple Row Functions on a single Table
2. Multiple Row Functions on Many Table
• Chapter 5 Joins
1. Understanding Primary Key
2. Understanding Foreign Key
3. Understanding Need of Joins
4. Cartesian Product
5. Equie Join Simple Join Self Join
6. Non Equie Join
7. Outer Join
8. Self Join

Course is Designed for College and University Students who want Solid SQL and Data Base Concepts in a short period of time.

233

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

#### Jazeb Akram

Freelancer, Web Developer

Jazeb Akram is a developer and a web designer with the great passion for building beautiful new Desktop/Web Applications from scratch. He has been working as a Freelancer since 2011. He designed various Applications for many web design companies as an Out-Sourcer. Jazeb Also have a university degree in computer science along with many research activities

You can read his full portfolio on his website jazebakram.com

Contact on his web , if you need his assistance online.

B...

See full profile

Report class