facebook
Become a Tutor

Online Microsoft sql server teachers via webcam

Find your perfect online Microsoft sql server private tutor on Apprentus.
Connect and learn Microsoft sql server online with our teachers today!

Private lessonsMicrosoft Sql ServerOnline Microsoft Sql Server lessons

12 online microsoft sql server teachers

12 online microsoft sql server teachers

(2 reviews)
Brahim - Berrechid, MoroccoRecently active28Fr
28FrIntroduction to Relational Database and SQL Language by practise
Trusted teacher: Module 1: SQL Overview Outlining SQL as the cornerstone of database activity Applying the ANSI/ISO standards Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys Module 2: Building the Database Schema - Creating tables and columns Building tables with CREATE TABLE Modifying table structure with ALTER TABLE Adding columns to an existing table Removing tables with DROP TABLE - Protecting data integrity with constraints Guaranteeing uniqueness with primary key constraints Enforcing integrity with foreign key constraints Imposing business rules with check constraints - Improving performance with indexes Expediting data retrieval with indexes Recommending guidelines for index creation Module 3: Manipulating Data - Modifying table contents Adding table rows with INSERT Changing row content with UPDATE Removing rows with DELETE - Applying transactions Controlling transactions with COMMIT and ROLLBACK Deploying BEGIN TRANSACTION in SQL Server Module 4: Working with the SELECT Statement - Writing Single Table queries Retrieving data with SELECT Specifying column expressions Sorting the result with ORDER BY Handling NULL values in expressions - Restricting rows with the WHERE filter Testing for equality or inequality Applying wildcard characters Avoiding NULL value pitfalls Module 5: Querying Multiple Tables - Applying the ANSI/ISO standard join syntax Matching related rows with INNER JOIN Including nonmatched rows with OUTER JOIN Creating a Cartesian product with CROSS JOIN - Combining results with set operators Stacking results with UNION Identifying matching rows with INTERSECT Utilizing EXCEPT to find nonmatching rows Module 6: Employing Functions in Data Retrieval - Processing data with row functions Conditional formatting with the CASE expression Utilizing the CASE expression to simulate IF tests Dealing with NULL values - Performing analysis with aggregate functions Summarizing data using SUM, AVG and COUNT Finding the highest/lowest values with MAX and MIN Defining the summary level with GROUP BY Applying filter conditions with HAVING Module 7: Constructing Nested Queries - Applying subqueries in filter conditions Creating correlated vs. noncorrelated subqueries Testing the existence of rows - Including subqueries in expressions Placing subqueries in the column list Creating complex expressions containing subqueries Handling subqueries that return no rows Module 8: Developing In-Line and Stored Views - Breaking down complex problems Selecting data from a query result set Using subqueries in the FROM clause - Creating views in a database Building reusable code Creating updateable vs. non-updateable views
Mysql · Oracle database · Microsoft sql server
Marouane - Kenitra, Morocco20Fr
20FrBusiness intelligence, data warehouse, Etl, SQL server, star schema or snowflake, power bi
Trusted teacher: As a data scientist with in-depth expertise in artificial intelligence, machine learning, deep learning, time series and data mining, I put my skills at your disposal as a data engineer specializing in Business Intelligence within a large company. I offer you comprehensive training covering the entire Business Intelligence pipeline, from data collection to visualization. During these sessions, you will learn: • The conception and design of data warehouses adapted to your specific needs. • Data models such as star schema and snowflake to optimize your data structure. • Practical use of SQL Server as well as other SQL databases to efficiently manage your data. • Advanced Extraction, Transformation and Loading (ETL) techniques with SSIS to automate processes. • Creating interactive reports and impactful dashboards with Power BI and DAX or IBM Cognos. In-depth presentations, based on solid practical experience and up-to-date theoretical knowledge, covering all aspects of the Business Intelligence pipeline. Concrete and relevant examples, taken from real use cases, to illustrate theoretical concepts and facilitate their understanding. Please feel free to contact me to discuss your specific needs and to schedule training sessions tailored to your schedule and goals. With this training, you will be ready to take full advantage of your data and make informed strategic decisions.
Computer science · Database · Microsoft sql server
Translate this text using Google Translate.
Showing results 1 - 12 of 121 - 12 of 12

You are here

Private lessons
Microsoft Sql Server
Online Microsoft Sql Server lessons