Udemy course Introduction to T-SQL for Data Analysts by Steve Fox
Introduction to T-SQL for Data Analysts is the best Udemy course on the market. With this offer they will be able to greatly improve their knowledge and become more competitive within the Development category. Therefore, if you are looking to improve your Development skills we recommend that you download Introduction to T-SQL for Data Analysts udemy course.
Here you can see Udemy courses linked to: Development.
- Author: Steve Fox
- Course rating: 4.4
- Category: Development
- Modality: Online
- Status: Available
- Idiom: English
Abouth Steve Fox
I am a Business Intelligence (BI) professional with 15+ years experience in the Tech industry. I have interest in building Business Intelligence teams, and enjoy mentoring and training young analysts. I have built Business Intelligence teams in organisations ranging from large established companies such as Microsoft UK, through to smaller fast growing tech companies. In my spare time I run a popular Business Intelligence & Analytics training blog called Analyticsinaction.com. I am currently the VP of Analytics & Insights for a New Zealand based Tech company that produces cloud based Point of Sale (POS) software.
What the udemy Introduction to T-SQL for Data Analysts course teaches?
What you’ll learn By the end of this course students will be comfortable performing the core T-SQL tasks that data analysts perform on a daily basis. This will include activities such as writing T-SQL to : Create databases and tables. Select either all or a subset of data from a table. Sort and filter records, including using wildcards. Join database tables using Inner, Left, Right & Full Joins. Manage Null & Non-Null records. Aggregate data by groups, and to filter these groups. Create Stored Procedures and Views. Back up tables Selectively delete data, tables or databases.
In 60 minutes, learn 30 of the most important Transact-SQL (T-SQL) tasks that data analysts need to perform
More information about the course Introduction to T-SQL for Data Analysts
This course teaches students the core Transact SQL (T-SQL) skills and tasks that Data Analysts need to perform, such as how to connect to databases, define data extracts, query, & format data. This is a crash course, and in just over 1 hour, students will build a strong foundation knowledge of T-SQL. This course is different from most other T-SQL courses, in that it focuses on skills required by data analysts. It avoids other tasks such as defining user permissions, building indexing, and designing databases that database administrators and designers focus on. Because this course is tailored towards students wanting to develop data analyst skills, it is very compressed and in 60 minutes students will develop an understanding of 30 of the core T-SQL tasks data analysts perform. The course, and supporting material is designed to enable students to follow along in real-time with the instructor. The course consists of 6 lectures, and assumes no prior understanding or experience with Microsoft SQL Server or writing code. The T-SQL code provided with the course works with Microsoft SQL Server 2008 to 2016. It will also work with all editions of SQL Server. How to obtain either a free, or low cost copy of Microsoft SQL Server is discussed in the course.