Loading
  • Main Menu
GreaterHeight Technologies LLC ~ GreaterHeight Academy
  • All Courses
    • BI and Visualization
      • Mastering Data and Business Analytics
        • Basic Excel for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • Excel for Business Analysis & Analyst
        • PivotTable, PowerPivot, PowerQuery & DAX for Data Analysi
        • Data Analytics and Visualization with Tableau
        • Data Analytics and Visualisation with SQL
      • Mastering Python for Data Analytics and Visualization
        • Python Foundation for Data Analytics
        • Data Analysis Using Python With Numpy and Pandas
        • Data Visualization Using Python with Matplotlib and Seaborn
        • Data Science with SQL Server and Azure SQL Database
        • Data Analytics and Visualisation with PowerBI
      • Data Analytics With SQL Master Program
      • Master Data Analytics With PowerBI
      • Financial Reporting with PowerBI
      • Data Analysts with Power-BI
      • Data Analytics and Visualization with Excel
    • Complete Microsoft Excel Master Program
      • Basic Excel for Data Analysis
      • Excel Interactive Dashboard for Data Analysis
      • Intermediate and Advanced Excel for Data Analysis
      • PivotTable PowerPivot, PowerQuery & DAX for Data Analysis
      • Excel for Data Analysis and Visualization
      • Excel for Business Analysis & Analyst
    • Mastering Python
      • Python Developer Masters Program
        • Python Programming Certification Course
        • Data Science With Python Certification
        • Artificial Intelligence Certification Course
        • PySpark Certification Training Course
        • Python Statistics for Data Science
      • The Complete Python Developer
      • Data Analysis and Visualization with Python
      • Complete Data Scientist with Python
      • Data Engineer with SQL and Python
      • Machine Learning Engineer with Python
    • Azure Cloud Computing
      • DevOps Engineer and Solutions Architect Master Program
    • Mastering SQL Server Development
    • Certifications
  • We Are For
    • Individuals
    • Business
    • Universities
  • Partners
    • Employer Networks
    • Community Partnership
    • Opportunity Funds
    • Future Finance
    • Scholarships
  • Resources
    • Webinars
    • Blog
    • Tutorials
    • White Papers
    • Podcast
    • Events
  • Get Advice
GreaterHeight Technologies LLC ~ GreaterHeight Academy
  • All Courses
    • BI and Visualization
      • Mastering Data and Business Analytics
        • Basic Excel for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • Excel for Business Analysis & Analyst
        • PivotTable, PowerPivot, PowerQuery & DAX for Data Analysi
        • Data Analytics and Visualization with Tableau
        • Data Analytics and Visualisation with SQL
      • Mastering Python for Data Analytics and Visualization
        • Python Foundation for Data Analytics
        • Data Analysis Using Python With Numpy and Pandas
        • Data Visualization Using Python with Matplotlib and Seaborn
        • Data Science with SQL Server and Azure SQL Database
        • Data Analytics and Visualisation with PowerBI
      • Data Analytics With SQL Master Program
      • Master Data Analytics With PowerBI
      • Financial Reporting with PowerBI
      • Data Analysts with Power-BI
      • Data Analytics and Visualization with Excel
    • Complete Microsoft Excel Master Program
      • Basic Excel for Data Analysis
      • Excel Interactive Dashboard for Data Analysis
      • Intermediate and Advanced Excel for Data Analysis
      • PivotTable PowerPivot, PowerQuery & DAX for Data Analysis
      • Excel for Data Analysis and Visualization
      • Excel for Business Analysis & Analyst
    • Mastering Python
      • Python Developer Masters Program
        • Python Programming Certification Course
        • Data Science With Python Certification
        • Artificial Intelligence Certification Course
        • PySpark Certification Training Course
        • Python Statistics for Data Science
      • The Complete Python Developer
      • Data Analysis and Visualization with Python
      • Complete Data Scientist with Python
      • Data Engineer with SQL and Python
      • Machine Learning Engineer with Python
    • Azure Cloud Computing
      • DevOps Engineer and Solutions Architect Master Program
    • Mastering SQL Server Development
    • Certifications
  • We Are For
    • Individuals
    • Business
    • Universities
  • Partners
    • Employer Networks
    • Community Partnership
    • Opportunity Funds
    • Future Finance
    • Scholarships
  • Resources
    • Webinars
    • Blog
    • Tutorials
    • White Papers
    • Podcast
    • Events
  • Get Advice

Mastering SQL Server Development


GreaterHeight Academy will teach you the basics of database design and the different SQL data types. Then help you to master the core concepts for the exam. In this track, you’ll learn how to write queries, functions, and stored procedures. You’ll also find out how to manage transactions, handle errors, and improve query performance.


Get Advice

Mastering SQL Server Development 


Who this course is for:

  • Beginner Database Developer.
  • Intermediate Database Developers.
  • Potential Database Administrators.
  • Everyone!


What you will Learn:

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization).
  • Using Microsoft SQL Management Studio.
  • SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping).
  • DELETE: How to remove data from a database.
  • INSERT INTO: How to insert data into a table.
  • UPDATE: How to update existing data.
  • Filter groups of data using the HAVING clause.
  • Overall Database Development Best Practices.
  • Creating Relationships and Foreign Keys.
  • How to query related data from multiple tables.
  • How to export Query Results to Excel.
  • How to craft SQL statements based on real scenarios.
  • Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers).
  • Using Aggregate Functions in SQL.
  • Backup and Restore Databases.
  • Generate Database Scripts for Automation.
  • How to manage database users and security.

Course Benefits & Key Features

Mastering SQL Server Development’s benefits and key features.
Modules

30+ Modules.

Lessons

80+ Lessons

Practical

40+ Hands-On Labs

Life Projects

5+ Projects

Resume

CV Preparations

Job

Jobs Reference

Recording

Session Recording

Interviews

Mock Interviews

Support

On Job Supports

Membership

Membership Access

Networks

Networking

Certification

Certificate of Completion


INSTRUCTOR-LED LIVE ONLINE CLASSES

Our learn-by-building-project method enables you to build

practical or coding experience that sticks. 95% of our                        

learners say they have confidence and remember more               

when they learn by building real world projects which is                

required to work in your real life.


  • Get step-by-step guidance to practice your skills without getting stuck
  • Validate your technical problem-solving skills in a real environment
  • Troubleshoot complex scenarios to practice what you learned
  • Develop production experience that translates into real-world
.

Why Mastering SQL Server Development?

High Paying Jobs

From startups to established companies, the job market looks good for SQL enthusiasts and it is expected to grow exponentially in the coming years. 

Simple Troubleshooting

SQL is one of those programming languages in which you can easily troubleshoot the issues. If you try to use a missing table, the error displays that the table does not exist.

Data From Multiple Sources

SQL makes it very easy to combine data from multiple sources. It is done by using the UNION operations, in which you have to mention fields or databases which must be combined.

Data Manipulation

SQL Server gives the users an easier time to test and manipulate the data. SQL is the base of many data visualization tools like Google Data Studio, Tableau and Power BI.

Quick Access To Data & Manage Big Data

Because data is stored in an organized manner in SQL, it easily access data within seconds. So, SQL manages big amounts of data.

Easy To Learn

SQL is used to retrieve, manage and access data present in a table in the databases, with the help of simple queries. These queries can be easily understood, similar to English lang.

Client-Server Access & Management

With SQL Server, you can easily navigate through humongous amounts of data and understand how to retrieve data from a web app.

Perform Data Mining

With SQL queries, you can view update events, monitor table, and database activity, identify specific data at time intervals and retrieve the information for key trends.

Standardization

SQL was developed in the 1970s at IBM, by Donald Chamberlin and Raymond F Boyce. It has been used for the past 40 years, and the syntax and commands have not changed.



GreaterHeight Certificates holders are prepared to work at companies like these.

Some Alumni Testimonies

Investing in the course "Become a Data Analyst" with GreaterHeight Academy is great value for the money and I highly recommend. The trainer is very knowledgeable, very engaging, provided us with quality training sessions on all courses and was easily acessible for queries. We also had access to the course materials and also the timely availability of the recorded videos made it easy and aided the learning process..

QUEEN OBIWULU

Team Lead, Customer Success

The training was fantastic, the instructor is an awesome lecturer, relentless and not tired in his delivery. He obviously enjoys teaching, it comes natural to him. We got more than we expected. He extended my knowledge of Excel beyond what I knew, and the courses were brilliantly delivered. They reach out, follow up, ask questions, and in fact the support has been great. They are highly recommended and I would definitely subscribe to other training programs from them.

BISOLA OGUNRO

Fraud Analytics Risk Oversight Manager

It's one thing to look for just a Data Analysis training, and it's another to get the knowledge transferred through certified professional trainers. No matter your initial level of proficiency in any of the Data Analysis tools, GreaterHeight Academy would meet you there and take you up to a highly proficienct and confident level in a short time at a reasonable pace. I learnt a lot of Data Analysis tools and skills at GreaterHeight from patient and resourceful teachers.

TUNDE MEREDITH

Operation Director - Abbfem Technology

The Data Analysis training program was one of the best I have attended. The way GreaterHeight took off with Excel and concluded the four courses with Excel was a mind blowing - it was WOW!! I concluded that I'm on the right path with the right mentor to take me from a novice to professional. GreaterHeight is the best as far as impacting Data Analysis knowledge is concern. I would shout it at the rooftop to recommend GreaterHeight to any trainee that really wants to learn.

JOHN OSI PETER

Greaterheight

I wanted to take a moment to express my deepest gratitude for the opportunity to study data analytics at GreaterHeight Academy. I am truly impressed by the level of dedication and support that the sponsor and CEO have put into this program. GreaterHeight Academy is without a doubt the best tech institution out there, providing top-notch education and resources for its students. One of the advantages of studying at GreaterHeight Academy is the access to the best tools and technologies in the field. 

AYODELE PAYNE

Sales/Data Analyst

It is an unforgettable experience that will surely stand the test of time learning to become a Data Analyst with GreaterHeights Academy. The Lecture delivery was so impactful and the Trainer is vast and well knowledgeable in using the applicable tools for the Sessions. Always ready to go extra mile with you. The supports you get during and after the lectures are top notch with materials and resources available to build your confidence on and off the job.

ADEBAYO OLADEJO

Customer Service Advisor (Special Operations)

Mastering SQL Server Development


Introduction to SQL Server
Master the basics of Microsoft SQL Server—one of the world's most popular database systems.

This course covers:
  • How to use SELECT statements to retrieve data
  • How to use SQL Server aggregate functions
  • How to manipulate text fields
  • How to retrieve data from multiple sources
  • All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.

4 Modules | 5+ Hours | 4+ Skills

Course Modules 


Hit the ground running by learning the basics of SELECT statements to retrieve data from one or more columns. You'll also learn how to apply filters to both numeric and text data, and sort the results.


  1. Welcome
  2. Simple selections
  3. More selections
  4. Ordering and filtering
  5. Order by
  6. Where
  7. Where again
  8. Working with NULL values
  9. WHERE the wild things are
  10. Exploring classic rock songs
  11. Exploring classic rock songs - AND/OR
  12. Using parentheses in your queries

Herein, you'll learn how to use important SQL Server aggregate functions such as SUM, COUNT, MIN, MAX, and AVG. Following that, you'll learn how to manipulate text fields. To round out the modules, you'll power up your queries using GROUP BY and HAVING, which will enable you to perform more meaningful aggregations.


  1. Aggregating Data
  2. Summing
  3. Counting
  4. MIN, MAX and AVG
  5. Strings
  6. LEN'gth of a string
  7. Left and right
  8. Stuck in the middle with you
  9. Grouping and Having
  10. GROUP BY
  11. Having
  12. Grouping together

This modules covers the basics of joining tables, using INNER, LEFT, and RIGHT joins, so that you can confidently retrieve data from multiple sources.


  1. Joining tables
  2. Inner Joins - a perfect match
  3. Inner Joins (II)
  4. Inner Join (III) - Join 3 tables
  5. LEFT & RIGHT JOIN
  6. LEFT join
  7. RIGHT JOIN
  8. UNION & UNION ALL
  9. UNION ALL Check
  10. Join the UNION

In this final modules, you'll get really hands on! You've worked with existing tables, but in this modules, you'll get to CREATE and INSERT data into them. You'll also UPDATE existing records and practice DELETE statements in a safe environment. This modules ensures the course gives you a thorough introduction to the key aspects of working with data in SQL Server.


  1. Creator
  2. CRUD operations
  3. Create tables
  4. Insert, Update, Delete
  5. Insert
  6. Update
  7. Delete
  8. Declare yourself
  9. DECLARE and SET a variable
  10. Declare multiple variables
  11. Ultimate Power


Introduction to Relational Databases in SQL
Explore the Role of SQL in Relational Database Management
There are a lot of reasons why SQL is the go-to query language for relational database management. The main one is that SQL is a powerful language that can handle large amounts of data in complex ways and solve tricky analytical questions. In this course, you will gain an introduction to relational databases in SQL.

Learn how to create tables and specify their relationships, as well as how to enforce data integrity. Additionally, discover other unique features of database systems, such as constraints.

Create Your First Database
You begin the section by creating your first database with simple SQL commands. Next, you’ll learn how to update your database as the structure changes by migrating data and deleting tables.

In the final module, you will glue tables in foreign keys together and establish relationships that greatly benefit your data quality. Finally, you will run ad hoc analyses on your new database.

Understand the Basics of Relational Databases
By the end of the course, you will gain a basic yet essential understanding of SQL relational databases. They are widely used in various data science fields (from healthcare to finance) and have consequently become one of the crucial languages for data scientists. If you're interested in deepening your knowledge further, you may be interested in our SQL for Database Administrators, SQL Server Developer, and SQL Server for Database Administrators Tracks!

4 Modules | 5+ Hours | 4+ Skills

Course Modules 


In this module, you'll create your very first database with a set of simple SQL commands. Next, you'll migrate data from existing flat tables into that database. You'll also learn how meta-information about a database can be queried.


  1. Introduction to relational databases
  2. Attributes of relational databases
  3. Query information_schema with SELECT
  4. Tables: At the core of every database
  5. CREATE your first few TABLEs
  6. ADD a COLUMN with ALTER TABLE
  7. Update your database as the structure changes
  8. RENAME and DROP COLUMNs in affiliations
  9. Migrate data with INSERT INTO SELECT DISTINCT
  10. Delete tables with DROP TABLE

After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this module.


  1. Better data quality with constraints
  2. Types of database constraints
  3. Conforming with data types
  4. Type CASTs
  5. Working with data types
  6. Change types with ALTER COLUMN
  7. Convert types USING a function
  8. The not-null and unique constraints
  9. Disallow NULL values with SET NOT NULL
  10. What happens if you try to enter NULLs?
  11. Make your columns UNIQUE with ADD CONSTRAINT

Now let’s get into the best practices of database engineering. It's time to add primary and foreign keys to the tables. These are two of the most important concepts in databases, and are the building blocks you’ll use to establish relationships between tables.


  1. Keys and superkeys
  2. Get to know SELECT COUNT DISTINCT
  3. Identify keys with SELECT COUNT DISTINCT
  4. Primary keys
  5. Identify the primary key
  6. ADD key CONSTRAINTs to the tables
  7. Surrogate keys
  8. Add a SERIAL surrogate key
  9. CONCATenate columns to a surrogate key
  10. Test your knowledge before advancing

In the final module, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.


  1. Model 1:N relationships with foreign keys
  2. REFERENCE a table with a FOREIGN KEY
  3. Explore foreign key constraints
  4. JOIN tables linked by a foreign key
  5. Model more complex relationships
  6. Add foreign keys to the "affiliations" table
  7. Populate the "professor_id" column
  8. Drop "firstname" and "lastname"p
  9. Referential integrity
  10. Referential integrity violations
  11. Change the referential integrity behavior of a key
  12. Roundup
  13. Count affiliations per university
  14. Join all the tables together.


Intermediate SQL Server
A majority of data is stored in databases and knowing the necessary tools needed to analyze and clean data directly in databases is indispensable. This course focuses on T-SQL, the version of SQL used in Microsoft SQL Server, needed for data analysis. You will learn several concepts in this course such as dealing with missing data, working with dates, and calculating summary statistics using advanced queries. After completing this course, you will have the skills needed to analyze data and provide insights quickly and easily.

4 Modules | 5+ Hours | 4+ Skills

Course Modules 


One of the first steps in data analysis is examining data through aggregations. This module explores how to create aggregations in SQL Server, a common first step in data exploration. You will also clean missing data and categorize data into bins with CASE statements.


  1. Data analysis with aggregations
  2. Creating aggregations
  3. Creating grouped aggregations
  4. Dealing with missing data
  5. Removing missing values
  6. Imputing missing values (I)
  7. Imputing missing values (II)
  8. Binning data with CASE
  9. Using CASE statements
  10. Creating several groups with CASE

This module explores essential math operations such as rounding numbers, calculating squares and square roots, and counting records. You will also work with dates in this module!


  1. Counting and totals
  2. Calculating the total
  3. Counting the number of rows
  4. Dates
  5. Which date function should you use?
  6. Counting the number of days between dates
  7. Adding days to a date
  8. Rounding and truncating
  9. Rounding numbers
  10. Truncating numbers
  11. More math functions
  12. Calculating the absolute value
  13. Calculating squares and square roots

In this module, you will create variables and write while loops to process data. You will also write complex queries by using derived tables and common table expressions.


  1. WHILE loops
  2. Creating and using variables
  3. Creating a WHILE loop
  4. Derived tables
  5. Queries with derived tables (I)
  6. Queries with derived tables (II)
  7. Common Table Expressions
  8. CTE syntax
  9. Creating CTEs (I)
  10. Creating CTEs (II)

In the final module of this course, you will work with partitions of data and window functions to calculate several summary stats and see how easy it is to create running totals and compute the mode of numeric columns.


  1. Window functions in T-SQL
  2. Window functions with aggregations (I)
  3. Window functions with aggregations (II)
  4. Common window functions
  5. Do you know window functions?
  6. First value in a window
  7. Previous and next values
  8. Increasing window complexity
  9. Creating running totals
  10. Assigning row numbers
  11. Using windows for statistical functions
  12. Calculating standard deviation
  13. Calculating mode (I)
  14. Calculating mode (II)


Time Series Analysis in SQL Server
SQL Server has a robust set of tools to prepare, aggregate, and query time series data. This course will show you how to build and work with dates, parse dates from strings (and deal with invalid strings), and format dates for reporting. From there, you will see how SQL Server's built-in aggregation operators and window functions can solve important business problems like calculating running totals, finding moving averages, and displaying month-over-month differences using realistic sample data sets. You will also see how taking a different perspective on your data can solve difficult problems.

4 Modules | 5+ Hours | 4 Skills

Course Modules 


This module covers date and time functionality in SQL Server, including building dates from component parts, formatting dates for reporting, and working with calendar tables.


  1. Building dates
  2. Break out a date into year, month, and day
  3. Break a date and time into component parts
  4. Date math and leap years
  5. Rounding dates
  6. Formatting dates for reporting
  7. Formatting dates with CAST() and CONVERT()
  8. Formatting dates with FORMAT()
  9. Working with calendar tables
  10. The benefits of calendar tables
  11. Try out a calendar table
  12. Joining to a calendar table

Here, we'll be converting strings and other inputs to date and time data types.


  1. Building dates from parts
  2. Build dates from parts
  3. Build dates and times from parts
  4. Build dates and times with offsets from parts
  5. Translating date strings
  6. Cast strings to dates
  7. Convert strings to dates
  8. Parse strings to dates
  9. Working with offsets
  10. Changing a date's offset
  11. Using the time zone DMV to look up times
  12. Converting to a date offset
  13. Handling invalid dates
  14. Try out type-safe date functions
  15. Convert imported data to dates with time zones
  16. Test type-safe conversion function performance

In this module, we will learn techniques to aggregate data over time. We will briefly review aggregation functions and statistical aggregation functions. We will cover upsampling and downsampling of data. Finally, we will look at the grouping operators.


  1. Basic aggregate functions
  2. Summarize data over a time frame
  3. Calculating distinct counts
  4. Calculating filtered aggregates
  5. Statistical aggregate functions
  6. Working with statistical aggregate functions
  7. Calculating median in SQL Server
  8. Downsampling and upsampling data
  9. Downsample to a daily grain
  10. Downsample to a weekly grain
  11. Downsample using a calendar table
  12. Grouping by ROLLUP, CUBE, and GROUPING SETS
  13. Generate a summary with ROLLUP
  14. View all aggregations with CUBE
  15. Generate custom groupings with GROUPING SETS
  16. Combine multiple aggregations in one query

In this module, we will learn how to use window functions to perform calculations over time, including calculating running totals and moving averages, calculating intervals, and finding the maximum levels of overlap.


  1. Using aggregation functions over windows
  2. Contrasting ROW_NUMBER(), RANK(), and DENSE_RANK()
  3. Aggregate window functions
  4. Calculating running totals and moving averages
  5. Running totals with SUM()
  6. Investigating window frames
  7. Calculating moving averages
  8. Working with LAG() and LEAD()
  9. Seeing prior and future periods
  10. Seeing the prior three periods
  11. Calculating days elapsed between incidents
  12. Finding maximum levels of overlap
  13. Analyze client data for potential fraud
  14. Build a stream of events
  15. Complete the fraud analysis
  16. Wrapping up


Functions for Manipulating Data in SQL Server

In this section, you will learn how to make use of the most important functions for manipulating data provided by SQL Server. You can use these functions for processing and transforming data to get the results you want.

4 Modules | 5+ Hours | 4 Skills

Course Modules 


In this module, you will learn what are the most used data types in SQL Server. You will understand the differences between implicit and explicit conversion and how each type of conversion manifests. You will also get familiar with the functions used for explicitly converting data: CAST() and CONVERT().


  1. Welcome to this section!
  2. Working with different types of data
  3. Storing dates in a database
  4. Types of character strings
  5. Implicit conversion
  6. Implicit conversion between data types
  7. Data type precedence
  8. Explicit conversion
  9. CASTing data
  10. CONVERTing data
  11. Working with the correct data types

Date and time functions are an important topic for databases. In this module, you will get familiar with the most common functions for date and time manipulation. You will learn how to retrieve the current date, only parts from a date, to assemble a date from pieces and to check if an expression is a valid date or not.


Functions that return system date and time
Get the know the system date and time functions
Selecting parts of the system's date and time
Functions returning date and time parts
Extracting parts from a date
Generating descriptive date parts
Presenting parts of a date
Creating a date from parts
Performing arithmetic operations on dates
Arithmetic operations with dates
Modifying the value of a date
Calculating the difference between dates
Validating if an expression is a date
Changing the date format
Changing the default language
Correctly applying different date functions

Strings are one of the most commonly used data types in databases. It's important to know what you can do with them. In this module, you will learn how to manipulate strings, to get the results you want.


  1. Functions for positions
  2. Calculating the length of a string
  3. Looking for a string within a string
  4. Looking for a pattern within a string
  5. Functions for string transformation
  6. Changing to lowercase and uppercase
  7. Using the beginning or end of a string
  8. Extracting a substring
  9. Replacing parts of a string
  10. Functions manipulating groups of strings
  11. Concatenating data
  12. Aggregating strings
  13. Splitting a string into pieces
  14. Applying various string functions on data

In this module, you will work with functions applied to numeric data. You will use aggregate functions for calculating the minimum, maximum or the sum of values from a set. You will learn how to raise a number to a power or to calculate its square root.


  1. Aggregate arithmetic functions
  2. Learning how to count and add
  3. MINimizing and MAXimizing some results
  4. Analytic functions
  5. Accessing values from the next row
  6. Accessing values from the previous row
  7. Getting the first and last value
  8. Mathematical functions
  9. Extracting the sign and the absolute valuep
  10. Rounding numbers
  11. Working with exponential functions
  12. Manipulating numeric data
  13. Wrapping things up


Database Design
A good database design is crucial for a high-performance application. Just like you wouldn't start building a house without the benefit of a blueprint, you need to think about how your data will be stored beforehand. Taking the time to design a database saves time and frustration later on, and a well-designed database ensures ease of access and retrieval of information. While choosing a design, a lot of considerations have to be accounted for. In this course, you'll learn how to process, store, and organize data in an efficient way. You'll see how to structure data through normalization and present your data with views. Finally, you'll learn how to manage your database and all of this will be done on a variety of datasets from book sales, car rentals, to music reviews.


4 Modules | 5+ Hours | 4 Skills

Course Modules 


Start your journey into database design by learning about the two approaches to data processing, OLTP and OLAP. In this first module, you'll also get familiar with the different forms data can be stored in and learn the basics of data modeling.


  1. OLTP and OLAP
  2. OLAP vs. OLTP
  3. Which is better?
  4. Storing data
  5. Name that data type!
  6. Ordering ETL Tasks
  7. Recommend a storage solution
  8. Database design
  9. Classifying data models
  10. Deciding fact and dimension tables
  11. Querying the dimensional model

In this module, you will take your data modeling skills to the next level. You'll learn to implement star and snowflake schemas, recognize the importance of normalization and see how to normalize databases to different extents.


  1. Star and snowflake schema
  2. Running from star to snowflake
  3. Adding foreign keys
  4. Extending the book dimension
  5. Normalized and denormalized databases
  6. Querying the star schema
  7. Querying the snowflake schema
  8. Updating countries
  9. Extending the snowflake schema
  10. Normal forms
  11. Converting to 1NF
  12. Converting to 2NF
  13. Converting to 3NF

Get ready to work with views! In this module, you will learn how to create and query views. On top of that, you'll master more advanced capabilities to manage them and end by identifying the difference between materialized and non-materialized views.


  1. Database views
  2. Tables vs. views
  3. Viewing views
  4. Creating and querying a view
  5. Managing views
  6. Creating a view from other views
  7. Granting and revoking access
  8. Updatable views
  9. Redefining a view
  10. Materialized views
  11. Materialized versus non-materialized
  12. Creating and refreshing a materialized view
  13. Managing materialized views

This final module ends with some database management-related topics. You will learn how to grant database access based on user roles, how to partition tables into smaller pieces, what to keep in mind when integrating data, and which DBMS fits your business needs best.


  1. Database roles and access control
  2. Create a role
  3. GRANT privileges and ALTER attributes
  4. Add a user role to a group role
  5. Table partitioning
  6. Reasons to partition
  7. Partitioning and normalization
  8. Creating vertical partitions
  9. Creating horizontal partitions
  10. Data integration
  11. Data integration do's and dont's
  12. Analyzing a data integration plan
  13. Picking a Database Management System (DBMS)
  14. SQL versus NoSQL
  15. Choosing the right DBMS


Transactions and Error Handling in SQL Server
It is critical to know how to handle errors and manage transactions when programming SQL scripts. Unhandled errors can be very harmful and can cause unexpected situations, such as inconsistent data in your database, or even worse, errors can lead you to make wrong business decisions. In this course, you will learn how to handle errors and discover how to manage transactions in case of an error. Additionally, you will study what happens when two or more people interact at the same time with the same data. You will practice all these concepts using two datasets, one of them based on bank accounts and the other one on an electric bike store.

4 Modules | 5+ Hours | 4 Skills

Course Modules 


To begin the course, you will learn how to handle errors using the TRY...CATCH construct that provides T-SQL. You will study the anatomy of errors, and you will learn how to use some functions that can give you information about errors.


  1. Welcome!
  2. The TRY...CATCH syntax
  3. Your first error-handling script
  4. Nesting TRY...CATCH constructs
  5. Error anatomy and uncatchable errors
  6. Anatomy review
  7. Correcting compilation errors
  8. Giving information about errors
  9. Error function syntax
  10. Using error functions
  11. Using error functions in a nested TRY...CATCH

In this module, you will deepen your knowledge of handling errors. You will learn how to raise errors using RAISERROR and THROW. Additionally, you will discover how to customize errors.


  1. RAISERROR
  2. RAISERROR syntax
  3. CATCHING the RAISERROR
  4. THROW
  5. THROW with or without parameters
  6. THROW without parameters
  7. Executing a stored procedure that throws an error
  8. THROW with parameters
  9. Customizing error messages in the THROW statement
  10. Ways of customizing error messages
  11. Concatenating the message
  12. FORMATMESSAGE with message string
  13. FORMATMESSAGE with message number

In this module, you will be introduced to the concept of transactions. You will discover how to commit and rollback them. You will finish by learning how to return the number of transactions and their state.


  1. Transactions
  2. Transaction statements
  3. Correcting a transaction
  4. Rolling back a transaction if there is an error
  5. Choosing when to commit or rollback a transaction
  6. @@TRANCOUNT and savepoints
  7. Modifiers of the @@TRANCOUNT value
  8. Checking @@TRANCOUNT in a TRY...CATCH construct
  9. Using savepoints
  10. XACT_ABORT & XACT_STATE
  11. XACT_ABORT behavior
  12. XACT_ABORT and THROW
  13. Doomed transactions

This module defines what concurrency is and how it can affect transactions. You will learn exciting concepts like dirty reads, repeatable reads, and phantom reads. To avoid or allow this reads, you will explore, one by one, the different transaction isolation levels.


  1. Transaction isolation levels
  2. Concurrency phenomena
  3. Using the READ UNCOMMITTED isolation level
  4. READ COMMITTED & REPEATABLE READ
  5. Choosing the correct isolation level
  6. Prevent dirty reads
  7. Preventing non-repeatable reads
  8. SERIALIZABLE isolation level
  9. Prevent phantom reads in a table
  10. Prevent phantom reads just in some rows
  11. SNAPSHOT
  12. Setting READ COMMITTED SNAPSHOT to ON
  13. Comparing WITH (NOLOCK) & READ UNCOMMITTED
  14. Avoid being blocked
  15. Congratulations!


Writing Functions and Stored Procedures in SQL Server
Take your SQL Server programming to the next level. First, we demystify how to manipulate datetime data by performing temporal exploratory data analysis with the Washington DC BikeShare transactional dataset. Then, you’ll master how to create, update, and execute user-defined functions and stored procedures. You will learn the proper context for each modular programming tool and best practices. In the final module, you will apply all of your new skills to solve a real-world business case identifying the New York City yellow taxi utilization for each borough, and which pickup locations should be scheduled for each driver shift.

4 Modules | 5+ Hours | 4 Skills

Course Modules 


Learn how to do effective exploratory data analysis on temporal data, create scalar and table variables to store data, and learn how to execute date manipulation. This module will also cover the following SQL functions: DATEDIFF( ), DATENAME( ), DATEPART( ), CAST( ), CONVERT( ), GETDATE( ), and DATEADD( ).


  1. Introduction to the course
  2. Transactions per day
  3. Seconds or no seconds?
  4. Which day of week is busiest?
  5. Find the outliers
  6. Variables for datetime data
  7. DECLARE & CAST
  8. DECLARE a TABLE
  9. INSERT INTO @TABLE
  10. Date manipulation
  11. Parameters matter with DATEDIFF
  12. First day of month

This module will explain how to create, update, and execute user-defined functions (UDFs). You will learn about the various types of UDFs: scalar, inline, and multi-statement table-valued. You’ll also learn best practices.


  1. Scalar user defined functions
  2. What was yesterday?
  3. One in one out
  4. Multiple inputs one output
  5. Table valued UDFs
  6. Inline TVF
  7. Multi statement TVF
  8. UDFs in action
  9. Execute scalar with select
  10. EXEC scalar
  11. Execute TVF into variable
  12. Maintaining user defined functions
  13. CREATE OR ALTER
  14. Best practices

Learn how to create, update, and execute stored procedures. Investigate the differences between stored procedures and user defined functions, including appropriate scenarios for each.


  1. Stored procedures
  2. CREATE PROCEDURE with OUTPUT
  3. Output parameters vs. Return values
  4. Oh CRUD!
  5. Use SP to INSERT
  6. Use SP to UPDATE
  7. Use SP to DELETE
  8. Let's EXEC!
  9. EXECUTE with OUTPUT parameter
  10. EXECUTE with return value
  11. EXECUTE with OUTPUT & return value
  12. TRY & CATCH those errors!
  13. Your very own TRY..CATCH
  14. CATCH an error

Apply your new skills in temporal EDA, user-defined functions, and stored procedures to solve a business case problem. Analyze the New York City taxi ride dataset to identify average fare per distance, ride count, and total ride time for each borough on each day of the week. And which pickup locations within the borough should be scheduled for each driver shift?


  1. Case study EDA & imputation
  2. Use EDA to find impossible scenarios
  3. SPs vs UDFs
  4. Mean imputation
  5. Hot Deck imputation
  6. Case study UDFs
  7. CREATE FUNCTIONs
  8. Test FUNCTIONs
  9. Formatting tools
  10. Logical weekdays with Hot Deck
  11. Format for Germany
  12. Case study stored procedures
  13. NYC Borough statistics SP
  14. NYC Borough statistics results
  15. Pickup locations by shift
  16. Pickup locations by shift results
  17. Congratulations!


Building and Optimizing Triggers in SQL Server
Auditing your SQL Server database and keeping data integrity can be a challenging task for DBAs and database developers. SQL Server triggers are special types of stored procedures designed to help you achieve consistency and integrity of your database. This course will teach you how to work with triggers and use them in real-life examples. Specifically, you will learn about the use cases and limitations of triggers and get practice designing and implementing them. You will also learn to optimize triggers to fit your specific needs.


4 Modules | 5+ Hours | 4 Skills

Course Modules 


An introduction to the basic concepts of SQL Server triggers. Create your first trigger using T-SQL code. Learn how triggers are used and what alternatives exist.


  1. Introduction
  2. Types of trigger
  3. Creating your first trigger
  4. Practicing creating triggers
  5. How DML triggers are used
  6. When to use triggers
  7. Creating a trigger to keep track of data changes
  8. Trigger alternatives
  9. Triggers vs. stored procedures
  10. Triggers vs. computed columns

Learn about the different types of SQL Server triggers: AFTER triggers (DML), INSTEAD OF triggers (DML), DDL triggers, and logon triggers.


  1. AFTER triggers (DML)
  2. Tracking retired products
  3. The TrackRetiredProducts trigger in action
  4. Practicing with AFTER triggers
  5. INSTEAD OF triggers (DML)
  6. Preventing changes to orders
  7. PreventOrdersUpdate in action
  8. Creating the PreventNewDiscounts trigger
  9. DDL triggers
  10. Tracking table changes
  11. Using FOR in a trigger
  12. Preventing table deletion
  13. Logon triggers
  14. Enhancing database security
  15. Defining a logon trigger

Find out known limitations of triggers, as well as common use cases for AFTER triggers (DML), INSTEAD OF triggers (DML) and DDL triggers.


  1. Known limitations of triggers
  2. Trigger limitations
  3. Creating a report on existing triggers
  4. Use cases for AFTER triggers (DML)
  5. Keeping a history of row changes
  6. Table auditing using triggers
  7. Use cases for INSTEAD OF triggers (DML)
  8. Preventing changes to Products
  9. Checking stock before placing orders
  10. Use cases for DDL triggers
  11. Database auditing
  12. Preventing server changes

Learn to delete and modify triggers. Acquaint yourself with the way trigger management is done. Learn how to investigate problematic triggers in practice.


  1. Deleting and altering triggers
  2. Removing unwanted triggers
  3. Modifying a trigger's definition
  4. Disabling a trigger
  5. Re-enabling a disabled trigger
  6. Trigger management
  7. Managing existing triggers
  8. Counting the AFTER triggers
  9. Troubleshooting triggers
  10. Keeping track of trigger executions
  11. Identifying problematic triggers
  12. Wrapping up


Improving Query Performance in SQL Server
A mission critical assignment is depending on your SQL coding skills. You’ve been given some code to fix. It is giving the results you need but it’s running too slow, and it’s poorly formatted making it hard to read. The deadline is tomorrow. You’ll need to reformat the code and try different methods to improve performance. The pressure is on!!! In this section we’ll be using SQL on real world datasets, from sports and geoscience, to look at good coding practices and different ways how we can can improve the performance of queries to achieve the same outcome.

4 Modules | 5+ Hours | 4 Skills

Course Modules 


In this module, students will learn how SQL code formatting, commenting, and aliasing is used to make queries easy to read and understand. Students will also be introduced to query processing order in the database versus the order of the SQL syntax in a query.


  1. Introduction
  2. Formatting - player BMI
  3. Commenting - player BMI
  4. Commenting - how many Kiwis in the NBA?
  5. Aliasing
  6. Ambiguous column names
  7. Aliasing - team BMI
  8. Query order
  9. Processing order
  10. Syntax order - New Zealand earthquakes
  11. Syntax order - Japan earthquakes
  12. Syntax order - very large earthquakes

This module introduces filtering with WHERE and HAVING and some best practices for how (and how not) to use these keywords. Next, it explains the methods used to interrogate data and the effects these may have on performance. Finally, the module goes over the roles of DISTINCT() and UNION in removing duplicates and their potential effects on performance.


  1. Filtering with WHERE
  2. Column does not exist
  3. Functions in WHERE
  4. Test your knowledge of WHERE
  5. Filtering with HAVING
  6. Row filtering with HAVING
  7. Filtering with WHERE and HAVING
  8. Test your knowledge of HAVING
  9. Interrogation after SELECT
  10. SELECT what you need
  11. Limit the rows with TOP
  12. Should I use ORDER BY?
  13. Managing duplicates
  14. Remove duplicates with DISTINCT()
  15. UNION and UNION ALL
  16. UNION or DISTINCT()?

This module is an introduction to sub-queries and their potential impacts on query performance. It also examines the different methods used to determine if the data in one table is present, or absent, in a related table.


  1. Sub-queries
  2. Uncorrelated sub-query
  3. Correlated sub-query
  4. Sub-query vs INNER JOIN
  5. Presence and absence
  6. INTERSECT
  7. EXCEPT
  8. Interrogating with INTERSECT
  9. Alternative methods 1
  10. IN and EXISTS
  11. NOT IN and NOT EXISTS
  12. NOT IN with IS NOT NULL
  13. Alternative methods 2
  14. INNER JOIN
  15. Exclusive LEFT OUTER JOIN
  16. Test your knowledge

Students are introduced to how STATISTICS TIME, STATISTICS IO, indexes, and executions plans can be used in SQL Server to help analyze and tune query performance.


  1. Time statistics
  2. STATISTICS TIME in queries
  3. STATISTICS TIME results
  4. Page read statistics
  5. STATISTICS IO: Example 1
  6. STATISTICS IO: Example 2
  7. STATISTICS IO comparison
  8. Indexes
  9. Test your knowledge of indexes
  10. Clustered index
  11. Execution plans
  12. Sort operator in execution plans
  13. Test your knowledge of execution plans
  14. Query performance tuning: final notes

MASTERING SQL SERVER DEVELOPMENT COST


United States

$799.99

United Kingdom

£899.99

Career and Certifications


GreaterHeight Academy's Certificate Holders also prepared work at companies like:



Our Advisor is just a CALL away

+1 5169831065                                    +447474275645
Available 24x7 for your queries


Talk to our advisors

Our advisors will get in touch with you in the next 24 hours.


Get Advice


FAQs

Data Analytics With SQL Master Program

  • Yes, this career track, Database Design in SQL, is suitable for beginners. You do not need any prior SQL knowledge to start developing your SQL skills.

  • This track covers key concepts for building effective databases, and will be beneficial to individuals seeking jobs in a variety of roles such as Database Administrator, Data Analyst, Business Intelligence Analyst, Data Scientist, or SQL Developer.

  • Nowadays, information is gathered from a variety of root, and the information is of great value to organizations. However, with an increasing amount of data comes the need for a database that can entrepot information for retrieval and analysis by the trained specialist. Thus, proper data analysis is in high demand in our digital world.
  • A relational database, which logically group information into chunks, are basically used to store and organize large amounts of data. Of course, if you’re looking to retrieve any kind of information from a database, you need to speak its oral communication! The most widely used speech communication for interacting with the database is SQL (Structured Query Language), the amber standard of relational databases.
  • SQL queries, which are essentially requests or instructions that you send to a database, allow you to retrieve information and update, insert, or delete data. SQL is mainly associated with the IT sector and is an everyday instrument for database administrators. Developers use SQL to write an application that requires database connector, and systems architects use it to design database models. All of this mean value that encyclopedism SQL is a great choice for anyone who would like to pursue a career in IT.

The Business Intelligence market is growing significantly across the world and such strong growth pattern followed by market demand is a great opportunity for the following IT Professionals.

  • Business Analysts
  • Data Analysts
  • Project Managers
  • Data Scientists
  • Statisticians and Analysts
  • Business Intelligence Managers

  • SQL Certification Training Cost in USA, UK and NIGERIA is £300.

  • All online training classes are recorded. You will get the recorded sessions so that you can watch the online classes when you want. Also, you can join other class to do your missing classes.

  • A skill track is a collection of courses that help users acquire a specialized set of skills and knowledge within a certain area/domain. A career track focuses on a particular job/career where users can learn how to become a successful practitioner in that respective field.

  • GreaterHeight is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry ready.
  • You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.

  • There are no pre-requisites for this course, however, some fundamentals knowledge about DBMS will be beneficial.

All our mentors are highly qualified and experience professionals. All have at least 18-25 yrs. of development experience in various technologies and are trained by GreaterHeight Academy to deliver interactive training to the participants.

  • Yes, we do. As the technology upgrades, we do update our content and provide your training on latest version of that technology.

Exam Pattern for Tableau Desktop Certified Associate Exam

  • Time Limit: 2 hours; please plan for extra time for online exam setup.
  • Question Format: Multiple choice, true/false, multiple responses, hands-on
  • Number of Questions: 36
  • Scoring: Automatically scored; point value varies per question type with hands-on worth more
  • Passing score: 75%
  • Language(s) Offered: English, Simplified Chinese, Japanese, German, Brazilian Portuguese, French, International Spanish.
  • Delivery Platform: Windows Virtual Machine containing Tableau Desktop Source: 
  • https://www.tableau.com/learn/certification/desktop-certified-associate

  • Yes, we would be providing you with the certificate of completion of the program once you have successfully submitted all the assessment and it has been verified by our subject matter experts.

  • Yes, we do. We will discuss all possible technical interview questions and answers during the training program so that you can prepare yourself for interview.

  • No. Any abuse of copyright is taken seriously. Thanks for your understanding on this one.

  • Yes. But you can also raise a ticket with the dedicated support team at any time. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, our support is provided for a period of Twelve Weeks from the start date of your course.

OUR POPULAR COURSES

Data Analytics and Visualization With Python

Data Analytics and Visualization With Python

Advanced developments of expertise in cleaning, transforming, and modelling data to obtain insight into  corporate decision making as a Senior Data Analyst - Using Python.

View Details
Data Science Training Masters Program

Data Science Training Masters Program

Learn Python, Statistics, Data Preparation, Data Analysis, Querying Data, Machine Learning, Clustering, Text Processing, Collaborative Filtering, Image Processing, etc..

View Details
Microsoft Azure DP-100 Data Science

Microsoft Azure DP-100 Data Science

You will Optimize & Manage Models,   Perform Administration by using T-SQL, Run Experiment & Train Models, Deploy & Consume Models, and Automate Tasks.

View Details
Machine Learning using Python

Machine Learning using Python

Learn Data Science and Machine Learning from scratch, get hired, and have fun along the way with the most modern, up-to-date Data Science course on.

View Details
Microsoft Azure PL-300 Data Analysis

Microsoft Azure PL-300 Data Analysis

You will learn how to Design a Data Model in Power BI, Optimize Model Performance,   Manage Datasets in Power BI and Create Paginated Reports.

View Details
Microsoft Azure DP-203 Data Engineer

Microsoft Azure DP-203 Data Engineer

You will learn Batch & Real Time Analytics, Azure Synapse Analytics, Azure Databricks,   Implementing Security and ETL & ELT Pipelines.

View Details

The GreaterHeight Advantage

0+

Accredited Courseware

Most of our training courses are accredited by the respective governing bodies.

0+

Assured Classes

All our training courses are assured & scheduled dates are confirmed to run by SME.

0+

Expert Instructor Led Programs

We have well equipped and highly experienced instructors to train the professionals.

OUR CLIENTS

We Have Worked With Some Amazing Companies Around The World

Our awesome clients we've had the pleasure to work with!


Client 01
Client 02
Client 03
Client 04
Client 05
Client 06
Client 07
  • Contact info
  • Facebook
  • WhatsApp
  • (+86)1234567809
  • creative@gmail.com
  • Back to top