SQL and Data Processing Training
Level
AdvancedDuration
45h / 6 daysDate
Individually arrangedPrice
Individually arrangedSQL and Data Processing Training
SQL is everywhere data storage and processing are involved — from machine learning engineers, through finance professionals, web developers, to data visualization experts and even journalists. SQL can be used in building web applications, analyzing data beyond Excel, or in Big Data or Data Science environments.
What will you learn?
- You will create and configure your own database; you’ll learn what practical applications it can serve.
- You will learn to build advanced reports, where you will search, sum up, filter, and process data as needed.
- You will discover programming-related language, concepts, principles, and best practices in working with data. You will also learn how to communicate with other developers.
- You will acquire knowledge that’s portable to other popular tools, such as MS Access or Oracle DB.
- You will be prepared for Microsoft certification 70-461 MCSA SQL.
- You will learn advanced tools for data processing and analysis, which for years have been market standards.
Who is this training for?
For those who want to learn SQL and data processing methods, and gain practical knowledge enabling them to work with them.-
For those who want to learn advanced tools for data processing and analytics that will significantly speed up their work.
-
For anyone who wants, during the course, to set up and use their own database in practice.
Training Program
Module 1: Introduction to Relational Databases
- Database engines
- Creating a new database
- Distinctions between DQL, DML, DDL, DCL
- Tools and accessories
Module 2: Fundamentals of Database Programming
- SELECT queries — DQL (Data Query Language)
- Application of operators and criteria in queries
- SQL functions and expressions: text/string operations, concatenation & splitting string fields, mathematical functions, date/time functions
- Creating your own functions
Module 3: Basics of SQL Queries
- Aggregating queries (GROUP BY, COUNT, MIN, MAX, SUM, AVG)
- Conditions in aggregated queries (WHERE, HAVING)
- Combining query results (UNION, INTERSECT, EXCEPT/MINUS)
- Nested queries
- Data Manipulation Language (DML): UPDATE, INSERT, DELETE, SELECT INTO
Module 4: Tables and SQL Objects
- Operations on joined tables: INNER JOIN, RIGHT/LEFT/FULL OUTER JOIN, CROSS JOIN
- Creation and modification of SQL objects: CREATE, ALTER, ALTER TABLE, DROP
Module 5: Advanced Functions in SQL Server
- Window functions: OVER, ROW_NUMBER, RANK, DENSE_RANK, PARTITION BY, NTILE
- Common table expressions (CTEs)
- Introduction to stored procedures and T-SQL programming
- Cursors in SQL
- Event handling using triggers
Module 6: Microsoft SQL Server and Basic Administration
- Communication with Microsoft SQL Server — data import and export
- Basic administration and introduction to access management
