SQL for beginners with: Microsoft SQL Server | PostgreSQL

Query and interact with databases using SQL

SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.

What you’ll learn

  • Backup a database.
  • Restore a database.
  • Create stored procedures.
  • Write SQL queries with confidence.
  • Select data from specific table column.
  • Select data from all table columns.
  • Join data from multiple tables.
  • Insert records into the database.
  • Extract data from database using subqueries.
  • Delete records.
  • Query databases with multiple operators.
  • Group data.
  • Aggregate data.
  • Filter Data from database.
  • Sort data from database.

Course Content

  • SQL Server Setup –> 10 lectures • 49min.
  • SQL | Microsoft SQL (T-SQL ) Fundamentals –> 15 lectures • 1hr 2min.
  • Filtering data from SQL Server –> 6 lectures • 52min.
  • Sorting data from SQL Server Database –> 4 lectures • 15min.
  • PostgreSQL Setup –> 8 lectures • 52min.
  • SQL Fundamentals with PostgreSQL Database –> 8 lectures • 1hr 1min.
  • SQL: Query data in PostgreSQL using Operators –> 14 lectures • 1hr 49min.
  • SQL: Data Aggregation with PostgreSQL –> 6 lectures • 52min.
  • Joining Data from multiple tables in PostgreSQL –> 6 lectures • 51min.

SQL for beginners with: Microsoft SQL Server | PostgreSQL

Requirements

  • No SQL experience required..

SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.

Millions of data points are being generated every minute and raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.

 

SQL is the most common language for extracting and organising data that is stored in a relational database.

A database is a table that consists of rows and columns. SQL is the language of databases.

It facilitates retrieving specific information from databases that are further used for analysis.

 

SQL can be used to:

 

  • Execute queries against a database
  • Retrieve data from a database
  • Insert records into a database
  • Update records in a database
  • Delete records from a database
  • Create new databases, or new tables in a database
  • Create stored procedures & views in a database
  • Set permissions on tables, procedures, and views
  • Backup and restore data
  • Join data from multiple tables

 

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other

software applications—which may run either on the same computer or on another computer across a network.

 

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.