Introduction To SQL And Microsoft SQL Server

by City Lit Claim Listing

Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.

£239

Contact the Institutes

Fill this form

Advertisement

City Lit Logo

img Duration

Enquire Now

Course Details

What Is The Course About?

Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.

Participants who will attend the full course will receive a City Lit certificate of attendance electronically for their CV or CPD records. The certificate will show your name, course title and dates of the course you have attended.

 

What Will We Cover?

The fundamental building block of a relational database is the table. We will use SQL to produce a series of tables and link them to build an efficient storage system for our data that avoids data duplication and redundancy.

We will also learn how to maintain data once stored in our database using the Data Manipulation Language components of SQL. 

Finally, we will learn how to interrogate our database, an activity central to nearly all organisations, to carry out mission critical tasks such as inventory management, order processing, tracking and booking amongst many others. We also need these skill to for the business intelligence process, data science and analysis.

 

What Will I Achieve?
By the end of this course you should be able to.

  • Define key terminology and concepts related to all RDBMS
  • Use the Data Definition Language commands in SQL to create a series of linked database tables that can store data of various data types
  • Use the Data Manipulation Language commands in SQL to add, update and delete data stored across related tables
  • Use the Data Query Language commands in SQL to interrogate our data, including using:-
  • Join operations
  • Logical and comparison operations
  • Fuzzy Search
  • The Null operator
  • Date functions
  • Created aliases and calculated fields with the data in our tables
  • Format currency and dates.

 

What Level Is The Course And Do I Need Any Particular Skills?

Though the course does not require any previous knowledge of SQL or Relational Database Management Systems it is quite fast paced and you will not only need good computing skills and a high level of typing accuracy, but would also benefit from having some experience in coding, (it doesn’t matter which language), such as having attended one of our many Python or HTML and CSS courses.

If you haven’t coded before you might consider our Beginner's Guide to SQL course first as an introduction to the topic.

  • London Branch

    1-10 Keeley St, London

Check out more SQL Server courses in UK

Global Knowledge Logo

Introduction To MySQL

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the mysql client program and MySQL Workbench.

by Global Knowledge [Claim Listing ]
Datrix Training Logo

Introduction to SQL

The Introduction to SQL course is intended to teach you the fundamentals of databases and the basics of SQL. The 1 day SQL training certification is aimed for anyone who is interested in databases and wants to learn SQL.

by Datrix Training [Claim Listing ]
Futuretech Info Vision Limited Logo

Database Specialist (IT Training Bundle Pack 4)

This is a database specialist package designed to give you enhanced knowledge and understanding of the various softwares and applications for database management.

by Futuretech Info Vision Limited
  • Price
  • Start Date
  • Duration
Indicia Training Logo

Introduction To SQL

This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases.

by Indicia Training [Claim Listing ]
Best Practice Training Limited Logo

Oracle Database 11g Administration Workshop I Release 2

The course helps the delegates in their initial step towards becoming an Oracle Database Administrator. The Oracle course is designed for the candidates who want to learn about installing and managing an Oracle Database.

by Best Practice Training Limited [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy