watching now
2 Students

Course Details

Lessons

79

Skill Level

Beginner

Certificate

Available

RESERVE - Only minutes left for your FREE certificate!

What You Will Learn?

  • Write, Read, Analyze SQL queries easily
  • Understanding Database Terminology
  • Get Any Data from the Database
  • Learn How to Use SQL functions Confidently
  • Restricting, Filtering, Grouping, Joining the Data

Description

Requirements

  • Using ability an operating system

Curriculum

Section 1: Course Introduction 02:04
Section 2: Database Concepts 42:31
  • What is a Database?
    Watch now
    07:38
Section 3: Preparation for SQL Development 41:13
Section 4: Entering the Database! 32:33
Section 5: Conditional Retrieval 32:21
Section 6: Converting Data & Conversion Functions 36:47
Section 7: Ordering the Results 11:54
Section 8: Single Row Functions 34:38
Section 9: Group Functions 15:07
Section 10: Grouping the Data 15:11
Section 11: Selecting From Multiple Tables (Joins) 48:32
Section 12: Subqueries (Query inside a Query) 26:04
Section 13: SET Operators 12:47
Section 14: Manipulating and Playing with the Data (DML Statements) 24:19
Section 15: Manipulating Tables - DDL Statements 12:04

About the Instructor

Reviews 0
Students 5
Courses 1

I have been working for more than 15+ years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 10+ years on SQL&PL/SQL programming and Oracle Technologies. And also I'm a Software Development Manager for more than "10" years.

For now, I am working on a huge database which has more than 15M (million) active-users as a Project Manager, and teaching SQL&PL/SQL and many programming language courses like C, Java, Python, PHP, etc.

BitDegree platform reviews

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