Structured Query Language (SQL) is used to extract information from a relational database to address an array of business information needs. Thus, the goal of the course is to teach participants how to query a relational database for information and analysis.
Job Outlook
The Bureau of Labor and Statistics expects the number of hired Data Analysts to grow by 25% during the decade from 2020 to 2030. This represents a much sharper increase than the average for other professions.
FAQs
What do data analysts do?
Main duties typically include:
- Collecting, mining, and analyzing sales and market information
- Assessing marketing effectiveness
- Evaluating consumer purchasing habits and patterns
- Designing data collection and evaluation tools
- Creating projections and reports based on their findings
These professionals usually need strengths in mathematics, communications, and social sciences. They benefit from understanding business, economics, and consumer behaviors.
What skills do I need as a data analyst?
In addition to the specialized hard skills, you need to qualify for data analyst jobs, you need to hone people or "soft" skills.
Data analysts need to be able to think critically, solve problems, and communicate their findings in a clear and concise manner.
Hard skills
- Data visualization
- Data cleaning and preparation
- Calculus and linear algebra
- SQL and NoSQL databases
- Microsoft Excel
- Programming languages: Python, R, SQL
- Database creation and navigation
People skills
- Problem-solving
- Communication
- Critical thinking
- Analytical
- Observant and detail oriented
Course Objectives
- Students will learn how to query a relational database for information and analysis using Transact-SQL.
- Understand how data is retrieved prior to analyze it,
Prerequisites
There are no specific prerequisites for taking this course.
Curriculum
- Installing Microsoft SQL Express and Management Studio
- Learning history of SQL and basic concepts of the structure of a relational database
- Understanding structured programming
- Understanding naming convention
- Understanding basic syntax to query one table
- Using built-in functions for strings
- Querying two or more datasets (tables or views) using INNER JOIN, OUTER LEFT JOIN and OUTER RIGHT JOIN
- Using built-in functions for numeric values including aggregate functions and GROUP BY
- Using clauses ORDER BY, CASE, WHERE and operators
- Sub-queries
- Understanding function FORMAT() for dates and currencies including culture codes
- Understanding data types
- Creating, dropping, and altering databases, schemata, tables and columns
- Inserting values into tablesand updating values
- Differences between DROP, TRUNCATE and DELETE
- Altering databases, schemata, tables and views
- Understanding NULL and NOT NULL
- Understanding functions CONVERT(), CAST(), DAY(), MONTH(), YEAR() and GETDATE()
- Creating, dropping, and altering views
Instructor
Francisco Olvera is a Systems Programmer at BMCC for 13 years. A computer science instructor for 17 years starting with DOS, writing batch files and other technologies working with Apache web servers via my personal website.
Registration and Enrollment
This course is 100% online. Add to cart and check out.
Please continue to visit our website for future updates.
