Combo Pack of Data Analyst with SQL+Python+Power BI+PowerQry

Explore the concepts of server and database, including creating databases with SQL Server Management Studio, Windows authentication, SQL Server authentication, and basic table structures.

Create a basic SQL table by defining columns and data types, and distinguish between fields (columns) and records (rows). View headers with select star from employee.

Learn how to create a new table with the select into command to back up the orders table, select three columns, and filter by negative profit.

Learn to use the insert into statement to add rows to the employee table, including single and multiple inserts with id, name, department, basic salary, and total salary.

Learn how to use the bulk insert command to import CSV data into a SQL table, configuring the file path, comma as field terminator, and row terminator while skipping header.

Import data into a sql server table from excel using the import data wizard, create invoice and orders tables in the Udemy database, and transfer 36,864 and 8,399 rows.

Export data from a sql server table to an excel file by using the export task. Connect to sql server, choose database, select tables, finish, and verify data in excel.

Compare delete, truncate, and drop in SQL Server: delete removes rows by condition or all rows, truncate removes all rows unconditionally, and drop removes the table.

Learn how to use the truncate statement to delete all data from a table while keeping the table itself, a faster ddl alternative to delete.

Explore the differences between delete, truncate, and drop in SQL server, including when to apply conditions, performance implications, and why truncate and drop are DDL, while delete is DML.

Learn to use the update statement to modify records with conditions, such as changing cities and incrementing salaries, while avoiding unintended global changes.

Update data on sql server using the update statement to modify columns based on conditions, including department and total salary with a where clause and a 10% increment.

Apply the and operator to filter data with multiple conditions in a where clause, such as region west and profit less than zero, and compare it with the or operator.

Learn how to use the between operator to filter data across numbers, dates, and text by applying ranges in a where clause, with practical SQL examples.

Learn to use the order by clause to sort data. Sort by ascending or descending order for single or multiple columns, including department and total salary, or by column numbers.

Sort data in ascending order on the basis of two columns using SQL Server, with a focus on technology product category and ordering by profit in large datasets.

Learn to use group by to summarize orders by region, calculating total sales, order counts, region wise profit, with aliases, avg, max, and min profits, and apply having clause.