Genre: eLearning | Language: English + srt | Duration: 41 lectures (3h 20m) | Size: 1.19 GB
Some knowledge of data reporting advantageous, but not necessary.
Bner querying and data analysis of Microsoft SQL server databases using the SELECT statement
Querying SQL server databases using the SELECT clause
Joining multiple tables in different ways to combine information
Filtering data to retrieve only the information you need
Using aggregation functions and processes to find totals and averages for reports
SQL Server SELECT query foundations aims to teach you the basics of retrieving data from the Microsoft SQL server database ee.
the course contains details on how to use the SELECT clause in the SQL server environment to query database tables and bring back data to present in reports or applications
This course is aimed at anyone looking to improve their understanding of database development, from data analysts looking to increase their skills on data querying, programmers looking to add database capabilities to their apps, or anyone who needs to get at the wealth of data contained in their companies’ database servers.
the course includes lessons on :
Retrieving and combining columns from SQL server tables using the SELECT clause to define columns and functions to display to the end users.
Joining multiple tables in different ways to combine information. Using the FROM clause to specify which tables you want to connect to, and multiple JOIN clauses to connect tables to each other.
Filtering data to retrieve only the information you want. Using the WHERE clause to filter your data on one or multiple columns, and the ways to combine the WHERE clause with JOINs on your tables to efficiently retrieve information.
Using aggregate functions to GROUP BY information and find totals and averages of data to perform analysis and make reports
the course contains lessons on how to and install all the tools you need to become proficient in coding SQL; I’ll take you through how you can and install SQL server express edition, a free personal use version of SQL server, and the sample ‘AdventureWorks’ database so you can try out all the examples, and develop and test your own queries.
We’ll also SQL Server Management Studio; your best interface into the database environment, and I’ll go through the basics of how to connect to Databases, and how to use the tool more efficiently.
I’ve included handouts with summaries and further information on some topics, as well as increasingly difficult review questions for you to try yourself. each set of questions is followed by a video analysis of the solutions and the different ways you could choose to solve them.
There’s also an end of course test that combines all the techniques you’ve learned into one final exam.
Data Science bners
Someone curious to extend their data skills, perhaps used to working with Excel
Programmers looking to add database capabilities to their applications
Someone looking to enter the world of data analysis and machine learningDOWNLOAD uploadgig.com