Play Video
Preview this course

SQL Masterclass

SQL course covering basic to advanced SQL topics for SQL Database (PostgreSQL). Beginner-friendly introduction to SQL Database

0 / 5
Rating
0 +
Students
0 Hrs
Duration

399

Price

SQL Masterclass

What you'll learn

Introduction to SQL

Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools. Learn the basic SQL syntax.

Useful SQL functions

Master SQL's most popular string, mathematical and date-time functions for data analytics.

Data Manipulation using SQL

Become competent in using sorting, filtering and grouping commands in SQL. Learn how to use sub queries.​

Joining data in SQL

Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.

Improving Query performance

Increase your efficiency by learning the best practices while writing SQL queries. Also learn using Views and Indexes for improved performance.

Our Happy Students!

This course is very good. My fear was it will be difficult because I dont use SQL, but I could read a code a bit. But this course turned on the light and Im so happy to took it. Each part is very comprehensive and I downloaded pdf’s, so if I would forgot anything I just check it.

4.5/5

Zoltan Imre Fekete

I learned so much from this course. I love the teaching style of both teachers. Along with the course, there is a pdf format of most of the lectures which will help us to revise these concepts in the future. Anybody who is beginner can learn so much from this course.

5/5

Sanjeev Kumar

Well, if you are a beginner like me, then it’s a best course to have. You will given the exercise after every section which will help you to know, how the question is asked based on the topic you have covered so far, this will also help you to revise what you have learned before.

5/5

Abhishek kumar singh

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate​

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

SQL- Desc

Course Content

Course Content

Introduction
Installation and getting started
Case Study : Demo
Fundamental SQL statements
Restore and Back-up
Selection commands: Filtering
Selection commands: Ordering
Alias
Aggregate Commands
Group By Commands
Conditional Statement
JOINS
Subqueries
Views and Indexes
String Functions
Mathematical Functions
Date-Time Functions
PATTERN (STRING) MATCHING
Data Type conversion functions
User Access Control Functions
Bonus Section: Nail that Interview!
Performance tuning tips
Conclusion

Leave a Reply