Cyber Week

Save big!

All courses under $5 - for a limited time!
watching now
5 Students
26 Lessons
Beginner

What Will You Learn?

  • You'll get solid SQL basics
  • You'll build a proper understand of complex SQL concepts
  • You'll be able to write robust SQL queries
  • You'll know how to use SQL to extract data from a database

Curriculum

2h 17m
Section 1: Introduction
08:23
Section 2: Fundamentals
24:45
Arithmmatic Expressions
06:14
Building Blocks
08:22
Section 3: Conditioning Sorting and Operators
20:51
Writing Comparison Operators In SQL
08:10
Logical Operators
05:04
Operator Precedence
02:46
ORDER BY Clause
04:51
Section 4: Functions
31:13
Character Functions
11:44
Numbers
03:36
Dates
06:28
Conversion
03:40
General
04:11
Nesting Function
01:34
Section 5: Groups
14:15
Multiple Row Functions on Table
04:22
Multiple Row Functions on Different Table sets of Data
09:53
Section 6: Joins
37:34
Primary Key and Foreign Key
09:12
Joins
03:42
Cartesian Product
03:05
Equie Join Simple Join Self Join
10:07
Non Equie Join
02:33
Outer Join
03:23
Self Join
05:32

Description

Requirements

  • No prior knowledge is necessary
  • MAC or PC

About the Instructor

Reviews 0
Students 23
Courses 10

Jazeb Akram is an experienced web designer and developer. He is passionate about building beautiful new Desktop/Web Applications from scratch. Since 2011, he has been working as a freelancer and has designed various applications for many web design companies. He also holds a university degree in Computer Science (hons), and is currently pursuing his Master’s degree.

Another Jazeb’s passion is teaching. He has joined the world's best learning platforms as an online instructor. Jazeb Akram says that the reason he came into teaching is his successful freelance experience because he loves to teach and gets very passionate and assisting others to achieve success in programming. That’s why at the end of his courses, students develop unique skill sets that they can use in a real-life and improve their career.

Jazeb loves to travel and explore new places.

On BitDegree, you have an opportunity to be guided by this amazing instructor to learn programming, complete projects and build apps. Jazeb Akram will teach you JavaScript, PHP, CSS, SQL and more. Choose the best course for you and dive into learning today!

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo