Become an Expert at Microsoft SQL! By writing SQL queries for Data Analytics and Data Science base concepts
Sub Category
- Programming Languages
{inAds}
Objectives
- Use SQL to query a database
- Get a job as a junior Database developer
- Advanced SQL statements
- Use SQL to perform data analysis
- Be comfortable putting SQL and Microsoft SQL on their resume
- Learn to perform GROUP BY statements
- Replicate real-world situations and query reports
- Complete literal SELECT statements.
- Complete basic SELECT statements querying against a single table
- Filter data using the WHERE clause
- Sort data using the ORDER BY clause
- Using joins, return columns from multiple tables in the same query
- Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
- Complete SQL statements that use aggregate functions
- Import Flat, .CSV, Excel to SQL Database
- Perform Secure Backup and Restore Full SQL Database task
- Write SELECT on Query Calculations to get Discount and Non Discount Sales
- learn what is Generative AI for future learning
Pre Requisites
- No prior technical experience is required! All you need a computer!
- No software is required in advance of the course (all software used in the course is free)
- No pre-knowledge is required - you will learn from basic
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)