Mastering SQL and PostgreSQL: Go from SQL Beginner to Expert

Focused View

Aakriti E-Learning Academy

9:56:50

23 View

1. INTRODUCTION TO THE COURSE

1. Day 0 Course Overview & Content.mp4

09:46

2. Quick points about this learning journey.html

2. DAY 1 GETTING STARTED - DATABASE, SQL & INSTALLING POSTGRES

1. What is Database and SQL.mp4

07:23

2. Introduction to PostgreSQL.mp4

01:49

3. Installing PostgreSQL on Windows.mp4

09:47

4.1 Installing PostgreSQL on Mac.pdf

4. Installing PostgreSQL on Mac.html

5.1 Common Installation challenges and how to fix them.pdf

5. Common Installation challenges and how to fix them.html

6. Introduction to pgAdmin.mp4

10:38

3. DAY 2 QUERYING DATA - PART 1

1. SELECT.mp4

12:26

2. WHERE.mp4

10:26

3. AS (ALIAS).mp4

04:37

4. DISTINCT.mp4

05:01

5. CODING EXERCISE 1.mp4

08:10

6. CODING EXERCISE 2.mp4

07:49

4. DAY 3 QUERYING DATA - PART 2

1. ORDER BY.mp4

08:47

2. LIMIT.mp4

07:50

3. BETWEEN.mp4

04:31

4. IN Keyword.mp4

05:20

5. LIKE.mp4

12:50

6. CODING EXERCISE 1.mp4

07:51

7. CODING EXERCISE 2.mp4

06:06

5. Quiz

1. SQL Querying Data.html

6. DAY 4 GROUPING & AGGREGATING DATA

1. AGGREGATION FUNCTIONS - AVG, MIN, MAX, SUM.mp4

10:05

2. COUNT.mp4

05:30

3. GROUP BY.mp4

18:59

4. HAVING.mp4

06:38

5. SUB-QUERY.mp4

13:56

6. CODING EXERCISE 1.mp4

09:38

7. CODING EXERCISE 2.mp4

06:33

7. Quiz 2

1. Grouping & Aggregating Data.html

8. DAY 5 JOINS

1. Introduction to JOINS.mp4

05:15

2. INNER JOIN.mp4

20:51

3. LEFT JOIN.mp4

17:09

4. RIGHT JOIN.mp4

15:23

5. FULL JOIN.mp4

10:06

6. UNION.mp4

06:06

7. MUST WATCH Lets Recap Joins one more time.mp4

05:50

8. CODING EXERCISE 1.mp4

10:27

9. CODING EXERCISE 2.mp4

12:26

10. CODING EXERCISE 3.mp4

13:09

9. Quiz 3

1. Joins.html

10. DAY 6 DATA TYPES & OPERATIONS

1. Data Types & how to choose the correct one.mp4

14:30

2. DateTime Functions.mp4

12:47

3. EXTRACT.mp4

08:16

4. Mathematical Functions.mp4

15:31

5. String Functions.mp4

18:54

6. CODING EXERCISE 1.mp4

09:07

7. CODING EXERCISE 2.mp4

08:36

11. Quiz 4

1. Data Types & Operations.html

12. DAY 7 CONDITIONAL EXPRESSIONS & OPERATORS

1. CAST.mp4

07:06

2. CASE.mp4

13:56

3. COALESCE.mp4

09:04

4. NULLIF.mp4

10:01

5. VIEW.mp4

09:47

6. CODING EXERCISE 1.mp4

13:41

7. CODING EXERCISE 2.mp4

02:21

13. Quiz 5

1. Conditional Expressions & Operators.html

14. DAY 8 CREATE DATABASE AND TABLES

1. Understanding Keys - Primary Key, Foreign Key.mp4

11:50

2. Constraints.mp4

04:54

3. Database - CREATE & DROP.mp4

09:33

4. CREATE TABLE.mp4

14:10

5. INSERT.mp4

11:57

6. UPDATE.mp4

07:10

7. ALTER.mp4

11:17

8. DELETE.mp4

06:28

9. DROP.mp4

04:29

10. TRUNCATE.mp4

05:12

11. CODING EXERCISE 1.mp4

11:24

12.1 Insert Statement.txt

12. INSERT statement for next coding exercise.html

13. CODING EXERCISE 2.mp4

04:32

15. Quiz 6

1. Quiz 6 Creating Database and Tables.html

16. DAY 9 BECOME JOB READY

1. Resume Preparation & Interview Tips.mp4

08:15

2.1 Resume Template.docx

2. Download Resume Template.html

3.1 Interview Questions.pdf

3. 50 SQL Interview Questions, explained to remember.html

17. [MUST WATCH] IMPORTANT NOTE

1. Final Video - Do Watch This.mp4

02:54

2.1 SQL Course Slides.pdf

2. Download Course Materials.html

3. Connect with me on LinkedIn.html

4. Bonus Section.html

Description

Master SQL, PostgreSQL, Database: Practical Hands-on, Coding Exercises, Quizzes, Interview Prep, Lifetime Query Support

What You'll Learn?

Writing SQL queries - basic to advanced ones
Setting up a database
Understand real world scenarios, how to do data analysis, and generate reports
Learn about Joins and other advanced concepts, in a very simple way
Tons of practical hands-on, coding exercises and quizzes

Who is this for?

Aspiring Data Scientists

Developers

QA/Testers

Anyone else seeking to upskill in the data field

What You Need to Know?

Nothing, just a computer and a desire to learn :)

More details

Description
Learn SQL and Database and become a master in Data Science, Development or QA. Take up this journey from being a SQL beginner to intermediate to advanced user. Engage in practical, hands-on sessions, sharpen your skills with coding exercises, and test your knowledge with quizzes at every step of your journey. Enroll Today and begin your data learning!!

In today's data-driven world, the ability to harness the power of databases is an indispensable skill for a wide range of professionals, from aspiring data scientists and Developers to QA specialists. Welcome to " Mastering SQL and PostgreSQL: Go from SQL Beginner to Expert", a comprehensive course designed to empower you with the knowledge and practical experience needed to excel in the exciting world of database management.
Enroll now, and let's embark on this exciting journey together. By the end of this course, you'll be armed with the expertise to manage, query, and analyze data like a pro. Don't miss out on this opportunity to level up your career and stay at the forefront of the data revolution!

Why SQL and PostgreSQL?
SQL (Structured Query Language) is the universal language of databases, and PostgreSQL is one of the most powerful, open-source relational database management systems available. Learning SQL and PostgreSQL not only opens the doors to numerous career opportunities but also provides you with the fundamental skills needed to manage and analyze data effectively. This learning can be applied to other databases also like MS-SQL, MySQL, Redshift, Cloudera etc.

What Will You Learn?
Foundations of SQL: Start your SQL journey by mastering the basics. Learn how to write queries to retrieve data, and apply conditions, ordering, grouping etc.
Master JOIN: JOIN is a tricky concept in SQL. We make sure to explain it very simply, with clear explanations, practical tips and hands-on practice exercises for a solid understanding.
Advanced SQL Techniques: Dive deeper into SQL with advanced topics such as sub-queries, aggregation, case, views etc.
Understanding Data Types: Explore the various data types used in SQL and how you can perform different operations on them.
Database Management & Analysis: Learn about creating databases, designing efficient tables, and inserting or updating data with step-by-step guidance.
PostgreSQL Essentials: Explore the unique features and capabilities of PostgreSQL and pgAdmin.
Hands-on Practical Learning: Apply your knowledge through a series of hands-on, query simulations, coding exercises and quizzes that simulate the challenges you'll encounter in your career.
And much, much moreâ€¦.

Why Take This Course?
1. Highly Practical Approach: This course is all about hands-on, practical learning. You'll write SQL queries and work with PostgreSQL databases from day one.
2. Coding Exercises: Sharpen your skills with coding exercises that reinforce your understanding of SQL and PostgreSQL concepts.
3. Quizzes and Assessments: Test your knowledge and track your progress with quizzes and assessments at the end of each section.
4. Career Opportunities: Data is in high demand across industries. By mastering SQL and PostgreSQL, you'll be well-equipped to pursue roles in data analysis, database administration, software development and more.
5. Interview Preparation Guide: 50 interview questions to help you land your dream job.
6. Life Time Support: You won't be alone on this learning journey. Get lifetime query support to answer your questions, provide guidance, and ensure your success.

Who Is This Course For?
- Aspiring Data Scientists: Data is the lifeblood of data science. Learn how to retrieve and manipulate data using SQL, a critical skill for data scientists.
- Developers: Enhance your software development skills by learning SQL and how to interact with databases programmatically.
- Quality Assurance Specialists: Learn how to write SQL queries for testing and pulling test data.
- Anyone Seeking Data Skills: Whether you're a beginner or have some experience, this course will help you build a strong foundation in SQL and PostgreSQL.
Who this course is for:
Aspiring Data Scientists
Developers
QA/Testers
Anyone else seeking to upskill in the data field

User Reviews

Rating

average 0

Total votes0

Focused display

Have a passion to learn, and up-skillI've 10+ years of experience in software industry in project management, automation, functional & non-functional testing. I've also worked as part-time trainer and corporate instructor. Looking to continue the spirit on Udemy and help learners. As a member of my course, you will get continuous support for any queries, concern, feedback you have. So never hesitate to drop me a message, and you can expect back quick reply.Thank you, and keep learning!!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.