Introduction to SQL query language

  1. Next course On demand
  2. Send inquiry

During two days of training, you will learn what are databases, how to merge tables and manipulate data. Learning the SQL query language will be done on the Microsoft SQL Server platform, and education involves demonstration on real-case examples.

SUMMARY

The amount of data generated in the databases becomes increasingly bigger and skills to query analytical database are must to answer a business question. SQL is a standard in working with databases and knowing the SQL query language in analytical business becomes an absolutely necessary skill. During two days of training, you will learn what are databases, how to join tables and manipulate data. Learning the SQL query language will be done on the Microsoft SQL Server platform, and education involves demonstration on real-case examples.

OBJECTIVES

The purpose of the course is to prepare attendees for SQL queries over their own relational database that will allow them to create simple to less complex reports.

AUDIENCE?

The course is intended for all those interested in learning the basics of SQL query language. This course is intended for business and technical users, regardless of experience.

CONTENT

Day 1:

  • Introduction to relational databases
  • Simple SQL queries
  • Exercise 1.
  • Retrieve data from multiple tables (JOIN)
  • Exercise 2.
  • Scalar and arithmetic functions
  • Exercise 3.
  • Filtering data (WHERE, HAVING, IN, BETWEEN)
  • Exercise 4.

Day 2:

  • Aggregated Functions and Data Grouping
  • Exercise 1.
  • Date functions
  • Exercise 2.
  • Data aggregation
  • Exercise 3.
  • Subqueries
  • Exercise 4.
  • Editing data
  • Exercise 5.


Warning: Creating default object from empty value in /home/customer/www/inteligencija.com/public_html/wp-content/themes/inteligencija/includes/courses.php on line 57

You are interested in this course? Ask us for more info!