SQL for Data Science + Data Analytics + Data Visualization

Set up your local SQL Server development environment by installing SQL Server and Management Studio, connect the server, configure authentication, and run queries and explore schema.

Install Microsoft SQL Server 2022 by downloading media, running the setup, and configuring the database engine. Choose the express edition with mixed or Windows authentication and set up login access.

Install SQL Server Management Studio by running the setup as administrator, download the latest SSMS, and complete the installation to connect to databases and manage tables, queries, and objects.

Connect to a SQL Server using Windows authentication in SQL Server Management Studio, then specify the server name or IP address and explore databases and server objects in Object Explorer.

Learn how to download the Adventure Works 2019 backup from GitHub and restore it in Microsoft SQL Server by creating the database, selecting the backup, and verifying the sample tables.

Connect to SQL Server using Azure Data Studio, configure local connections, select databases, and run queries in the query window to explore data.

Insert data rows into the student table using insert into, with columns student ID, name, location, and email. Practice writing and running insert queries in a data studio environment.

Explore how to view data returned by a query in SQL Server using Data Studio, write and run a select statement, and read the resulting data set.

Create a database in sql server management studio by logging in with sql server authentication, navigating to databases, and selecting new database to define name and data and log files.

Learn how to create a new table in Microsoft SQL Server using either a create statement or the SSMS designer, focusing on data types, columns, and a primary key.

Learn to create a new table in SQL Server Management Studio, set a primary key, define columns and data types, and apply naming conventions, such as a student details table.

Create a foreign key on the items table that references the products table by product_id, and define a composite primary key on item_id and product_id.

Explore HTML commands for queries, insert statements, add data records, update statements for modifying data, and delete statements for permanently removing records from your table through real-world queries.

Learn how to update data in a products table using the update statement, setting product_name for a specific ID with a where clause to filter the record.

Learn how to write a delete query in SQL Server to remove specific records with a where clause, and why omitting it can delete the entire table.

Introduce data definition language commands, including create, alter, truncate, comment, and rename, to modify database structure and data in SQL for data science.

Learn to create a new table with a SQL script, define columns like id, name, email, phone, and address, set a primary key, and verify the table with DDL commands.

Learn how to modify a table with the alter command, including adding and dropping columns in a student details table, and adjusting data types.

Learn how the truncate statement quickly removes all rows from a table by allocating data pages, preserving the table structure, and understand that truncate is rollbackable while delete is not.

Rename a table or database easily with a right-click rename option, preserving existing content. Rename test to test_student and continue using your web app.

learn to grant database user permissions with the grant query, assigning select, insert, update, and delete on a table or database, and create or map the user.

Discover the basics of sql statements, including select, distinct, and custom column headings. Practice selecting with calculations, using aggregate count to total a column in real-world queries.

Master basic structured query language statements to read, update, insert, and delete data, using select, where, order by, and limit, plus create or drop databases, tables, and indexes.

Learn to write a clean select statement by detailing the select, from, and where clauses. Practice using column names and wildcards to retrieve data and view results.

Learn to use the distinct keyword to remove duplicates in a query, producing a unique result set without altering the underlying table.

Master the column as statement to create aliases for columns and tables, improving join output. See how as clause labels data, such as user number, in inner joins.