Structured Query Language (SQLor “Sequel”)is the way we communicate with a relational database. It’s an intuitive and powerful language and mastering it is rapidly becoming a prerequisite for career paths outside of software development. SQLhas been one of the most common skill sets required by employers for software developers for years, according to research published by Indeed. That fact is not likely to change any time soon, as businesses have woken up to the reality that the data they capture, generate, and store has tremendous business value to improve performance and efficiency and uncover new paths for growth. If you’re a software developer just getting started, a Business Analyst, a Test Engineer, Project Manager looking to augment your technical skill set, or a data or financial analyst who works primarily with spreadsheets, you’ll benefit from taking this course to learn how you can power up your data skills. We start from the ground up to teach you what a relational database is, how to plan and build a database structure, how to get data into your database, and then how to work with it to retrieve meaningful insights using SQL. In this course, you will learn: What a Relational Database isHow to install Microsoft SQLServer and SQLServer Management Studio on your local computerHow to use SQLServer Management Studio to create, explore, and query a databaseHow to research SQLServer functionality using the online documentationDatabase Design Techniques including how to diagram a database using an Entity Relationship Diagram (ERD)The basic database structures: tables, columns, data types, primary keys, and foreign key relationshipsBest practices for how to name your database elements (objects)How to learn SQLby automatically generating queries and SQLstatements with SQLServer Management StudioInserting data into tables using the INSERTstatementRetrieving and filtering data usingSELECTstatements and WHEREclausesExtracting data from multiple tables with a single query using INNERJOIN, LEFTJOIN, RIGHTJOIN, FULLJOIN, and CROSSJOIN statementsSorting query resultsAggregating data with aggregate functions like SUMand COUNT and GROUPBY clauses (very important for building reports and summarizing data!)Updating and deleting data with UPDATEand DELETEstatementsThis course is very hands on! It is structured as a series of lectures to help you understand what we’ll do with labs, exercises, and quizzes along the way so that you’re involved right from the start.
