What is SQL Server?
SQL is the fundamental language for relational database management system.
99% of companies use relational database to store their business information.
It is very important for Business Analyst and database administrator to use SQL skills
to retrieve insights from data and support decision making.
SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as：
SQL Server, MySQL, MariaDB, and PostgreSQL.
This course provides an introduction to this core programming language.
Whatever a database is being used for—websites, bookkeeping, sales and inventory,or even the
lowly to-do list—it’s still all about the data.
Completely updated for 2014, SQL Essential Training is designed to help users understand
the most commonlanguage for database wrangling.
Beginning with a quick start introduction for those who want to start working with data immediately,
instructor teaches all the major features of SQL:
- creating tables;
- defining relationships;
- manipulating strings, numbers, and dates;
- using triggers to automate actions;
- and working with subselects and views.
He offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently.
The final chapter includes a real-world example of building a simple CRUD (Create, Read, Update, and Delete)
application using SQL.
SQL Requirements include:
- Understanding SQL terminology and syntax
- Creating new tables and records
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Finding the numeric type of a value
- Using aggregate functions and transactions
- Updating a table with triggers
- Creating views
Learn how to request data from a server, limit and sort the responses aggregate data from multiple tables with joins,
and edit and delete data.
Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.
Course Topics include:
- What is SQL?
- Asking for data with SELECT
- Limiting database responses
- Organizing responses
- Asking for data from two or more tables
- Understanding join types and data types
- Transforming data
- Performing math
- Adding and modifying data in a table
There is an increasing need for data scientists and analysts to understand relational data stores.
Organizations have long used SQL databases to store transactional data as well as business intelligence related data.
If you need to work with SQL databases, this course is designed to help you learn how to perform common data
science tasks including finding, exploration, and extraction within relational databases.
The course begins with a brief overview of SQL.
Then the five major topics a data scientist should understand when working with relational databases:
- basic statistics in SQL
- data preparation in SQL
- advanced filtering and data aggregation
- window functions
- and preparing data for use with analytics tools.
- Data manipulation
- ANSI standards
- SQL and variations
- Statistical functions in SQL
- String, numeric, and regular expression functions in SQL
- Advanced filtering techniques
- Advanced aggregation techniques
- Windowing functions for working with ordered data sets
Available both live online & face to face in a classroom
(minimum # of student is 3)
Essential Level 32 hours
Advanced topic 32 hours
Business Intelligence Analyst
Data Warehouse Analyst