facebook
favorite button
member since icon
Depuis août 2024
Professeur depuis août 2024
Query , Design and Implementation SQL Server Database
course price icon
Àpd 23 $ /h
arrow icon
My SQL Server class focuses on database management, covering the installation, configuration, and maintenance of SQL Server environments.
It includes writing SQL queries, optimizing performance, and ensuring data security.
Students learn to design, implement, and troubleshoot databases, gaining hands-on experience with SQL Server tools and features.
Lieu
location type icon
En ligne depuis Autriche
Age
Adolescents (13-17 ans)
Adultes (18-64 ans)
Niveau du Cours
Débutant
Intermédiaire
Avancé
Durée
30 minutes
45 minutes
60 minutes
90 minutes
120 minutes
Enseigné en
anglais
Disponibilité semaine type
(GMT -04:00)
New York
at teacher icon
Cours par webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Cours Similaires
arrow icon previousarrow icon next
verified badge
Analyst-Programmer, I teach computer science and programming at all levels.
My teaching method is: simple, effective and very quickly learned by the students.
I take all the time necessary for the student to really understand the course. My goal is to simplify the material as much as possible during the explanation and I always use examples to facilitate understanding.
I never skip topics that I don't understand because during the time the student is learning, I too am learning something new!
verified badge
Je propose une formation en SQL (requête principalement, moins la construction d'un modèle de donnée).
La formation que je propose s'adresse à tout les niveaus (introduction aux selections, insertions, jointures, ...) ainsi qu'à des utilisateurs plus avancés (fonctions analytiques, ...).
Je propose aussi une formation a tout les langage C , C sharp , java , php
Je suis ouvert également pour des scéances de questions/réponses.

Diplômé ingénieur en informatique depuis 2008 , je travaille à présent en tant qu'analyste fonctionnel sur Bruxelles.
Durant mes études, je me suis principalement intéressé aux développements en C , C++ , JAVA , C sharp ainsi qu'à l'analyse Uml , Merise
Dans mon travail au quotidien, je suis à présent en relation avec des clients et définit les analyses pour une équipe de développement en C sharp.
verified badge
les concepts de base pour être un développeur BI
comment commencer un carrière dans le domaine du data
les bases fondamentaux du base de donnée
introduction MSBI(SSMS - SSIS - SSAS - PowerBI)
les types des visuels
les concepts de data marketing
verified badge
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
verified badge
Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.

In this two-hour introduction to SQL, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test. SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results. PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course you’ll have some hands-on experience in learning SQL and the grounding to start applying it on projects or continue your learning in a more specialized direction.

Relational Databases
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.

Querying
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.
verified badge
I'm a developer coach with over 10 years of experience in website and database development. Holding a professional license and several industry-recognized certifications, he is a MySQL expert and able to walk you through the most complex requests. As a coordinated and passionate website builder, I am able to share my knowledge and experience with over 100's of people to help achieve their development goals. Many renewable projects are experienced and able to deliver high quality results. If you are looking for a talented developer coach to help you with your MySQL demands, please feel free to contact me.”
verified badge
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.
verified badge
Le cours SQL (Structured Query Language) est conçu pour enseigner les concepts fondamentaux et avancés de la gestion de bases de données relationnelles afin de maîtriser la création et la gestion de bases de données et d'apprendre à interroger et à manipuler des données à l'aide de SQL.
Nous avons plusieurs chapitres abordés dans ce cours tels que : introduction aux bases de données, SQL de base, manipulation de données, fonctions SQL, jointures, gestion de base de données, SQL avancé et meilleures pratiques.
De plus, les cours sont modifiables en fonction des besoins des participants, l'essentiel étant qu'à la fin, ils soient capables de concevoir, d'interroger et de gérer efficacement des bases de données relationnelles, en utilisant SQL comme principal outil de manipulation de données.
Par ailleurs, ce cours s'adresse aux débutants souhaitant acquérir des compétences en SQL ainsi qu'aux professionnels souhaitant renforcer leurs connaissances.
message icon
Contacter Hamid
repeat students icon
Le premier cours est couvert par notre Garantie Le-Bon-Prof
Cours Similaires
arrow icon previousarrow icon next
verified badge
Analyst-Programmer, I teach computer science and programming at all levels.
My teaching method is: simple, effective and very quickly learned by the students.
I take all the time necessary for the student to really understand the course. My goal is to simplify the material as much as possible during the explanation and I always use examples to facilitate understanding.
I never skip topics that I don't understand because during the time the student is learning, I too am learning something new!
verified badge
Je propose une formation en SQL (requête principalement, moins la construction d'un modèle de donnée).
La formation que je propose s'adresse à tout les niveaus (introduction aux selections, insertions, jointures, ...) ainsi qu'à des utilisateurs plus avancés (fonctions analytiques, ...).
Je propose aussi une formation a tout les langage C , C sharp , java , php
Je suis ouvert également pour des scéances de questions/réponses.

Diplômé ingénieur en informatique depuis 2008 , je travaille à présent en tant qu'analyste fonctionnel sur Bruxelles.
Durant mes études, je me suis principalement intéressé aux développements en C , C++ , JAVA , C sharp ainsi qu'à l'analyse Uml , Merise
Dans mon travail au quotidien, je suis à présent en relation avec des clients et définit les analyses pour une équipe de développement en C sharp.
verified badge
les concepts de base pour être un développeur BI
comment commencer un carrière dans le domaine du data
les bases fondamentaux du base de donnée
introduction MSBI(SSMS - SSIS - SSAS - PowerBI)
les types des visuels
les concepts de data marketing
verified badge
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
verified badge
Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.

In this two-hour introduction to SQL, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test. SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results. PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course you’ll have some hands-on experience in learning SQL and the grounding to start applying it on projects or continue your learning in a more specialized direction.

Relational Databases
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.

Querying
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.
verified badge
I'm a developer coach with over 10 years of experience in website and database development. Holding a professional license and several industry-recognized certifications, he is a MySQL expert and able to walk you through the most complex requests. As a coordinated and passionate website builder, I am able to share my knowledge and experience with over 100's of people to help achieve their development goals. Many renewable projects are experienced and able to deliver high quality results. If you are looking for a talented developer coach to help you with your MySQL demands, please feel free to contact me.”
verified badge
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.
verified badge
Le cours SQL (Structured Query Language) est conçu pour enseigner les concepts fondamentaux et avancés de la gestion de bases de données relationnelles afin de maîtriser la création et la gestion de bases de données et d'apprendre à interroger et à manipuler des données à l'aide de SQL.
Nous avons plusieurs chapitres abordés dans ce cours tels que : introduction aux bases de données, SQL de base, manipulation de données, fonctions SQL, jointures, gestion de base de données, SQL avancé et meilleures pratiques.
De plus, les cours sont modifiables en fonction des besoins des participants, l'essentiel étant qu'à la fin, ils soient capables de concevoir, d'interroger et de gérer efficacement des bases de données relationnelles, en utilisant SQL comme principal outil de manipulation de données.
Par ailleurs, ce cours s'adresse aux débutants souhaitant acquérir des compétences en SQL ainsi qu'aux professionnels souhaitant renforcer leurs connaissances.
Garantie Le-Bon-Prof
favorite button
message icon
Contacter Hamid