SQL for Newcomers - The Full Mastery Course

Simpliv

Course

Online

£ 10 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Hi!I'm Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I'm experienced enough.This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.I'm a beginner, is this course for me?Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.Is there any prerequisites to attend this course?The only thing you need is a PC or laptop with average performance and any operating system installed on. We'll be using Windows 10 for this course but the OS does not matter since the tech we'll be using is cross-platform and can work on Linux and Mac.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Able to select & filter data using SQL, fetch data for useful reports based on different requirements
Manipulate data by adding new records & modifying or deleting existing ones
Create & modify tables with setting constraints to columns
Learn some of the most useful built-in functions in SQL, as well as data type conversion
Join tables using different join types SQL provides
Brag about how cool they are knowing how to use SQL with their friends

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Install
  • Import
  • Database training
  • SQL
  • Database
  • Windows

Course programme

Introduction 2 lectures 02:16 Introduction Tools Used In This Course Introduction 2 lectures 02:16 Introduction Tools Used In This Course Introduction Introduction Introduction Introduction Tools Used In This Course Tools Used In This Course Tools Used In This Course Tools Used In This Course Setting Up Course Tools 9 lectures 19:50 Download PostgreSQL Install PostgreSQL Download SQLectron Install SQLectron Connect to PostgreSQL - Credentials Connect to PostgreSQL Using SQLectron Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Import Course Data Using SQLectron FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data Setting Up Course Tools 9 lectures 19:50 Download PostgreSQL Install PostgreSQL Download SQLectron Install SQLectron Connect to PostgreSQL - Credentials Connect to PostgreSQL Using SQLectron Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Import Course Data Using SQLectron FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data Download PostgreSQL Download PostgreSQL Download PostgreSQL Download PostgreSQL Install PostgreSQL Install PostgreSQL Install PostgreSQL Install PostgreSQL Download SQLectron Download SQLectron Download SQLectron Download SQLectron Install SQLectron Install SQLectron Install SQLectron Install SQLectron Connect to PostgreSQL - Credentials Connect to PostgreSQL - Credentials Connect to PostgreSQL - Credentials Connect to PostgreSQL - Credentials Connect to PostgreSQL Using SQLectron Connect to PostgreSQL Using SQLectron Connect to PostgreSQL Using SQLectron Connect to PostgreSQL Using SQLectron Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Data Used In This Course Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Please download this file and open it using Notepad or SQL client you downloaded & installed. Run the scripts in this file to build the tables used in this course. Import Course Data Using SQLectron Import Course Data Using SQLectron Import Course Data Using SQLectron Import Course Data Using SQLectron FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data Browsing & Filtering Data 15 lectures 58:01 Check Imported Data So.. What is a Database? SQL Data Types Finally Some Fun! Extracting Data Based on Requirements Filtering Data using WHERE Keyword Filter Data by Range Using BETWEEN Filter Data by Set of Values Using IN Filter Data by Date More Filtering by Date Another Query Filtering by Date Filter Data by Strings (Names, Addresses, ...) More Filtering by Strings More Filtering by Strings 2 More Filtering by Strings 3 How to Ignore Caps when Filtering by String Browsing & Filtering Data. 15 lectures 58:01 Check Imported Data So.. What is a Database? SQL Data Types Finally Some Fun! Extracting Data Based on Requirements Filtering Data using WHERE Keyword Filter Data by Range Using BETWEEN Filter Data by Set of Values Using IN Filter Data by Date More Filtering by Date Another Query Filtering by Date Filter Data by Strings (Names, Addresses, ...) More Filtering by Strings More Filtering by Strings 2 More Filtering by Strings 3 How to Ignore Caps when Filtering by String Check Imported Data Check Imported Data Check Imported Data Check Imported Data So.. What is a Database? So.. What is a Database? So.. What is a Database? So.. What is a Database? SQL Data Types SQL Data Types SQL Data Types SQL Data Types Finally Some Fun! Extracting Data Based on Requirements Finally Some Fun! Extracting Data Based on Requirements Finally Some Fun! Extracting Data Based on Requirements Finally Some Fun! Extracting Data Based on Requirements Filtering Data using WHERE Keyword Filtering Data using WHERE Keyword Filtering Data using WHERE Keyword Filtering Data using WHERE Keyword Filter Data by Range Using BETWEEN Filter Data by Range Using BETWEEN Filter Data by Range Using BETWEEN Filter Data by Range Using BETWEEN Filter Data by Set of Values Using IN Filter Data by Set of Values Using IN Filter Data by Set of Values Using IN Filter Data by Set of Values Using IN Filter Data by Date Filter Data by Date Filter Data by Date Filter Data by Date More Filtering by Date More Filtering by Date More Filtering by Date More Filtering by Date Another Query Filtering by Date Another Query Filtering by Date Another Query Filtering by Date Another Query Filtering by Date Filter Data by Strings (Names, Addresses, ...) Filter Data by Strings (Names, Addresses, ...) Filter Data by Strings (Names, Addresses, .. ...

Additional information

Can work on any operating system (Windows, Linux & MacOS)

See related categories

SQL for Newcomers - The Full Mastery Course

£ 10 + VAT

The best SQL Server courses

See all

See all