Has discount
✅
Made in
English
Last updated at
Tue, 10-Jan-2023
Level
Beginner
Total lessons
88
Total duration
06:11:35 Hours
Number of reviews
0
Total enrolment
0
Avg rating
Short description
Become an Expert at Microsoft SQL! By writing SQL queries for Data Analytics and Data Science base concepts
-
-
Requirements
- 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
Outcomes
- Use SQL to query a database
- Advanced SQL statements
- Be comfortable putting SQL and Microsoft SQL on their resume
- Replicate real-world situations and query reports
- Complete basic SELECT statements querying against a single table
- Sort data using the ORDER BY clause
- Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
- Import Flat, .CSV, Excel to SQL Database
- Write SELECT on Query Calculations to get Discount and Non Discount Sales
- Get a job as a junior Database developer
- Use SQL to perform data analysis
- Learn to perform GROUP BY statements
- Complete literal SELECT statements.
- Filter data using the WHERE clause
- Using joins, return columns from multiple tables in the same query
- Complete SQL statements that use aggregate functions
- Perform Secure Backup and Restore Full SQL Database task
Write a public review