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.
DurationUsing 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.
At City Lit, we pride ourselves on creating opportunities for people to come together to enrich their lives through learning.
Central to everything we do are our values.
Open-hearted
Imaginative
Ambitious
City Lit is the ultimate destination for online and class-room based adult courses, from part-time short courses and one-off workshops to year-long programmes.
We offer an array of courses across a massive range of subject areas including art and design, music, dance, history, writing, computing, massage, languages and much more.
Ofsted inspectors rated City Lit as an Outstanding provider following inspection in May 2023. This is a great achievement which we are proud of as a college.
Since 2020 many of our courses are available through online learning and we've expanded our reach, nationally and internationally. Our online courses are live, interactive and usually delivered in small groups. Read our guide to online learning for more information. Onsite courses are delivered at our world class locations in London's buzzing Covent Garden.
Our flagship building in Keeley Street hosts a range of purpose built facilities including our Digital and Design Lab and Lunch Room to help you get the most out of your studies and time at City Lit. Studying at one of our other sites? Don’t worry, you can still benefit from the facilities and resources at Keeley Street.
Our courses are taught by expert tutors, many of whom are industry professionals looking to pass on their knowledge and wisdom.
In earlier times, the data storage was being handled by DBMS packages such as FoxPro and Access. As technology is growing and the social media is also becoming an important aspect of the IT industry so need to handle data in bulk. The database giants such as DB2 and Oracle come into the market.
Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL.
SQL Intro training is offered by Media Training. Our courses are meticulously prepared to ensure that they provide the real world skills you'll need to deliver your projects.
This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting the database.
This is the perfect training course for those with experience of working with databases in a commercial environment e.g. VB – ActiveX or ASP/ADO and a good knowledge of at least one programming/scripting language, preferably Microsoft e.g.VBScript, VBA, VB.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan