Overview Program & Features Course Content Corporate / Individual Training

Course Overview

SQL is one of the most in-demand tech skills, so learning it is one of the quickest ways to improve your career prospects! You will learn quickly in this course and will be challenged and tested to improve your understanding! At Howe, you will learn how to read and write complex queries to a database using PostgreSQL, one of the most in-demand skills.

Program Feature

  • Corporate Trainers for Training Corporate
  • Affordable Course Fees
  • Flexible Schedule
  • Free Demo on Request
  • Certification on Completion
  • Create Your Own Content

Course Content

  • Intro to database
  • DBMS VS RDMS
  • Intro to MYSQL
  • Tables and Relationship in SQL
  • Downloading MYSQL
  • Configuring SQL
  • Connecting to server
  • DATABASE MANIPULATION
  • STORAGE ENGINES
  • CREATING AND MANAGING TABLES
  • FILTERING DATA
  • SORTING TABLE
  • GROUPING
  • JOINS
  • UNION
  • HAVING
  • COMMENTS AND OPERATORS
  • ALIAS
  • EMULATION
  • SUBQUERY
  • EXISTS
  • NOT OPERATOR
  • MINUS
  • IN
  • CHAR VARCHAR
  • NVARCHAR
  • AGGREGATE FUNCTION
  • SCALAR
  • STRING
  • NUMERIC
  • DATE AND TIME
  • GENERAL
  • MISCELLANEOUS
  • CREATING VIEWS USING WITH CHECK OPTION LOCAL
  • CASCADED CHECK OPTION
  • LOCAL CHECK OPTION
  • ALTERING AND RENAMING VIEWS
  • COMPOUND AND CONDITIONAL STATEMENTS
  • CASE STATEMENT
  • LOOP STATEMENT
  • WHILE
  • LEAVE
  • REPEAT
  • STORED PROCEDURES
  • TRIGGER
  • CURSORS
back to top