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

Explore the SQL Server interface and SQL Server Management Studio, connect to a server via authentication, and use Object Explorer to run queries in a training database.

Explain comment in sql server by showing how double dash disables a query. Demonstrate activating the Udemy database and running a select from the employee table and the invoice table.

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.

Create a table in SQL Server by writing a script, define an employee table with rows and columns, connect to the Udemy database, and execute the create table command.

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 alter table to modify the structure, add or drop columns and constraints, and manage data types in SQL Server, using a practical employee table example.

Insert data into a SQL table via the graphical user interface by creating an employee table, then import name, department, and salary from Excel using paste or bulk insert.

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 to use the delete statement in sql to remove data on a condition, including deleting by employee id and with multiple conditions using a where clause.

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.

Master the SQL Server select statement to view data, choosing all columns with star or specific fields, and use square brackets for spaced column names like order date.

Learn how to use the distinct keyword with select to fetch unique values and remove duplicates from columns like region, product category, and product name in the orders table.

Filter a table by region using a where clause in SQL, selecting from orders. Isolate West region data with an additional condition profit < 0 to capture losses.

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.

Master the or operator in SQL to combine multiple conditions in a where clause. Filter data by region and profit, returning records when any condition is true.

Learn how the in operator filters data by listing multiple values in a where clause, compare it to or, and filter by department and matching names across tables.

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.

Master the SQL like operator to filter data with pattern matching in where clauses, using wildcards %, underscore, and not like, with hands-on examples on employee and orders data.

Use the top clause to return the first n records or a percentage from a table, ordering by a column to identify top sales and monitor performance.

Learn to retrieve the third largest salary and its name using subqueries, selecting top three records by total salary desc, and using a temp table to min the salary.

Learn how to extract the third smallest total salary using a subquery, order by total salary, store results in a temp table, and retrieve the corresponding employee name.

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.

Sort data in descending order by profit using SQL: select * from orders order by profit desc. Filter to technology products to see top profits.

Learn how to use group by to group and summarize data on one or more columns, produce unique values, and remove duplicates with a department example in sql.

Master using the having clause with group by to filter aggregated profit, explore group by on multiple columns, and apply sum calculations on the orders table.

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.