Signed in as:
filler@godaddy.com
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.
For more info
Please, reach here if you want to join this course!!
Feedback
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.