By the end of this course,you will be able to
1.Describe the structure of relational databases,
2.Interpret and create entity relationship diagrams and relational schamas that describe the contents of specific criteria, and retrieve such data from MySQL an teradata databases that contain over one million rows of data.
3.Execute practices that limit the impact of your queries on other coworkers.
4. Summarize rows of data using aggregate function and segment aggregations according to specified variables.
5. Combine and manipulate data from multiple tables, across a database.
6.Retrieve records and compute calculations that are dependent on dynamic data features. And translate data analysis questions into SQL queries.
网友评论