Coders Code
Coders Code
  • Home
  • Courses
    • Learn C
    • Coding Primer
    • Web Developer
    • Core JavaScript
    • Core Python
    • Blockchain With Python
    • React Developer
    • Learn SQL
    • Artificial Intelligence
    • Study Material
  • Apply
  • More
    • Home
    • Courses
      • Learn C
      • Coding Primer
      • Web Developer
      • Core JavaScript
      • Core Python
      • Blockchain With Python
      • React Developer
      • Learn SQL
      • Artificial Intelligence
      • Study Material
    • Apply
  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

Signed in as:

filler@godaddy.com

  • Home
  • Courses
    • Learn C
    • Coding Primer
    • Web Developer
    • Core JavaScript
    • Core Python
    • Blockchain With Python
    • React Developer
    • Learn SQL
    • Artificial Intelligence
    • Study Material
  • Apply

Account


  • My Account
  • Sign out


  • Sign In
  • My Account

Learn SQL With PostgreSQL

In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice with 4 projects—how to manipulate data and build queries that communicate with more than one table

15 hours live classes.

15 hours live classes.

15 hours live classes.

There will be a minimum of 15 hours classes for this course --a minimum of one hour each and minimum 15 hours.

Self Study Material

15 hours live classes.

15 hours live classes.

Keynotes and Videos will be provided for self study. These are well designed keynotes. 

Live Lectures

15 hours live classes.

Live Lectures

Students will able to interact with the teacher and can ask questions anytime.

Syllabus

  • What is a database?
  • Installing PostgreSQL on your own computer


  • Introduction
  • Select
  • As
  • Distinct
  • Where
  • Like I
  • Like II
  • Is Null
  • Between
  • And
  • Or
  • Order By
  • Limit
  • Case


  • Introduction to SQL
  • Relational Databases
  • Statements
  • Insert
  • Select
  • Alter
  • Update
  • Delete
  • Constraints


  • Introduction
  • Count
  • Sum
  • Max / Min
  • Average
  • Round
  • Group By I
  • Group By II
  • Having


  • Introduction
  • Combining Tables Manually
  • Combining Tables with SQL
  • Inner Joins
  • Left Joins
  • Primary Key vs Foreign Key
  • Cross Join
  • Union
  • With


Projects

  • Friends/ Family DataBase
  • Restaurant Queries
  • Finding Trends

Why We Started Teaching ?

We started teaching as an experimental service during Covid-2020. 

We have received great reviews and more are inquiring for courses. 


We have seen people are giving more than $1000 for coding courses which we think is too expensive and education should be affordable because it is the fundamental to development and growth. Many are learning from YouTube, and various other places. There’s nothing bad in that but the way is pathless and it is easier to deviate.


Everyone has their own background of knowledge and one thing which they choose themselves is path. They navigate from one video to another and most find themselves nowhere. Mentorship is necessary to achieve your goals in the shortest time and I think it’s also productive.


We offer online classes which is live and student can interact with the mentor unlike pre-recorded videos. Our courses are project based not slide based. 

We teach industry-based code not class code. 

Want to learn with us!!

We will reach you with more details about the course.

Learn coding by building projects.

Find out more

For more info

Please, reach here if you want to join this course!!

Message us on WhatsApp

anujsharma@thesiliconheart.com

Feedback

  • Privacy Policy
  • Terms of Services
  • Refund
  • Web Developer
  • Core Python
  • Apply
  • Python Coding Bootcamp

SiliconHeart Infotech Private Limited.

Copyright © 2022 CodersCode - All Rights Reserved.

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept