Expand your database knowledge to learn more advance techniques to manage and query data. A greater understanding of the SQL language will enable you to read or create more than the most basic queries. This series discusses the concept of SQL Queries from Basics to Advanced techniques. It will show employers that you understand and have a foundation on relational databases, including Microsoft SQL Server.
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.
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, analysis using Transact-SQL and fundamentals of administrating SQL Server.
Prerequisites
Course Introduction to SQL or equivalent
Understanding Manipulation Language (DML) and Data Definition Language (DDL)
Curriculum
- Understanding Manipulation Language (DML)
- Understanding Data Definition Language (DDL)
- Querying multiple tables or views using INNER JOIN, LEFT JOIN or RIGHT JOIN
- Creating, dropping, and altering data objects like tables, views
- Understanding built-in functions for strings and numeric values
- Understanding parameters
- Creating, dropping, and altering user-defined functions and stored procedures
- Creating, dropping, and altering constraints
- Understanding primary, foreign, and composite keys
- Understanding clustered and non-clustered indexes
- Understanding the five levels of normalization
- Understanding server level security
- Understanding database level security
- Understanding Windows security
- Understanding SQL security
- Creating, dropping, and altering logins, users, roles
- Granting access to a database
- Understanding fixed database roles
- Understanding object permissions
- Understanding ownership chains
- Understanding recovery models, database backups, backup devices, database restore
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.
