Published 11/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.62 GB | Duration: 11h 24m
Learn complete MySQL & PostgreSQL. Solve HackerRank problems to get Gold star and 670 points in SQL HackerRank
What you’ll learn
Get silver and gold rank with 600+ points
Solve 30+ questions of HackerRank SQL section
How to write SELECT queries to fetch relevant data in PostgreSQL and MySQL
How to filter and sort the data using WHEN, logical operators and ORDER BY
How to group and aggregate data in PostgreSQL and MySQL
How to apply joins and combining queries in PostgreSQL and MySQL
String, mathematical, date-time functions and pattern matching in PostgreSQL and MySQL
Understanding of VIEWS and INDEXES in PostgreSQL and MySQL
How to write subqueries in PostgreSQL and MySQL
Requirements
Just a PC with any web browser
Description
6 Reasons why you should choose this SQL courseSolve complete 20 questions of ‘Weather Observation Station’ case study of HackerRankOther HackerRank SQL case studies we will be solvingThe Pads Binary Tree Nodes New Companies The Report Top Companies Ollivander’s Inventory Challenges Contest Leaderboard Placements Symmetric Pairs SQL Project PlanningCarefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businessesComprehensive – covers basic and advanced SQL statements in both, PostgreSQL and MySQLDownloadable resources covering important topics on SQLYour queries on SQL and anything covered in the Masterclass will be responded by the Instructor himselfA Verifiable Certificate of Completion is presented to all students who undertake this SQL course.Why should you choose this course?This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL and MySQL are highly desired skills for database management and data analysis roles. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.What makes us qualified to teach you?The course is taught by Abhishek, Pukhraj and Nadeem. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced SQL, PostgreSQL, MySQL, database management, and various data analysis tools available in the market.Our PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.By the end of this course, your confidence in using SQL will soar. You’ll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.Go ahead and click the enroll button, and I’ll see you in lesson 1!CheersStart-Tech AcademyFAQ’sWhy learn SQL?SQL is the most universal and commonly used database language. It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put, If you want to access databases then yes, you need to know SQL.It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people to get interesting data from the database. It is also an English-like language so anyone who can use English at a basic level can write SQL queries easily.SQL is one of the most sought-after skills by hiring employers.You can earn good moneyHow much time does it take to learn SQL?SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.What’s the difference between SQL and PostgreSQL?SQL is a language. Specifically, the "Structured Query Language"PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS’s, others of which are Oracle, Informix, MySQL, and MSQL.All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it’s all still SQL.Which is better, PostgreSQL or MySQL?Both are excellent products with unique strengths, and the choice is often a matter of personal preference.PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.Open source development will bring more features to subsequent releases of both databases.Who uses these databases?Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.Companies that use MySQL: Uber, Airbnb, Netflix, Udemy, Pinterest etc.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Course Resources
Lecture 2 Course Resources
Lecture 3 This is a milestone!
Section 3: HackerRank – Weather Observation Station 20 questions
Lecture 4 Weather Observation Station 1 – 15 points – EASY level
Lecture 5 Weather Observation Station 2 – 15 points – EASY level
Lecture 6 Weather Observation Station 3 – 10 points – EASY level
Lecture 7 Weather Observation Station 4 – 10 points – EASY level
Lecture 8 Weather Observation Station 5 – 30 points – EASY level
Lecture 9 Weather Observation Station 6 – 10 points – EASY level
Lecture 10 Weather Observation Station 7 – 10 points – EASY level
Lecture 11 Weather Observation Station 8 – 15 points – EASY level
Lecture 12 Weather Observation Station 9 – 10 points – EASY level
Lecture 13 Weather Observation Station 10 – 10 points – EASY level
Lecture 14 Weather Observation Station 11 – 15 points – EASY level
Lecture 15 Weather Observation Station 12 – 15 points – EASY level
Lecture 16 Weather Observation Station 13 – 10 points – EASY level
Lecture 17 Weather Observation Station 14 – 10 points – EASY level
Lecture 18 Weather Observation Station 15 – 15 points – EASY level
Lecture 19 Weather Observation Station 16 – 10 points – EASY level
Lecture 20 Weather Observation Station 17 – 15 points – EASY level
Lecture 21 Weather Observation Station 18 – 25 points – MEDIUM level
Lecture 22 Weather Observation Station 19 – 30 points – MEDIUM level
Lecture 23 Weather Observation Station 20 – 40 points – MEDIUM level
Section 4: HackerRank – Medium & Hard questions
Lecture 24 The Pads – 30 points – MEDIUM level
Lecture 25 Binary Tree Nodes – 30 points – MEDIUM level
Lecture 26 New Companies – 30 points – MEDIUM level
Lecture 27 The Report – 20 points – MEDIUM level
Lecture 28 Top Companiess – 30 points – MEDIUM level
Lecture 29 Ollivander’s Inventory – 30 points – MEDIUM level
Lecture 30 Challenges – 30 points – MEDIUM level
Lecture 31 Contest Leaderboard – 30 points – MEDIUM level
Lecture 32 Placements – 40 points – MEDIUM level
Lecture 33 Symmetric Pairs – 40 points – MEDIUM level
Lecture 34 SQL Project Planning – 40 points – MEDIUM level
Section 5: Setting up PostgreSQL and PGAdmin
Lecture 35 Installing PostgreSQL and pgAdmin in your PC
Lecture 36 If pgAdmin is not opening…
Section 6: Installing MySQL
Lecture 37 Installing and Setting up MySQL
Section 7: Fundamental SQL statements
Lecture 38 CREATE in PostgreSQL
Lecture 39 CREATE in MySQL
Lecture 40 INSERT in PostgreSQL
Lecture 41 INSERT in MySQL
Lecture 42 Import data from File in PostgreSQL
Lecture 43 Import data from File in MySQL
Lecture 44 SELECT statement in PostgreSQL
Lecture 45 SELECT statement in MySQL
Lecture 46 SELECT DISTINCT in PostgreSQL
Lecture 47 SELECT DISTINCT in MySQL
Lecture 48 WHERE in PostgreSQL
Lecture 49 WHERE in MySQL
Lecture 50 Logical Operators in PostgreSQL
Lecture 51 Logical Operators in MySQL
Lecture 52 UPDATE in PostgreSQL
Lecture 53 UPDATE in MySQL
Lecture 54 DELETE in PostgreSQL
Lecture 55 DELETE in MySQL
Lecture 56 ALTER Part 1 in PostgreSQL
Lecture 57 ALTER Part 2 in PostgreSQL
Lecture 58 ALTER in MySQL
Section 8: Restore and Back-up in PostgreSQL
Lecture 59 Restore and Back-up
Lecture 60 Debugging restoration issues
Lecture 61 Creating DB using CSV files
Lecture 62 Debugging summary and Code for CSV files
Section 9: Restore and Back-up in MySQL
Lecture 63 Restoring and Back-up in MySQL
Lecture 64 Restore and Back-up in MySQL
Section 10: Selection commands: Filtering
Lecture 65 IN in PostgreSQL
Lecture 66 IN in MySQL
Lecture 67 BETWEEN in PostgreSQL
Lecture 68 BETWEEN in MySQL
Lecture 69 LIKE in PostgreSQL
Lecture 70 LIKE in MySQL
Section 11: Selection commands: Ordering
Lecture 71 Side Lecture: Commenting in SQL
Lecture 72 ORDER BY in PostgreSQL
Lecture 73 ORDER BY in MySQL
Lecture 74 LIMIT in PostgreSQL
Lecture 75 LIMIT in MySQL
Section 12: Aliases
Lecture 76 AS in PostgreSQL
Lecture 77 AS in MySQL
Section 13: Aggregate Commands
Lecture 78 COUNT in PostgreSQL
Lecture 79 COUNT in MySQL
Lecture 80 SUM in PostgreSQL
Lecture 81 SUM in MySQL
Lecture 82 AVERAGE in PostgreSQL
Lecture 83 AVERAGE in MySQL
Lecture 84 MIN & MAX in PostgreSQL
Lecture 85 MIN & MAX in MySQL
Section 14: Group By Commands
Lecture 86 GROUP BY in PostgreSQL
Lecture 87 GROUP BY in MySQL
Lecture 88 HAVING in PostgreSQL
Lecture 89 HAVING in MySQL
Section 15: Conditional Statement
Lecture 90 CASE WHEN in PostgreSQL
Lecture 91 CASE WHEN in MySQL
Section 16: JOINS
Lecture 92 Introduction to Joins
Lecture 93 Concepts of Joining and Combining Data
Lecture 94 Preparing the data
Lecture 95 Inner Join in PostgreSQL
Lecture 96 Inner Join in MySQL
Lecture 97 Left Join in PostgreSQL
Lecture 98 Left Join in MySQL
Lecture 99 Right Join in PostgreSQL
Lecture 100 Right Join in MySQL
Lecture 101 Full Outer Join in PostgreSQL
Lecture 102 Full Outer Join in MySQL
Lecture 103 Cross Join in PostgreSQL
Lecture 104 Cross Join in MySQL
Lecture 105 Intersect and Intersect ALL in PostgreSQL
Lecture 106 Intersect in MySQL
Lecture 107 Except in PostgreSQL
Lecture 108 Except in MySQL
Lecture 109 Union in PostgreSQL
Lecture 110 Union in MySQL
Section 17: Subqueries
Lecture 111 Subqueries: Subquery in WHERE clause in PostgreSQL
Lecture 112 Subqueries: Subquery in FROM clause in PostgreSQL
Lecture 113 Subqueries: Subquery in SELECT in PostgreSQL
Lecture 114 Subqueries in MySQL
Section 18: Views and Indexes
Lecture 115 VIEWS in PostgreSQL
Lecture 116 VIEWS in MySQL
Lecture 117 INDEX in PostgreSQL
Lecture 118 INDEX in MySQL
Section 19: String Functions
Lecture 119 LENGTH in PostgreSQL
Lecture 120 UPPER LOWER in PostgreSQL
Lecture 121 REPLACE in PostgreSQL
Lecture 122 TRIM, LTRIM, RTRIM in PostgreSQL
Lecture 123 CONCATENATION in PostgreSQL
Lecture 124 SUBSTRING in PostgreSQL
Lecture 125 LIST AGGREGATION in PostgreSQL
Lecture 126 String Functions Part 1 in MySQL
Lecture 127 String Functions Part 2 in MySQL
Section 20: Mathematical Functions
Lecture 128 CEIL & FLOOR in PostgreSQL
Lecture 129 RANDOM in PostgreSQL
Lecture 130 SETSEED in PostgreSQL
Lecture 131 ROUND in PostgreSQL
Lecture 132 POWER in PostgreSQL
Lecture 133 Mathematical Functions in MySQL
Section 21: Date-Time Functions
Lecture 134 CURRENT DATE & TIME in PostgreSQL
Lecture 135 AGE in PostgreSQL
Lecture 136 EXTRACT in PostgreSQL
Lecture 137 Date-Time Functions in MySQL
Section 22: Data type Conversion
Lecture 138 Data Type conversion to string in PostgreSQL
Lecture 139 Data Type conversion to Number and Date in PostgreSQL
Lecture 140 Data Type conversion in MySQL
Section 23: PATTERN (STRING) MATCHING
Lecture 141 PATTERN MATCHING BASICS
Lecture 142 Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)
Lecture 143 Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)
Lecture 144 Pattern matching in MySQL
Section 24: Congratulations
Lecture 145 The final milestone!
Lecture 146 Bonus Lecture
Working Professionals beginning their Data journey,Anyone curious to learn and compare both PostgreSQL and MySQL,Students about to join their first corporate job
Homepage
https://www.udemy.com/course/sql-hackerrank-challenge/
Download From 1DL
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM