Published 11/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.84 GB | Duration: 8h 52m
Learn most popular SQL dialects, PostgreSQL & MSSQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MSSQL
What you’ll learn
How to write SELECT queries to fetch relevant data in PostgreSQL and MS SQL
How to filter and sort the data using WHEN, logical operators and ORDER BY
How to group and aggregate data in PostgreSQL and MS SQL
How to apply joins and combining queries in PostgreSQL and MS SQL
String, mathematical, date-time functions and pattern matching in PostgreSQL and MS SQL
Understanding of VIEWS and INDEXES in PostgreSQL and MS SQL
How to write subqueries in PostgreSQL and MS SQL
Requirements
Just a PC with any web browser
Description
4 Reasons why you should choose this SQL courseCarefully 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 MS SQLDownloadable resources covering essential 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 MS SQL 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, MS SQL, 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 MS SQL. 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 has minor variations in the "dialect" of SQL that they use, but it’s all still SQL.Which is better, PostgreSQL or MS SQL?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 MS SQL 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 MS SQL: 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: Setting up PostgreSQL and PGAdmin
Lecture 4 Installing PostgreSQL and pgAdmin in your PC
Lecture 5 If pgAdmin is not opening…
Section 4: Installing MS SQL
Lecture 6 Installing and Setting up MS SQL
Lecture 7 Debugging the installation process
Section 5: Fundamental SQL statements
Lecture 8 CREATE in PostgreSQL
Lecture 9 CREATE in MS SQL
Lecture 10 INSERT in PostgreSQL
Lecture 11 INSERT in MS SQL
Lecture 12 Import data from File in PostgreSQL
Lecture 13 Import data from File in MS SQL
Lecture 14 SELECT statement in PostgreSQL
Lecture 15 SELECT statement in MS SQL
Lecture 16 SELECT DISTINCT in PostgreSQL
Lecture 17 SELECT DISTINCT in MS SQL
Lecture 18 WHERE in PostgreSQL
Lecture 19 WHERE in MS SQL
Lecture 20 Logical Operators in PostgreSQL
Lecture 21 Logical Operators in MS SQL
Lecture 22 UPDATE in PostgreSQL
Lecture 23 UPDATE in MS SQL
Lecture 24 DELETE in PostgreSQL
Lecture 25 DELETE in MS SQL
Lecture 26 ALTER Part 1 in PostgreSQL
Lecture 27 ALTER Part 2 in PostgreSQL
Lecture 28 ALTER in MS SQL
Section 6: Restore and Back-up in PostgreSQL
Lecture 29 Restore and Back-up
Lecture 30 Debugging restoration issues
Lecture 31 Creating DB using CSV files
Lecture 32 Debugging summary and Code for CSV files
Section 7: Restore and Back-up in MS SQL
Lecture 33 Restoring and Back-up in MySQL
Lecture 34 Restore and Back-up in MS SQL
Section 8: Selection commands: Filtering
Lecture 35 IN in PostgreSQL
Lecture 36 IN in MS SQL
Lecture 37 BETWEEN in PostgreSQL
Lecture 38 BETWEEN in MS SQL
Lecture 39 LIKE in PostgreSQL
Lecture 40 LIKE in MS SQL
Section 9: Selection commands: Ordering
Lecture 41 Side Lecture: Commenting in SQL
Lecture 42 ORDER BY in PostgreSQL
Lecture 43 ORDER BY in MS SQL
Lecture 44 LIMIT in PostgreSQL
Lecture 45 LIMIT in MS SQL
Section 10: Aliases
Lecture 46 AS in PostgreSQL
Lecture 47 AS in MS SQL
Section 11: Aggregate Commands
Lecture 48 COUNT in PostgreSQL
Lecture 49 SUM in PostgreSQL
Lecture 50 AVERAGE in PostgreSQL
Lecture 51 MIN & MAX in PostgreSQL
Lecture 52 Aggregate Functions in MS SQL
Section 12: Group By Commands
Lecture 53 GROUP BY in PostgreSQL
Lecture 54 GROUP BY in MS SQL
Lecture 55 HAVING in PostgreSQL
Lecture 56 HAVING in MS SQL
Section 13: Conditional Statement
Lecture 57 CASE WHEN in PostgreSQL
Lecture 58 CASE WHEN in MS SQL
Section 14: JOINS
Lecture 59 Introduction to Joins
Lecture 60 Concepts of Joining and Combining Data
Lecture 61 Preparing the data
Lecture 62 Inner Join in PostgreSQL
Lecture 63 Inner Join in MS SQL
Lecture 64 Left Join in PostgreSQL
Lecture 65 Left Join in MS SQL
Lecture 66 Right Join in PostgreSQL
Lecture 67 Right Join in MS SQL
Lecture 68 Full Outer Join in PostgreSQL
Lecture 69 Full Outer Join in MS SQL
Lecture 70 Cross Join in PostgreSQL
Lecture 71 Cross Join in MS SQL
Lecture 72 Intersect and Intersect ALL in PostgreSQL
Lecture 73 Except in PostgreSQL
Lecture 74 Union in PostgreSQL
Lecture 75 Intersect, Except & Union in MS SQL
Section 15: Subqueries
Lecture 76 Subqueries: Subquery in WHERE clause in PostgreSQL
Lecture 77 Subqueries: Subquery in FROM clause in PostgreSQL
Lecture 78 Subqueries: Subquery in SELECT in PostgreSQL
Lecture 79 Subqueries in MS SQL
Section 16: Views and Indexes
Lecture 80 VIEWS in PostgreSQL
Lecture 81 VIEWS in MS SQL
Lecture 82 INDEX in PostgreSQL
Lecture 83 INDEX in MS SQL
Section 17: String Functions
Lecture 84 LENGTH in PostgreSQL
Lecture 85 UPPER LOWER in PostgreSQL
Lecture 86 REPLACE in PostgreSQL
Lecture 87 TRIM, LTRIM, RTRIM in PostgreSQL
Lecture 88 CONCATENATION in PostgreSQL
Lecture 89 SUBSTRING in PostgreSQL
Lecture 90 LIST AGGREGATION in PostgreSQL
Lecture 91 String Functions in MS SQL
Section 18: Mathematical Functions
Lecture 92 CEIL & FLOOR in PostgreSQL
Lecture 93 RANDOM in PostgreSQL
Lecture 94 SETSEED in PostgreSQL
Lecture 95 ROUND in PostgreSQL
Lecture 96 POWER in PostgreSQL
Lecture 97 Mathematical Functions in MS SQL- Part 1
Lecture 98 Mathematical Functions in MS SQL- Part 2
Section 19: Date-Time Functions
Lecture 99 CURRENT DATE & TIME in PostgreSQL
Lecture 100 AGE in PostgreSQL
Lecture 101 EXTRACT in PostgreSQL
Lecture 102 Date-Time Functions in MS SQL
Section 20: Data Type conversion
Lecture 103 Data Type conversion to string in PostgreSQL
Lecture 104 Data Type conversion to Number and Date in PostgreSQL
Section 21: PATTERN (STRING) MATCHING
Lecture 105 PATTERN MATCHING BASICS
Lecture 106 Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)
Lecture 107 Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)
Lecture 108 Pattern matching in MS SQL
Section 22: Congratulations
Lecture 109 The final milestone!
Lecture 110 Bonus Lecture
Working Professionals beginning their Data journey,Anyone curious to learn and compare both PostgreSQL and MS SQL,Students about to join their first corporate job
Homepage
https://www.udemy.com/course/postgresql-and-ms-sql-for-beginners/
Download From 1DL
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 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