SQL

SQL

These skills are applicable to any other major SQL database, such as MySQL, MS SQL Server, Amazon Redshift, Oracle, and much more.     Course Topic Overview and Description: In this course you’ll learn how to read and write complex queries to a database using one of the most in demand skill in SQL. These skills are applicable to any other major SQL database, such as MySQL, MS SQL Server, Amazon Redshift, Oracle, and much more.   Advantages of taking this course: Learn how to write complex queries to a database Use SQL to query a database Use SQL to perform data analysis The course is for 5 days. Various instructional methods will be used to teach the objectives mentioned above. The training method would be completely interactive and participative. Students will receive course materials which will be discussed during class. Who Should Attend: This course is designed for anyone who is interested in learning more about SQL, PostgreSQL, or basic data analysis. Related Job Functions: SQL Database Admin SQL Analyst IT Admin Course Delivery: The course will be delivered using formal lectures combined with questions based on the topics. The class will be conducted both online and in-person. 

    

Day 1

  • Introduction
  • PostGreSQL Installation Mac/Windows
  • Databases and Tables
  • SQL Statement Fundamentals

Day 2 – GROUP BY Statements

  • MIN MAX SUM and AVG
  • GROUP BY
  • HAVING

Day 3 - JOINS

  • Overview of JOINS
  • AS Statement
  • Inner Join
  • Join Types
  • Outer Joins
  • Union

Day 4 – Advanced SQL Commands

  • Advanced SQL Commands
  • Timestamps and Extract
  • Mathematical Functions
  • String Function and Operators
  • SubQuery
  • Self-Join

Day 5 – Creating Databases & Tables

  • Data Types
  • Primary Keys and Foreign Keys
  • Resource for Create Table Code
  • Note on Constraints
  • Insert, Update, Delete
  • Alter Table, Drop Table
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech