Introduction to SQL

Introduction to SQL

PUBLIC COURSES

£1750

- Anyone can join the training
- Course outline as presented on the website
- Small groups, 3-10 people

PRIVATE COURSES

Price set individually

- Training workshop just for your team
- You choose date and location of the training
- Course outline tailored to your needs

About the training

Data Analytics is the future – We live in times where information plays a mayor role in business. Thanks to the technology of collecting, storing, processing and prediction data is the core of every decision-making process. In this world knowledge of the most popular database language – SQL – is a necessity not only for the Data Scientist but virtually everyone.

Effective training – Introduction to SQL is designed in such way that everyone can easily learn how to effectively use SQL language. During the three-day training, you will gain solid SQL language foundation and practical tips on effective data management. Forget about boring and unproductive PowerPoint presentations. This course is conducted using Live Script method, where 100% of training time you will work directly with SQL language.

People come first – Our trainers are experienced professionals with a great passion for SQL and teaching. They have hands-on experience with Oracle, Teradata, and MS SQL databases and have worked on projects for the biggest companies in the FMCG industry, telecommunications, and banking. They will make sure you enjoy the training and get the most of it.

Who is this training for?

This training is designed for people who want to effectively use SQL. Whether it is your very first time working with databases or you just want to systemize your knowledge this training is for you!

What will I learn?

After completing the training you will be able to:

    • Create database schemas and filling them with data, modify data model
    • Create queries choosing the appropriate data from the database
    • Filter the results, group and sort the data extracts
    • Create queries choosing data from more than one table with the relevant conditions
    • Format query results
    • Perform basic data analysis
    • Create new users and give them permissions
    • Manage basic database objects
    • Create views

Course outline

  1. Introduction to Databases
    • Definition of database
    • Uses of database systems
    • Types of databases
    • Connecting to database
    • Installation + environment configuration
  2. Database theory
    •   Structure
    •   Types of data
    •   Tables
    •   Referential Integrity
  3. Sessions and transactions
    •   What are Sessions
    •   What are Transactions
    •   Managing Sessions and Transactions
  4. Managing a database (DDL instructions)
    •   Creating objects
    •   Deleting objects
    •   Editing objects
    •   Adding data
    •   Removing data
    •   Refreshing data
    •   Exercises
  5. Basic queries
    •   SELECT Statement
    •   Structure of a query
    •   Aliases
    •   Good practices
    •   Queries examples
    •   Exercises
  6. SQL operators
    •   What are operators
    •   Types of operators
    •   Examples and exercises
  7. Filtering records in SQL
    •  WHERE clause
    •  HAVING clause
    •  TOP, LIMIT, ROWNUM()
    •  Examples and exercises
  8. Grouping and sorting data
    •  ORDER BY
    •  GROUP BY
    •  CUBE and ROLL UP
    •   Aggregation functions
    •  Examples and exercises
  9. Sub Queries
    •   What are sub queries?
    •   How can Sub Queries be used?
    •   Operators in Sub Queries
    •   Examples and exercises
  10. Formatting results
    •   Formatting functions
    •   Examples and exercises
  11. Joining query results
    •   Methods to join query results
    •   Examples and exercises
  12. Joining tables
    •  Theory
    •   Clauses for joining tables
    •   Examples and exercises
  13. Advanced functions
    •   Analytical functions
    •   Examples and exercises
  14. Database structures
    •   Indices
    •   Views
    •   Triggers
    •   Partitioning
    •   Examples and exercises
  15. Managing users
    •   Creating and Removing users
    •   Giving and modifying permissions
    •   Examples and exercises

Course Curriculum

Curriculum is empty

Instructors


Send an enquiry

I am interested in


 

Enquire about the private (on-site) training course

I am interested in


 

Enquire about the public training course
 

I am interested in


 
Szybki kontakt